Skip to Content
This question has been flagged
fieldsimportfieldcsvimporting
2 Replies
9760 Views
Avatar
Eric

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?

Avatar
Discard
Avatar
Viktor Aditya
Best 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..

Avatar
Discard
Eric
Author

Good idea. Thank you

Avatar
mmycool
Best 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.

Avatar
Discard
Related Posts Replies Views Activity
Required CSV import fields and template of CSV files Solved
fields import v7 csv
Avatar
Avatar
Avatar
Avatar
3
Oct 23
37703
Importing CSV into OpenERP leads to a timeout
import csv timeout importing
Avatar
Avatar
1
Mar 15
9308
Loading and reading files
fields import csv files
Avatar
0
Mar 15
5140
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
Avatar
Avatar
Avatar
Avatar
Avatar
4
Oct 23
10392
Import One2many field
sales import one2many field csv
Avatar
Avatar
4
Mar 20
7484