Export orders into csv
#41
Posted 18 March 2008 - 04:07 AM
<mgamble2@cox.net>
#42
Posted 19 March 2008 - 02:43 PM
#43
Posted 28 March 2008 - 11:10 AM
any ideas please?
#44
Posted 31 March 2008 - 08:35 AM
sps-merlin, on Mar 28 2008, 11:10 AM, said:
any ideas please?
this was a register_globals issue... fixed
#45
Posted 04 April 2008 - 02:48 PM
sps-merlin, on Mar 7 2008, 07:42 PM, said:
Hi,
Sorry for the long delay ...
You need to change the exportprder.php file, it is the one that contains the queries and that creates the CSV file.
Regards,
#46
Posted 04 April 2008 - 02:51 PM
nimloth, on Mar 18 2008, 06:07 AM, said:
Hi,
You will find the full package in the contribs area on the main osc website. Search for "export orders into csv".
Full package is available under the first link "Export Orders into CSV v2.0" then other people have corrected a few things that you may want to implement.
Regards,
#47
Posted 04 April 2008 - 02:53 PM
steven78, on Mar 14 2008, 04:24 PM, said:
I have RC1
I can use the contrib but after pressing 'Generate' nothing is happening; only the url gives: export_orders_csv.php?start=800&end=850&status=&submitted=1
Does anyone have the same problem?
Sorry I don't have this problem. Have you checked that your new server is actually having the exact same configuration as the old one? Take a look at your php.ini and mainly at the register_globals option.
Regards,
#48
Posted 07 April 2008 - 11:33 PM
I seem to be having problems with long numbers, for example telephone and credit card numbers. A phone number comes out as 2.09E+09 in the excel box, but when you high light it it reads 2086405970 in the formula bar (this is nearly correct, it is missing the leading 0).
#49
Posted 02 May 2008 - 11:42 PM
"There was a bug in the code - it used an old rarely supported PHP feature, of turning form fields directly into variables."
He modified the "exportorders.php" file for me and now it works. I've added it as a download here so hopefully it will work for you too!
#50
Posted 02 May 2008 - 11:45 PM
lambro, on Apr 8 2008, 09:33 AM, said:
I seem to be having problems with long numbers, for example telephone and credit card numbers. A phone number comes out as 2.09E+09 in the excel box, but when you high light it it reads 2086405970 in the formula bar (this is nearly correct, it is missing the leading 0).
Isn't that just because the size of the field is too small? So when you expand it the full number appears? I just noticed that happening in Excel and haven't read the previous posts so maybe you and I are talking about two completely different things - (if so sorry
#51
Posted 04 May 2008 - 04:31 PM
laracameron, on May 3 2008, 03:45 AM, said:
Telephone no as 4E+07. you enlarge excel filed it reads OK. But I use mail merge function of MS word to create shipping labels. Telephone NO shows 4E+07 in word.
by the way how do you use this order data?
#52
Posted 06 May 2008 - 12:50 PM
#53
Posted 07 May 2008 - 06:51 AM
This contribution is great and I have been using it a lot. My problem is that when people add commas to their addresses it creates all kind of problems when I import it in to a different database. Is there a way of preventing people from being able to do that, either by doing something to the form not to accept commas or to the the database itself?
Any help would be appreciated.
#54
Posted 28 May 2008 - 01:07 PM
In php.ini under root I changed to register_globals = off
what does this mean, is register_globals = off going to affect something else stop to work?
#55
Posted 28 May 2008 - 02:03 PM
nudylady, on May 28 2008, 06:07 PM, said:
#56
Posted 14 August 2008 - 04:04 AM
I have one question:
Is it possible to get the spreadsheet to export with a header line (column titles)?
Thanks
Sol
#57
Posted 14 August 2008 - 04:04 AM
I have one question:
Is it possible to get the spreadsheet to export with a header line (column titles)?
Thanks
Sol
#58
Posted 14 August 2008 - 02:29 PM
#59
Posted 18 August 2008 - 12:55 AM
I would love to know how the fields can be altered!
Specifically, I would love to add header titles. And how to move the output columns around ? I've tried working on this and it is not obvious at all.... any experts out there who can tell me how to re-arrange the output?
Thanks
Edited by ssnb, 18 August 2008 - 12:59 AM.
#60
Posted 26 September 2008 - 09:19 AM
I can't see any newly added button in my admin.
Please help with this!









