CSV Export

  • Posts: 110
  • Thank you received: 1
  • Hikashop Business
1 month 1 week ago #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

Please Log in or Create an account to join the conversation.

  • Posts: 65706
  • Thank you received: 9593
  • MODERATOR
1 month 1 week ago #305850

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 or Create an account to join the conversation.

  • Posts: 110
  • Thank you received: 1
  • Hikashop Business
1 month 1 week ago #305874

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 browser does not support PDFs. Please download the PDF to view it: Download PDF

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 65706
  • Thank you received: 9593
  • MODERATOR
1 month 1 week ago #305878

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 or Create an account to join the conversation.

  • Posts: 110
  • Thank you received: 1
  • Hikashop Business
1 month 1 week ago #305906

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 or Create an account to join the conversation.

  • Posts: 110
  • Thank you received: 1
  • Hikashop Business
1 month 1 week ago #305912

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 or Create an account to join the conversation.

  • Posts: 65706
  • Thank you received: 9593
  • MODERATOR
1 month 1 week ago #305907

Hi,

If you get the error again, add the code:

if( empty($value) || is_array($value) || is_object($value)) {
				$value = '""';
			}
after the line:
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: 1 month 1 week ago by nicolas.
The following user(s) said Thank You: phiddius

Please Log in or Create an account to join the conversation.

  • Posts: 110
  • Thank you received: 1
  • Hikashop Business
1 month 2 days ago #305984

thanks nicolas ..

Please Log in or Create an account to join the conversation.

Time to create page: 0.068 seconds
Powered by Kunena Forum