Bulk updates

[kurt.santo]

Work since a while on ideas/code for site of a friend's furniture business. Having too much trouble with his backend system he is using, we decided to have a separate database for his website (before we would have gotten all the item data across the internet from his other system).As he does not want to spend hours updating both systems (he has to keep the other system for internal processes for now) I wondered what the easiest way would be to extract the item data from his existing database to populate the new database (and do similar bulk updates when he updates the other system). He can export in Excel or as comma separated values. If we were then to match the column heading exactly with the columns of the new database how would we get all the data in one go as such?Any help appreciated.Kurt

[Synook]

Is it an MySQL database? Many systems can export databases as a series of CREATE and INSERT queries (which you then use on the new database), in MySQL you can use phpMyAdmin's "Export" feature to do this.Updating both systems at the same time won't be so easy though. If you can modify the old system then you could, say, if it was PHP/MySQL, just change the mysql_connect() statements so it connects to the new database server instead of the old one.

[kurt.santo]

Is it an MySQL database? Many systems can export databases as a series of CREATE and INSERT queries (which you then use on the new database), in MySQL you can use phpMyAdmin's "Export" feature to do this.Updating both systems at the same time won't be so easy though. If you can modify the old system then you could, say, if it was PHP/MySQL, just change the mysql_connect() statements so it connects to the new database server instead of the old one.

To tell you the truth: I do not have a clue what database it is. We cannot directly access it, just use what is given (the product is under "http://www.netsuite.co.uk/portal/uk/developers/main.shtml"). We just know that we can export the product data. We do not need to automate an update on both systems. It is fine for my friend to do it manually on his system. It is just that afterwards we do not want to do the same manually again. Is there nothing like a "Import" feature in phpMyAdmin, where we could at least initially (better later on as well) get all the products in in one go?Kurt

[justsomeguy]

Yes, you can import using phpMyAdmin. You can import a CSV file, you upload the file and tell it the column order that things are in. Click on import in phpMyAdmin to see.

[kurt.santo]

Yes, you can import using phpMyAdmin. You can import a CSV file, you upload the file and tell it the column order that things are in. Click on import in phpMyAdmin to see.

Cheers. Will give it a go...Kurt