Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
importcsvleads
2 Odpowiedzi
32905 Widoki
Awatar
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.

Awatar
Odrzuć
Awatar
Joel Prendes
Autor Najlepsza odpowiedź

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.

Awatar
Odrzuć
Awatar
Nhomar Hernandez
Najlepsza odpowiedź

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.

Awatar
Odrzuć
Joel Prendes
Autor

thanks a bunch...

Powiązane posty Odpowiedzi Widoki Czynność
Disable automatic follow when importing res.partner csv
import csv
Awatar
Awatar
Awatar
3
cze 20
3843
Enable/disable import rights?
import csv
Awatar
Awatar
1
lis 18
9362
I can not import the Leads Database in OpenERP 6.1
import leads
Awatar
0
lis 17
2605
'utf8' codec can't decode byte error when importing a list of products as a CSV file Rozwiązane
import csv
Awatar
Awatar
Awatar
Awatar
Awatar
11
lut 17
63643
user defined values on import of leads
import leads
Awatar
Awatar
1
mar 15
3357