Export Order Info

[Jim McGowan]

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

[Michael Zornek]

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/

[Michael Tyson]

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: mic...@atastypixel.com
aim: mikerusselltyson
twitter: MichaelTyson

[Jim McGowan]

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