Archives
Contributors
ODOO Update versions V.15 to V.17 - Historical data.
Hello everyone.
I am doing an upgrade project from version 15 to 17, I am not going to migrate historical data, I will leave the historical data in version 15, up to the date of Go Live, and, in version 17 I will start with initial balances and operations from scratch , example: New Purchase Orders, New customer orders, etc.
My questions are: Is there a way to extract information from data that I will leave in version 15, for example: historical sales data, processed purchase orders, historical inventory data, etc.? Is there a connector or application for I can use Power BI to manage this data and be able to do reports, demand analysis, inventory analysis, etc.?
Thank you all in advance for your comments and recommendations.
Regards.
HF
by Hugo Ferrer - 11:40 - 3 Jul 2024
Follow-Ups
-
Re: ODOO Update versions V.15 to V.17 - Historical data.
On the contrary, I give more value to old data, and more with all the generative AIs coming. In this case, migrating the instance to v17 with OpenUpgrade (not yet there, but you can wait a bit or do a progressive migration - we do it constantly on our customers -) is the best strategy IMO.I introduce another factor on your previous suggestion: you have to maintain the old system. Apart from keeping the resources used by this system, their foundation software, libraries, etc should be also kept, and this is more and more a burden as times pass by. And even worse, both the foundation and the old Odoo version become vulnerable, as they are not updated by their manufacturers at any point, so you have an attack surface that is also a concern due to the RGPD.Regards.
by Pedro M. Baeza - 09:01 - 4 Jul 2024 -
Re: ODOO Update versions V.15 to V.17 - Historical data.
Hi Hugo,
i agree with that Graeme said. In most cases where we had such challenges we simply decided to keep a version of the old system running (with the data of the last day in productive use and reset to that every night if necessary). This has 2 advantages
1.) This is the cheapest approach that you can probably take (at the jost of manually logging on to an old system in the case its needed)
2.) It literally shows you (either obvserved or measured by monitoring) how infrequently this system is being used.
Any kind of integration just makes a system more complex and doesn't render the base of decision making better imho
Best Frederik
Am 04.07.24 um 00:19 schrieb Graeme Gellatly:
Not for less than the cost of just migrating the historical data in the first place IMO if it is Odoo. Other historical systems, sometimes (most times) the cost isn't worth it.
Indeed I have one project like that. A v7 instance still running after nearly 14 years plus 8 historical systems still after 25 years. One of the dumber things I agreed to.
Any connector I'd do at database level. Most people that use Power BI, Jasper, Crystal or any reporting tools do at db level.
In any case, consider that the historical data is immutable and devalues quickly. You can probably just produce the historical summary reports / flat tables you need and stick them in tables/views in whatever software you want including Odoo. Maybe override some reports to add Unions on the historical. In fact that is something I'm considering even for instances where all the data is migrated, it sucks waiting minutes for reports when 90% of the information is aggregations of historical data that will never change.
On Thu, Jul 4, 2024 at 9:42 AM hugo.ferrer <notifications@odoo-community.org> wrote:
Hello everyone.
I am doing an upgrade project from version 15 to 17, I am not going to migrate historical data, I will leave the historical data in version 15, up to the date of Go Live, and, in version 17 I will start with initial balances and operations from scratch , example: New Purchase Orders, New customer orders, etc.
My questions are: Is there a way to extract information from data that I will leave in version 15, for example: historical sales data, processed purchase orders, historical inventory data, etc.? Is there a connector or application for I can use Power BI to manage this data and be able to do reports, demand analysis, inventory analysis, etc.?
Thank you all in advance for your comments and recommendations.
Regards.
HF
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
-- Dr.-Ing. Frederik Kramer Geschäftsführer initOS GmbH Innungsstraße 7 21244 Buchholz i.d.N. Tel: +49 (0) 4181 13503 12 Fax: +49 (0) 4181 13503 10 Mobil: +49 (0) 179 3901819 Email: frederik.kramer@initos.com Internet: www.initos.com Geschäftsführung: Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke Sitz der Gesellschaft: Buchholz i.d.N. Amtsgericht Tostedt, HRB 205226 USt-IdNr.: DE815580155 Steuer-Nr: 15/200/53247
by Frederik Kramer - 08:36 - 4 Jul 2024