[Skip to main content](#vessel-content) # Problem exporting ## - **[Dibben](/forum/user/6788-dibben "View Dibben's Profile")** - [![Dibben's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6788-dibben "View Dibben's Profile") Topic Author - [ Offline](/forum/user/6788-dibben) Less More - Posts: 377 - Thank you received: 7 - - 13 years 3 months ago [\#116713](#116713) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile") *[Problem exporting](/forum/37-import-export-csv-xls/860554-problem-exporting#116713 ": liveelite.co.uk [HikaShop version] : 2.2.0 [Joomla version] : 2.5.11 [PHP version] : 5.3.24 [Browser(s) name and version] : Firefox 22.0 [Error-message(debug-mod must be tuned on)] : Backend error - no error message the screen just goes white when trying to export, we are trying to export last months orders and we have 1500 records. However i can only export what is displayed. The maximum it shows me is 100 records. I need to be able to export the full 1500 records however. Surely i don't have to do 15 exports? We didnt have an issue with doing this before updating hikashop to the newest version. It would be good to either let us know how we need to configure it to show all records, or have an export button that allows us to export the range selected without having to display that whole range on the screen? Thanks Alex")* was created by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")* [url of the page with the problem] : [ liveelite.co.uk](http://liveelite.co.uk) [HikaShop version] : 2.2.0 [Joomla version] : 2.5.11 [PHP version] : 5.3.24 [Browser(s) name and version] : Firefox 22.0 [Error-message(debug-mod must be tuned on)] : Backend error - no error message the screen just goes white when trying to export, we are trying to export last months orders and we have 1500 records. However i can only export what is displayed. The maximum it shows me is 100 records. I need to be able to export the full 1500 records however. Surely i don't have to do 15 exports? We didnt have an issue with doing this before updating hikashop to the newest version. It would be good to either let us know how we need to configure it to show all records, or have an export button that allows us to export the range selected without having to display that whole range on the screen? Thanks Alex[/url] Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjA1NTQtcHJvYmxlbS1leHBvcnRpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 3 months ago [\#116760](#116760) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Problem exporting](/forum/37-import-export-csv-xls/860554-problem-exporting#116760 ": liveelite.co.uk [HikaShop version] : 2.2.0 [Joomla version] : 2.5.11 [PHP version] : 5.3.24 [Browser(s) name and version] : Firefox 22.0 [Error-message(debug-mod must be tuned on)] : Backend error - no error message the screen just goes white when trying to export, we are trying to export last months orders and we have 1500 records. However i can only export what is displayed. The maximum it shows me is 100 records. I need to be able to export the full 1500 records however. Surely i don't have to do 15 exports? We didnt have an issue with doing this before updating hikashop to the newest version. It would be good to either let us know how we need to configure it to show all records, or have an export button that allows us to export the range selected without having to display that whole range on the screen? Thanks Alex")* Hi Alex, How do you export your product? If you don't select any product in your backend product listing then it export everything in one time. I guess this is the solution to export your 1500 products ![:)](/media/kunena/emoticons/3.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjA1NTQtcHJvYmxlbS1leHBvcnRpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Dibben](/forum/user/6788-dibben "View Dibben's Profile")** - [![Dibben's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6788-dibben "View Dibben's Profile") Topic Author - [ Offline](/forum/user/6788-dibben) Less More - Posts: 377 - Thank you received: 7 - - 13 years 3 months ago [\#116780](#116780) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile") Replied by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")* on topic *[Problem exporting](/forum/37-import-export-csv-xls/860554-problem-exporting#116780 ": liveelite.co.uk [HikaShop version] : 2.2.0 [Joomla version] : 2.5.11 [PHP version] : 5.3.24 [Browser(s) name and version] : Firefox 22.0 [Error-message(debug-mod must be tuned on)] : Backend error - no error message the screen just goes white when trying to export, we are trying to export last months orders and we have 1500 records. However i can only export what is displayed. The maximum it shows me is 100 records. I need to be able to export the full 1500 records however. Surely i don't have to do 15 exports? We didnt have an issue with doing this before updating hikashop to the newest version. It would be good to either let us know how we need to configure it to show all records, or have an export button that allows us to export the range selected without having to display that whole range on the screen? Thanks Alex")* Hi Eliot, Sorry i wasn't referring to the products i was referring to the orders. What we do is export the orders each month and then send this to the suppliers. However i am having difficulty exporting these orders as it only displays 100 at a time. Thanks Alex Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjA1NTQtcHJvYmxlbS1leHBvcnRpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 3 months ago [\#116783](#116783) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Problem exporting](/forum/37-import-export-csv-xls/860554-problem-exporting#116783 ": liveelite.co.uk [HikaShop version] : 2.2.0 [Joomla version] : 2.5.11 [PHP version] : 5.3.24 [Browser(s) name and version] : Firefox 22.0 [Error-message(debug-mod must be tuned on)] : Backend error - no error message the screen just goes white when trying to export, we are trying to export last months orders and we have 1500 records. However i can only export what is displayed. The maximum it shows me is 100 records. I need to be able to export the full 1500 records however. Surely i don't have to do 15 exports? We didnt have an issue with doing this before updating hikashop to the newest version. It would be good to either let us know how we need to configure it to show all records, or have an export button that allows us to export the range selected without having to display that whole range on the screen? Thanks Alex")* My bad! In this case I would suggest to use our brand new mass action system. You can find this feature in System>Mass Action, it allow you to create a csv of orders really easily even with some filters. i hope it will fit your needs! The following user(s) said Thank You: [Dibben](/forum/user/6788-dibben "View Dibben's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjA1NTQtcHJvYmxlbS1leHBvcnRpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Dibben](/forum/user/6788-dibben "View Dibben's Profile")** - [![Dibben's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6788-dibben "View Dibben's Profile") Topic Author - [ Offline](/forum/user/6788-dibben) Less More - Posts: 377 - Thank you received: 7 - - 13 years 3 months ago [\#116799](#116799) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile") Replied by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")* on topic *[Problem exporting](/forum/37-import-export-csv-xls/860554-problem-exporting#116799 ": liveelite.co.uk [HikaShop version] : 2.2.0 [Joomla version] : 2.5.11 [PHP version] : 5.3.24 [Browser(s) name and version] : Firefox 22.0 [Error-message(debug-mod must be tuned on)] : Backend error - no error message the screen just goes white when trying to export, we are trying to export last months orders and we have 1500 records. However i can only export what is displayed. The maximum it shows me is 100 records. I need to be able to export the full 1500 records however. Surely i don't have to do 15 exports? We didnt have an issue with doing this before updating hikashop to the newest version. It would be good to either let us know how we need to configure it to show all records, or have an export button that allows us to export the range selected without having to display that whole range on the screen? Thanks Alex")* Thanks Eliot. I seem to be getting further this way, one thing though, we have 15,000 orders so far which takes a long time to process so i set the limit to 3,000 orders, however this gives me the first 3000 orders. Can i set it in any way so that i get the 3000 most recent orders rather than 3000 first? Or do i need to set the start limit to say 12,000 then run the process? Regards, Alex - [ ![h83403d1.png](/forum/attachment/11494) ](/forum/attachment/11494 "h83403d1.png") [ ](/forum/attachment/11494?download=1 "h83403d1.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjA1NTQtcHJvYmxlbS1leHBvcnRpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 3 months ago [\#116820](#116820) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Problem exporting](/forum/37-import-export-csv-xls/860554-problem-exporting#116820 ": liveelite.co.uk [HikaShop version] : 2.2.0 [Joomla version] : 2.5.11 [PHP version] : 5.3.24 [Browser(s) name and version] : Firefox 22.0 [Error-message(debug-mod must be tuned on)] : Backend error - no error message the screen just goes white when trying to export, we are trying to export last months orders and we have 1500 records. However i can only export what is displayed. The maximum it shows me is 100 records. I need to be able to export the full 1500 records however. Surely i don't have to do 15 exports? We didnt have an issue with doing this before updating hikashop to the newest version. It would be good to either let us know how we need to configure it to show all records, or have an export button that allows us to export the range selected without having to display that whole range on the screen? Thanks Alex")* Indeed setting a limit is a good idea (plus this system is quite convenient to use). What you have to do is simply change the value of the "start" field. Set it to 0, then 3000, then 6000 (if you have a limit set to 3000) so it will export the orders from where it stopped ![:)](/media/kunena/emoticons/3.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjA1NTQtcHJvYmxlbS1leHBvcnRpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Dibben](/forum/user/6788-dibben "View Dibben's Profile")** - [![Dibben's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6788-dibben "View Dibben's Profile") Topic Author - [ Offline](/forum/user/6788-dibben) Less More - Posts: 377 - Thank you received: 7 - - 13 years 3 months ago [\#116821](#116821) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile") Replied by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")* on topic *[Problem exporting](/forum/37-import-export-csv-xls/860554-problem-exporting#116821 ": liveelite.co.uk [HikaShop version] : 2.2.0 [Joomla version] : 2.5.11 [PHP version] : 5.3.24 [Browser(s) name and version] : Firefox 22.0 [Error-message(debug-mod must be tuned on)] : Backend error - no error message the screen just goes white when trying to export, we are trying to export last months orders and we have 1500 records. However i can only export what is displayed. The maximum it shows me is 100 records. I need to be able to export the full 1500 records however. Surely i don't have to do 15 exports? We didnt have an issue with doing this before updating hikashop to the newest version. It would be good to either let us know how we need to configure it to show all records, or have an export button that allows us to export the range selected without having to display that whole range on the screen? Thanks Alex")* I agree, this is a great system, you guys really do provide the best products and support! Thanks! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjA1NTQtcHJvYmxlbS1leHBvcnRpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Dibben](/forum/user/6788-dibben "View Dibben's Profile")** - [![Dibben's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6788-dibben "View Dibben's Profile") Topic Author - [ Offline](/forum/user/6788-dibben) Less More - Posts: 377 - Thank you received: 7 - - 13 years 3 months ago [\#116828](#116828) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile") Replied by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")* on topic *[Problem exporting](/forum/37-import-export-csv-xls/860554-problem-exporting#116828 ": liveelite.co.uk [HikaShop version] : 2.2.0 [Joomla version] : 2.5.11 [PHP version] : 5.3.24 [Browser(s) name and version] : Firefox 22.0 [Error-message(debug-mod must be tuned on)] : Backend error - no error message the screen just goes white when trying to export, we are trying to export last months orders and we have 1500 records. However i can only export what is displayed. The maximum it shows me is 100 records. I need to be able to export the full 1500 records however. Surely i don't have to do 15 exports? We didnt have an issue with doing this before updating hikashop to the newest version. It would be good to either let us know how we need to configure it to show all records, or have an export button that allows us to export the range selected without having to display that whole range on the screen? Thanks Alex")* Please can you look into why i am getting duplicates on the export? Is this because of hikamarket? We have changed the setting on there to use same order number throughout however this export seems to just be giving us a duplicate. Are you sure there is no way we can export the old way as this didnt give us duplicates. Otherwise we need to go through 1500 orders and de-duplicate each order. Thanks Alex - [ ![h865f088.png](/forum/attachment/11499) ](/forum/attachment/11499 "h865f088.png") [ ](/forum/attachment/11499?download=1 "h865f088.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjA1NTQtcHJvYmxlbS1leHBvcnRpbmc/dG1wbD1tYXJrZG93bg==) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86324 - Thank you received: 14286 - - 13 years 3 months ago [\#116858](#116858) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Problem exporting](/forum/37-import-export-csv-xls/860554-problem-exporting#116858 ": liveelite.co.uk [HikaShop version] : 2.2.0 [Joomla version] : 2.5.11 [PHP version] : 5.3.24 [Browser(s) name and version] : Firefox 22.0 [Error-message(debug-mod must be tuned on)] : Backend error - no error message the screen just goes white when trying to export, we are trying to export last months orders and we have 1500 records. However i can only export what is displayed. The maximum it shows me is 100 records. I need to be able to export the full 1500 records however. Surely i don't have to do 15 exports? We didnt have an issue with doing this before updating hikashop to the newest version. It would be good to either let us know how we need to configure it to show all records, or have an export button that allows us to export the range selected without having to display that whole range on the screen? Thanks Alex")* It's normal. Both orders and sub orders (orders for each vendor) are stored together. If you only want to export the main orders, you need to add a second filter on the order_type column equal to the value "sale" Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjA1NTQtcHJvYmxlbS1leHBvcnRpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Dibben](/forum/user/6788-dibben "View Dibben's Profile")** - [![Dibben's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6788-dibben "View Dibben's Profile") Topic Author - [ Offline](/forum/user/6788-dibben) Less More - Posts: 377 - Thank you received: 7 - - 13 years 2 months ago [\#117424](#117424) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile") Replied by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")* on topic *[Problem exporting](/forum/37-import-export-csv-xls/860554-problem-exporting#117424 ": liveelite.co.uk [HikaShop version] : 2.2.0 [Joomla version] : 2.5.11 [PHP version] : 5.3.24 [Browser(s) name and version] : Firefox 22.0 [Error-message(debug-mod must be tuned on)] : Backend error - no error message the screen just goes white when trying to export, we are trying to export last months orders and we have 1500 records. However i can only export what is displayed. The maximum it shows me is 100 records. I need to be able to export the full 1500 records however. Surely i don't have to do 15 exports? We didnt have an issue with doing this before updating hikashop to the newest version. It would be good to either let us know how we need to configure it to show all records, or have an export button that allows us to export the range selected without having to display that whole range on the screen? Thanks Alex")* Hi Nicolas, Thanks, this doesn't seem to retrieve any data, can you confirm that it is correct (attached).? Many thanks. - [ ![hb6f68b9.jpg](/forum/attachment/11567) ](/forum/attachment/11567 "hb6f68b9.jpg") [ ](/forum/attachment/11567?download=1 "hb6f68b9.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjA1NTQtcHJvYmxlbS1leHBvcnRpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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) - 13 years 2 months ago [\#117431](#117431) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Problem exporting](/forum/37-import-export-csv-xls/860554-problem-exporting#117431 ": liveelite.co.uk [HikaShop version] : 2.2.0 [Joomla version] : 2.5.11 [PHP version] : 5.3.24 [Browser(s) name and version] : Firefox 22.0 [Error-message(debug-mod must be tuned on)] : Backend error - no error message the screen just goes white when trying to export, we are trying to export last months orders and we have 1500 records. However i can only export what is displayed. The maximum it shows me is 100 records. I need to be able to export the full 1500 records however. Surely i don't have to do 15 exports? We didnt have an issue with doing this before updating hikashop to the newest version. It would be good to either let us know how we need to configure it to show all records, or have an export button that allows us to export the range selected without having to display that whole range on the screen? Thanks Alex")* Hi, I confirm that this is correct, but because you added a filter on the order type, you have less orders returned than before, so you have probably to change the limit start. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjA1NTQtcHJvYmxlbS1leHBvcnRpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Dibben](/forum/user/6788-dibben "View Dibben's Profile")** - [![Dibben's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6788-dibben "View Dibben's Profile") Topic Author - [ Offline](/forum/user/6788-dibben) Less More - Posts: 377 - Thank you received: 7 - - 13 years 2 months ago [\#117440](#117440) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile") Replied by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")* on topic *[Problem exporting](/forum/37-import-export-csv-xls/860554-problem-exporting#117440 ": liveelite.co.uk [HikaShop version] : 2.2.0 [Joomla version] : 2.5.11 [PHP version] : 5.3.24 [Browser(s) name and version] : Firefox 22.0 [Error-message(debug-mod must be tuned on)] : Backend error - no error message the screen just goes white when trying to export, we are trying to export last months orders and we have 1500 records. However i can only export what is displayed. The maximum it shows me is 100 records. I need to be able to export the full 1500 records however. Surely i don't have to do 15 exports? We didnt have an issue with doing this before updating hikashop to the newest version. It would be good to either let us know how we need to configure it to show all records, or have an export button that allows us to export the range selected without having to display that whole range on the screen? Thanks Alex")* Hi Xavier, This has now worked, thanks, do you know why the '£' has an A with an accent above it on export? Thanks Alex - [ ![he115fbc.jpg](/forum/attachment/11568) ](/forum/attachment/11568 "he115fbc.jpg") [ ](/forum/attachment/11568?download=1 "he115fbc.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjA1NTQtcHJvYmxlbS1leHBvcnRpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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) - 13 years 2 months ago [\#117444](#117444) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Problem exporting](/forum/37-import-export-csv-xls/860554-problem-exporting#117444 ": liveelite.co.uk [HikaShop version] : 2.2.0 [Joomla version] : 2.5.11 [PHP version] : 5.3.24 [Browser(s) name and version] : Firefox 22.0 [Error-message(debug-mod must be tuned on)] : Backend error - no error message the screen just goes white when trying to export, we are trying to export last months orders and we have 1500 records. However i can only export what is displayed. The maximum it shows me is 100 records. I need to be able to export the full 1500 records however. Surely i don't have to do 15 exports? We didnt have an issue with doing this before updating hikashop to the newest version. It would be good to either let us know how we need to configure it to show all records, or have an export button that allows us to export the range selected without having to display that whole range on the screen? Thanks Alex")* I think it"s the encode format which is not read as expected by your csv reader. Try to open the csv with another program and see if there is still the A with accent. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjA1NTQtcHJvYmxlbS1leHBvcnRpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[Dibben](/forum/user/6788-dibben "View Dibben's Profile")** - [![Dibben's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6788-dibben "View Dibben's Profile") Topic Author - [ Offline](/forum/user/6788-dibben) Less More - Posts: 377 - Thank you received: 7 - - 13 years 2 months ago [\#117449](#117449) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile") Replied by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")* on topic *[Problem exporting](/forum/37-import-export-csv-xls/860554-problem-exporting#117449 ": liveelite.co.uk [HikaShop version] : 2.2.0 [Joomla version] : 2.5.11 [PHP version] : 5.3.24 [Browser(s) name and version] : Firefox 22.0 [Error-message(debug-mod must be tuned on)] : Backend error - no error message the screen just goes white when trying to export, we are trying to export last months orders and we have 1500 records. However i can only export what is displayed. The maximum it shows me is 100 records. I need to be able to export the full 1500 records however. Surely i don't have to do 15 exports? We didnt have an issue with doing this before updating hikashop to the newest version. It would be good to either let us know how we need to configure it to show all records, or have an export button that allows us to export the range selected without having to display that whole range on the screen? Thanks Alex")* It is set to be an excel export, which when opened with libre or calc still shows the 'A' at the beginning. Thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjA1NTQtcHJvYmxlbS1leHBvcnRpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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) - 13 years 2 months ago [\#117530](#117530) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Problem exporting](/forum/37-import-export-csv-xls/860554-problem-exporting#117530 ": liveelite.co.uk [HikaShop version] : 2.2.0 [Joomla version] : 2.5.11 [PHP version] : 5.3.24 [Browser(s) name and version] : Firefox 22.0 [Error-message(debug-mod must be tuned on)] : Backend error - no error message the screen just goes white when trying to export, we are trying to export last months orders and we have 1500 records. However i can only export what is displayed. The maximum it shows me is 100 records. I need to be able to export the full 1500 records however. Surely i don't have to do 15 exports? We didnt have an issue with doing this before updating hikashop to the newest version. It would be good to either let us know how we need to configure it to show all records, or have an export button that allows us to export the range selected without having to display that whole range on the screen? Thanks Alex")* We have corrected the export on our end, because the currency should not be displayed in the price field. So we removed it from the csv export. It will be available in the next release. To correct that problem now, you have to replace: Code: if($element->$column->currency != '0' ){ $currency = hikashop_get('class.currency'); $square = $currency->format($element->$column->value,$element->$column->currency); }else{ $square = $element->$column->value; } By: Code: if($element->$column->currency != '0' && JRequest::getVar('from_task','displayResults') == 'displayResults'){ $currency = hikashop_get('class.currency'); $square = $currency->format($element->$column->value,$element->$column->currency); }else{ $square = $element->$column->value; } In the class "massaction" function "displayByType()". And add: Code: JRequest::setVar('from_task','exportCsv'); in the _exportCSV() function before the call of the "displayByType" function, you can place it at the top of the function. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjA1NTQtcHJvYmxlbS1leHBvcnRpbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & 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.133 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)