Apsona CSV data exporter [support thread]

[apsona]

This add-on exports data records (customers, orders, products, product attributes, and categories) to CSV format from the admin to interact with the Apsona service.

Tested with Zen Cart 1.3.8, but should work on earlier versions as well.

Download link:
http://www.zen-cart.com/index.php?ma...oducts_id=1500

More details about how this add-on works are here: http://apsona.com/pages/ec/howItWorks.html

You will need this add-on for using the Apsona service.

Comments/feedback very welcome.

[KnowNoneSince]

This seems exactly what I was looking for so thank you.

I have two remarks if I may:
1. When I export the Orders, all orders show twice. It exports 1,2,3, and then starts again with 1,2,3 etc.
2. The discount amount is not exported, when I select orders_products.

Can you fix it?
Please?


ZC 1.3.8a

[apsona]

Hello,

Thanks for the feedback. I'd love to fix these two issues, but I'd like some help with them.

- I am not seeing this order duplication problem you mention, so perhaps there is something in your environment that I have not accounted for. Does this happen under all circumstances, or only when you choose a particular date value in the export form?

- As for the discount amount, would you happen to know the table/column in the database where this value appears? I looked around in the schema and in the source code but wasn't able to deduce the answer. I am hoping some of the other folks in this forum will be able to help answer these questions as well.

Thanks.

[KnowNoneSince]

Hi Apsona,

Thanks for your reply. i played a lot with your code to make it custom for my own use and the order export is working fine. (it was my mistake)
And the discounts, I added by referring to the discounts-table.

I love your exporter, it's great.
Removed the quotation marks and some fields that I didn't need to my backend system.
Thanks.

[Mike_Dean]

Hi,

I'm currently using Easy Populate (EP) 1.2.5.7 which allows uploading of meta data (which earlier versions of EP don't support)

I am about to start the upgrade path form ZC 1.3.8a to 1.3.9b.

EP 1.2.5.7 is not yet compatible with the 1.2.5.7 and or PHP 5.3

Your add-on looks like a good fit and a great replacement for EP, but is it compatible with the latest version of ZC and will it run on PHP 5.3 ?

Thanks,
Mike

[apsona]

Mike_Dean - The exporter add-on is meant only for data export. It does not do any importing, unlike Easy Populate. Perhaps you are referring to Apsona ShopAdmin, which is entirely different from the exporter add-on, and does export, import and quite a lot more.

Thanks,
Apsona
http://apsona.com