[aeisecurity]

Hello everyone

i have been looking at ways of importing the companys current customer database data into a zen cart database the current database table headers are layed out as follows:

customerId | name | address | postcode | country | telephone | email | username | password | isWebMaster | isSalesAdmin | lastAccess | isAffiliate

the old database was created about 5 years ago without upgrading in mind and its HUGE

now i know most of this data is useless but the important information is there

unfortunatly not all the data is simply copy/paste

email (ok)
name (first and last names in one field, sometimes only a company name)
address (all in one line not always correct)
postcode (ok)
country (ok)
email (ok)
password (ok)

The only way i can see the data working on Zen Cart is to create a script to fill out the form and the data that i dont have filled with something along the lines of "PLEASE UPDATA DATA" because the zen cart database structure is a bit overwhelming.

the goal here is to migrate the customers to the new database and cart software without customers having to sign up again.

Can anyone point me in the righ direction for making a script that would

1) fill out a form with data from a partially filled database
2) submit the data and go to the next row in the database

Many Thanks

[blinn_shade]

Have you tried kicrosoft access or excel to switch over the data?

[aeisecurity]

Hello thanks for the quick reply

Yes i have tried porting the data via excel but the database structure in Zen Cart is spread over more than one table unlike the current database and i dont know if it will all work once imported.

[End User]

You'll need a script that reads the existing database row-by-row doing transforms on the data. For things like the name field a series of simple tests could decide what to do with it. Addresses are considerably more difficult, but they could be processed repeatedly and then passed or failed depending on the result. Some of the data will very likely be impossible to import properly in a purely programmatic fashion.

[Jay6390]

Originally Posted by End User

Some of the data will very likely be impossible to import properly in a purely programmatic fashion.

Agreed. I highly doubt this will all be possible from a script alone

[aeisecurity]

Hello

Is this possible to accomplish? what is the best way of going about this if not with a php script.

Many Thanks.

[End User]

Originally Posted by aeisecurity

Is this possible to accomplish?

Allow me to repeat myself: You'll need a script that reads the existing database row-by-row doing transforms on the data. For things like the name field a series of simple tests could decide what to do with it. Addresses are considerably more difficult, but they could be processed repeatedly and then passed or failed depending on the result. Some of the data will very likely be impossible to import properly in a purely programmatic fashion.

Originally Posted by aeisecurity

what is the best way of going about this if not with a php script.

If you can't do it programmatically then you may want to consider hiring someone to transfer the info through basic data entry. Or, transfer as much as you can via a script and have them do what can't be parsed, like the addresses.

[Jay6390]

Originally Posted by End User

Allow me to repeat myself

LOL, sometimes I wonder if people actually read responses, since both me and you quite clearly stated it is HIGHLY unlikely that it will be possible