Re: [SM-USERS] some quick and dirty sql - conversion scripts

2004-01-29 Thread Jay Lee
Great! I've been looking for something just like this myself as I'd love to move to MySQL from the flat .pref and .abook files. Do you have them on a website or did you mean to attach them? Jay ~ Jay Lee Network / Systems Administrator Information Technology Dept. P

[SM-USERS] some quick and dirty sql - conversion scripts

2004-01-28 Thread Nino Novak
From a need to store the .pref and .abook stuff into MySQL - and without any perl skills I just set up two "mini-scripts" for populating MySQL. Maybe someone else will find them usefull, too. Cheers Nino --- The SF.Net email is sponsored by

Re: [SM-USERS] some quick and dirty sql - conversion scripts

2004-01-26 Thread Jay Lee
I just tried the script on about 1,000 .pref and .abook files and it seems to work pretty well! The only problem I found was it doesn't take into account the possiblity of ' characters in the .abook file. I don't know my SQL as well as PHP but maybe it needs to convert ' to \' ? Other than that

Re: [SM-USERS] some quick and dirty sql - conversion scripts

2004-01-26 Thread Nino Novak
On Monday 26 January 2004 16:10, Jay Lee wrote: > Great! I've been looking for something just like this myself as > I'd love to move to MySQL from the flat .pref and .abook files. Do you > have them on a website or did you mean to attach them? you're right, I forgot to attach the file... he