I have been Googling all morning to see if it is possible for an installed AIR application can execute a simple bat file and it seems that the 'no-no' of running other apps on a user's machines is the overwhelming answer. I thought I would throw the idea past you experts and see if there is any solutions to my issue.
We have a mass uploading process that we need to do daily to upload data from a local system database (Oracle) to a remote CMS database though a java based batch uploader. I have the bat file sitting on my desktop. I thought a cool little project would be to have my AIR app query the oracle database, generate XML files on the desktop, then run the batch file that uploads them..putting all the steps in the process in one place and automate it by running it at a specific time each day. Getting the information, generating XML documents doesn't seem to be a real problem. Simple web service and conversion manager class will get that done, its the bat file that seems to be the kink in the process. Can an AIR app run a local bat file OR can the actual JAVA in the bat file be executed by the AIR app?
