Jump to content

Bulk updates


kurt.santo
 Share

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...