We're calling on all EU-based Mozillians with iOS or iPadOS devices to help us monitor Apple’s new browser choice screens. Join the effort to hold Big Tech to account!

搜索 | 用户支持

防范以用户支持为名的诈骗。我们绝对不会要求您拨打电话或发送短信,及提供任何个人信息。请使用“举报滥用”选项报告涉及违规的行为。

详细了解

moving contacts from Outlook to Thunderbird

  • 10 个回答
  • 1 人有此问题
  • 66 次查看
  • 最后回复者为 sfhowes

more options

I took the contacts from Outlook 2010 (3000) to a CSV file then imported to TB like many articles say but the email addresses do not appear. Looking at the CSV file on Excel the email addresses appear in column "BF". I cannot figure out how to correctly "align" the entries...I must be doing something wrong.

thanks, Gene

I took the contacts from Outlook 2010 (3000) to a CSV file then imported to TB like many articles say but the email addresses do not appear. Looking at the CSV file on Excel the email addresses appear in column "BF". I cannot figure out how to correctly "align" the entries...I must be doing something wrong. thanks, Gene

被采纳的解决方案

Edit your spreadsheet down to just 5 columns, with the first row labelled First Name, Last Name, Display Name, Nickname, Primary Email. Leave a column empty if you don't use it. When you import the csv, check that the input columns match the Address book fields using move up/down.

Tools/Import...Address books...Text file... select Comma separated in the File type filter (defaults to LDIF), select the csv.

定位到答案原位置 👍 1

所有回复 (10)

more options

You should try and arrange the columns in Excel to match the TB address book structure:

http://kb.mozillazine.org/Import_address_list_from_text_file

An alternate method is to export the contacts as vCards and import to TB with the help of an add-on.

more options

OK, i figured out how to delete and move columns in excel (acyually Libre Calc). It appears the file columns need to "line up" with TB columns....right? All I need is name and email...suggestions?

thanks, Gene

more options

选择的解决方案

Edit your spreadsheet down to just 5 columns, with the first row labelled First Name, Last Name, Display Name, Nickname, Primary Email. Leave a column empty if you don't use it. When you import the csv, check that the input columns match the Address book fields using move up/down.

Tools/Import...Address books...Text file... select Comma separated in the File type filter (defaults to LDIF), select the csv.

more options

Can anyone explain? CSV file with up to 6 columns. (First Name, Last Name, Display Name, Nickname, Primary Email, Company). The scv import tool with commas does not import First Name, Last Name, Display Name the first time. The next time you run the tool, with the same csv file and settings, only Display Name is imported :(

Example csv: First Name, Last Name, Display Name, Nickname, Primary Email, Company Miroslawa Witecka,,dyr.Miroslawa Witecka,,kontakt@pm109.elodz.edu.pl,PRZEDSZKOLE NR 109 - Z MALGORZATA FRASZ,,dyr.MALGORZATA FRASZ,,kontakt@pm97.elodz.edu.pl,PRZEDSZKOLE NR 97 Malgorzata Tomczak,,dyr.Malgorzata Tomczak,,kontakt@pm139.elodz.edu.pl,PRZEDSZKOLE NR 139

How to win with this tool?

more options

Your csv should not have spaces before the field labels, i.e. the first line should be:

First Name,Last Name,Display Name,Nickname,Primary Email,Company

With that change, the csv imports correctly (see picture), but you have to click the 'Move Up' button for Organization in the left column so it lines up with Company in the right column.

You might want to also change the records so the First and Last names are entered, e.g. the first contact should be:

Miroslawa,Witecka,dyr.Miroslawa Witecka,,kontakt@pm109.elodz.edu.pl,PRZEDSZKOLE NR 109 - Z

That way, the contacts will appear in Address Book for any setting of View/Show Name As.

more options

Thank you for the advice. At the beginning I removed the spaces from the beginning and end of each record. The effect is the same. There are two different results of importing a file. I attach screenshots.


imported file: First Name,Last Name,Display Name,Nickname,Primary Email,Company Mirosława,Witecka,dyr.Mirosława Witecka,,kontakt@pm109.elodz.edu.pl,PRZEDSZKOLE MIEJSKIE NR 109 - Z ODDZIAŁAMI INTEGRACYJNYMI MAŁGORZATA,FRASZCZYŃSKA-SADOWSKA,dyr.MAŁGORZATA FRASZCZYŃSKA-SADOWSKA,,kontakt@pm97.elodz.edu.pl,PRZEDSZKOLE MIEJSKIE NR 97 MAŁGORZATA,Tomczak,dyr.Małgorzata Tomczak,,kontakt@pm139.elodz.edu.pl,PRZEDSZKOLE MIEJSKIE NR 139

more options

I've done some tests and find similar results, which are odd, to say the least.

With this csv: First Name,Last Name,Display Name,Nickname,Primary Email,Company Miroslawa,Witecka,dyr.Miroslawa Witecka,,kontakt@pm109.elodz.edu.pl,PRZEDSZKOLE NR 109 - Z MALGORZATA,FRASZ,dyr.MALGORZATA FRASZ,,kontakt@pm97.elodz.edu.pl,PRZEDSZKOLE NR 97 Malgorzata,Tomczak,dyr.Malgorzata Tomczak,,kontakt@pm139.elodz.edu.pl,PRZEDSZKOLE NR 139

the records import, but only the First, Last and Email appear for a contact.

With this csv: First Name,Last Name,Display Name,Nickname,Primary Email,Company Mirosława,Witecka,dyr.Mirosława Witecka,,kontakt@pm109.elodz.edu.pl,PRZEDSZKOLE MIEJSKIE NR 109 - Z ODDZIAŁAMI INTEGRACYJNYMI MAŁGORZATA,FRASZCZYŃSKA-SADOWSKA,dyr.MAŁGORZATA FRASZCZYŃSKA-SADOWSKA,,kontakt@pm97.elodz.edu.pl,PRZEDSZKOLE MIEJSKIE NR 97 MAŁGORZATA,Tomczak,dyr.Małgorzata Tomczak,,kontakt@pm139.elodz.edu.pl,PRZEDSZKOLE MIEJSKIE NR 139

only the Display Name and Organization appear for a contact. So, there are no common records in the two address books, and I can't see that the presence of special characters in the 2nd one explains the difference.

Edit: With TB 70b2, the first csv appears to import, but it shows no contacts. The second imports correctly (see picture). The text encoding of the successful csv import had been changed to UTF-8 Unicode. When the encoding of the first was converted from Western 1252 W. European to UTF-8, it then imported correctly. UTF-8 encoding did not affect the results in TB 68.1.

由sfhowes于修改

more options

Thank you very much for your time :) Isn't that weird? Just reading the next fragments of the text string to find the next comma and writing in the database fields until the end of the line is reached, but it doesn't work properly :( I will keep testing.

more options

It's also odd that when you're at the import dialog where the categories are moved up or down, you can step through the csv (click Next, Previous) and see that all the records are read in their proper places, but not when the process is finished.

I imported a csv to Gmail, but there too, the First Name and Last Name records were not imported.

If I had hundreds of contacts to import, I'd be inclined to install 70b2 in a separate directory, run it in its own profile, import the csv, export it to LDIF, then import the LDIF to 68.1 (or copy the abook.mab from one profile to the other).

I'm not aware of any changes to importing between TB 60 and 68, let alone 68 and 70, but this is an operation that should be nearly bullet-proof, given the frequency of its application.

more options

The CardBook add-on can import vcf and csv files, and applying it to the Unicode csv above provides a correct result.