Skip to main content

Export CSV Not Exporting Majority Of Addresses

More
12 years 1 month ago #166520 by MumsHealth
Export CSV Not Exporting Majority Of Addresses was created by MumsHealth
-- url of the page with the problem -- : NA
-- HikaShop version -- : 2.3.2
-- Joomla version -- : 3.3.3
-- PHP version -- : 5.4.30
-- Browser(s) name and version -- : NA
-- Error-message(debug-mod must be tuned on) -- : NA

I was trying to export a cvs containing all order details for every order. Everything seems to work fine except the address information (Country, state, ect) is only exported for about 1 in 10 orders.

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

More
12 years 1 month ago #166542 by nicolas
Replied by nicolas on topic Export CSV Not Exporting Majority Of Addresses
Hi,

I'm not able to reproduce the problem on our end.
I'm getting all the address data in the CSV of the orders with the 2.3.2.
Do you see any pattern in the problem ?

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

More
12 years 1 month ago - 12 years 1 month ago #166640 by MumsHealth
Replied by MumsHealth on topic Export CSV Not Exporting Majority Of Addresses
It seems that every row exported with an address contains an entry in the "billing_address_id" field while those without an address do not. Orders exported with an address are also missing an entry in "billing_order_id" (see attached image names changed for privacy).

When I export using maximum error reporting these errors appear at the top of the csv file
Code:
Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 241 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 242 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 245 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 246 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Warning: Creating default object from empty value in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 267 Notice: Undefined property: stdClass::$joomla_users in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 331 Warning: Invalid argument supplied for foreach() in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 331 Notice: Undefined property: stdClass::$joomla_users in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 331 Warning: Invalid argument supplied for foreach() in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 331
Last edit: 12 years 1 month ago by MumsHealth. Reason: spelling

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

More
12 years 1 month ago #166668 by nicolas
Replied by nicolas on topic Export CSV Not Exporting Majority Of Addresses
Hi,

Thank you for the additional information. That was helpful.
Please replace the file administrator/components/com_hikashop/classes/massaction.php with the one in the archive enclosed and that should fix the problem.

This attachment is hidden for guests.
Please log in or register to see it.

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

More
12 years 1 month ago #166736 by MumsHealth
Replied by MumsHealth on topic Export CSV Not Exporting Majority Of Addresses
That script seems to just give me a white screen and no csv file. The white screen only occurs when exporting address fields.

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

More
12 years 1 month ago #166751 by nicolas
Replied by nicolas on topic Export CSV Not Exporting Majority Of Addresses
I tried on my end but it's working fine.
Can you try again with the "error reporting" option of the Joomla configuration turned on ? That way, you should get an error message instead of a blank page.

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

More
12 years 1 month ago #166830 by MumsHealth
Replied by MumsHealth on topic Export CSV Not Exporting Majority Of Addresses
Code:
Fatal error: Cannot use object of type stdClass as array in /var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php on line 279

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

More
12 years 1 month ago #166831 by Jerome
Replied by Jerome on topic Export CSV Not Exporting Majority Of Addresses
Hi,

Please edit the file "/var/www/vhosts/mumshealth.com/httpdocs/administrator/components/com_hikashop/classes/massaction.php", line 279 and replace
Code:
$action['billing_address'][$billing_column] = $billing_column;
By
Code:
$action['billing_address']->$billing_column = $billing_column;

Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

More
12 years 1 month ago #166867 by MumsHealth
Replied by MumsHealth on topic Export CSV Not Exporting Majority Of Addresses
That works, keep in mind you also have to replace line 250 from:
Code:
$action['billing_address'][$billing_column] = $billing_column;

To:
Code:
$action['billing_address']->$billing_column = $billing_column;

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

More
12 years 1 month ago #166876 by nicolas
Replied by nicolas on topic Export CSV Not Exporting Majority Of Addresses
Thanks for the feedback but the solution proposed by Jerome is not correct as far as I can see.
Instead of doing these changes, it's the line:
Code:
if(!isset($action['billing_address'])) $action['billing_address'] = new stdClass();
which ought to be replaced by:
Code:
if(!isset($action['billing_address'])) $action['billing_address'] = array();

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

Time to create page: 0.226 seconds
Powered by Kunena Forum