Importing Exsisting Folders/Messages/Address books

[phoenix]

Originally Posted by fmodola

That's true.
We're not member of the RHN so we can't have updates ... can we ?
That's why I'm going to install gcc from the install CDs.

Ah, that's why I use CentOS.

[kwinter]

Originally Posted by Sam Hunter

Attached is a little python program I wrote to convert the exported address books from either thunderbird (v1.0.7) or squirrelmail (1.4.4) to a Zimbra format. It is a pretty simple little program, with only minimal checking/cleaning, but it seems to work pretty well for me. Hopefully it will be usefull to someone else.

Sam

p.s. the extension is .txt so it will upload to this message board. For best results change it to .py, and under windows (and Linux) make sure to run it as follows:
python csv_conversion.py s squirrel_export.csv zim_import.csv

Thanks for the starter - it was of great help. I added a couple of fields in the thunderbird conversion (mobile, email2 and so forth).


Greetings,

Keith

[rdjurovich]

Originally Posted by Sam Hunter

Attached is a little python program I wrote to convert the exported address books from either thunderbird (v1.0.7) or squirrelmail (1.4.4) to a Zimbra format. It is a pretty simple little program, with only minimal checking/cleaning, but it seems to work pretty well for me. Hopefully it will be usefull to someone else.

Sam

p.s. the extension is .txt so it will upload to this message board. For best results change it to .py, and under windows (and Linux) make sure to run it as follows:
python csv_conversion.py s squirrel_export.csv zim_import.csv

Thanks for your excellent script Sam! Works a treat

[bowergo]

Originally Posted by KevinH

CSV is correct. To get the format (easy way) is just create a contact in a Zimbra test account with all the fields you are interested in. Export that contact then use that as a template for your imports. If that doesn't work let us know and we'll take a look. If you could post the CVS file then we can use it as a test case on our side.

The scripts are not an option for our user community. We created a simple csv file for Thunderbird 2.x that has one contact. Users can import this new address book with one entry. The entry is actually the Zimbra csv field names.

Once imported this new card can be copied to any address book. After this card is in the address book you export from Thunderbird as you would normally. Then open your csv file, remove the original headers & move the fake address to the top and now you can import into Zimbra. I expect this can be duplicated with any mail client...

[mlategan]

Have a look at my post here about the tool called dawn:

http://www.zimbra.com/forums/showthr...7887#post47887

It is by far the easiest way to solve the addressbook problem from just about any mail client.

[fcash]

Originally Posted by GertThiel

imapsync will not be able to authenticate to ZCS until you Enable clear text login for the IMAP service.
You can set that option under Global Settings > IMAP in zimbraAdmin.

Did I forget to tell you that, really

Newer versions of imapsync include --authmech options where you can set which login type to use. There's also --ssl options.

The version we have is 1.182. Works like a charm. Just migrated my 600 MB mailstore from our webmail server (running Cyrus) to our Zimbra server (running 5.0rc2).