[Skip to main content](#vessel-content)

#   Piping symbol in import file is not possible ...

##

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

10 years 9 months ago [\#227347](#227347) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[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#227347 "-- 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 (&quot;|&quot;) in the column names (product&#95;name|en-GB, product&#95;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?")*

Hi,

The plugin is made to accept a relative path for the CSV file.
So the file should be in your Joomla folder.

Now I created a ticket in order to let the rest of the HikaShop team take a look more deeply in that plugin code.
I am personally not found to always convert the file path into an URL.
If you still have some issues with the plugin, please try to put a full URL like Code:

http://www.mydomain.com/folder/import.csv

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Nzc2MjAtcGlwaW5nLXN5bWJvbC1pbi1pbXBvcnQtZmlsZS1pcy1ub3QtcG9zc2libGU/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo&#95;wilms's Profile")**
- [![yvo&#95;wilms's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/37661-yvo-wilms "View yvo&#95;wilms's Profile") Topic Author
- [ Offline](/forum/user/37661-yvo-wilms)

Less More

- Posts: 20
- Thank you received: 0
-
-

10 years 9 months ago [\#227608](#227608) by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo&#95;wilms's Profile")  Replied by *[yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo&#95;wilms's Profile")* on topic *[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 (&quot;|&quot;) in the column names (product&#95;name|en-GB, product&#95;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?")*

I tried that (and again today) with the original datafeed.php ... doesn't work ..
this is probably something stupid (and small) that I forgot to set ...

thank you for creating a ticket ... let's hope this can be solved more permanently.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Nzc2MjAtcGlwaW5nLXN5bWJvbC1pbi1pbXBvcnQtZmlsZS1pcy1ub3QtcG9zc2libGU/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

10 years 9 months ago [\#227845](#227845) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[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#227845 "-- 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 (&quot;|&quot;) in the column names (product&#95;name|en-GB, product&#95;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?")*

Hi,

We are not able to reproduce that issue on our end, even after many different tries.

You said that you entered the path "db/thefile.csv" but is the folder "db" in your Joomla files ? Not in the parent folder ?
Have you tried with "/db/thefile.csv" ?

This feature of updating products from a csv file can be done via the mass actions too, so you can give it a try and see if the path is correctly handled in that way.

Else to debug definitely this issue, we will need a backend and FTP access in order to test it directly on your end.
These informations can be sent via our contact form, don't forget to give the link to this topic in your message.
[ www.hikashop.com/support/contact-us.html](https://www.hikashop.com/support/contact-us.html)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Nzc2MjAtcGlwaW5nLXN5bWJvbC1pbi1pbXBvcnQtZmlsZS1pcy1ub3QtcG9zc2libGU/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo&#95;wilms's Profile")**
- [![yvo&#95;wilms's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/37661-yvo-wilms "View yvo&#95;wilms's Profile") Topic Author
- [ Offline](/forum/user/37661-yvo-wilms)

Less More

- Posts: 20
- Thank you received: 0
-
-

10 years 9 months ago [\#227864](#227864) by [yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo&#95;wilms's Profile")  Replied by *[yvo\_wilms](/forum/user/37661-yvo-wilms "View yvo&#95;wilms's Profile")* on topic *[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 (&quot;|&quot;) in the column names (product&#95;name|en-GB, product&#95;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?")*

The db-folder is in the site root (just as Joomla is)
so the db-folder is at the same level as index.php, administrator (folder), components, images, ...
I tried /db/... but this is the response: Could not retrieve the CSV file /db/cataloog_import_ok.csv

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Nzc2MjAtcGlwaW5nLXN5bWJvbC1pbi1pbXBvcnQtZmlsZS1pcy1ub3QtcG9zc2libGU/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

10 years 9 months ago [\#228591](#228591) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[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#228591 "-- 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 (&quot;|&quot;) in the column names (product&#95;name|en-GB, product&#95;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?")*

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Nzc2MjAtcGlwaW5nLXN5bWJvbC1pbi1pbXBvcnQtZmlsZS1pcy1ub3QtcG9zc2libGU/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.063 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
