When importing CSV contacts, email and phone fields go into the wrong place. What should I do?
William...
26
Points
13
Posts
|
This is a typical issue of the header being mismatched. Various applications exporting CSV files differently may each refer to the same data by different terms like “Mobile No,” “Work 1,” or “Cellphone,” whereas vCard uses a set of standard field names. If the converter cannot find the heading, it will insert the data incorrectly. Such a problem occurred to me when I was converting my phone address book. The method is to rename columns so that they standardize the names and then make use of a trustworthy CSV to VCF converter, which is capable of field mapping. I experimented with GainTools once, and what contributed the most to the success of the process was that it recognized most of the headers automatically. So, it is better to first correct the column names in your CSV (Name, Phone, Email) and then do the CSV to VCF conversion again. It should totally resolve the issue of data being misplaced. |



