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!

Avatar for Username

Шукати в статтях підтримки

Остерігайтеся нападів зловмисників. Mozilla ніколи не просить вас зателефонувати, надіслати номер телефону у повідомленні або поділитися з кимось особистими даними. Будь ласка, повідомте про підозрілі дії за допомогою меню “Повідомити про зловживання”

Докладніше

Ця тема перенесена в архів. Якщо вам потрібна допомога, запитайте.

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

  • 1 відповідь
  • 1 має цю проблему
  • 7 переглядів
  • Остання відповідь від 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.

Усі відповіді (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