Skip to Content
  2. Mailing Lists
  3. Contributors
  4. Re: ODOO Update versions V.15 to V.17 - Historical data.

Archives

Contributors

Re: ODOO Update versions V.15 to V.17 - Historical data.

Re: ODOO Update versions V.15 to V.17 - Historical data.

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

by "Graeme Gellatly" <graeme@moahub.nz> - 12:18 - 4 Jul 2024

Reference

  • 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

    3 replies 3 replies

    • 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
    • Re: ODOO Update versions V.15 to V.17 - Historical data.
      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

      by "Graeme Gellatly" <graeme@moahub.nz> - 12:18 - 4 Jul 2024