[Skip to main content](#vessel-content)
# Profile for yvo\_wilms
##
[](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile")
**[ Offline](/forum/user/37661-yvo-wilms)**
- **User Type:** User
- **Register Date:** 16 Jun 2015
- **Last login:** 10 years 3 months ago
- **Time Zone:** UTC +1:00
- **Local Time:** 03:52
- **Posts:** 20
- **Profile views:** 81
- **Gender:** Unknown
- **Birthdate:** Unknown
- Posts
# yvo\_wilms recent posts (20 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/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20#227864) | [Piping symbol in import file is not possible ...](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20#227864 "-- HikaShop version -- : latest -- Joomla version -- : latest I have a working import based on manually entered data. Now our IT department has to create a periodical export from our ERP that will be imported via a cron into our Hikashop. They however have a problem using a piping-symbol ("\|") in the column names (product_name\|en-GB, product_name\|fr-FR, ...) Is there a way to change this piping-symbol so they/we can use some different character as a separator for the language-indicator?") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 11 years 4 months ago, by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") [Last Post](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20#228591 "Hi, Then enter db/cataloog_import_ok.csv as the CSV file path and not /db/cataloog_import_ok.csv Or try with the absolute path of the CSV file on the server. Both should work. If you prepend the relative path with a /, it thinks that you're trying to access a file in /db/cataloog_import_ok.csv and not in /home/myuser/www/db/cataloog_import_ok.csv") 10 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") - [1](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=0 "Page:1") - [2](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20 "Page:2") | Replies:24 Views:2920 | [Last Post](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20#228591 "Hi, Then enter db/cataloog_import_ok.csv as the CSV file path and not /db/cataloog_import_ok.csv Or try with the absolute path of the CSV file on the server. Both should work. If you prepend the relative path with a /, it thinks that you're trying to access a file in /db/cataloog_import_ok.csv and not in /home/myuser/www/db/cataloog_import_ok.csv") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 10 years 8 months ago |
| [](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20#227608) | [Piping symbol in import file is not possible ...](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20#227608 "-- HikaShop version -- : latest -- Joomla version -- : latest I have a working import based on manually entered data. Now our IT department has to create a periodical export from our ERP that will be imported via a cron into our Hikashop. They however have a problem using a piping-symbol ("\|") in the column names (product_name\|en-GB, product_name\|fr-FR, ...) Is there a way to change this piping-symbol so they/we can use some different character as a separator for the language-indicator?") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 11 years 4 months ago, by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") [Last Post](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20#228591 "Hi, Then enter db/cataloog_import_ok.csv as the CSV file path and not /db/cataloog_import_ok.csv Or try with the absolute path of the CSV file on the server. Both should work. If you prepend the relative path with a /, it thinks that you're trying to access a file in /db/cataloog_import_ok.csv and not in /home/myuser/www/db/cataloog_import_ok.csv") 10 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") - [1](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=0 "Page:1") - [2](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20 "Page:2") | Replies:24 Views:2920 | [Last Post](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20#228591 "Hi, Then enter db/cataloog_import_ok.csv as the CSV file path and not /db/cataloog_import_ok.csv Or try with the absolute path of the CSV file on the server. Both should work. If you prepend the relative path with a /, it thinks that you're trying to access a file in /db/cataloog_import_ok.csv and not in /home/myuser/www/db/cataloog_import_ok.csv") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 10 years 8 months ago |
| [](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible#227255) | [Piping symbol in import file is not possible ...](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible#227255 "-- HikaShop version -- : latest -- Joomla version -- : latest I have a working import based on manually entered data. Now our IT department has to create a periodical export from our ERP that will be imported via a cron into our Hikashop. They however have a problem using a piping-symbol ("\|") in the column names (product_name\|en-GB, product_name\|fr-FR, ...) Is there a way to change this piping-symbol so they/we can use some different character as a separator for the language-indicator?") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 11 years 4 months ago, by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") [Last Post](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20#228591 "Hi, Then enter db/cataloog_import_ok.csv as the CSV file path and not /db/cataloog_import_ok.csv Or try with the absolute path of the CSV file on the server. Both should work. If you prepend the relative path with a /, it thinks that you're trying to access a file in /db/cataloog_import_ok.csv and not in /home/myuser/www/db/cataloog_import_ok.csv") 10 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") - [1](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=0 "Page:1") - [2](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20 "Page:2") | Replies:24 Views:2920 | [Last Post](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20#228591 "Hi, Then enter db/cataloog_import_ok.csv as the CSV file path and not /db/cataloog_import_ok.csv Or try with the absolute path of the CSV file on the server. Both should work. If you prepend the relative path with a /, it thinks that you're trying to access a file in /db/cataloog_import_ok.csv and not in /home/myuser/www/db/cataloog_import_ok.csv") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 10 years 8 months ago |
| [](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible#227157) | [Piping symbol in import file is not possible ...](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible#227157 "-- HikaShop version -- : latest -- Joomla version -- : latest I have a working import based on manually entered data. Now our IT department has to create a periodical export from our ERP that will be imported via a cron into our Hikashop. They however have a problem using a piping-symbol ("\|") in the column names (product_name\|en-GB, product_name\|fr-FR, ...) Is there a way to change this piping-symbol so they/we can use some different character as a separator for the language-indicator?") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 11 years 4 months ago, by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") [Last Post](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20#228591 "Hi, Then enter db/cataloog_import_ok.csv as the CSV file path and not /db/cataloog_import_ok.csv Or try with the absolute path of the CSV file on the server. Both should work. If you prepend the relative path with a /, it thinks that you're trying to access a file in /db/cataloog_import_ok.csv and not in /home/myuser/www/db/cataloog_import_ok.csv") 10 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") - [1](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=0 "Page:1") - [2](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20 "Page:2") | Replies:24 Views:2920 | [Last Post](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20#228591 "Hi, Then enter db/cataloog_import_ok.csv as the CSV file path and not /db/cataloog_import_ok.csv Or try with the absolute path of the CSV file on the server. Both should work. If you prepend the relative path with a /, it thinks that you're trying to access a file in /db/cataloog_import_ok.csv and not in /home/myuser/www/db/cataloog_import_ok.csv") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 10 years 8 months ago |
| [](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible#217127) | [Piping symbol in import file is not possible ...](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible#217127 "-- HikaShop version -- : latest -- Joomla version -- : latest I have a working import based on manually entered data. Now our IT department has to create a periodical export from our ERP that will be imported via a cron into our Hikashop. They however have a problem using a piping-symbol ("\|") in the column names (product_name\|en-GB, product_name\|fr-FR, ...) Is there a way to change this piping-symbol so they/we can use some different character as a separator for the language-indicator?") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 11 years 4 months ago, by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") [Last Post](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20#228591 "Hi, Then enter db/cataloog_import_ok.csv as the CSV file path and not /db/cataloog_import_ok.csv Or try with the absolute path of the CSV file on the server. Both should work. If you prepend the relative path with a /, it thinks that you're trying to access a file in /db/cataloog_import_ok.csv and not in /home/myuser/www/db/cataloog_import_ok.csv") 10 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") - [1](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=0 "Page:1") - [2](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20 "Page:2") | Replies:24 Views:2920 | [Last Post](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20#228591 "Hi, Then enter db/cataloog_import_ok.csv as the CSV file path and not /db/cataloog_import_ok.csv Or try with the absolute path of the CSV file on the server. Both should work. If you prepend the relative path with a /, it thinks that you're trying to access a file in /db/cataloog_import_ok.csv and not in /home/myuser/www/db/cataloog_import_ok.csv") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 10 years 8 months ago |
| [](/forum/45-filters-search/878181-search-result-for-other-languages-go-to-404-page#208557) | [Search result for other languages go to 404-page](/forum/45-filters-search/878181-search-result-for-other-languages-go-to-404-page#208557 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 When configuring the Hikashop search plugins everything seems to work ... for the default language. For the other languages (4 now but more to come) however I get a 404 whenever I click on a link to a product that was found in the hikashop. I've been looking for the answer in the forum but can't find this specific problem (or a solution to this problem)... "Force canonical URLs on listings" is set to "No, generate the URL's" because I noticed some unexpected behaviour when this was set to "use canonical url if specified" (when browsing the products in our catalog the language seemed to change for the whole site) the regular content that shows up in the search results does work ... only products from the Hikashop don't.") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 11 years 3 months ago, by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") [Last Post](/forum/45-filters-search/878181-search-result-for-other-languages-go-to-404-page#208557 "That was exactly what was wrong ... thank you ... the canonical urls ... i will leave them the same as it was ... all my products are imported via cron directly from our erp-software ... since there is no url in our erp (and certainly no url per language) our IT-team would not be pleased if they have to come up with something like this ... ;-)") 11 years 3 months ago by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") | Replies:2 Views:905 | [Last Post](/forum/45-filters-search/878181-search-result-for-other-languages-go-to-404-page#208557 "That was exactly what was wrong ... thank you ... the canonical urls ... i will leave them the same as it was ... all my products are imported via cron directly from our erp-software ... since there is no url in our erp (and certainly no url per language) our IT-team would not be pleased if they have to come up with something like this ... ;-)") by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") 11 years 3 months ago |
| [](/forum/45-filters-search/878181-search-result-for-other-languages-go-to-404-page#208477) | [Search result for other languages go to 404-page](/forum/45-filters-search/878181-search-result-for-other-languages-go-to-404-page#208477 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 When configuring the Hikashop search plugins everything seems to work ... for the default language. For the other languages (4 now but more to come) however I get a 404 whenever I click on a link to a product that was found in the hikashop. I've been looking for the answer in the forum but can't find this specific problem (or a solution to this problem)... "Force canonical URLs on listings" is set to "No, generate the URL's" because I noticed some unexpected behaviour when this was set to "use canonical url if specified" (when browsing the products in our catalog the language seemed to change for the whole site) the regular content that shows up in the search results does work ... only products from the Hikashop don't.") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 11 years 3 months ago, by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") [Last Post](/forum/45-filters-search/878181-search-result-for-other-languages-go-to-404-page#208557 "That was exactly what was wrong ... thank you ... the canonical urls ... i will leave them the same as it was ... all my products are imported via cron directly from our erp-software ... since there is no url in our erp (and certainly no url per language) our IT-team would not be pleased if they have to come up with something like this ... ;-)") 11 years 3 months ago by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") | Replies:2 Views:905 | [Last Post](/forum/45-filters-search/878181-search-result-for-other-languages-go-to-404-page#208557 "That was exactly what was wrong ... thank you ... the canonical urls ... i will leave them the same as it was ... all my products are imported via cron directly from our erp-software ... since there is no url in our erp (and certainly no url per language) our IT-team would not be pleased if they have to come up with something like this ... ;-)") by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") 11 years 3 months ago |
| [](/forum/37-import-export-csv-xls/877802-importing-multiple-user-groups-for-price-access#206702) | [Importing multiple user groups for price\_access](/forum/37-import-export-csv-xls/877802-importing-multiple-user-groups-for-price-access#206702 "-- HikaShop version -- : latest -- Joomla version -- : latest -- PHP version -- : latest Hi, I'm making an import with a lot of articles (starting out small but it will be large once everything works) Most of those articles have 2 prices and 2 quantities ... price 1-> qty 1, from Qty 2 -> price 2 ... the regular stuff ... HOWEVER, I want price 2 to only be visible to 3 (or 4) user groups ... There is no problem if I want it for 1 user group (I can import price_access as "all\|21" where 21 is the id of the user group). However, HOW can I import something like "all\|21,13,8"? when I try this some strange things happen to my articles ... products appear in categories they don't belong and translations get all mixed-up ... I tried "all\|21\|13\|8", "all\|,21,\|,13,\|,8,", "all\|21,13,8", "all\|,21,13,8," ... none of these seem to work ... I usually use ";" as a separator for the fields and "\|" as a separator inside the fields ... "," appears in some product names so might not be the best choice as a separator ... I also have access levels defined (Joomla!) with the correct user groups in them ... but how can I select those for import ... it appears only user groups can be selected ...") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 11 years 4 months ago, by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") [Last Post](/forum/37-import-export-csv-xls/877802-importing-multiple-user-groups-for-price-access#206702 "It seems that one does work ... thanks ...") 11 years 3 months ago by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") | Replies:2 Views:955 | [Last Post](/forum/37-import-export-csv-xls/877802-importing-multiple-user-groups-for-price-access#206702 "It seems that one does work ... thanks ...") by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") 11 years 3 months ago |
| [](/forum/37-import-export-csv-xls/877802-importing-multiple-user-groups-for-price-access#206350) | [Importing multiple user groups for price\_access](/forum/37-import-export-csv-xls/877802-importing-multiple-user-groups-for-price-access#206350 "-- HikaShop version -- : latest -- Joomla version -- : latest -- PHP version -- : latest Hi, I'm making an import with a lot of articles (starting out small but it will be large once everything works) Most of those articles have 2 prices and 2 quantities ... price 1-> qty 1, from Qty 2 -> price 2 ... the regular stuff ... HOWEVER, I want price 2 to only be visible to 3 (or 4) user groups ... There is no problem if I want it for 1 user group (I can import price_access as "all\|21" where 21 is the id of the user group). However, HOW can I import something like "all\|21,13,8"? when I try this some strange things happen to my articles ... products appear in categories they don't belong and translations get all mixed-up ... I tried "all\|21\|13\|8", "all\|,21,\|,13,\|,8,", "all\|21,13,8", "all\|,21,13,8," ... none of these seem to work ... I usually use ";" as a separator for the fields and "\|" as a separator inside the fields ... "," appears in some product names so might not be the best choice as a separator ... I also have access levels defined (Joomla!) with the correct user groups in them ... but how can I select those for import ... it appears only user groups can be selected ...") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 11 years 4 months ago, by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") [Last Post](/forum/37-import-export-csv-xls/877802-importing-multiple-user-groups-for-price-access#206702 "It seems that one does work ... thanks ...") 11 years 3 months ago by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") | Replies:2 Views:955 | [Last Post](/forum/37-import-export-csv-xls/877802-importing-multiple-user-groups-for-price-access#206702 "It seems that one does work ... thanks ...") by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") 11 years 3 months ago |
| [](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible#206178) | [Piping symbol in import file is not possible ...](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible#206178 "-- HikaShop version -- : latest -- Joomla version -- : latest I have a working import based on manually entered data. Now our IT department has to create a periodical export from our ERP that will be imported via a cron into our Hikashop. They however have a problem using a piping-symbol ("\|") in the column names (product_name\|en-GB, product_name\|fr-FR, ...) Is there a way to change this piping-symbol so they/we can use some different character as a separator for the language-indicator?") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 11 years 4 months ago, by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo_wilms's Profile") [Last Post](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20#228591 "Hi, Then enter db/cataloog_import_ok.csv as the CSV file path and not /db/cataloog_import_ok.csv Or try with the absolute path of the CSV file on the server. Both should work. If you prepend the relative path with a /, it thinks that you're trying to access a file in /db/cataloog_import_ok.csv and not in /home/myuser/www/db/cataloog_import_ok.csv") 10 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") - [1](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=0 "Page:1") - [2](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20 "Page:2") | Replies:24 Views:2920 | [Last Post](/forum/37-import-export-csv-xls/877620-piping-symbol-in-import-file-is-not-possible?start=20#228591 "Hi, Then enter db/cataloog_import_ok.csv as the CSV file path and not /db/cataloog_import_ok.csv Or try with the absolute path of the CSV file on the server. Both should work. If you prepend the relative path with a /, it thinks that you're trying to access a file in /db/cataloog_import_ok.csv and not in /home/myuser/www/db/cataloog_import_ok.csv") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 10 years 8 months ago |
[](/forum/topics/feed/mode-topics?format=feed&type=rss)
Time to create page: 0.186 seconds
[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
[](#top)