|
Installing Makes and Models |
|
|
|
|
How do we install makes and models?
We have written a CSV installer, and this one will install the CSV you can download from the download section if you have a subscription for it. Make sure your database tables are empty before using the installer, other wise your makes will get the wrong id's. If you're busy with a new installation they're allready empty. You don't have to do the first steps.
Let go to your PHP MyAdmin first. Delete the tables Makes and Models using this query:
DROP TABLE `jos_rdautos_makes`, `jos_rdautos_models`;
Your table are gone now, but needs to be installed again.
CREATE TABLE IF NOT EXISTS `#__rdautos_makes` ( `makeid` int(20) NOT NULL AUTO_INCREMENT, `makename` varchar(100) NOT NULL, `published` tinyint(1) NOT NULL, PRIMARY KEY (`makeid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `#__rdautos_models` ( `modelid` int(20) NOT NULL AUTO_INCREMENT, `makeid` int(20) NOT NULL, `model` varchar(50) NOT NULL, `published` tinyint(1) NOT NULL, PRIMARY KEY (`modelid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Make sure you replace #?? with the prefix of your tables. After your tables are ready to go we have to run the models script.
1: Go to the Makes and models Manager for RD-Autos. 2: On the right you will see: "Import Makes from CSV" 3: Search the file on your computer 4: Click "Import Now"
Do the same for models:
1: Go to the Makes and models Manager for RD-Autos. 2: On the right you will see: "Import Models From CSV file RD-Media Download" 3: Search the file on your computer 4: Click "Import Now"
|