warrenerjm Posted January 7, 2008 Share Posted January 7, 2008 Hi Firstly I have 2000 products in my live database. I have set up another site with a different categories structure. Instead of redoing all these on the new admin>categories can I take the data & upload the products to the new categories? What will happen to the product id? Sorry I am having difficulties explaining what I need. Second I need to (at the last minute) take only the customers details/orders/points from the first database & move to the second. For the points & rewards I have used the same contribution so there shouldn't be any differences in the fields. For the customers the only addition is the titles which I assume just won't get filled? I have not put all the same contributions onto the second site as I didn't end up using 20% on the first anyhow! I CAN do the products :( but I obviously can't do the customers details, so this does need to be moved over, or it wouldn't look good to ask them all to register again. Even if someone could help me with a technical term for what I am trying to do, I could comtinue the search. Thanks Julie Link to comment Share on other sites More sharing options...
Guest Posted January 7, 2008 Share Posted January 7, 2008 For the products that is easy, install a contribution named Easy Populate, install it on the old and new website and export your products from your old website then import them on to your new website. As for the customers details am sorry I don't know, I've been looking for a solution also but without messing about with the database itself I haven't found anything else. You could always make a backup of your database using the backup feature in the admin section of your old website, download it to your computer, rename it to oscommerce.sql and put it into the install folder of your new website, run install and it will have EVERYTHING your old website has got, you would need to redo anything which your new website has got which your old one doesn't for example the categories and maybe a few sql installations from contributions. Link to comment Share on other sites More sharing options...
warrenerjm Posted January 7, 2008 Author Share Posted January 7, 2008 For the products that is easy, install a contribution named Easy Populate, install it on the old and new website and export your products from your old website then import them on to your new website. As for the customers details am sorry I don't know, I've been looking for a solution also but without messing about with the database itself I haven't found anything else. You could always make a backup of your database using the backup feature in the admin section of your old website, download it to your computer, rename it to oscommerce.sql and put it into the install folder of your new website, run install and it will have EVERYTHING your old website has got, you would need to redo anything which your new website has got which your old one doesn't for example the categories and maybe a few sql installations from contributions. Thanks Richard Not sure I understand about the customers data? I do not want everything else, just the parts the customers need, ie account dtetails/addresses/orders/points etc. As for the Easy Populate I'll check that out. I will be able to download my products, re-arrange them into the new places & upload them to my new site? Julie Link to comment Share on other sites More sharing options...
Guest Posted January 7, 2008 Share Posted January 7, 2008 I know you only want the customer data and the products but what I suggested was just a quick and easy way to get them but of course you would have everything else. What I do suggest is going to the link below which is a Google search, look through the links and you may find a answer but as I said it will involve messing about with the database. Google Search With Easy Populate you can download all products in a CSV file and you will then be able to open it and alter the categories name to what your new category names are. Link to comment Share on other sites More sharing options...
warrenerjm Posted January 7, 2008 Author Share Posted January 7, 2008 I know you only want the customer data and the products but what I suggested was just a quick and easy way to get them but of course you would have everything else. What I do suggest is going to the link below which is a Google search, look through the links and you may find a answer but as I said it will involve messing about with the database. Google Search With Easy Populate you can download all products in a CSV file and you will then be able to open it and alter the categories name to what your new category names are. Hi Richard I searched the contributions for Easy Populate & came up with QUITE a few! Checked out a few & read the details & found a few that are probably the main ones...only they have so many updates & add ons that it is unclear which is a stable working version. Even started reading the support tread of one & that didn't help. :o As for the customers, I have one database & another one which is completely different as alot of new additions & some old ones missing. I can't re-build the new onto the old. I might see if my host has a suggestion for moving only one part of the database. You never know they may have come accross it before. Do you use Easy Populate? Thanks for your help Julie Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 7, 2008 Share Posted January 7, 2008 Try this.... In phpmyadmin compare the fields in the customer table in the old db and the new db. Find any new fields and ones that are no longer there. Then export the customer table from your first db to a csv file. Open the csv and insert blank columns if required e.g titles, or delete columns where fields are not in the new layout. Import the csv file into the new db. Repeat for each file. Please note if you need the order history you need to make sure you have all of the tables relating to orders copied over. This will probably take you longer than your last incursion into the realms of sql I use EP Contribution 1838 Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
warrenerjm Posted January 7, 2008 Author Share Posted January 7, 2008 Try this.... In phpmyadmin compare the fields in the customer table in the old db and the new db. Find any new fields and ones that are no longer there. Then export the customer table from your first db to a csv file. Open the csv and insert blank columns if required e.g titles, or delete columns where fields are not in the new layout. Import the csv file into the new db. Repeat for each file. Please note if you need the order history you need to make sure you have all of the tables relating to orders copied over. This will probably take you longer than your last incursion into the realms of sql I use EP Contribution 1838 :lol: This will probably take you longer than your last incursion into the realms of sql I guessed as much!! :lol: I need to read about csv first :blush: I was guessing that I would need certain "whole tables" within my first database for customer address, address_book, orders etc but I didn't know how to technically "pick them up" & move them (well copy & move them) The customer Title is the only addition as I purposfully chose the same working version of Points & Reward so the database tables/fields should be the same. Is it a bit like compare? I have access to more databases if it would be easier to test it out first, so I do not break my live & new sites? Just checking out the google link & so far alot of people asking but getting no answers. I am the lucky one :D . EP Contribution 1838 was the third from last!! I'm guessing 29/03/04 Nothing against old :-" It is compatable with the latest MS2 (not RC1) I'll have a look. Do you ever say to yourself "I wish I hadn't started this!!" :P Thanks Julie Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 8, 2008 Share Posted January 8, 2008 Yep, every time I reply to one of your posts :-) Seriously, although it may take some time, all it is, is working it through in a methodical way making sure the old data "fits" the record layout in the new db. Where layout of file a (old) = file a (new), and this should be true in most cases, you can export the file as sql add drop table and if mot exist and that saves you some of time. See, I told you exploring phpmyadmin would come in usefull. Take a back up of the new db, then even if you make an error you can delete and restore either just one table or the whole lot. Just to annoy you, here is the way I'd do it, export both dbs as sql and install them locally, use an access db and queries to move the data between them and then put the new updated db back up on the server. Look forward to hearing from you when you have finished :-) Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
warrenerjm Posted January 8, 2008 Author Share Posted January 8, 2008 Yep, every time I reply to one of your posts :-) ;) ...export both dbs as sql and install them locally, use an access db and queries to move the data between them and then put the new updated db back up on the server. This sounds good, but how do I install them locally & use an access db and queries? Is there a program I need installed on my local computer. Alternatively I can create a new database on the server & change my configure.php files? :D Julie Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 8, 2008 Share Posted January 8, 2008 Wish I'd .......... :-) You can use xampp or wampp to create a web server on your pc. See the link at the bottom of the page, support forum at .... (ha ha ) This includes apache, mysql and phpmyadmin so you are well on the way to having you own dev environment. But you are right you can create a copy db on your server. Just to go back to your initial post, if you create a EP download file remember to change the categories before uploading it to the new db. Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.