extract daily orders automatically as csv and email out
extract daily orders automatically as csv and email out
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.
Re: extract daily orders automatically as csv and email out
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
Re: extract daily orders automatically as csv and email out
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.
Re: extract daily orders automatically as csv and email out
Is there any plugin?
Re: extract daily orders automatically as csv and email out
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.
-
- Commodore (COMO)
- Posts: 436
- Joined: Tue May 07, 2013 1:59 pm
Re: extract daily orders automatically as csv and email out
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
Re: extract daily orders automatically as csv and email out
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.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.