Avatar for Username

Pesquisar no site de suporte

Evite golpes de suporte. Nunca pedimos que você ligue ou envie uma mensagem de texto para um número de telefone, ou compartilhe informações pessoais. Denuncie atividades suspeitas usando a opção “Denunciar abuso”.

Saiba mais

Esta discussão foi arquivada. Faça uma nova pergunta se precisa de ajuda.

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

  • 1 resposta
  • 1 tem este problema
  • 7 visualizações
  • Última resposta de 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.

Todas as respostas (1)

sfhowes
sfhowes
  • Top 25 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