Basically, im testing Odoo at the moment and would like to see how is it possible to import all the " Leads " " Customers " section
if possible the " Schedulled calls " and " Logged calls "
Do i have to log as administration and give some privilidges ? or its by default possible to import and export ?
Where is the field that i can import and export ? cant find it , i did manage to find some export field however not the fields that i mentioned above ..... i think i exported the users ..... would appreciate to get like a step by step import /export guide :)
Finally, once i export and then import leads, customers info, on the export will get them perfectly formated as it was before ? or i would have to re-adjust the database ? i would say that the import would be just the way it was before .
Please advise , much appreciated.
Would prefer to get non scrypted answers or coding, just GUI guide thanks :)
PS : i guess the excel format or CSV doesnt matter.
About a week ago I migrated over 3.000 leads from V7 -> V8 through CSV.
CSV is a great way to export and import data but it requires a lot of patience.
The idea is that you simply export alle records from your current Odoo by selecting them in the tree view and then click on more > export. This will look like this:
A new menu will now pop up where you can choose which fields you would want to export. Choose the fields you want, every field you've chosen for export will show up on the right side like this:
In this sample screenshot I would only export the subject when I would click on 'Export To File'.
The choise is yours really, but there are some fields (such as subject) that you will always need (the fields that have a blue-ish colour are needed). I'd suggest you to export a few records (like 5 leads) just to give it a test run.
The second step is to login on your new Odoo. You go to sales > Leads and click on 'Import' there. Choose your CSV file and then see if all the column titles match up. Give the import a try with 'Validate', if this succeeds you can finally import them! If it does not you will get errors which tells you what is wrong.
The concept of importing and exporting is the same for about everything in Odoo. It just requires quite some testing and patience, but you'll get better in it gradually. To answer your last question about the perfect format.. The format should match up perfectly, if you choose the correct fields.
Best of luck and if you need more help just let me know!
Much appreciate regarding the screenshot, everything is clear, however i have one problem....
i cannot see the " more " field, i tried logging in as " administrator " to see maybe that was the reason but still nothing ! i really wanna get there where you got in order to import / export, seams very straight forward however do you have any idea why i cannot see the " more " field ? do i have to like set a privilige for that in some kind of back end in the software ? im troubleshooting as we speak to check it out, maybe is it the free testing version does not include that >? do i have to download a new module for that ? please advise .
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 2/26/15, 3:12 AM|
|Seen: 971 times|
|Last updated: 3/16/15, 8:10 AM|