bugzilla.mozilla.org will be intermittently unavailable on Saturday, March 24th, from 16:00 until 20:00 UTC.

Import of text (csv/tab) address book shows only 1st 36 fields



MailNews Core
Address Book
15 years ago
6 years ago


(Reporter: dave b, Unassigned)


(Depends on: 1 bug)

Windows 2000

Firefox Tracking Flags

(Not tracked)




15 years ago
User-Agent:       Opera/7.01 (Windows NT 5.0; U)  [en]
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.3b) Gecko/20030210

When I do a address book import from a csv file with more than 36 fields, in 
this case created by Outlook export, the mapping of address book fields to 
import record fields only presents the 1st 36 fields of the import record. 
Making the remaining fields unavailable.

This would allow mapping fields that are not directly supported in Mozilla to be 
mapped to Mozilla Custom fields, overcoming some limitations such as the Oulook 
import, which drops unmatched fields, and has bugs such as not importing Notes 
(bug 157722)

Reproducible: Always

Steps to Reproduce:
1.Go to Address Book, Tools, Import, Address Book, next, text file, next

2.select a csv file with more than 36 fields or columns.

3.Import Address book mapping dialog appears

Actual Results:  
The mapping of address book fields to import record fields only presents the 1st 
36 fields of the import record. 

Expected Results:  
In this case where there are more fields in the import record than the Mozilla 
addressbook can store, I want to see all the import fields and all the 
Addressbook fields so I can map any 2 fields. 

There is some relationship to 117852
Product: Browser → Seamonkey

Comment 1

14 years ago
I see the same thing on thunderbird 1.0 rc1 - is it the same code these days?
Assignee: racham → nobody
Component: Address Book → MailNews: Address Book
Product: Mozilla Application Suite → Core
QA Contact: nbaca → addressbook
Ever confirmed: true


10 years ago
Product: Core → MailNews Core


9 years ago
Depends on: 95087


9 years ago
Duplicate of this bug: 461401

Comment 3

9 years ago
In Tbird U2U support newsgroup, the workaround we have recommended is use of a spreadsheet application to adapt the export to better match the Tb fields.  What we seem to be lacking is user documentation of all 72 or so fields available in Abook.mab for use as a guide to re-structuring the *.csv in a spreadsheet environment.
Summary: Import csv address book shows only 1st 36 fields → Import of text (csv/tab) address book shows only 1st 36 fields
Duplicate of this bug: 507240

Comment 5

6 years ago
At least, it would be nice to see an obvious information like "Only the first 36 fields supported"!

But how much work would it be to fill up the Thunderbird field list with dummy entries like "NO IMPORT"?
I mean, if I have a CSV file with 50 fields, then this dialogue could offer the first 36 entries with TB fields and the following 14 with "no import" dummy fields. So the user could at least see and rearrange them.

This would have some advantages:
- More obvious and intuitive handling.
- No need for a workaround in a spreadsheet application.

Especially if you want to appeal to appeal to Outlook users that could ease migration, because direct Outlook PST import suffers several flaws.
You need to log in before you can comment on or make changes to this bug.