kaffy Posted June 8, 2009 Posted June 8, 2009 Hiya, Having looked through the threads I see that it wouldn't be beyond my capabilities to transfer customers to my new oscom website if I didn't already have customers in the database, but I have. So can it be done without over-riding all the ones that are there already, and can any one give me a really easy to follow step by step guide to do it? I am guessing that I will need to change some customer ID's first. Many thanks in advance, kaffy
Guest Posted June 9, 2009 Posted June 9, 2009 If you go to PHPadmin panel you should be able to export the two and see, if anything what needs to be changed. You probably just need to copy one to the other using INSERT (which phpmyadmin panel will show you how if you download the data in sql form). So, take the one you are going to use and insert the old ones, should increment properly, shouldn't have to change any ids.
kaffy Posted June 9, 2009 Author Posted June 9, 2009 If you go to PHPadmin panel you should be able to export the two and see, if anything what needs to be changed. You probably just need to copy one to the other using INSERT (which phpmyadmin panel will show you how if you download the data in sql form). So, take the one you are going to use and insert the old ones, should increment properly, shouldn't have to change any ids. Hiya, thanks for answering. Went to 'insert' on the customer table and it will let me do them one at a time. But there must be a way of uploading them altogether as I have over a 1000 to transfer? Tried 'import' but it won't let me do that as the customer table already exists. Anything else I could try? Perhaps merging the 2 sql files together in excel first and then uploading them together?
Nullachtfuffzehn Posted June 9, 2009 Posted June 9, 2009 Did you set the hook at 'add IF NOT EXISTS' at the structure section while exporting the tables?
kaffy Posted June 9, 2009 Author Posted June 9, 2009 Did you set the hook at 'add IF NOT EXISTS' at the structure section while exporting the tables? I hadn't so I tried again with and got this error code: #1062 - Duplicate entry '8' for key 1
Nullachtfuffzehn Posted June 9, 2009 Posted June 9, 2009 That's because you have a customer with id=8 in your old database as well as in the new one. There are several ways to get around this. You can export the data from the old database as CSV and change the customer_id within your Excel or whatever you're using to a number that doesn't exist in the new database before importing. Also you can change the customer numbers in the new database via SQL-statement to avoid this conflict. But make sure to change both tables (customers and customers_info) the same way, otherwise the data will be messed up. BTW, did you make a backup of the new database before making any changes?
kaffy Posted June 9, 2009 Author Posted June 9, 2009 I hadn't so I tried again with and got this error code: #1062 - Duplicate entry '8' for key 1 Ok, changed the duplicate ID numbers and tried again. I have all the customers now transferred but minus any details other than their names. There must be another field I need to tick to save all information?
Nullachtfuffzehn Posted June 9, 2009 Posted June 9, 2009 Did you also export and import the customers_info table?
kaffy Posted June 9, 2009 Author Posted June 9, 2009 Did you also export and import the customers_info table? Hiya, no I hadn't - hadn't realised the data was stored in different tables. Nor have I exported/imported the address book. Will change the customer ID numbers within those later and give it a go. I'm thinking now that I may be able to transfer orders too in a similar way (changing customer ID and order ID)? A bit time consuming but it would be nice to have all the information in the same place. Thanks for your advice.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.