[Skip to main content](#vessel-content) # CSV Export ## - **[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")** - [![phiddius's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/41209-phiddius "View phiddius's Profile") Topic Author - [ Offline](/forum/user/41209-phiddius) Less More - Posts: 161 - Thank you received: 4 - - 7 years 6 months ago [\#305847](#305847) by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") *[CSV Export](/forum/25-install-update/897327-csv-export#305847 "-- HikaShop version -- : 4.0.3 -- Joomla version -- : 3.9.5 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : none Hi I appear to have an anomaly when exporting products in CSV I can export products associated with multiple categories fine, however, when I add a brand then try to export it fails. Am I missing something? thanks")* was created by *[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")* -- HikaShop version -- : 4.0.3 -- Joomla version -- : 3.9.5 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : none Hi I appear to have an anomaly when exporting products in CSV I can export products associated with multiple categories fine, however, when I add a brand then try to export it fails. Am I missing something? thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5NzMyNy1jc3YtZXhwb3J0P3RtcGw9bWFya2Rvd24=) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86363 - Thank you received: 14296 - - 7 years 6 months ago [\#305850](#305850) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[CSV Export](/forum/25-install-update/897327-csv-export#305850 "-- HikaShop version -- : 4.0.3 -- Joomla version -- : 3.9.5 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : none Hi I appear to have an anomaly when exporting products in CSV I can export products associated with multiple categories fine, however, when I add a brand then try to export it fails. Am I missing something? thanks")* Hi, I'm not sure what you mean. I don't remember having the possibility to select several categories and brands with the different export buttons available by default in HikaShop. Could you provide more precise information on what you do exactly to reproduce the error on your website ? Could you maybe provide some screenshots ? Also, you say that the export fails. How does it fail ? Do you get any error message ? If not, can you try again with the debug mode and error reporting settings of the Joomla configuration turned on ? Do you get any error message then ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5NzMyNy1jc3YtZXhwb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")** - [![phiddius's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/41209-phiddius "View phiddius's Profile") Topic Author - [ Offline](/forum/user/41209-phiddius) Less More - Posts: 161 - Thank you received: 4 - - 7 years 6 months ago [\#305874](#305874) by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") Replied by *[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")* on topic *[CSV Export](/forum/25-install-update/897327-csv-export#305874 "-- HikaShop version -- : 4.0.3 -- Joomla version -- : 3.9.5 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : none Hi I appear to have an anomaly when exporting products in CSV I can export products associated with multiple categories fine, however, when I add a brand then try to export it fails. Am I missing something? thanks")* Hi nicolas, apologies for the lack of clarity .. heres 4 screenshots. 1- apply 2 x categories to a product 2 - export it - successfully 3 - add brand to that product 4 - export fails - server error 500 happens everytime, Im just testing that I can successfully import and export data for a new project with 10'000 products, so its important I get it right before I commit. Thanks in advance for any suggestions to why this may be happening *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5NzMyNy1jc3YtZXhwb3J0P3RtcGw9bWFya2Rvd24=) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86363 - Thank you received: 14296 - - 7 years 6 months ago [\#305878](#305878) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[CSV Export](/forum/25-install-update/897327-csv-export#305878 "-- HikaShop version -- : 4.0.3 -- Joomla version -- : 3.9.5 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : none Hi I appear to have an anomaly when exporting products in CSV I can export products associated with multiple categories fine, however, when I add a brand then try to export it fails. Am I missing something? thanks")* Hi, Thank you, that's a lot more clearer. I don't have the error on my end when I try to reproduce the issue. Could you check the PHP error log of your server ? It should contain the error message corresponding to the issue you have. Also, you could try to activate the "error reporting" and the "debug mode" settings of the Joomla configuration and then try again the export with the issue. That should hopefully give more information on the error. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5NzMyNy1jc3YtZXhwb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")** - [![phiddius's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/41209-phiddius "View phiddius's Profile") Topic Author - [ Offline](/forum/user/41209-phiddius) Less More - Posts: 161 - Thank you received: 4 - - 7 years 6 months ago [\#305906](#305906) by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") Replied by *[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")* on topic *[CSV Export](/forum/25-install-update/897327-csv-export#305906 "-- HikaShop version -- : 4.0.3 -- Joomla version -- : 3.9.5 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : none Hi I appear to have an anomaly when exporting products in CSV I can export products associated with multiple categories fine, however, when I add a brand then try to export it fails. Am I missing something? thanks")* Hi nicolas, I did that, and I got the following message: Warning: substr() expects parameter 1 to be string, object given in /home/mysite/public_html/dev/administrator/components/com_hikashop/helpers/spreadsheet.php on line 142 Warning: strpos() expects parameter 1 to be string, object given in /home/mysite/public_html/dev/administrator/components/com_hikashop/helpers/spreadsheet.php on line 147 Recoverable fatal error: Object of class stdClass could not be converted to string in /home/mysite/public_html/dev/administrator/components/com_hikashop/helpers/spreadsheet.php on line 148 this is on a different domain - its my development area, I can give access to it if required hope this helps, and thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5NzMyNy1jc3YtZXhwb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")** - [![phiddius's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/41209-phiddius "View phiddius's Profile") Topic Author - [ Offline](/forum/user/41209-phiddius) Less More - Posts: 161 - Thank you received: 4 - - 7 years 6 months ago [\#305912](#305912) by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") Replied by *[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")* on topic *[CSV Export](/forum/25-install-update/897327-csv-export#305912 "-- HikaShop version -- : 4.0.3 -- Joomla version -- : 3.9.5 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : none Hi I appear to have an anomaly when exporting products in CSV I can export products associated with multiple categories fine, however, when I add a brand then try to export it fails. Am I missing something? thanks")* HOLD ON ... Hi nicolas, I have tried reinstalling already, however today, I removed hikashop completely, and then reinstalled but installed the starter version first before upgrading, Ive no idea why this made any difference but its working now. Must have just been a glitch in the installation but thanks for looking into it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5NzMyNy1jc3YtZXhwb3J0P3RtcGw9bWFya2Rvd24=) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86363 - Thank you received: 14296 - - 7 years 6 months ago - 7 years 6 months ago [\#305907](#305907) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[CSV Export](/forum/25-install-update/897327-csv-export#305907 "-- HikaShop version -- : 4.0.3 -- Joomla version -- : 3.9.5 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : none Hi I appear to have an anomaly when exporting products in CSV I can export products associated with multiple categories fine, however, when I add a brand then try to export it fails. Am I missing something? thanks")* Hi, If you get the error again, add the code: Code: if( empty($value) || is_array($value) || is_object($value)) { $value = '""'; } after the line: Code: function writeText($row, $col, $value, $lastOne) { in that file and that should help. We'll add that patch on our end too as it makes sense anyways. Last edit: 7 years 6 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile"). The following user(s) said Thank You: [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5NzMyNy1jc3YtZXhwb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")** - [![phiddius's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/41209-phiddius "View phiddius's Profile") Topic Author - [ Offline](/forum/user/41209-phiddius) Less More - Posts: 161 - Thank you received: 4 - - 7 years 6 months ago [\#305984](#305984) by [phiddius](/forum/user/41209-phiddius "View phiddius's Profile") Replied by *[phiddius](/forum/user/41209-phiddius "View phiddius's Profile")* on topic *[CSV Export](/forum/25-install-update/897327-csv-export#305984 "-- HikaShop version -- : 4.0.3 -- Joomla version -- : 3.9.5 -- PHP version -- : 7.2 -- Error-message(debug-mod must be tuned on) -- : none Hi I appear to have an anomaly when exporting products in CSV I can export products associated with multiple categories fine, however, when I add a brand then try to export it fails. Am I missing something? thanks")* thanks nicolas .. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5NzMyNy1jc3YtZXhwb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) 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.071 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)