extract daily orders automatically as csv and email out

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
Tea-Dev
Lieutenant (LT)
Lieutenant (LT)
Posts: 55
Joined: Wed Oct 12, 2011 11:15 am

extract daily orders automatically as csv and email out

Post by Tea-Dev » Thu Jul 31, 2014 10:51 am

Hi. Is there a facility where someone can automate the selection of orders, generate the report in csv and send it via email or ftp to another location? If so, can you share your thoughts/program please. Thanks.

abradley
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 101
Joined: Wed Feb 12, 2014 4:46 pm

Re: extract daily orders automatically as csv and email out

Post by abradley » Thu Jul 31, 2014 11:28 am

I dont think there is an automatic capability to do this yet. Manually you can do this however, Go to Data > Export > Orders. Dont know if that helps at all.
Austin

Tea-Dev
Lieutenant (LT)
Lieutenant (LT)
Posts: 55
Joined: Wed Oct 12, 2011 11:15 am

Re: extract daily orders automatically as csv and email out

Post by Tea-Dev » Thu Jul 31, 2014 12:00 pm

Thanks. We are already doing that. We need to automate this process based on date range, create csv and email out for other system processing.

Tea-Dev
Lieutenant (LT)
Lieutenant (LT)
Posts: 55
Joined: Wed Oct 12, 2011 11:15 am

Re: extract daily orders automatically as csv and email out

Post by Tea-Dev » Fri Aug 01, 2014 7:19 am

Is there any plugin?

User avatar
calvis
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 710
Joined: Tue Jan 27, 2004 3:57 pm
Location: Redmond, WA

Re: extract daily orders automatically as csv and email out

Post by calvis » Fri Aug 01, 2014 11:46 am

We could use something like this as well, but our requirements would to save the file to a shared folder on the server. In addition, we would also like to save the file in XML format.
Able Customer Since 1999 Currently Running on GOLD R12 SR1 and PCI Certified.

jguengerich
Commodore (COMO)
Commodore (COMO)
Posts: 436
Joined: Tue May 07, 2013 1:59 pm

Re: extract daily orders automatically as csv and email out

Post by jguengerich » Fri Aug 08, 2014 6:29 am

One possibility would be to set up a timer in Global.asax that runs every X minutes (like AC's Google Feed generation code). Write the current date in the store settings when you run the report, and don't run it again until the current date is different than the saved date. Or use date and time and a little more logic if you want it to run at a specific time during then day instead of soon after midnight. However, I think that timer will not fire if the App Pool unloads due to inactivity, so depending how busy your store is and when you want to run the report you might have to adjust your App Pool settings. Of course, you'd also have to write the code to actually generate the CSV and mail it.
Jay

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: extract daily orders automatically as csv and email out

Post by mazhar » Fri Aug 29, 2014 5:03 am

Tea-Dev wrote:Hi. Is there a facility where someone can automate the selection of orders, generate the report in csv and send it via email or ftp to another location? If so, can you share your thoughts/program please. Thanks.
One way to do this could be to override CommerceBuilder.Services.MaintenanceWorker service. For example extend your custom class from default MaintenanceWorker and extend it by adding your custom routine to export orders. This way this change wont effect future upgrades. You can implement the class in service in separate DLL and then hook it into system using Windsor configuration file. Read this viewtopic.php?f=65&t=17522 about how to override a default service in Gold.

Post Reply