Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
Potion Store Discussions
+ new post
About this group
Join this group
Export Order Info
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   4 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Jim McGowan  
View profile  
 More options Sep 7 2010, 7:52 am
From: Jim McGowan <jamespmcgo...@googlemail.com>
Date: Tue, 7 Sep 2010 04:52:34 -0700 (PDT)
Local: Tues, Sep 7 2010 7:52 am
Subject: Export Order Info
Print | Individual message | Show original | Report this message | Find messages by this author
Hi All,

Is there any way I can export my previous orders from Potion Store in
to a csv file, or something similar?  I suppose I could do this
directly with MySQL, but I'm not familiar enough with it to be
confident not to corrupt the DB, so I was wondering if anyone had any
code they'd added to the store that could do this?

Thanks,

Jim


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Michael Zornek  
View profile  
 More options Sep 7 2010, 11:48 am
From: Michael Zornek <list...@mikezornek.com>
Date: Tue, 07 Sep 2010 11:48:34 -0400
Local: Tues, Sep 7 2010 11:48 am
Subject: Re: [Potion Store] Export Order Info
Print | Individual message | Show original | Report this message | Find messages by this author
On 9/7/10 7:52 AM, "Jim McGowan" <jamespmcgo...@googlemail.com> wrote:

> Hi All,

> Is there any way I can export my previous orders from Potion Store in
> to a csv file, or something similar?  I suppose I could do this
> directly with MySQL, but I'm not familiar enough with it to be
> confident not to corrupt the DB, so I was wondering if anyone had any
> code they'd added to the store that could do this?

> Thanks,

> Jim

To my knowledge the store code doesn't have any tools for csv export.

If you can connect to the database remotely (bad idea for security reasons)
you could use a program like Sequel Pro to export to CSV. If you have no
remote connection just pull down a recent backup and do the csv export
local.

http://www.sequelpro.com/

Hope this info helps.

~ Mike
--
Michael Zornek
Clickable Bliss
http://clickablebliss.com/


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Michael Tyson  
View profile  
 More options Sep 7 2010, 12:30 pm
From: Michael Tyson <mich...@atastypixel.com>
Date: Tue, 7 Sep 2010 17:30:35 +0100
Local: Tues, Sep 7 2010 12:30 pm
Subject: Re: [Potion Store] Export Order Info
Print | Individual message | Show original | Report this message | Find messages by this author
Not really a bad idea as long as you use a secure tunnel - which, at least on my host, is the only way to make a connection anyway. If you have shell access on your host, just specify those details in the "SSH" connection settings.  Oh, and I second Sequel Pro as the best app for the job.

On 7 Sep 2010, at 16:48, Michael Zornek wrote:

> If you can connect to the database remotely (bad idea for security reasons)
> you could use a program like Sequel Pro to export to CSV. If you have no
> remote connection just pull down a recent backup and do the csv export
> local.

--
Michael Tyson | atastypixel.com
A Tasty Pixel: Delectable apps for iPhone and Mac

Loopy, our loop-based instrument, musical notepad and Best App Ever '08 nominee is now half-price for a limited time. Grab it on the app store!

Subscribe to our newsletter

e: mich...@atastypixel.com
aim: mikerusselltyson
twitter: MichaelTyson


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Jim McGowan  
View profile  
 More options Sep 8 2010, 6:30 am
From: Jim McGowan <jamespmcgo...@googlemail.com>
Date: Wed, 8 Sep 2010 11:30:28 +0100
Local: Wed, Sep 8 2010 6:30 am
Subject: Re: [Potion Store] Export Order Info
Print | Individual message | Show original | Report this message | Find messages by this author

On 7 Sep 2010, at 17:30 , Michael Tyson wrote:

> Oh, and I second Sequel Pro as the best app for the job.

Thanks for the pointers guys, I'll have a look at Sequel Pro

Jim


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2012 Google