ThatGuyinYuma Posted February 24, 2007 Posted February 24, 2007 Greetings all, Some time ago I built a site for a friend and used Product Cart for his site. I new this day was comming but now its here, he has outgrown the Access database and the site is crashing. I have been limping the site along by thinning the db as needed but it's time to change carts. OS Commerce looks to be just what I need becouse of its vast support/contribs/use and I have worked with several other php/mysql programs so I do not believe installation or simple customization will be a problem. I do have a few questions: Migrating the data from access into mysql seems possible from the beggining reasearch I have done. It seems as though I can convert the MSDB into a CSV then import the CSV into mysql. I know this is drasticly oversimplifying the process, but is that the general procedure? Many hosts seem to be moving to PHP 5, If his does will it affect OSCommerce and can it be fixed? My php skills are weak. If I need advanced customization, help with the db migration or custom work can I post work for hire here? Thanks in advance for any help/advice. Side Note: I have asked many people in the past about how many records the Acces DB will handle before crashing, and the general concensis was about a million. Well in my case it's about 275,000. If anyone was wondering.
Velveeta Posted February 24, 2007 Posted February 24, 2007 Greetings all,Some time ago I built a site for a friend and used Product Cart for his site. I new this day was comming but now its here, he has outgrown the Access database and the site is crashing. I have been limping the site along by thinning the db as needed but it's time to change carts. OS Commerce looks to be just what I need becouse of its vast support/contribs/use and I have worked with several other php/mysql programs so I do not believe installation or simple customization will be a problem. I do have a few questions: Migrating the data from access into mysql seems possible from the beggining reasearch I have done. It seems as though I can convert the MSDB into a CSV then import the CSV into mysql. I know this is drasticly oversimplifying the process, but is that the general procedure? Many hosts seem to be moving to PHP 5, If his does will it affect OSCommerce and can it be fixed? My php skills are weak. If I need advanced customization, help with the db migration or custom work can I post work for hire here? Thanks in advance for any help/advice. Side Note: I have asked many people in the past about how many records the Acces DB will handle before crashing, and the general concensis was about a million. Well in my case it's about 275,000. If anyone was wondering. Yes, that is an oversimplification, but you can dump access to a csv file and then read it in w/ a php script to do some translation between the table and field names over to the osc table and field names, and insert all of that data in its proper locations... There may be some fields that osc doesn't support, or some fields that Product Cart doesn't have and osc does, but this will get the bulk of the work out of the way for you... As for PHP 5, osc MS2 (the current official release) should work fine with it provided register_globals is turned on... If it's off, the store won't work, but yes, there are contributions available to get around that as well, so you shouldn't have any problems... As for posting work for hire here, I don't think the moderators like that to be done, at least I've read in the past that it's a no-no... Richard. Richard Lindsey
Recommended Posts
Archived
This topic is now archived and is closed to further replies.