Problems converting Sqmail .abook flatfiles into MySQL tables.

["Mike Swearingen" <mikes@xxxxxxxx>]

Hello,

 

 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.

 

Any Suggestions?

 

 

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','');

 

 

 

 Thanks,

 

 Mike Swearingen

------------------------------------------------------------------------------

-----
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