Please don't top post. Read the mailing list posting guidelines before posting. >>> I was hoping someone can help with converting the .abook flatfiles into >>> mysql records. We were able to generate a sql script that should allow us >>> to >>> import all the .abooks by using the flat2sql.pl file that was supplied >>> from >>> http://www.squirrelmail.org/docs/admin/admin-5.html#db-backend, but as you >>> can see below the INSERT command attempts to add multiple enteries in the >>> same sqmail.address table. This of course generates a sql error. The >>> error >>> references duplicate entry's for this one record. >>> >>> As you guess this user has more than one address in their .abook record. >> >> PRIMARY KEY (owner,nickname) is going to give you trouble if all your >> nicknames are '' >> >> Maybe change it to PRIMARY KEY (owner,email) ? > > Actually the problem seems to be with multiple entries with the same owner > name Then show the contents of the original .abook file >> INSERT INTO sqmail.address (owner,nickname,firstname,lastname,email,label) >> VALUES ('jcmerchant','','','Real Name','email.name@company',''); >> >> INSERT INTO sqmail.address (owner,nickname,firstname,lastname,email,label) >> VALUES ('jcmerchant','','','Real Name','email.name@company',''); >> >> INSERT INTO sqmail.address (owner,nickname,firstname,lastname,email,label) >> VALUES ('jcmerchant','','','Hoksbergen','edsylvia@xxxxxxxxxxxxxxx',''); >> >> INSERT INTO sqmail.address (owner,nickname,firstname,lastname,email,label) >> VALUES ('jcmerchant','','','Nancy King','njking@xxxxxxxxxxx',''); >> >> INSERT INTO sqmail.address (owner,nickname,firstname,lastname,email,label) >> VALUES ('jcmerchant','','','Krish & Bob >> Fennessy','nana1950@xxxxxxxxxxx',''); >> >> INSERT INTO sqmail.address (owner,nickname,firstname,lastname,email,label) >> VALUES ('jcmerchant','','','Rita Glasscock','plcrc@xxxxxxx',''); ------------------------------------------------------------------------------ ----- squirrelmail-users mailing list Posting guidelines: http://squirrelmail.org/postingguidelines List address: squirrelmail-users@xxxxxxxxxxxxxxxxxxxxx List archives: http://news.gmane.org/gmane.mail.squirrelmail.user List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
