When importing and aligning CSV contact fields, first name disappears
Halfway through the process of realigning the fields when trying to import my CSV contacts file the First name field simply disappears.
Chosen solution
CSV Sux really.
try my way see http://thunderbirdtweaks.blogspot.com.au/2013/03/importing-csv-files.html
It is much easier to do the aligning in a spreadsheet that that pokey interface that just sort of works if your lucky.
Just give the CSV file the headings Thunderbird expects.
Don't know what they are. I just exported an address book and Thunderbird used First Name,Last Name,Display Name,Nickname,Primary Email,Secondary Email,Screen Name,Work Phone,Home Phone,Fax Number,Pager Number,Mobile Number,Home Address,Home Address 2,Home City,Home State,Home ZipCode,Home Country,Work Address,Work Address 2,Work City,Work State,Work ZipCode,Work Country,Job Title,Department,Organization,Web Page 1,Web Page 2,Birth Year,Birth Month,Birth Day,Custom 1,Custom 2,Custom 3,Custom 4,Notes,
Note however I have seen a bug where Thunderbird can not import as many fields as it exports. Go figure. SO you must have one lest column in your CSV that there is in that list.. Note also if you uses Excel as a spreadsheet, it will not save the CSV as UTF-8 which is required. you can accomplish this by opening the file in notepad and expressly setting it in the file save as dialog.
You might also want to file a bug for the loss of the First name field. but a fix for that will not arrive in time to do you any good with this file.
See https://bugzilla.mozilla.org/
Ler a resposta no contexto 👍 2All Replies (1)
Chosen Solution
CSV Sux really.
try my way see http://thunderbirdtweaks.blogspot.com.au/2013/03/importing-csv-files.html
It is much easier to do the aligning in a spreadsheet that that pokey interface that just sort of works if your lucky.
Just give the CSV file the headings Thunderbird expects.
Don't know what they are. I just exported an address book and Thunderbird used First Name,Last Name,Display Name,Nickname,Primary Email,Secondary Email,Screen Name,Work Phone,Home Phone,Fax Number,Pager Number,Mobile Number,Home Address,Home Address 2,Home City,Home State,Home ZipCode,Home Country,Work Address,Work Address 2,Work City,Work State,Work ZipCode,Work Country,Job Title,Department,Organization,Web Page 1,Web Page 2,Birth Year,Birth Month,Birth Day,Custom 1,Custom 2,Custom 3,Custom 4,Notes,
Note however I have seen a bug where Thunderbird can not import as many fields as it exports. Go figure. SO you must have one lest column in your CSV that there is in that list.. Note also if you uses Excel as a spreadsheet, it will not save the CSV as UTF-8 which is required. you can accomplish this by opening the file in notepad and expressly setting it in the file save as dialog.
You might also want to file a bug for the loss of the First name field. but a fix for that will not arrive in time to do you any good with this file.
Matt modificouno o