Forums / General Questions / Exporting all types of store data in CSV format?

Exporting all types of store data in CSV format?

Views: 1,416

Results 1 to 7 of 7
28 Apr 2011, 2:34 PM
#1
dutchy avatar

dutchy

Zen Follower

Join Date:
May 2010
Location:
London
Posts:
324
Plugin Contributions:
0

Exporting all types of store data in CSV format?

Hi,

Does anyone know of an add-on or method of exporting Zen Cart generated data into CSV format for inputting into systems like Sage Accounting or Mamut Account?

For example;
New Customers (name, address, phone, fax, etc)
Stock (model, name, qty, etc)
Sales data / invoices (Order number, customer details, items taken (model/name), qty, prices, etc)

I am aware of the two Sage Line 50 export add-on's available here but these
a) Don't quite fit the bill
b) While they work on 1.3.9 they have been designed for 1.3.7
c) unsupported

I thought I would ask here before seeking a solution off site.

Thank you

28 Apr 2011, 4:58 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Exporting all types of store data in CSV format?

While they work on 1.3.9 they have been designed for 1.3.7
If there are no DB changes affected what are you concerned about

Don't fix what isn't broke

Zen-Venom Get Bitten

29 Apr 2011, 10:43 AM
#3
dutchy avatar

dutchy

Zen Follower

Join Date:
May 2010
Location:
London
Posts:
324
Plugin Contributions:
0

Re: Exporting all types of store data in CSV format?

kobra:

If there are no DB changes affected what are you concerned about

Don't fix what isn't broke

Well at least have the listing updated to show it works with 1.3.9x as it is it is a confusing minefield of unmaintained information.

Either way, it still doesn't work as required and is unsupported.

Im guess if there was such as feature/add-on, someone with your knowledge would have pointed me in the right direction. Guess it's an oDesk moment?

29 Apr 2011, 7:30 PM
#4
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Exporting all types of store data in CSV format?

Are you aware of THIS?
datalinkuk.com/products-services/web-datalink-for-sage-line-50

20 years a Zencart User

30 Apr 2011, 11:27 AM
#5
dutchy avatar

dutchy

Zen Follower

Join Date:
May 2010
Location:
London
Posts:
324
Plugin Contributions:
0

Re: Exporting all types of store data in CSV format?

I was not, Thank you so much.

A few hundred over my budget, business is struggling atm with cash flow :( But defo something to save up for!

Do you have any experience? If so please PM in case this chat breaks forum rules on off site/paid add-ons.

Once again, diamond find! Thank you.

30 Apr 2011, 1:12 PM
#6
torvista avatar

torvista

Totally Zenned

Join Date:
Aug 2007
Location:
Gijón, Asturias, Spain
Posts:
2,876
Plugin Contributions:
7

Re: Exporting all types of store data in CSV format?

Apsona does all this, I believe

Steve
github.com/torvista: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...

30 Apr 2011, 1:33 PM
#7
dutchy avatar

dutchy

Zen Follower

Join Date:
May 2010
Location:
London
Posts:
324
Plugin Contributions:
0

Re: Exporting all types of store data in CSV format?

IMHO while Apsona is an amazing and fantastic idea / tool (features of which I would love to be built in to ZC core). The way Apsona works (i.e. third party involvement for db / admin connection /data-transfer) is far too much of a security risk to me and sadly something that I will never ever use. (I have actually tried it and run into a few problems which resulted in my hosts 3rd line technical support advising strongly against using Apsona because of the nature in which it works. They even queried if it would cause PCI scan issues. But I have not yet required a PCI scan and Certificate so that is something I cannot answer. Just passing on what I was told.)

If this was developed to be an add-on with no third party involvement then I would use it. Even pay for it.