oscommerce --> osCMax 2.0 migration

[zaxxon]

hi, i am currently using oscomerce(www.complete-computer-care.co.uk) i havent donr much to the site in a long while and now that i am taking the site more seriously i want to upgrade to oscmax. i have installed oscmax on my computer, to start and play about with it before i install it to the site, and am having a few problems.
1)database import.
i downloaded my database in pure sql form from oscommerce and when i try to import it to oscmax, it will not let me install it using the restore database.
a. are the database structure and tables for OSC and max the same ?
b. if so what am i doing wrong?

2)product attirbutes contribution
i didnt install all the contribs i have on the cart so i am not sure what my webdesigner did, and i cant locate him. he added an attachment so i can have multiple attributes to my product, basicaly its a pc configurator, and with that contrib i manage to give my users the option to add/remove/modify parts to the pc they are building in the screen shot you can see its back end, where i can choose how it will look, can you guys take a look and identiy the attribute manger there and tell me if i can install the same for OSCMAX ?

3) truncated discription
i havent started to to modify the cart just yet(obviously - since i dont have the database installed) but i wonder if you can point me to the right direction here as well. as can be seen here here when i display my product, i have the discription stripped from any formatting and truncated. i think this was done with a contrib as well, does any one know what the name of that contribution ?


Last,
i know these are all noobs quetions, i am not familiar with php and or mysql or design in general. so excuse the ignorance, also, as posted somewhere else on the site. is any one interested in a site redesign work ? there are a few more things i need done. would pay for a good coder graphic designer.
many thanks in advance for any job inquiry and help with these matters

[spottedhaggis]

lol,

thats almost a scary question. How familiar are you in working with Mysql databases would be the first thing to ask.

You need to do a compare on the databases. I used SQLYOG to achieve this, others found it harder, I found it perfect. What this does is compare both database
Structures, which are hugely different. My osc shop had 54 database tables, oscmax has 91 or so, and this is why it wont simply import your data.

You do a compare, swhich creates a script that will add the missing tables into your oscommerce database and make both databases identical in structure. This also will include adding any missing fields etc.

Backup your database before you work on it, or do what I did, create a new database and import your current backup or OSC into it and use that as the database to
work with, thus not destroying your already working shop

When this is done you should (Use the word lightly) be able to simply export the now altered osc database and import it into the new oscmax database using PHPmyadmin or some similar tool.

There are a number of forum entries in this section that have covered this thing in various ways.

I myself have managed to get mine working perfectly, and a good friend of mine has also achireved this so it can be done, persevere.

If it was going to be of any help I can give you the structure of my osc database, it has a load of tables that are not standard, but you can delete these from the database when its got the new data into it.

[jpf]

Originally Posted by zaxxon

hi, i am currently using oscomerce(www.complete-computer-care.co.uk) i havent donr much to the site in a long while and now that i am taking the site more seriously i want to upgrade to oscmax. i have installed oscmax on my computer, to start and play about with it before i install it to the site, and am having a few problems.
1)database import.
i downloaded my database in pure sql form from oscommerce and when i try to import it to oscmax, it will not let me install it using the restore database.
a. are the database structure and tables for OSC and max the same ?
b. if so what am i doing wrong?

That is out right dangerous

Look at using MYSQLDIFF to convert the MAJORITY of stuff. A bit of fudging may have to be done on products.

YOU can not just do an IMPORT as they database has SO much more information

2)product attirbutes contribution
i didnt install all the contribs i have on the cart so i am not sure what my webdesigner did, and i cant locate him. he added an attachment so i can have multiple attributes to my product, basicaly its a pc configurator, and with that contrib i manage to give my users the option to add/remove/modify parts to the pc they are building in the screen shot you can see its back end, where i can choose how it will look, can you guys take a look and identiy the attribute manger there and tell me if i can install the same for OSCMAX ?

He may have added a large program CCC - Custom Computer Creator or CPC - Custom PC Creator. No this has not be made for BTS - that I know of.

3) truncated discription
i havent started to to modify the cart just yet(obviously - since i dont have the database installed) but i wonder if you can point me to the right direction here as well. as can be seen here here when i display my product, i have the discription stripped from any formatting and truncated. i think this was done with a contrib as well, does any one know what the name of that contribution ?

Not sure - but why did you want it truncated?

Last,
i know these are all noobs quetions, i am not familiar with php and or mysql or design in general. so excuse the ignorance, also, as posted somewhere else on the site. is any one interested in a site redesign work ? there are a few more things i need done. would pay for a good coder graphic designer.
many thanks in advance for any job inquiry and help with these matters

PM me.

[zaxxon]

the reason i want it truncated is cuz i want it to apear under the product name, yet obviously not take a full page just to fit under , say abotu 300 characters, take a look here to seee what i mean:
http://www.complete-computer-care.co...x.php?cPath=22 (look under the product name)