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.

2

How can i import datas of 100 employees from a csv file?

By
Remya
on 6/3/13, 7:42 AM 2,194 views

I want to import datas of 100 employees from a csv to openerp 7.0 database.

But when i tried to import It shows below message

"You must configure at least one field to import"

How can i import datas in my database?

Hi firstly I would advise you not not open or edit your CSV file with MS Excel not great with CSV. Use Openoffice for editing and saving CSV files ( although it might not be as user friendly as excel it works better) and I also find the ea_import module from Enapps very helpful http://bazaar.launchpad.net/~enapps-london-uk/enapps-csv-import-tool/trunk/revision/6. Also you might need to add and remove a line or two of code https://code.launchpad.net/~domsense/enapps-csv-import-tool/ea_import_fix_1069819_lep/+merge/131044

kaynis
on 6/3/13, 8:06 AM

i'm using openoffice, still cant import the same exported file. why?

Remya
on 6/3/13, 8:23 AM

while importing csv you should select the appropriate column names

Maniganda
on 6/3/13, 8:56 AM

Copying and pasting data from the web to your CSV sometimes carry extra format which might not be supported by CSV when saving thus openerp might not be able to read the whole document it would help if you type directly into the CSV document. Also take what @Maniganda advised.

kaynis
on 6/3/13, 11:13 AM
0
Amit Bhavsar (amb)
On 6/3/13, 9:33 AM

Hello Remya,

There is two way to solved this Issue,

1st edit your csv file with OE field name. where edit the first line of csv with same field name.

For eg:

  1. "name","supplier"
  2. "Amit Bhavsar","True" : value

2nd : Otherwise, you can select the OE field from selection ("Don't Import").

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

1 follower(s)

Stats

Asked: 6/3/13, 7:42 AM
Seen: 2194 times
Last updated: 3/16/15, 8:10 AM