Community mailing list archives

community@mail.odoo.com

[Fwd: Re: Conversion from mysql to postgreSQL]

by
Dave Ellison
- 02/26/2015 03:57:35
Hi,

Agree with exporting and using ETL, TalenD is a very good application
for that. Even exporting, reformat the CSV files and import into Odoo
would suffice. If you are not sure of the format, I would suggest
creating a database with demo data. Then export a sample of each, to get
a good idea of what format it would expect. Make sure when you export
you have import compatible selected.

There is no magic wand for this, unless someone has already written
something to transform the information. Even then, I'd personally rather
transform the data myself, so it is correct.

Thanks
Dave

-------- Forwarded Message --------
> From: bouzakri khalil <khalilbouzakri@gmail.com>
> Reply-to: "Odoo S.A. Community" <community@mail.odoo.com>
> To: Community <community@mail.odoo.com>
> Subject: Re: Conversion from mysql to postgreSQL
> Date: Wed, 25 Feb 2015 18:01:57 +0000
> 
> 
> 
> the problem is the structure of  databases are differents , you need
> to add some column and delete other .so simple import/export isn't the
> solution , you have to analyse the 2 structure databases and  work by
> an ETL like talend.
> 
> On Wed, Feb 25, 2015 at 5:47 PM, Kristian Koci
> <kristian.koci@gmail.com> wrote:
>         I think you should better export this data inside dolibarr
>         backend, as an excel spreadsheet or better .csv file , then
>         import them into Odoo.
>         
>         
>         You should also check field names into dolibarr, maybe adapt
>         your dolibarr module fields to the odoo module you want to
>         import data in...
>         
>         On Wed, Feb 25, 2015 at 12:13 PM, cyr saint
>         <saintcyrwin@gmail.com> wrote:
>                 Hi, i'm in Odoo 8.0. I want to use my dolibarr
>                 database in Odoo 8.0. I have backup my dolibarr
>                 database in a dump sql format. How can i do this
>                 import(or conversion) please?
>                 _______________________________________________
>                 Mailing-List: https://www.odoo.com/groups/community-59
>                 Post to: mailto:community@mail.odoo.com
>                 Unsubscribe: https://www.odoo.com/groups?unsubscribe
>                 
>                 
>                 
>         
>         
>         
>         
>         -- 
>         Kristian Koci
>         Linux User #582221
>         Website: http://tuespacioweb.com.ve
>         Cel. 0416 202 92 94
>         
>         
>          
>         _______________________________________________
>         Mailing-List: https://www.odoo.com/groups/community-59
>         Post to: mailto:community@mail.odoo.com
>         Unsubscribe: https://www.odoo.com/groups?unsubscribe
>         
>         
>         
> 
> 
> 
> 
> -- 
> Cordialement 
> Khalil Bouzakri
> Skype: Khali Bouzakri
> 0669175514
> _______________________________________________
> Mailing-List: https://www.odoo.com/groups/community-59
> Post to: mailto:community@mail.odoo.com
> Unsubscribe: https://www.odoo.com/groups?unsubscribe
> 
> 
>