search

RainLoop / rainloop-webmail

Simple, modern & fast web-based email client
http://rainloop.net
MIT License
4.09k stars 881 forks source link

Addressbook CSV Import from Thunderbird #960

Open anoxi opened 8 years ago

anoxi commented 8 years ago

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 commented 8 years ago

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

anoxi commented 8 years ago

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 commented 8 years ago

@anoxi Thanks.

kanrisya commented 8 years ago

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 commented 8 years ago

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

kanrisya commented 8 years ago

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 https://github.com/RainLoop/rainloop-webmail/issues/960#issuecomment-228139494, or mute the thread https://github.com/notifications/unsubscribe/ATJrxKI7zcE9Mxm5H0HLkJpZ3RILwbPFks5qOs8fgaJpZM4Hd5oL.

kanrisya commented 8 years ago

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 https://github.com/RainLoop/rainloop-webmail/issues/960#issuecomment-228139494, or mute the thread https://github.com/notifications/unsubscribe/ATJrxKI7zcE9Mxm5H0HLkJpZ3RILwbPFks5qOs8fgaJpZM4Hd5oL.

ghoeffner commented 4 years ago

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