[HACK] Export Orders and Batch update of Status

[chris.t.uk]

Daisy,
Please check your messages for email address.
Chris,

[wadeo]

First off Great Chris and thanks for getting back to me.

I have another request this may be something that I can do on my own with a little guidance.

What I would like to do is change the character that separates the values from a "," to something else. The problem we have is for some reason our customers are putting in a comma in the name field and it is causing all kinds of problems with our order system that we are importing the data due to the extra commas.

So I was looking in the code (ps_orders_export.php) line 1030

Code: [Select]

$exportFormat = "csv";
$delim=",";
So I proceeded to change the comma "," to a pipe "|" saved my changes and well as you know already it did not work.

Is there something else I will need to change for this to work the way I need it to .

Also on future updates to this you may want to add a feature that will allow you to use a custom separating character.

Looking forward to hearing from you and thanks again for a great product.

 

[chris.t.uk]

Line 1305
Change:
$contents .= $db->f("title") . " " . $db->f("first_name") . " " . $db->f("last_name") .$delim;
To:
$contents .= "\"". $db->f("title") . " " . $db->f("first_name") . " " . $db->f("last_name")."\"".$delim;

Should 'trap' the name in a cell.

You should also aim to change the Tab Delimited Text delimiter as the Excel and like should prompt for the delimiter. CSV will just get opened as it wants to see a comma!

If you are not splitting the address and it then gets split over lines then try modifiying the delimiter in  function getAddress, from \n to "," or whatever you like.

[DaisyEE8]

Checked and replied.

It really looks nice now.

[samparker89]

Can anyone tell me what file I modify to change the layout of the invoice which is created in excel (The microsoft excel - invoice one).

Thanks

[chris.t.uk]

ps_orders_export.php -> export_excel_invoices

the image problem you had will be fixed early next week.

[samparker89]

Thanks, how do i get the shipping address in to the top left (where the shop address is).

Thanks

[chris.t.uk]

Manipulation of the cell numbers.

You could just move the code that says Ship To to the shop details output(keeping the cell numbers the same!).

i.e
$excel->writecell(A, B, shopname);
...
$excel->writecell(X, Y, customername);

becomes
//$excel->writecell(A, B, shopname);
$excel->writecell(A, B, customername);
...
//$excel->writecell(X, Y, customername);

[tyrael84]

When I try to export with to Invoices.xls i got this error in the file

Code: [Select]

<b>Fatal error</b>:  Non-static method imagebmp::imagebmp() cannot be called statically, assuming $this from incompatible context in localhost/administrator/components/com_virtuemart/classes/ps_orders_export.php</b> on line <b>987</b><br />
Please help me.

Thanks for the hack.

[samparker89]

Hi,

I have found a problem with your hack, might be something i changed or something in your code i am unsure.

My problem is as follows, when i export an order in to excel and the customer enters a different shipping adddress to billing address, the billing address is displayed in both billing and shipping. This creates a massive problem as my parcels will get sent to the wrong address.

Can someone please shed some light on my problem.

Thanks

[samparker89]

Also Tyrael, I got the same error when my site was still local, once i put it live it worked fine

Hope that helps

[chris.t.uk]

  Are you using WAMP? This issue appears to only accept WAMP configrations. I do have a patch but I am trying to finalise XML export, so.... anytime soon will be 1.1-0.7 which will resolve the Invoices issue.

Chris.

P.S. Sam, can you backup your ps_orders_export.php and reapply the hack, this will isolate the problem. Thanks.

[samparker89]

Hi,

I replaced the ps_order_export with the original one and it is still using the billing address for both shipping and billing. I have also replaced all the other files with the originals.

Also just looking at the code (and by any means i am definately no expert) and am wondering if the label will also make the data correspond i.e.

            //name + address
            $sheet->write($startRow + 13, $col, $VM_LANG->_('PHPSHOP_ORDER_PRINT_CUST_BILLING_LBL'), $addressFormat);
            $sheet->write($startRow + 14, $col, $db->f("title")." ".$db->f("first_name")." ".$db->f("last_name"));
            $sheet->write($startRow + 15, $col, $db->f("address_1"));
            $sheet->write($startRow + 16, $col, $db->f("address_2"));
            $sheet->write($startRow + 17, $col, $db->f("city"));
            $sheet->write($startRow + 18, $col, $db->f("country"));
            $sheet->write($startRow + 19, $col, $db->f("zip"));

            $col=3;
            //name + address
            $sheet->write($startRow + 13, $col, $VM_LANG->_('PHPSHOP_ORDER_PRINT_CUST_SHIPPING_LBL'), $addressFormat); - Will having this shipping label make all the data eg name address correspond the the data the customer entered in the shipping address fields?
            $sheet->write($startRow + 14, $col, $db->f("title")." ".$db->f("first_name")." ".$db->f("last_name"));
            $sheet->write($startRow + 15, $col, $db->f("address_1"));
            $sheet->write($startRow + 16, $col, $db->f("address_2"));
            $sheet->write($startRow + 17, $col, $db->f("city"));
            $sheet->write($startRow + 18, $col, $db->f("country"));
            $sheet->write($startRow + 19, $col, $db->f("zip"));

The reason i ask this is because all the $sheet->write... are the same for both shipping and billing, the only difference is the label.

Thanks

[chris.t.uk]

Seems I skipped the check for delivery address on invoice export. 

Will get fixed in 1.1-0.7.

Chris.

[samparker89]

Thanks! Any idea when this will be released?