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

#   Share order information outside Joomla/hikashop

##

- **[Teto](/forum/user/8045-teto "View Teto's Profile")**
- [![Teto's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar8045_2012-09-12.png)](/forum/user/8045-teto "View Teto's Profile") Topic Author
- [ Offline](/forum/user/8045-teto)

Less More

- Posts: 184
- Thank you received: 4
-
- [](http://www.madeinvino.com)
-

14 years 2 months ago [\#62792](#62792) by [Teto](/forum/user/8045-teto "View Teto's Profile")  *[Share order information outside Joomla/hikashop](/forum/2-general-talk-about-hikashop/62792-share-order-information-outside-joomla-hikashop#62792 "Good morning  we are almost ready to start with our business.  We need to extract the order data from Hikashop, in order to load the information into another application (the application is outside the web) that we use for different things.  I know I can use the export button but I am looking for a way to automatically extract the data.  Do you know if exist any extension which can share the Joomla tables? Like a SOA service? Otherwise do you think is possible to schedule a task which everyday extracts a CSV with the orders and sends the file to an email or a folder?  Thanks for you help.")* was created by *[Teto](/forum/user/8045-teto "View Teto's Profile")*

Good morning

we are almost ready to start with our business.

We need to extract the order data from Hikashop, in order to load the information into another application (the application is outside the web) that we use for different things.

I know I can use the export button but I am looking for a way to automatically extract the data.

Do you know if exist any extension which can share the Joomla tables? Like a SOA service?
Otherwise do you think is possible to schedule a task which everyday extracts a CSV with the orders and sends the file to an email or a folder?

Thanks for you help.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYyNzkyLXNoYXJlLW9yZGVyLWluZm9ybWF0aW9uLW91dHNpZGUtam9vbWxhLWhpa2FzaG9wP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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: 86322
- Thank you received: 14281
-
-

14 years 2 months ago [\#62901](#62901) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Share order information outside Joomla/hikashop](/forum/2-general-talk-about-hikashop/62792-share-order-information-outside-joomla-hikashop#62901 "Good morning  we are almost ready to start with our business.  We need to extract the order data from Hikashop, in order to load the information into another application (the application is outside the web) that we use for different things.  I know I can use the export button but I am looking for a way to automatically extract the data.  Do you know if exist any extension which can share the Joomla tables? Like a SOA service? Otherwise do you think is possible to schedule a task which everyday extracts a CSV with the orders and sends the file to an email or a folder?  Thanks for you help.")*

Hi,

I don't know any extension for that.

You could create a hikashop plugin which would implement the cron trigger event of HikaShop and use the hikashop_getLayout function to load the export layout of the back end and save it as a file in a folder and potentially mail it or upload it somewhere. That will however require that a developer do that plugin.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYyNzkyLXNoYXJlLW9yZGVyLWluZm9ybWF0aW9uLW91dHNpZGUtam9vbWxhLWhpa2FzaG9wP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

- **[PolishedGeek](/forum/user/8378-polishedgeek "View PolishedGeek's Profile")**
- [![PolishedGeek's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar8378_2012-07-29-5.png)](/forum/user/8378-polishedgeek "View PolishedGeek's Profile")
- [ Offline](/forum/user/8378-polishedgeek)
- Official HikaShop Development Partner

Less More

- Posts: 329
- Thank you received: 94
-
- [](http://PolishedGeek.com/?utm_source=hikashop)
-

14 years 2 months ago [\#63372](#63372) by [PolishedGeek](/forum/user/8378-polishedgeek "View PolishedGeek's Profile")  Replied by *[PolishedGeek](/forum/user/8378-polishedgeek "View PolishedGeek's Profile")* on topic *[Re: Share order information outside Joomla/hikashop](/forum/2-general-talk-about-hikashop/62792-share-order-information-outside-joomla-hikashop#63372 "Good morning  we are almost ready to start with our business.  We need to extract the order data from Hikashop, in order to load the information into another application (the application is outside the web) that we use for different things.  I know I can use the export button but I am looking for a way to automatically extract the data.  Do you know if exist any extension which can share the Joomla tables? Like a SOA service? Otherwise do you think is possible to schedule a task which everyday extracts a CSV with the orders and sends the file to an email or a folder?  Thanks for you help.")*

@Teto - As Nicolas mentions, you could either have a plugin written or could have a cron job developed to automate the process. Both would be custom development projects. My company Polished Geek specializes in custom development and external integrations for Joomla. We've integrated Joomla components and ecommerce with multiple outside applications, including complex ones like SalesForce and eBay. I'm sure our team can design and develop a solution that best fits your needs.

If you would like to privately chat about it, just send me a note by using our ticket system: [ polishedgeek.com/clients/submitticket.php?step=2&amp;deptid=3](https://polishedgeek.com/clients/submitticket.php?step=2&deptid=3)

Look forward to hearing from you!

---

~ Deb Cinkus, CEO

Polished Geek: more with monday․com
eCommerce Business Process Automation Experts

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYyNzkyLXNoYXJlLW9yZGVyLWluZm9ybWF0aW9uLW91dHNpZGUtam9vbWxhLWhpa2FzaG9wP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation.

- **[Teto](/forum/user/8045-teto "View Teto's Profile")**
- [![Teto's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar8045_2012-09-12.png)](/forum/user/8045-teto "View Teto's Profile") Topic Author
- [ Offline](/forum/user/8045-teto)

Less More

- Posts: 184
- Thank you received: 4
-
- [](http://www.madeinvino.com)
-

14 years 1 month ago [\#63977](#63977) by [Teto](/forum/user/8045-teto "View Teto's Profile")  Replied by *[Teto](/forum/user/8045-teto "View Teto's Profile")* on topic *[Re: Share order information outside Joomla/hikashop](/forum/2-general-talk-about-hikashop/62792-share-order-information-outside-joomla-hikashop#63977 "Good morning  we are almost ready to start with our business.  We need to extract the order data from Hikashop, in order to load the information into another application (the application is outside the web) that we use for different things.  I know I can use the export button but I am looking for a way to automatically extract the data.  Do you know if exist any extension which can share the Joomla tables? Like a SOA service? Otherwise do you think is possible to schedule a task which everyday extracts a CSV with the orders and sends the file to an email or a folder?  Thanks for you help.")*

Dear Nicolas,

regarding the standard CSV export, is there a way to change the separator character used?

For example i would like to use "&#124;" instead the ";"

Thanks.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYyNzkyLXNoYXJlLW9yZGVyLWluZm9ybWF0aW9uLW91dHNpZGUtam9vbWxhLWhpa2FzaG9wP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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: 86322
- Thank you received: 14281
-
-

14 years 1 month ago [\#64169](#64169) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Share order information outside Joomla/hikashop](/forum/2-general-talk-about-hikashop/62792-share-order-information-outside-joomla-hikashop#64169 "Good morning  we are almost ready to start with our business.  We need to extract the order data from Hikashop, in order to load the information into another application (the application is outside the web) that we use for different things.  I know I can use the export button but I am looking for a way to automatically extract the data.  Do you know if exist any extension which can share the Joomla tables? Like a SOA service? Otherwise do you think is possible to schedule a task which everyday extracts a CSV with the orders and sends the file to an email or a folder?  Thanks for you help.")*

Hi,

By default you can only choose between comma and semi colon in the Files tab of the configuration.
If you need another separator, you can go in the table hikashop_config via phpmyadmin and edit the entry called "csv_separator" and change its value from ; to &#124;

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYyNzkyLXNoYXJlLW9yZGVyLWluZm9ybWF0aW9uLW91dHNpZGUtam9vbWxhLWhpa2FzaG9wP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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.108 seconds

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