JLT80 Posted March 27, 2009 Share Posted March 27, 2009 Dear... I have installed the contribute "Easy CVS". Everything is working fine except for the name & description elements. I am using the dutch language but also in English there is no name of description is showing up. I have tried to adjust the ini files and the PHP file but nothing worked. Maybe some of you have any sugestions or iedeas? I love this contribute because it's nice and simple and hopefully it going to work proparly. With regards, Jelte V. The Netherlands Ps. Below you will find the .ini files and the example .CSV file I use -------------------------------------- CSV_import.ini -------------------------------------- [settings] debug = "0" csv_upload_folder = "csv" correct_fields_count = "1" correct_fields_radius = "5" products_default_status = "0" default_category_id = "0" auto_add_categories = "1" import_images_urls = "1" image_name_delimiter = "|" allow_empty_db = "1" decimal_point = "." thousands_sep = "," [csv] delimiter = ";" enclosure = "" columns_headers = "category, model, name_en, name_es, name_it, name_de, name_nl, name_fr, quantity, image, price, weight, description_en, description_es, description_it, description_de, description_nl, description_fr, tax class, manufacturer name" columns_headers_delimiter = "," categories_delimiter = "|" categories_subcat_delimiter = "." categories_language = "" [products] products_model = "1" products_image = "9" products_price = "10" products_quantity = "8" products_weight = "11" products_tax_class_id = "18" [categories] categories_id = "0" [manufacturers] manufacturers_id = "19" [products_description] products_name = "en:2, es:3, it:4, de:5, nl:6, fr:7" products_description = "en:12, es:13, it:14, de:15, nl:16, fr:17" -------------------------------------- example.csv -------------------------------------- Category;Model;Name_en;Name_es;Name_it;Name_de;Name_nl;Name_fr;Quantity;Image;Pr ice;Weight;Description_en;Description_es;Description_it;Description_de;Descriptio n_nl;Description_fr;Tax Class;Manufacturer test33;KING1G533;;;;;1GB Ram Memory;;50;memoria.jpg;50,99;0,2;;;;;memoria ram da 1gb;;BTW; Quote Link to comment Share on other sites More sharing options...
eugeniobonifacio Posted March 30, 2009 Share Posted March 30, 2009 Are you sure your oscommerce language code is "nl"? I remember a similar case like yours where the language code was "ho" not "nl". Check it in admin->localization->languages tip: you can remove unused languages from cvs and csv_import.ini (don't forget columns_headers setting) Let me know. Quote Link to comment Share on other sites More sharing options...
JLT80 Posted March 30, 2009 Author Share Posted March 30, 2009 Thanks for your reply! The languages code in my shop is "NL" not "nl" does this make any difference? If so how do I change this in Easy CVS. I know I can remove te other languages but I first want to get the script working before I make any other changes. One thing at a time ;-) Thanks! Jelte Are you sure your oscommerce language code is "nl"? I remember a similar case like yours where the language code was "ho" not "nl". Check it in admin->localization->languages tip: you can remove unused languages from cvs and csv_import.ini (don't forget columns_headers setting) Let me know. Quote Link to comment Share on other sites More sharing options...
eugeniobonifacio Posted March 31, 2009 Share Posted March 31, 2009 Yes, it's different. You must change "nl" to "NL" in your csv_import.ini, under [products_description] section Quote Link to comment Share on other sites More sharing options...
JLT80 Posted March 31, 2009 Author Share Posted March 31, 2009 Thanks, it's working!! You said I could remove the other languages. Do I need to remove the languages from the "csv_import.ini" at the bottom AND from the excel sheet? Again thanks!! Quote Link to comment Share on other sites More sharing options...
JLT80 Posted April 2, 2009 Author Share Posted April 2, 2009 Languages are updates. It's working like a charm! But I have an extra field called (Extra). I have the "csv_import.ini" updated (see below) I also have an extra field in the CVS file called Extra on place 20 Could you please help me out here? Grtz Jelte ------------------------------------ csv_import.ini --------------------------------------- [settings] debug = "0" csv_upload_folder = "csv" correct_fields_count = "1" correct_fields_radius = "10" products_default_status = "0" default_category_id = "0" auto_add_categories = "1" import_images_urls = "1" image_name_delimiter = "|" allow_empty_db = "1" decimal_point = "." thousands_sep = "," [csv] delimiter = ";" enclosure = "" columns_headers = "category, model, name_nl, quantity, image, price, weight, description_nl, tax class, manufacturer name, Extra" columns_headers_delimiter = "," categories_delimiter = "|" categories_subcat_delimiter = "." categories_language = "" [products] products_model = "1" products_image = "9" products_price = "10" products_quantity = "8" products_weight = "11" products_tax_class_id = "18" [categories] categories_id = "0" [manufacturers] manufacturers_id = "19" [extra velden] Extra = "20" [products_description] products_name = "NL:6" products_description = "NL:16" ------------------------------------ end csv_import.ini --------------------------------------- Quote Link to comment Share on other sites More sharing options...
eugeniobonifacio Posted April 2, 2009 Share Posted April 2, 2009 if your field goes into products table just add it in [products] section inside ini file. [products] products_model = "1" products_image = "9" products_price = "10" products_quantity = "8" products_weight = "11" products_tax_class_id = "18" extra = "20" Quote Link to comment Share on other sites More sharing options...
JLT80 Posted April 2, 2009 Author Share Posted April 2, 2009 That's it! I am done. Thank you so much for all your help! Grtz. Jelte Quote Link to comment Share on other sites More sharing options...
Guest Posted September 29, 2009 Share Posted September 29, 2009 Hello, first, thanks for this contrib. Works really good for my needs. One thing I woult like to implement, but dont´t know how to solve. Is it possible to make a minimum price, for example all products in the csv which are 50€ ore more expensive will be imported, all other will be ignored? Any hint ist greatly appreciated ;) Thanks Quote Link to comment Share on other sites More sharing options...
Saldor Posted April 25, 2016 Share Posted April 25, 2016 Yes, it's different. You must change "nl" to "NL" in your csv_import.ini, under [products_description] section HI! I have troubl with import product with russian languages. Text abcent in my russian product, then i import. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.