jakub Posted November 26, 2008 Share Posted November 26, 2008 Hi,This is my first post here,So Welcome, My name is Jakub, I am posting from Poland.I already installed prestashop. It is working, but I wouldlike to use Oracle Database.I already found in conifguration file that database type is set to mysql.Some other base are supported?In which files I will find declaration of batabase methods?I will share few informations for peaople who can look for same problems what i had.I am now importing categories and products from other DB (mssql)I am using my own scripts based on deps in shop base.I am using only one lang ver so I am not multipli quest i *_lang.In same way I will made manufacture id (like category)Downloading categories:2 sql questions with category_id dep. $pytanie = "insert into `ps_category` ( `id_parent`, `level_depth`, `active`, `date_add`, `date_upd`) select id_category,'2','1','$data','$data' from ps_category_lang where name= '$nazwa_nadkategorii[$a]' and id_lang=8 limit 1"; $pytanie = "insert into ps_category_lang (id_category, id_lang, name, link_rewrite) select id_category, '8','$podkategorie[$a]','$podkategorie[$a]'from ps_category order by id_category desc limit 1"; Now productsI added ps_product_tempwhere I am keeping dep from mssql db. $pytanie = " insert into `ps_product` (`id_category_default`,`ean13`,`weight`,`id_tax`, `date_add`, `date_upd`) select id_category,'$wartosc[3]','$wartosc[0]','1','$data', '$data' from ps_category_lang inner join ps_product_temp on name=nazwa_kategorii and kod_produktu='$wartosc[1]' where id_lang=8 "; $pytanie = "insert into `ps_product_lang` (`id_product`, `link_rewrite`, `id_lang`, `description_short`, `name`) select id_product, '$wartosc[1]','8', '$wartosc[0]', '$wartosc[2]' from ps_product where weight='$wartosc[0]'"; $pytanie ="insert into `ps_category_product` (`id_category`, `id_product`) select id_category,id_product from ps_category_lang inner join ps_product_temp on name=nazwa_kategorii and kod_produktu='$wartosc[1]' inner join ps_product_lang on ps_product_lang.link_rewrite='$wartosc[1]' and ps_product_lang.id_lang=8"; 2 questions with dep (id_product) and to make products visible 3rd questionMy quesstion is:I found out that in ps_product is default category columnit is not used? Any else is making updates via sql questions? if some one has some *.sqlit is very welcome Regards! Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now