Hi all,

I installed the OsCommerce Data Importer and started testing it out on a test db to see how it would work.. as I am migrating from OSc to Zen.

I found 2 problems that someone could perhaps help me with.

1. I have a table prefix. I hardcoded it in the sql statements (my zen tables starts with zen_) Any ideas on how to add a prefix? I'd be happy to submit it back as a contribution for download when I was done.

2. I am getting errors any time an apostrophe is used. (for example, I have a customer name that is O'Connor) which causes the process to fail. I could go through and modify each customer name, but since I haven't reached the part where I start loading product descriptions, I'm sure I haven't seen the last of this pesky problem. Isn't there a quick way to account for this within a script? Like... stripslashes/addslashes? Forgive me for talking out of my ######## here since I'm not an accomplished PHP programmer. If anyone could look at the code here and start me out, I'll update and test!

Any help would be appreciated!

Thanks,
Albert