.csv address export from Thunderbird to Outlook07 only showed name

[Mrs G Chew]

Hello,

I attempted to export my Thunderbird address book via comma separation.
Outlook displayed the names (plus a very large number of blank records) but
no email addresses. If I open the .csv file manually (it uses Excel to do
that) I can see all the information.

Please can you advise further?

Regards
Glenys Chew

 

[Gordon]

Hello,

I attempted to export my Thunderbird address book via comma separation.
Outlook displayed the names (plus a very large number of blank records)
but
no email addresses. If I open the .csv file manually (it uses Excel to do
that) I can see all the information.

Please can you advise further?

Regards
Glenys Chew

Well the first thing I would do is to manually create a full contact in
Outlook, export to csv and then compare the two files.....

 

[Mrs G Chew]

I'm sorry, I'm not sure I understand what you mean, and I may have
inaccurately described what I did before. I was importing into Outlook07
from Thunderbird. I can't choose any of the information that is exported,
unless I go through Excel and wipe out the unwanted columns manually.

Do you mean that there is some kind of incompatibility between the fields?
That's why I need to compare the files?

Regards
Glenys

 

[Gordon]

I'm sorry, I'm not sure I understand what you mean, and I may have
inaccurately described what I did before. I was importing into Outlook07
from Thunderbird. I can't choose any of the information that is exported,
unless I go through Excel and wipe out the unwanted columns manually.

Do you mean that there is some kind of incompatibility between the fields?
That's why I need to compare the files?

Yes. If you do an export from Outlook after creating a (fictional if
necessary) fully-detailed contact into a csv file and compare the file from
Outlook with the file that was exported from Thunderbird, then manipulate
the Thunderbird file so it is exactly the same format as the Outlook one,
you eliminate at a stroke any possibility of mismatched fields...

 

[Gordon]

I'm sorry, I'm not sure I understand what you mean, and I may have
inaccurately described what I did before. I was importing into Outlook07
from Thunderbird. I can't choose any of the information that is exported,
unless I go through Excel and wipe out the unwanted columns manually.

Do you mean that there is some kind of incompatibility between the fields?
That's why I need to compare the files?

The other alternative is to re-install TBird (if you've uninstalled it), set
up a free Gmail account and download and install the Thunderbird Gmail
Contacts synchroniser extension. Then you can synch your TBird contacts with
Gmail. You can then download a similar utility for Outlook and synch the
Outlook contacts with Gmail....

 

[Mrs G Chew]

My husband uses gmail. Thank you very much, I'll ask him to do that this
evening.

God bless your weekend

Regards
Glenys

 

[Brian Tillman [MVP - Outlook]]

I attempted to export my Thunderbird address book via comma separation.
Outlook displayed the names (plus a very large number of blank records) but
no email addresses. If I open the .csv file manually (it uses Excel to do
that) I can see all the information.

Sounds like you haven't properly mapped the fields for the import.

 

[Karl Timmermans]

Your description of the problem is typical of <NOT> manually mapping the
fields during the import process (manually mapping fields is done via the
<Map Custom Fields> button). Ensure that whatever the column names are in
the CSV file correspond to the fields you want those imported to in Outlook.
There is no need to change any names in the TBird file to correspond to
Outlook names. Manually mapping is a 2 minute process which saves endless
problems and time and far more accurate than any <auto-map> function. (This
of course assumes that the first row in the CSV file is a <header row>
containing the individual column names for all the rows that follow).

Re: Email Address - make sure that this is mapped to the field <E-mail
Address> (found by expanding the E-mail field name - click on plus sign).
There is no need to map anything to <E-mail Display Name> or <E-mail Type>
(will be auto filled by Outlook).

Re: Empty records - if you are getting blank records when importing the
TBird file - means that you have empty records in the CSV file. Oopen the
file in NotePad or other text editor and see if you have rows with just
commas and nothing else - delete any of those rows that you find. If you
don't see any blank lines in the middle of your data when opening the file
in Excel - then you will find the empty rows at the end of the CSV file.

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com

 

[Mrs G Chew]

Dear Karl & Brian,

Thank you for your replies, we have hit the end of school and my time on the
pc is now severely limited.

I have never attempted a file transfer of this sort before, and have never
heard of mapping, although I gather the general procedure from your comments.
Thank you for your instructions, I will take them away and try to follow
them.

Regards

Glenys