Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

1

Import csv files

By
Hans Schleidt
on 10/1/14, 3:39 PM 1,444 views

Hello.

 

I have to import a lot of different csv files with product informations not only one but a a minimum one a week. The files are from different suppliers.

No i'm looking for a posibility to save a template within odoo.

 

For example: first supplier is Trixie with other csv format like the next supplier. I have to import this file and i will match only once the fields within oddo and the csv files and save this template within odoo. If i receive the next csv file from Trixie i will not do the match again. I will open the template and then the matching will do automaticly.

 

Have anyone a idee of a solution

many thanks

Hans

0
Hans Schleidt
On 10/2/14, 4:10 PM

Thanks a lot.

i test it but it is not practible for my specific problem. Everytime i get new csv files from the supplier. it's not posible make copy and paste or everytink like that in a excel template.

I must define the matches one a time and the use it for every import for this supplier.

We have mor than 100 supplier with differnt csv files and we get round about 30-40 csv files per week.

0

michel Guénard

--michel Guénard--
1033
| 5 5 8
VIROFLAY, France
--michel Guénard--

VP operations & finance Social entrepreneur Certified Public Accountant Past Chief internal auditor

michel Guénard
On 10/2/14, 6:27 PM

This question is not trivial and many companies are facing this;  Think to the retail activities for books (printed or not) or for notated music (printed or not) or for recorded music where in these simple cases the number of Skus counts in hundreds of thousands, from thousands of suppliers worldwide.

Managing numerous and/or frequent changes of the masterdata requires specific workflows and dedicated solutions; which seems to be out of the objective of the current Odoo system.

The masterdata (partners, products, settings... should be manage as strictly as the accounting (creation date, deletion date, partner involved ......)

The minimum from Odoo or community could be to develop some utility functions to identify duplicates (or prevent duplication)  and/obsoletes and once validated as true duplicates other tools to merge them or eliminate the tuple.

Any comment will be welcome!

 

in the meantime, I discovered http://odoo-connector.com/guides/concepts.html which seems to be an answer

AD LIBITOM, michel Guénard
on 10/3/14, 9:06 AM
0
ahmad
On 10/2/14, 6:06 AM

you can use document module to handle the document, and process it using erppeek. you will have more control of the process.

Your Answer

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

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 10/1/14, 3:39 PM
Seen: 1444 times
Last updated: 3/16/15, 8:10 AM