We are importing leads and keep getting this error below - how do we fix it? Missing required value for the field 'name'. This might be 'Subject' in the current model, or a field of the same name in an o2m. at row 2 (1172 more)
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- 客户关系管理
- e-Commerce
- 会计
- 库存
- PoS
- Project
- MRP
此问题已终结
1
回复
12345
查看
Create one of whatever you are importing via the UI - check out all the blue fields - they are all mandatory.
For a Lead, the Subject is a short summary of the lead like 'Wants information on product X'.
You need one field with a value in your CSV for every blue field in the UI of whatever you are importing.
In the case of a Lead, you will see ALL you need is the Subject, everything else is optional.
There is only one field that is blue, Subject. We've tried adding the Subject field to the end of the CSV file entries and put 'blank' in each one, but we get the same error.
blank is not a value - you need a value in that field - blank won't work.
We do actually have the characters blank I.e. Contact,EMailAddress,Company,Title,Phone,Street1,City,State,Country,Zip,Subject Claire lname,CToups@xxx.com,Acadian,(985) 493-4618,338 Waverly Rd,Thibodaux,LA,USA,70302,blank
11 column headings and 10 values...means Subject is blank because Phone and everything after it is moved over one.
Actually the word Claire is on the wrong line. This forum wraps it -- it 11/11
Sorry 10/10
You have no value for Title - it needs to be something like Miss. USA is not the name of a country in OpenERP - you need to have United States. Company will match to the wrong field - you should rename it or manually match it to partner_name. Contact will match to the wrong field - you should rename it contact_name. Street1 will not map to any field so rename it to Street or manually match it to Street. EmailAddress will not map to any field so rename it to Email or manually match it to Email. Reconsider using blank as this will show up in the treeview and form view (in large letters).
See your sample one line file with these issues resolved at http://www.fileconvoy.com/dfl.php?id=g781b6fe685a3057a9992606796c3a0442e8a21cc0
I have been using the pull down to 'map' it to the correct fields. I.e. Contact is being matched to 'Contact Name' (from the pull down)
You have no value for Title - if I am taking the time to help you can you take the time to read?
I am deleting that row - we don't know all of them and since it is not required, we are not going to attempt to import
sorry that column
Unfortunately - that doesn't fix it -- after clean up - i get this: You must configure at least one field to import
Sample input (sorry about the \n after Subject on the first line but this forum post does that): contact_name,Email,partner_name,Phone,Street, City,State, Country,Zip,Subject Claire lname,CToups@xxx.com,Acadian,(985) 493-4618,338 Waverly Rd,Thibodaux,LA,United States,70302,blank
I was able to import the sample I posted - start with that and look for the differences. I have no other suggestions if you have problems since I was able to get it working with my suggestions.
Check that all rows in your CSV contain a value for the name field - or the field you are mapping to the name field. It is telling you to look at the second row. Start there.
We don't have a 'name' field. Here's our data:
Contact,EMailAddress,Company,Title,Phone,Street1,City,State,Country,Zip Claire lname,CToups@xxx.com,Acadian,(985) 493-4618,338 Waverly Rd,Thibodaux,LA,USA,70302
What model are you importing into?
I am trying to import into 'Leads'