[Skip to main content](#vessel-content) # Profile for dforrest ## [![dforrest's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2297-dforrest "View dforrest's Profile") **[ Offline](/forum/user/2297-dforrest)** - **User Type:** User - **Register Date:** 25 Apr 2011 - **Last login:** 12 years 1 month ago - **Time Zone:** UTC +1:00 - **Local Time:** 14:59 - **Posts:** 56 - **Profile views:** 344 - **Gender:** Unknown - **Birthdate:** Unknown > HikaShop Business 2.3.2 on Joomla 1.5.26 + JoomFish 2.1.6 - Multilingual site - Posts # dforrest's recent posts (56 messages ) All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year | [ ](#forumbottom) | Subject | Replies / Views | Last Post | [ ](#forumtop) | |---|---|---|---|---| | [](/forum/4-how-to/72410-csv-import-problems#74215) | [CSV import problems](/forum/4-how-to/72410-csv-import-problems#74215 "I have a goal that I hope is realistic: I would like to keep my entire (small) shop, with 10 categories, 16 sub-categories, and 47 variants, all in one spreadsheet, just as exported by the HS >...") Category: [How to?](/forum/4-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question here.") Topic started 14 years 1 day ago, by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") [Last Post](/forum/4-how-to/72410-csv-import-problems#74255 "Hi Dforrest, I understand what you experienced with the free products on non defined variants, i have been struggling with that last week, fortunately Xavier pointed me in the right direction and with a couple of lines of code in the product/listing_price view he solved that annoying problem, you can see the solution here: About the configuration of the csv i usually use this configuration, i use openOffice, i think it is better for handling csv's: -On the OpenOffice "Save As" Dialog, when you choose csv there are some checkboxes that activates, the first one should say something like "Automatic File Extension" then there is a greyed one that says "Protect with password" or something like that and there is a third one that in italian says "Modifica Impostazioni Filtro" (that should be something like "modify export options") if you check that box when you click "Salva" it asks you if you want maintain the current format or save as ODS, you click Maintain and the another popup comes up with csv's options. I usually choose: UTF-8 for the char type Field separator ";" (punto y coma) Text Separator " (Comillas) then i select the "save cell contents as shown - (Salva el contenido de las celdas como mostrado) And let the next checkbox unselected This way have been working for me very good and i allways work in the ODS file that i have color coded (sort of) One thing that is still tricky to me is the decimal handling on the product_price column because if you use the comma HS understand it as multiple values (and this is very useful when assigning multiple categories to a product) so you need to use the period (punto) as decimal separator. The problem i have found is that when i receive the excel files from my suppliers they always use the comma in their price column and may be they have also defined the cell as € value so a simple copy/paste of this values onto the HS import file can be dangerous. So i sorted this by: 1. Set the format of the whole product_price column as number and the language as "Italiano (Svizzera)" because fortunately swiss buddies uses the period as decimal separator. 2. When Copy/Pasting your values don't use the simple Ctrl+C - Ctrl+V , instead use Special Paste or Ctrl+Shift+V and in the popup select only numbers and uncheck everything else. This way, when you paste the values in your preformated swiss number cell they will show with period separator, no mater if the original cell was formated with commas and euro symbol. Try and see. Have a good day. En el futuro si quieres charlar un rato sobre HS podeis escrivirme en español via PM Hasta luego") 13 years 11 months ago by [protorob](/forum/user/5729-protorob "View protorob's Profile") | Replies:6 Views:2449 | [Last Post](/forum/4-how-to/72410-csv-import-problems#74255 "Hi Dforrest, I understand what you experienced with the free products on non defined variants, i have been struggling with that last week, fortunately Xavier pointed me in the right direction and with a couple of lines of code in the product/listing_price view he solved that annoying problem, you can see the solution here: About the configuration of the csv i usually use this configuration, i use openOffice, i think it is better for handling csv's: -On the OpenOffice "Save As" Dialog, when you choose csv there are some checkboxes that activates, the first one should say something like "Automatic File Extension" then there is a greyed one that says "Protect with password" or something like that and there is a third one that in italian says "Modifica Impostazioni Filtro" (that should be something like "modify export options") if you check that box when you click "Salva" it asks you if you want maintain the current format or save as ODS, you click Maintain and the another popup comes up with csv's options. I usually choose: UTF-8 for the char type Field separator ";" (punto y coma) Text Separator " (Comillas) then i select the "save cell contents as shown - (Salva el contenido de las celdas como mostrado) And let the next checkbox unselected This way have been working for me very good and i allways work in the ODS file that i have color coded (sort of) One thing that is still tricky to me is the decimal handling on the product_price column because if you use the comma HS understand it as multiple values (and this is very useful when assigning multiple categories to a product) so you need to use the period (punto) as decimal separator. The problem i have found is that when i receive the excel files from my suppliers they always use the comma in their price column and may be they have also defined the cell as € value so a simple copy/paste of this values onto the HS import file can be dangerous. So i sorted this by: 1. Set the format of the whole product_price column as number and the language as "Italiano (Svizzera)" because fortunately swiss buddies uses the period as decimal separator. 2. When Copy/Pasting your values don't use the simple Ctrl+C - Ctrl+V , instead use Special Paste or Ctrl+Shift+V and in the popup select only numbers and uncheck everything else. This way, when you paste the values in your preformated swiss number cell they will show with period separator, no mater if the original cell was formated with commas and euro symbol. Try and see. Have a good day. En el futuro si quieres charlar un rato sobre HS podeis escrivirme en español via PM Hasta luego") by [protorob](/forum/user/5729-protorob "View protorob's Profile") 13 years 11 months ago | | [](/forum/3-bug-report/72387-csv-export-error-notice-import-problems#72861) | [CSV export error notice / Import problems](/forum/3-bug-report/72387-csv-export-error-notice-import-problems#72861 "In HS > Products > Products, when I choose to export all items (Root/Product category and All sub-elements), the CSV file that comes out now has error notices in it which it did not before. I suspect...") Category: [Bug Report](/forum/3-bug-report "Please report any bugs or errors here.") Topic started 14 years 1 day ago, by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") [Last Post](/forum/3-bug-report/72387-csv-export-error-notice-import-problems#81467 "Thank you") 13 years 10 months ago by [espcctv](/forum/user/746-espcctv "View espcctv's Profile") | Replies:4 Views:2442 | [Last Post](/forum/3-bug-report/72387-csv-export-error-notice-import-problems#81467 "Thank you") by [espcctv](/forum/user/746-espcctv "View espcctv's Profile") 13 years 10 months ago | | [](/forum/4-how-to/72410-csv-import-problems#72858) | [CSV import problems](/forum/4-how-to/72410-csv-import-problems#72858 "I have a goal that I hope is realistic: I would like to keep my entire (small) shop, with 10 categories, 16 sub-categories, and 47 variants, all in one spreadsheet, just as exported by the HS >...") Category: [How to?](/forum/4-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question here.") Topic started 14 years 1 day ago, by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") [Last Post](/forum/4-how-to/72410-csv-import-problems#74255 "Hi Dforrest, I understand what you experienced with the free products on non defined variants, i have been struggling with that last week, fortunately Xavier pointed me in the right direction and with a couple of lines of code in the product/listing_price view he solved that annoying problem, you can see the solution here: About the configuration of the csv i usually use this configuration, i use openOffice, i think it is better for handling csv's: -On the OpenOffice "Save As" Dialog, when you choose csv there are some checkboxes that activates, the first one should say something like "Automatic File Extension" then there is a greyed one that says "Protect with password" or something like that and there is a third one that in italian says "Modifica Impostazioni Filtro" (that should be something like "modify export options") if you check that box when you click "Salva" it asks you if you want maintain the current format or save as ODS, you click Maintain and the another popup comes up with csv's options. I usually choose: UTF-8 for the char type Field separator ";" (punto y coma) Text Separator " (Comillas) then i select the "save cell contents as shown - (Salva el contenido de las celdas como mostrado) And let the next checkbox unselected This way have been working for me very good and i allways work in the ODS file that i have color coded (sort of) One thing that is still tricky to me is the decimal handling on the product_price column because if you use the comma HS understand it as multiple values (and this is very useful when assigning multiple categories to a product) so you need to use the period (punto) as decimal separator. The problem i have found is that when i receive the excel files from my suppliers they always use the comma in their price column and may be they have also defined the cell as € value so a simple copy/paste of this values onto the HS import file can be dangerous. So i sorted this by: 1. Set the format of the whole product_price column as number and the language as "Italiano (Svizzera)" because fortunately swiss buddies uses the period as decimal separator. 2. When Copy/Pasting your values don't use the simple Ctrl+C - Ctrl+V , instead use Special Paste or Ctrl+Shift+V and in the popup select only numbers and uncheck everything else. This way, when you paste the values in your preformated swiss number cell they will show with period separator, no mater if the original cell was formated with commas and euro symbol. Try and see. Have a good day. En el futuro si quieres charlar un rato sobre HS podeis escrivirme en español via PM Hasta luego") 13 years 11 months ago by [protorob](/forum/user/5729-protorob "View protorob's Profile") | Replies:6 Views:2449 | [Last Post](/forum/4-how-to/72410-csv-import-problems#74255 "Hi Dforrest, I understand what you experienced with the free products on non defined variants, i have been struggling with that last week, fortunately Xavier pointed me in the right direction and with a couple of lines of code in the product/listing_price view he solved that annoying problem, you can see the solution here: About the configuration of the csv i usually use this configuration, i use openOffice, i think it is better for handling csv's: -On the OpenOffice "Save As" Dialog, when you choose csv there are some checkboxes that activates, the first one should say something like "Automatic File Extension" then there is a greyed one that says "Protect with password" or something like that and there is a third one that in italian says "Modifica Impostazioni Filtro" (that should be something like "modify export options") if you check that box when you click "Salva" it asks you if you want maintain the current format or save as ODS, you click Maintain and the another popup comes up with csv's options. I usually choose: UTF-8 for the char type Field separator ";" (punto y coma) Text Separator " (Comillas) then i select the "save cell contents as shown - (Salva el contenido de las celdas como mostrado) And let the next checkbox unselected This way have been working for me very good and i allways work in the ODS file that i have color coded (sort of) One thing that is still tricky to me is the decimal handling on the product_price column because if you use the comma HS understand it as multiple values (and this is very useful when assigning multiple categories to a product) so you need to use the period (punto) as decimal separator. The problem i have found is that when i receive the excel files from my suppliers they always use the comma in their price column and may be they have also defined the cell as € value so a simple copy/paste of this values onto the HS import file can be dangerous. So i sorted this by: 1. Set the format of the whole product_price column as number and the language as "Italiano (Svizzera)" because fortunately swiss buddies uses the period as decimal separator. 2. When Copy/Pasting your values don't use the simple Ctrl+C - Ctrl+V , instead use Special Paste or Ctrl+Shift+V and in the popup select only numbers and uncheck everything else. This way, when you paste the values in your preformated swiss number cell they will show with period separator, no mater if the original cell was formated with commas and euro symbol. Try and see. Have a good day. En el futuro si quieres charlar un rato sobre HS podeis escrivirme en español via PM Hasta luego") by [protorob](/forum/user/5729-protorob "View protorob's Profile") 13 years 11 months ago | | [](/forum/4-how-to/72528-csv-upload-for-translations-which-columns#72855) | [CSV upload for translations: Which columns?](/forum/4-how-to/72528-csv-upload-for-translations-which-columns#72855 "I've seen that uploading a CSV file of a whole shop together with two language translations can be problematic. So I am planning on uploading translations one language at a time. This will be helpful...") Category: [How to?](/forum/4-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question here.") Topic started 14 years 2 hours ago, by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") [Last Post](/forum/4-how-to/72528-csv-upload-for-translations-which-columns#72855 "OK, this is good to know. So for all CSV imports, I will leave out the rows of the CSV export file for what I call the "mother row" that only has the text "product category" and the row for each category. I will include only the rows for the products and variants. These will be in the format: product_code; [productorvariant_info]; productorvariant_info]\|xx-XX (xx-XX = language code) Thanks, this clarifies things a lot. :)") 13 years 11 months ago by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") | Replies:2 Views:718 | [Last Post](/forum/4-how-to/72528-csv-upload-for-translations-which-columns#72855 "OK, this is good to know. So for all CSV imports, I will leave out the rows of the CSV export file for what I call the "mother row" that only has the text "product category" and the row for each category. I will include only the rows for the products and variants. These will be in the format: product_code; [productorvariant_info]; productorvariant_info]\|xx-XX (xx-XX = language code) Thanks, this clarifies things a lot. :)") by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") 13 years 11 months ago | | [](/forum/4-how-to/72528-csv-upload-for-translations-which-columns#72528) | [CSV upload for translations: Which columns?](/forum/4-how-to/72528-csv-upload-for-translations-which-columns#72528 "I've seen that uploading a CSV file of a whole shop together with two language translations can be problematic. So I am planning on uploading translations one language at a time. This will be helpful...") Category: [How to?](/forum/4-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question here.") Topic started 14 years 2 hours ago, by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") [Last Post](/forum/4-how-to/72528-csv-upload-for-translations-which-columns#72855 "OK, this is good to know. So for all CSV imports, I will leave out the rows of the CSV export file for what I call the "mother row" that only has the text "product category" and the row for each category. I will include only the rows for the products and variants. These will be in the format: product_code; [productorvariant_info]; productorvariant_info]\|xx-XX (xx-XX = language code) Thanks, this clarifies things a lot. :)") 13 years 11 months ago by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") | Replies:2 Views:718 | [Last Post](/forum/4-how-to/72528-csv-upload-for-translations-which-columns#72855 "OK, this is good to know. So for all CSV imports, I will leave out the rows of the CSV export file for what I call the "mother row" that only has the text "product category" and the row for each category. I will include only the rows for the products and variants. These will be in the format: product_code; [productorvariant_info]; productorvariant_info]\|xx-XX (xx-XX = language code) Thanks, this clarifies things a lot. :)") by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") 13 years 11 months ago | | [](/forum/3-bug-report/72427-php-error-message#72450) | [PHP error message](/forum/3-bug-report/72427-php-error-message#72450 "I don't know enough about PHP to know if this error is important, if it is I'd like some advice on how to get rid of it. In HS > Categories, if I open one (and only one) of my categories with sytem error reporting set to maximun, I get these error messages: Notice: Undefined offset: 7 in [site path]/administrator/components/com_hikashop/helpers/translation.php on line 62 Notice: Trying to get property of non-object in [site path]/administrator/components/com_hikashop/helpers/translation.php on line 62 I went to the offending file and copied a few lines of code. Here are lines 56-63: Should I do anything about this? Sounds like it has to do with JoomFish. I have checked and resaved the translations for the category name and description; they are all fine. Thanks for any advice.") Category: [Bug Report](/forum/3-bug-report "Please report any bugs or errors here.") Topic started 14 years 1 day ago, by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") [Last Post](/forum/3-bug-report/72427-php-error-message#72450 "Got it. This was because I translated one category name into French but no more. I've now deactivated French as a language for our initial launch, and voilà. The message disappeared when I reactivated French but now I know I can safely ignore it, thanks!") 14 years 20 hours ago by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") | Replies:2 Views:1937 | [Last Post](/forum/3-bug-report/72427-php-error-message#72450 "Got it. This was because I translated one category name into French but no more. I've now deactivated French as a language for our initial launch, and voilà. The message disappeared when I reactivated French but now I know I can safely ignore it, thanks!") by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") 14 years 20 hours ago | | [](/forum/4-how-to/72410-csv-import-problems#72432) | [CSV import problems](/forum/4-how-to/72410-csv-import-problems#72432 "I have a goal that I hope is realistic: I would like to keep my entire (small) shop, with 10 categories, 16 sub-categories, and 47 variants, all in one spreadsheet, just as exported by the HS >...") Category: [How to?](/forum/4-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question here.") Topic started 14 years 1 day ago, by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") [Last Post](/forum/4-how-to/72410-csv-import-problems#74255 "Hi Dforrest, I understand what you experienced with the free products on non defined variants, i have been struggling with that last week, fortunately Xavier pointed me in the right direction and with a couple of lines of code in the product/listing_price view he solved that annoying problem, you can see the solution here: About the configuration of the csv i usually use this configuration, i use openOffice, i think it is better for handling csv's: -On the OpenOffice "Save As" Dialog, when you choose csv there are some checkboxes that activates, the first one should say something like "Automatic File Extension" then there is a greyed one that says "Protect with password" or something like that and there is a third one that in italian says "Modifica Impostazioni Filtro" (that should be something like "modify export options") if you check that box when you click "Salva" it asks you if you want maintain the current format or save as ODS, you click Maintain and the another popup comes up with csv's options. I usually choose: UTF-8 for the char type Field separator ";" (punto y coma) Text Separator " (Comillas) then i select the "save cell contents as shown - (Salva el contenido de las celdas como mostrado) And let the next checkbox unselected This way have been working for me very good and i allways work in the ODS file that i have color coded (sort of) One thing that is still tricky to me is the decimal handling on the product_price column because if you use the comma HS understand it as multiple values (and this is very useful when assigning multiple categories to a product) so you need to use the period (punto) as decimal separator. The problem i have found is that when i receive the excel files from my suppliers they always use the comma in their price column and may be they have also defined the cell as € value so a simple copy/paste of this values onto the HS import file can be dangerous. So i sorted this by: 1. Set the format of the whole product_price column as number and the language as "Italiano (Svizzera)" because fortunately swiss buddies uses the period as decimal separator. 2. When Copy/Pasting your values don't use the simple Ctrl+C - Ctrl+V , instead use Special Paste or Ctrl+Shift+V and in the popup select only numbers and uncheck everything else. This way, when you paste the values in your preformated swiss number cell they will show with period separator, no mater if the original cell was formated with commas and euro symbol. Try and see. Have a good day. En el futuro si quieres charlar un rato sobre HS podeis escrivirme en español via PM Hasta luego") 13 years 11 months ago by [protorob](/forum/user/5729-protorob "View protorob's Profile") | Replies:6 Views:2449 | [Last Post](/forum/4-how-to/72410-csv-import-problems#74255 "Hi Dforrest, I understand what you experienced with the free products on non defined variants, i have been struggling with that last week, fortunately Xavier pointed me in the right direction and with a couple of lines of code in the product/listing_price view he solved that annoying problem, you can see the solution here: About the configuration of the csv i usually use this configuration, i use openOffice, i think it is better for handling csv's: -On the OpenOffice "Save As" Dialog, when you choose csv there are some checkboxes that activates, the first one should say something like "Automatic File Extension" then there is a greyed one that says "Protect with password" or something like that and there is a third one that in italian says "Modifica Impostazioni Filtro" (that should be something like "modify export options") if you check that box when you click "Salva" it asks you if you want maintain the current format or save as ODS, you click Maintain and the another popup comes up with csv's options. I usually choose: UTF-8 for the char type Field separator ";" (punto y coma) Text Separator " (Comillas) then i select the "save cell contents as shown - (Salva el contenido de las celdas como mostrado) And let the next checkbox unselected This way have been working for me very good and i allways work in the ODS file that i have color coded (sort of) One thing that is still tricky to me is the decimal handling on the product_price column because if you use the comma HS understand it as multiple values (and this is very useful when assigning multiple categories to a product) so you need to use the period (punto) as decimal separator. The problem i have found is that when i receive the excel files from my suppliers they always use the comma in their price column and may be they have also defined the cell as € value so a simple copy/paste of this values onto the HS import file can be dangerous. So i sorted this by: 1. Set the format of the whole product_price column as number and the language as "Italiano (Svizzera)" because fortunately swiss buddies uses the period as decimal separator. 2. When Copy/Pasting your values don't use the simple Ctrl+C - Ctrl+V , instead use Special Paste or Ctrl+Shift+V and in the popup select only numbers and uncheck everything else. This way, when you paste the values in your preformated swiss number cell they will show with period separator, no mater if the original cell was formated with commas and euro symbol. Try and see. Have a good day. En el futuro si quieres charlar un rato sobre HS podeis escrivirme en español via PM Hasta luego") by [protorob](/forum/user/5729-protorob "View protorob's Profile") 13 years 11 months ago | | [](/forum/3-bug-report/72427-php-error-message#72427) | [PHP error message](/forum/3-bug-report/72427-php-error-message#72427 "I don't know enough about PHP to know if this error is important, if it is I'd like some advice on how to get rid of it. In HS > Categories, if I open one (and only one) of my categories with sytem error reporting set to maximun, I get these error messages: Notice: Undefined offset: 7 in [site path]/administrator/components/com_hikashop/helpers/translation.php on line 62 Notice: Trying to get property of non-object in [site path]/administrator/components/com_hikashop/helpers/translation.php on line 62 I went to the offending file and copied a few lines of code. Here are lines 56-63: Should I do anything about this? Sounds like it has to do with JoomFish. I have checked and resaved the translations for the category name and description; they are all fine. Thanks for any advice.") Category: [Bug Report](/forum/3-bug-report "Please report any bugs or errors here.") Topic started 14 years 1 day ago, by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") [Last Post](/forum/3-bug-report/72427-php-error-message#72450 "Got it. This was because I translated one category name into French but no more. I've now deactivated French as a language for our initial launch, and voilà. The message disappeared when I reactivated French but now I know I can safely ignore it, thanks!") 14 years 20 hours ago by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") | Replies:2 Views:1937 | [Last Post](/forum/3-bug-report/72427-php-error-message#72450 "Got it. This was because I translated one category name into French but no more. I've now deactivated French as a language for our initial launch, and voilà. The message disappeared when I reactivated French but now I know I can safely ignore it, thanks!") by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") 14 years 20 hours ago | | [](/forum/4-how-to/72410-csv-import-problems#72410) | [CSV import problems](/forum/4-how-to/72410-csv-import-problems#72410 "I have a goal that I hope is realistic: I would like to keep my entire (small) shop, with 10 categories, 16 sub-categories, and 47 variants, all in one spreadsheet, just as exported by the HS >...") Category: [How to?](/forum/4-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question here.") Topic started 14 years 1 day ago, by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") [Last Post](/forum/4-how-to/72410-csv-import-problems#74255 "Hi Dforrest, I understand what you experienced with the free products on non defined variants, i have been struggling with that last week, fortunately Xavier pointed me in the right direction and with a couple of lines of code in the product/listing_price view he solved that annoying problem, you can see the solution here: About the configuration of the csv i usually use this configuration, i use openOffice, i think it is better for handling csv's: -On the OpenOffice "Save As" Dialog, when you choose csv there are some checkboxes that activates, the first one should say something like "Automatic File Extension" then there is a greyed one that says "Protect with password" or something like that and there is a third one that in italian says "Modifica Impostazioni Filtro" (that should be something like "modify export options") if you check that box when you click "Salva" it asks you if you want maintain the current format or save as ODS, you click Maintain and the another popup comes up with csv's options. I usually choose: UTF-8 for the char type Field separator ";" (punto y coma) Text Separator " (Comillas) then i select the "save cell contents as shown - (Salva el contenido de las celdas como mostrado) And let the next checkbox unselected This way have been working for me very good and i allways work in the ODS file that i have color coded (sort of) One thing that is still tricky to me is the decimal handling on the product_price column because if you use the comma HS understand it as multiple values (and this is very useful when assigning multiple categories to a product) so you need to use the period (punto) as decimal separator. The problem i have found is that when i receive the excel files from my suppliers they always use the comma in their price column and may be they have also defined the cell as € value so a simple copy/paste of this values onto the HS import file can be dangerous. So i sorted this by: 1. Set the format of the whole product_price column as number and the language as "Italiano (Svizzera)" because fortunately swiss buddies uses the period as decimal separator. 2. When Copy/Pasting your values don't use the simple Ctrl+C - Ctrl+V , instead use Special Paste or Ctrl+Shift+V and in the popup select only numbers and uncheck everything else. This way, when you paste the values in your preformated swiss number cell they will show with period separator, no mater if the original cell was formated with commas and euro symbol. Try and see. Have a good day. En el futuro si quieres charlar un rato sobre HS podeis escrivirme en español via PM Hasta luego") 13 years 11 months ago by [protorob](/forum/user/5729-protorob "View protorob's Profile") | Replies:6 Views:2449 | [Last Post](/forum/4-how-to/72410-csv-import-problems#74255 "Hi Dforrest, I understand what you experienced with the free products on non defined variants, i have been struggling with that last week, fortunately Xavier pointed me in the right direction and with a couple of lines of code in the product/listing_price view he solved that annoying problem, you can see the solution here: About the configuration of the csv i usually use this configuration, i use openOffice, i think it is better for handling csv's: -On the OpenOffice "Save As" Dialog, when you choose csv there are some checkboxes that activates, the first one should say something like "Automatic File Extension" then there is a greyed one that says "Protect with password" or something like that and there is a third one that in italian says "Modifica Impostazioni Filtro" (that should be something like "modify export options") if you check that box when you click "Salva" it asks you if you want maintain the current format or save as ODS, you click Maintain and the another popup comes up with csv's options. I usually choose: UTF-8 for the char type Field separator ";" (punto y coma) Text Separator " (Comillas) then i select the "save cell contents as shown - (Salva el contenido de las celdas como mostrado) And let the next checkbox unselected This way have been working for me very good and i allways work in the ODS file that i have color coded (sort of) One thing that is still tricky to me is the decimal handling on the product_price column because if you use the comma HS understand it as multiple values (and this is very useful when assigning multiple categories to a product) so you need to use the period (punto) as decimal separator. The problem i have found is that when i receive the excel files from my suppliers they always use the comma in their price column and may be they have also defined the cell as € value so a simple copy/paste of this values onto the HS import file can be dangerous. So i sorted this by: 1. Set the format of the whole product_price column as number and the language as "Italiano (Svizzera)" because fortunately swiss buddies uses the period as decimal separator. 2. When Copy/Pasting your values don't use the simple Ctrl+C - Ctrl+V , instead use Special Paste or Ctrl+Shift+V and in the popup select only numbers and uncheck everything else. This way, when you paste the values in your preformated swiss number cell they will show with period separator, no mater if the original cell was formated with commas and euro symbol. Try and see. Have a good day. En el futuro si quieres charlar un rato sobre HS podeis escrivirme en español via PM Hasta luego") by [protorob](/forum/user/5729-protorob "View protorob's Profile") 13 years 11 months ago | | [](/forum/3-bug-report/72387-csv-export-error-notice-import-problems#72387) | [CSV export error notice / Import problems](/forum/3-bug-report/72387-csv-export-error-notice-import-problems#72387 "In HS > Products > Products, when I choose to export all items (Root/Product category and All sub-elements), the CSV file that comes out now has error notices in it which it did not before. I suspect...") Category: [Bug Report](/forum/3-bug-report "Please report any bugs or errors here.") Topic started 14 years 1 day ago, by [dforrest](/forum/user/2297-dforrest "View dforrest's Profile") [Last Post](/forum/3-bug-report/72387-csv-export-error-notice-import-problems#81467 "Thank you") 13 years 10 months ago by [espcctv](/forum/user/746-espcctv "View espcctv's Profile") | Replies:4 Views:2442 | [Last Post](/forum/3-bug-report/72387-csv-export-error-notice-import-problems#81467 "Thank you") by [espcctv](/forum/user/746-espcctv "View espcctv's Profile") 13 years 10 months ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.156 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)