Mozilla VPN is currently experiencing an outage. Our team is actively working to resolve the issue. Please check the status page for real-time updates. Thank you for your patience.

Avatar for Username

Kërkoni te Asistenca

Shmangni karremëzime gjoja asistence. S’do t’ju kërkojmë kurrë të bëni një thirrje apo të dërgoni tekst te një numër telefoni, apo të na jepni të dhëna personale. Ju lutemi, raportoni veprimtari të dyshimtë duke përdorur mundësinë “Raportoni Abuzim”.

Mësoni Më Tepër

Kjo rrjedhë është arkivuar. Ju lutemi, bëni një pyetje të re, nëse keni nevojë për ndihmë.

How to parse mobile, home, work phone numbers when exporting contacts to a csv file?

  • 1 përgjigje
  • 1 e ka hasur këtë problem
  • 7 parje
  • Përgjigjja më e re nga sfhowes

j.b.stone
j.b.stone
more options

When I transitioned to Thunderbird Email, it was not immediately apparent to me that in Contacts the first number, second number, etc were unique to each contact. So - For example, I have many contacts where first number is home, others where first is work, and of course many where first is mobile. When I export the contacts to a csv, the numbers are exported by column, rather than by label. In addition to my personal contacts, I am maintaining a civic organization contact list. We want to be able to pull mobile numbers for group text notifications, but the Thunderbird export data in the current form is useless. Is there a way to export by label? The only other solution I can come up with would be to individually redo each entry with standardized 1st number etc. This would be many hundreds of entries.

When I transitioned to Thunderbird Email, it was not immediately apparent to me that in Contacts the first number, second number, etc were unique to each contact. So - For example, I have many contacts where first number is home, others where first is work, and of course many where first is mobile. When I export the contacts to a csv, the numbers are exported by column, rather than by label. In addition to my personal contacts, I am maintaining a civic organization contact list. We want to be able to pull mobile numbers for group text notifications, but the Thunderbird export data in the current form is useless. Is there a way to export by label? The only other solution I can come up with would be to individually redo each entry with standardized 1st number etc. This would be many hundreds of entries.

Krejt Përgjigjet (1)

sfhowes
sfhowes
  • Top 10 Contributor
more options

I don't know how you arrived at an address book with the wrong type of phone numbers in the different fields, perhaps they were imported from another app, but TB stores phone numbers in distinct fields: Work, Home, Fax, Pager and Mobile. If an address book is exported to a csv and viewed in a spreadsheet or similar, the numbers are in separate columns. There is no 'label' attached to a phone number - the column header indicates the type of number. You will have to edit the csv to put numbers in the right columns, and then import it back to TB, taking care to align the input fields with the address book fields.

http://kb.mozillazine.org/Import_address_list_from_text_file