본 사이트는 여러분의 사용자 경험을 개선하기 위해 유지 보수를 진행하는 동안 기능이 제한됩니다. 도움말로 문제가 해결되지 않고 질문을 하고 싶다면 Twitter의 @FirefoxSupport 및 Reddit의 /r/firefox 채널을 활용하세요.

Mozilla 도움말 검색

고객 지원 사기를 피하세요. 저희는 여러분께 절대로 전화를 걸거나 문자를 보내거나 개인 정보를 공유하도록 요청하지 않습니다. "악용 사례 신고"옵션을 사용하여 의심스러운 활동을 신고해 주세요.

자세히 살펴보기

How to prevent scrambled import of contacts from csv file

  • 8 답장
  • 6 이 문제를 만남
  • 16 보기
  • 최종 답변자: cliffcoggin

more options

I imported 693 contacts from a csv file to Thunderbird address book after much swearing and cursing. Most of them seem to have displayed correctly, but about 30 are scrambled so that, for example, postcode shows in the name field, or name shows in phone number field. I have checked that the csv file for those entries are correct, so something must have gone wrong during import. How can put this right?

I imported 693 contacts from a csv file to Thunderbird address book after much swearing and cursing. Most of them seem to have displayed correctly, but about 30 are scrambled so that, for example, postcode shows in the name field, or name shows in phone number field. I have checked that the csv file for those entries are correct, so something must have gone wrong during import. How can put this right?

모든 댓글 (8)

more options

Sounds like you did not match the data with the fields Thunderbird expects to see. Here is a pretty good tutorial. https://www.howtogeek.com/79968/import-gmail-contacts-into-thunderbird/

more options

Thank you, but I must have done something right as 660 records imported correctly while only 30 were wrong. It seems that the wrong ones did not have either a full name or a full address in the csv file. Does that mean each of the 693 records has to be manually adjusted during the import process?

more options

No you do it once for the entire import. I would say you those 30 records were not in the same order as the successful ones.

Examine your CSV file and confirm the same data is in the correct columns.

more options

I have been over the whole csv file, (trimming it down to 470 records in the process,) and not found any errors. Reinstalling the address book still scrambles some of the records. Any further ideas?

more options

No, it is a pretty straightforward process that has worked fine every time I use it.

Is it the same contacts that are not correct each time you import?

글쓴이 user01229325 수정일시

more options

That's a blow. Without my contacts list Thunderbird will not work for me, and without email the change from Windows to Linux is no longer viable.

I have read elsewhere of extensions such as Tzpush which enable the import of address book, but the extension is incomprehensible to me. Are such extensions of any value?

more options

I have never used or heard of them so I cannot advise.

If all but 30 import correctly what is wrong with just fixing the few with errors?

more options

Yes I could correct those that are obviously wrong, but I would then doubt whether the other 440 records are right, and that is too many to manually check and correct.