Skip to Content
This question has been flagged
importcsvleads
2 Replies
33726 Views
Avatar
Joel Prendes

I am trying to import a CSV of leads into the Sales/Leads section. My CSV file does not have an ID field so I would expect OpenERP to create that value in import. My only required field in the crm.lead model (Lead/Opportunity) is the name field (Field Label = Subject). I have added this field to me CSV and mapped it accordingly on the import screen. All fields are mapped, all fields in the CSV are within defined parameters for that field in OpenERP, and other than the missing ID field, this CSV is formatted identically to the res.partner.csv that OpenERP recommends exporting from the demo data (comma-delimited, double-quote-qualified - a typical CSV). Here's the first line:

"Abbey College, London","Abbey College, London Lead","22 Grosvenor Gardens Belgravia Belgravia London SW1W 0DH","020 7824 7300","020 7824 7309","emailhere","/sitelinkhere/","Abbey College, London, Belgravia is an independent school for boys and girls aged from 15 to 22. Takes boarders.","Westminster",130,"Non-denominational","Our aim is to guide our students to achieve academic success and fulfil their aspirations so as to enable them to access top universities. We respect and value each student, providing a friendly, safe and supportive environment where each person can learn and grow in confidence. We help you to develop key skills to succeed: resiliance, adaptability, independence and determination.;If you wish to...","£17,500 - £27,000 pa"

I've tried everything on this file and when I try to validate and/or import the file after mapping I get the same error(s):

No matching record found for name 'Abbey College, London' in field 'Company' at row 1 Get all possible values No matching record found for name 'Abercorn School' in field 'Company' at row 2 Get all possible values No matching record found for name 'Aberdour School' in field 'Company' at row 3 Get all possible values

...all the way down to line 120, the end of the file. And of course it does not import. I'm probably just being thick, don't hesitate to tell me if I am, but can someone please tell me what I am doing wrong?

I am running OpenERP 7.x on Ubuntu 13.04. Not sure what else you need in terms of system spec, but tell me and I'll be happy to fill in more details.

Avatar
Discard
Avatar
Joel Prendes
Author Best Answer

Thanks - this was helpful - I think I was missing the requirement for an ID field as it doesn't come up in the list of fields under the Lead/Opportunity model as a 'required' field. I edited the first lines to read, in part:

"id","partner_name","name","x_Lead_FullAddress... "Schools01_01","Abbey College, London","Abbey College, London Lead","22 Grosvenor Gardens...

Then tried re-importing - all the fields mapped properly this time. I've still got a bit of work to do with it to change the form views now, but thanks for the help.

Avatar
Discard
Avatar
Nhomar Hernandez
Best Answer

Hello.

The "Company" is a many2one field, the import feature use "search" method with "Ilike" criteria to select the foreing id and set it in the many2one field.

THen. When you pass the company with "'Abbey College, London" you are passisng the "get_name" result not the "Unique sercheable name".

You have 3 options:

Pass Abbey College only, "If you have only 1 company that match with this criteria.".

Change the header of the field in your csv: company_id/.id (see the (.)) and change Abbey College by the sql id of your company (frequently 1 if you have a mono company enviroment).

Ignore this field "company_id" -Only in monocompany enviroments.

Avatar
Discard
Joel Prendes
Author

thanks a bunch...

Related Posts Replies Views Activity
Disable automatic follow when importing res.partner csv
import csv
Avatar
Avatar
Avatar
3
Jun 20
5085
Enable/disable import rights?
import csv
Avatar
Avatar
1
Nov 18
10553
I can not import the Leads Database in OpenERP 6.1
import leads
Avatar
0
Nov 17
3197
'utf8' codec can't decode byte error when importing a list of products as a CSV file Solved
import csv
Avatar
Avatar
Avatar
Avatar
Avatar
11
Feb 17
65261
user defined values on import of leads
import leads
Avatar
Avatar
1
Mar 15
3916