Jump to content



Latest News: (loading..)

- - - - -

Export orders into csv


  • Please log in to reply
100 replies to this topic

#41   nimloth

nimloth
  • Members
  • 8 posts
  • Real Name:Maureen Gamble
  • Location:Kansas

Posted 18 March 2008 - 04:07 AM

I can not find any "exportorders" referenc es or files in my installation, which is the durrent one. Where can I get this module...in English???
Maureen Gamble
<mgamble2@cox.net>

#42   steven78

steven78
  • Members
  • 19 posts
  • Real Name:Steven Jobs

Posted 19 March 2008 - 02:43 PM

Does anyone have a solution for this?

#43   sps-merlin

sps-merlin
  • Members
  • 19 posts
  • Real Name:Pete Gleadall

Posted 28 March 2008 - 11:10 AM

Is there any reason this wouldn't work on an xampp localhost install? it works fine on my live site but i want to run a test site locally via xampp and it doesn't work. i've installed it the same as on my live site but when i click to process the csv (either to a file or to the screen) it doesn't appear to do anything other than essentially a screen refresh

any ideas please?

#44   sps-merlin

sps-merlin
  • Members
  • 19 posts
  • Real Name:Pete Gleadall

Posted 31 March 2008 - 08:35 AM

View Postsps-merlin, on Mar 28 2008, 11:10 AM, said:

Is there any reason this wouldn't work on an xampp localhost install? it works fine on my live site but i want to run a test site locally via xampp and it doesn't work. i've installed it the same as on my live site but when i click to process the csv (either to a file or to the screen) it doesn't appear to do anything other than essentially a screen refresh

any ideas please?

this was a register_globals issue... fixed

#45   dlan

dlan
  • Members
  • 16 posts
  • Real Name:dlan
  • Gender:Male
  • Location:France

Posted 04 April 2008 - 02:48 PM

View Postsps-merlin, on Mar 7 2008, 07:42 PM, said:

excellent contrib. i'm needing to alter the order of how things display in the exported .csv file. i have a pretty good idea of what i need to do in terms of the php and can join tables if i need to but i don't know where in the .php file i need to be looking for that aspect of the script. could anyone please advise? i'm using the latest downloadable version

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   dlan

dlan
  • Members
  • 16 posts
  • Real Name:dlan
  • Gender:Male
  • Location:France

Posted 04 April 2008 - 02:51 PM

View Postnimloth, on Mar 18 2008, 06:07 AM, said:

I can not find any "exportorders" referenc es or files in my installation, which is the durrent one. Where can I get this module...in English???

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   dlan

dlan
  • Members
  • 16 posts
  • Real Name:dlan
  • Gender:Male
  • Location:France

Posted 04 April 2008 - 02:53 PM

View Poststeven78, on Mar 14 2008, 04:24 PM, said:

Who can help me? This script was working well; and after a change to another server this great contribution isn't working anymore.

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?
Hi,
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   lambro

lambro
  • Members
  • 32 posts
  • Real Name:Peter

Posted 07 April 2008 - 11:33 PM

Still have this problem, any one?

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   laracameron

laracameron
  • Members
  • 2 posts
  • Real Name:Lara Cameron

Posted 02 May 2008 - 11:42 PM

I was having the same problem as a few others here. I installed the most recent version of this add-on but wasn't being prompted to download a CSV file after clicking 'Export to CSV'. I know little about PHP but I showed my expert brother and he said:

"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   laracameron

laracameron
  • Members
  • 2 posts
  • Real Name:Lara Cameron

Posted 02 May 2008 - 11:45 PM

View Postlambro, on Apr 8 2008, 09:33 AM, said:

Still have this problem, any one?

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   nudylady

nudylady
  • Members
  • 234 posts
  • Real Name:nudylady

Posted 04 May 2008 - 04:31 PM

View Postlaracameron, on May 3 2008, 03:45 AM, said:

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 :) )

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   JBCards

JBCards
  • Members
  • 52 posts
  • Real Name:Jeff
  • Gender:Male
  • Location:NC, USA

Posted 06 May 2008 - 12:50 PM

I have this contribution working for me and am happy about it.  I have the product attribute option type feature and I need the information typed in by others in the fields for their orders.  How do I pull these into the csv file?  I'm obviously not a php expert and can really only about cut and paste.

#53   jtheneo

jtheneo
  • Members
  • 10 posts
  • Real Name:Jay the neo

Posted 07 May 2008 - 06:51 AM

Hi there.
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   nudylady

nudylady
  • Members
  • 234 posts
  • Real Name:nudylady

Posted 28 May 2008 - 01:07 PM

I did nothing. It suffenly stopped to work today.  I read thread here.
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   nudylady

nudylady
  • Members
  • 234 posts
  • Real Name:nudylady

Posted 28 May 2008 - 02:03 PM

View Postnudylady, on May 28 2008, 06:07 PM, said:

In php.ini under root I changed to register_globals = off
It's not a register_globals issue. Internet  connection from My PC to my Europe web server has problem so this addon became instable. chinese ISP is the most stupid in the world except Cuba & North korea.

#56   ssnb

ssnb
  • Members
  • 283 posts
  • Real Name:Alan
  • Gender:Male

Posted 14 August 2008 - 04:04 AM

Hi - thanks for this great contribution - it was just what I was looking for!!!

I have one question:

Is it possible to get the spreadsheet to export with a header line (column titles)?

Thanks
Sol

#57   ssnb

ssnb
  • Members
  • 283 posts
  • Real Name:Alan
  • Gender:Male

Posted 14 August 2008 - 04:04 AM

Hi - thanks for this great contribution - it was just what I was looking for!!!

I have one question:

Is it possible to get the spreadsheet to export with a header line (column titles)?

Thanks
Sol

#58   Mantistech

Mantistech
  • Members
  • 8 posts
  • Real Name:Mak

Posted 14 August 2008 - 02:29 PM

Hi Please can you help me.  I've installed the lastest version however when I download the CSV file it does not have anything in the Shipping Address Line 2.  How can I add this function?

#59   ssnb

ssnb
  • Members
  • 283 posts
  • Real Name:Alan
  • Gender:Male

Posted 18 August 2008 - 12:55 AM

It seems not many people using this contribution because the forum support is very sparse...

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   cyberjorge

cyberjorge
  • Members
  • 24 posts
  • Real Name:cyberjorge
  • Gender:Male

Posted 26 September 2008 - 09:19 AM

Exactly how do you install this thing besides copying in the admin folder?

I can't see any newly added button in my admin.
Please help with this!  :(