Importing Exsisting Folders/Messages/Address books

[schemers]

No support for LDIF files at this point.

The interface for defining field mappings in CSV files is normally the first line of the file. For example:

"First Name","Last Name","E-mail Address"
"John","Doe","john@doe.com"

At some point in the future we'll probably have more options for importing (LDIF, vcards, a specific CSV flavor (thunderbird, yahoo, etc)), but at this point we require the mappings as the first line of the file, which we use to map into our contact model.

We've successfully imported Thunderbird, Yahoo, Google, and various forms of Outlook CSV files.

As KevinH pointed out, the best way to see what fields we natively support is to completely populate a contact within Zimbra, and do a CSV export.

[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

[renzochavez77]

Hello......I need a little help...... My old server have Postfix + Imp , i was using horde. Now. i already install zimbra.. Its nice, works very good..! but, what about the spools or the messages of all the accounts of the old server?? Actually, in my old server all the spools are in the folder /var/spool/mail, one file per user... In zimbra the messages are in /opt/zimbra/store/0/msg/0/1,2.3... etc..one folder per user, and each message is a file.., and each file is associate whith a database record.. .and each user have a database in mysql,..! Is there anyone that know, how can i migrate the spools of the users that worked with horde to Zimbra..???.
Tanks...

Renzo Chavez

[KevinH]

zmlmtpinject is your friend. It should be able to load these files into each user's account. You may need to pre-process them a little but it should work.

Do you have IMAP access by chance? If so imapsync is your best bet.

[renzochavez77]

Thaks.. It Works!!!! ..Imapsync is amazing!!!! .. Only i have a one problem... I how can i import the contacts of each user.?????????????????
I'm using the open source edition and dont have the migration tools......Thanks for your help. (Gracias causita)

Renzo Chavez V.

[KevinH]

Easy way is to export to .csv and import under options.

[renzochavez77]

Good.. I found that option...!
Thaks
Renzo

[icedutah]

I ran imapsync like this: ./imapsync --nosyncacls --syncinternaldates --noauthmd5 --folder INBOX --host1 server1.com -user1 xxxxx --password1 xxxxxxxx --host2 server2.com -user2 xxxxx --password2 xxxxxxxx

It only copies over the most current messages in the INBOX folder up to the date of 10/11/05. It skips the older messages. Why is it not getting all messages in the specified folder.

The server it's getting them from is running Postifx + courier-imap.

[KevinH]

Originally Posted by icedutah

I ran imapsync like this: ./imapsync --nosyncacls --syncinternaldates --noauthmd5 --folder INBOX --host1 server1.com -user1 xxxxx --password1 xxxxxxxx --host2 server2.com -user2 xxxxx --password2 xxxxxxxx

It only copies over the most current messages in the INBOX folder up to the date of 10/11/05. It skips the older messages. Why is it not getting all messages in the specified folder.

The server it's getting them from is running Postifx + courier-imap.

Not sure. You may want to try without the folder flag and see if that helps. Not sure anyone else has had this problem.

[marcmac]

Originally Posted by icedutah

I ran imapsync like this: ./imapsync --nosyncacls --syncinternaldates --noauthmd5 --folder INBOX --host1 server1.com -user1 xxxxx --password1 xxxxxxxx --host2 server2.com -user2 xxxxx --password2 xxxxxxxx

It only copies over the most current messages in the INBOX folder up to the date of 10/11/05. It skips the older messages. Why is it not getting all messages in the specified folder.

The server it's getting them from is running Postifx + courier-imap.

Are the dates on the 2 boxes in sync? I assume you did --user1/--user2 (not -user1/-user2). Did you try explicitly setting maxage/minage?