Matching fields with csv import

Question

Hello,
Im trying to import some contacts from a csv file which has its own data fields. When I load the csv file the grid appears with all of the fields and data from the csv file. When I click on the dropdown menus that are in each of the grid columns, I get a list of a lot of other fields from the database (I'm assuming) and have no way of knowing which ones to match them to. Does anyone know how to determine which fields, from the drop down menus, go to which table in the database?

Viktor Aditya · Accepted Answer

The easiest way is to make just 1 contact in the system through UI (make sure to fill all the field that you need), and then export the contact with all the field that you need... This will give you a template of field in the sytem, now you just have to move your own data fields to this template, and import it.. It will automatically select the field for you..

mmycool · Answer

The compulsory fields to export(Compatible) will be blue in color. Some of them need to appear as column names, but not necessarily have data.

Related Posts	Odpovědi	Zobrazení
Required CSV import fields and template of CSV files Vyřešeno fields import v7 csv	3 říj 23	36012
Importing CSV into OpenERP leads to a timeout import csv timeout importing	1 bře 15	8828
Loading and reading files fields import csv files	0 bře 15	4593
Product Attribute Values containing comma character: csv-Import seems to work differently when importing into Attribute Values and when importing into Product Templates import field csv attributes char	4 říj 23	9538
Import One2many field sales import one2many field csv	4 bře 20	6942

This question has been flagged

Enjoying the discussion? Don't just read, join in!