Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Addressbook CSV Import from Thunderbird #960

Open
anoxi opened this issue Feb 19, 2016 · 8 comments
Open

Addressbook CSV Import from Thunderbird #960

anoxi opened this issue Feb 19, 2016 · 8 comments

Comments

@anoxi
Copy link

@anoxi anoxi commented Feb 19, 2016

Imported addresses from Thunderbird miss the email address, because Thunderbird uses "Primary Email" instead of "Email" as column header. Also some kind of help/documentation of the csv import would be nice what columns are expected, thanks.

@RainLoop
Copy link
Owner

@RainLoop RainLoop commented Feb 19, 2016

Could you give me (support@rainloop.net) your CSV file for testing. It will help me improve this functionality.

@anoxi
Copy link
Author

@anoxi anoxi commented Feb 19, 2016

Example CSV Export from Thunderbird:

First Name,Last Name,Display Name,Nickname,Primary Email,Secondary Email,Screen Name,Work Phone,Home Phone,Fax Number,Pager Number,Mobile Number,Home Address,Home Address 2,Home City,Home County,Home Post Code,Home Country,Work Address,Work Address 2,Work City,Work County,Work Post Code,Work Country,Job Title,Department,Organisation,Web Page 1,Web Page 2,Birth Year,Birth Month,Birth Day,Custom 1,Custom 2,Custom 3,Custom 4,Notes
XXX,XXX,XXX XXX,,XXX@XXX.XX,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
...

@RainLoop
Copy link
Owner

@RainLoop RainLoop commented Feb 19, 2016

@anoxi Thanks.

RainLoop added a commit that referenced this issue May 17, 2016
@kanrisya
Copy link

@kanrisya kanrisya commented Jun 22, 2016

I tested rainloop 1.10.1 on my Debian Wheezy; I tried to import a CSV file, which was exported from Thunderbird 38.7.2. But, I failed. Nothing can be imported.

The CSV file is written in Japanese, which might have caused the problem.

As a trial, I replaced the top line (in Japanese) with its English counterpart. Then, only e-mail addresses have been imported, whereas Name, Phone, etc. have not been imported.

As another trial, I converted the CSV file, which was originally in Shift-JIS code, into UNICODE (UTF-8). But, nothing has been imported.

Could you help me?

@RainLoop
Copy link
Owner

@RainLoop RainLoop commented Jun 23, 2016

RainLoop supports CSV with english headers only.
Could you give me example file for test?

@kanrisya
Copy link

@kanrisya kanrisya commented Jun 24, 2016

Dear RainLoop Team,

Thank you for reply.

I am sending herewith two examples:

  1. TBadbook.csv: A CSV file, which was exported from TB. The header and addresses are in Japanese.
  2. TBadbook2.csv: A CSV file, in which the header is replaced with the English counterpart. Addresses are partly in Japanese.

With best regards,

kanrisya

On 2016/06/24 3:23, RainLoop Team wrote:

RainLoop supports CSV with english headers only.
Could you give me example file for test?

�$B!=�(B
You are receiving this because you commented.
Reply to this email directly, view it on GitHub #960 (comment), or mute the thread https://github.com/notifications/unsubscribe/ATJrxKI7zcE9Mxm5H0HLkJpZ3RILwbPFks5qOs8fgaJpZM4Hd5oL.

@kanrisya
Copy link

@kanrisya kanrisya commented Jun 24, 2016

I am sending also

  1. TBadbookU8.csv: UTF-8 encoded version of 1.
  2. TBadbook2U8.csv: UTF-8 encoded version of 2.

Thank you in advance.

On 2016/06/24 15:12, Akira SHIMIZU wrote:

Dear RainLoop Team,

Thank you for reply.

I am sending herewith two examples:

  1. TBadbook.csv: A CSV file, which was exported from TB. The header and addresses are in Japanese.
  2. TBadbook2.csv: A CSV file, in which the header is replaced with the English counterpart. Addresses are partly in Japanese.

With best regards,

kanrisya
shmzakr@gmail.com

On 2016/06/24 3:23, RainLoop Team wrote:

RainLoop supports CSV with english headers only.
Could you give me example file for test?

�$B!=�(B
You are receiving this because you commented.
Reply to this email directly, view it on GitHub #960 (comment), or mute the thread https://github.com/notifications/unsubscribe/ATJrxKI7zcE9Mxm5H0HLkJpZ3RILwbPFks5qOs8fgaJpZM4Hd5oL.

@ghoeffner
Copy link

@ghoeffner ghoeffner commented Jan 7, 2020

A csv from thunderbird with German headers does not work. Replacing the header with the following (taken from a post here) works flawlessly.

First Name,Last Name,Display Name,Nickname,Primary Email,Secondary Email,Screen Name,Work Phone,Home Phone,Fax Number,Pager Number,Mobile Number,Home Address,Home Address 2,Home City,Home County,Home Post Code,Home Country,Work Address,Work Address 2,Work City,Work County,Work Post Code,Work Country,Job Title,Department,Organisation,Web Page 1,Web Page 2,Birth Year,Birth Month,Birth Day,Custom 1,Custom 2,Custom 3,Custom 4,Notes

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
4 participants
You can’t perform that action at this time.