Avatar for Username

Търсене в помощните статии

Избягвайте измамите при поддръжката. Никога няма да ви помолим да се обадите или изпратите SMS на телефонен номер или да споделите лична информация. Моля, докладвайте подозрителна активност на "Докладване за злоупотреба".

Научете повече

Тази тема беше архивирана. Моля, задайте нов въпрос ако имате нужда от помощ.

Trying to Import a large list of names and addresses. Using all the documented steps,but import gets the email addresses, but everything else is garbaged.38.3

  • 1 отговор
  • 1 има този проблем
  • 3 изгледи
  • Последен отговор от sfhowes

b_b
b_b
more options

Tried .csv from Excel spreadsheet and tried a generic comma "," delimited file in the form

First name,Last Name, emailaddress ( oh yes,,,de-selecting any unused , not present information)

The import creates an Address Book by the name of the Import file. The addresses are found correctly, but all the FirstNames and Lastnames are missed, BUT Thunderbird put the first part of the email address in the Firstname field.

I should say it is partially successful as I can go in and update the properties of each one, but what good is the import outside of adding 100's email addresses only ???

Double - triple checked the file format and the field selection / positioning scenarios of the import function...just stumped.

Tried .csv from Excel spreadsheet and tried a generic comma "," delimited file in the form First name,Last Name, emailaddress ( oh yes,,,de-selecting any unused , not present information) The import creates an Address Book by the name of the Import file. The addresses are found correctly, but all the FirstNames and Lastnames are missed, BUT Thunderbird put the first part of the email address in the Firstname field. I should say it is partially successful as I can go in and update the properties of each one, but what good is the import outside of adding 100's email addresses only ??? Double - triple checked the file format and the field selection / positioning scenarios of the import function...just stumped.

Всички отговори (1)

sfhowes
sfhowes
  • Top 10 Contributor
more options

Create a spreadsheet with these columns:

First Name, Last Name, Display Name, Nickname, Primary Email, Secondary Email, Work Phone, Home Phone

Leave a column empty if it's not relevant, then export to csv format, and then import to TB. Check that the input fields line up with the address book fields before the final import step.

http://kb.mozillazine.org/Import_address_list_from_text_file