I have actually looked at that site. All it does is give you a GUI interface to simplify the batch creation process. It still uses the same options and switches as when I manually create the batch. I dont think it is in the batch, as I have roughly 1500 projects written in Monarch that work from command lines. The last 50 or so just dont work from a command line. The only change I have found from these last new projects is the amount of SQL system lookups I do.
Previously all my data was exported from the server to CSV files. I then try to create them to do it on the 'fly' as it was more real time, the other way involved extra steps. My work around has been to go back to CSV files, which work perfect from a DOS batch.
Previously all my data was exported from the server to CSV files. I then try to create them to do it on the 'fly' as it was more real time, the other way involved extra steps. My work around has been to go back to CSV files, which work perfect from a DOS batch.[/quote]
It might be worth taking this up with Datawatch, now that you have mentioned it, to see if they can offer some practical advice from the experience of others that has not been discussed as part of the forum interaction.
Bear in mind that 'real time' can, in some circumstances and in my experience, be more of a problem than a benefit, but the net result and effectiveness depends on what you are trying to achieve.
"c:\Program Files\Monarch\Program\Monarch.exe" /PXALL "I:\NEWBUSINESS\Import\Monarch Models\DAILY\140 - RETURN - URBUDB.XPRJ"
I have also tried:
"C:\Program Files\Monarch\Program\MONARCH.EXE" /prj:"I:\NEWBUSINESS\Import\Monarch Models\DAILY\140 - RETURN - URBUDB.xprj" /mod:"I:\NEWBUSINESS\Import\Monarch Models\DAILY\140 - RETURN - URBUDB.xmod" /R /expfileopt:overwrite /pxall
With in the project I have results for 4 export. Whether I run with the /pxall or /px:(exportname) I dont get any results. I have used the 1st method of command line automation for 2 years. In the last 6 months, half of the new projects I set up do not work from the command line. Please help as this is very frustrating.[/QUOTE]
based on what i was seeing there you don't need to use /mod as that is part of the /prj also not sure you need to use the /R /expfileopt:overwrite /pxall
because when you create the file it already creates the data in there?
try playing around with the following I do not see you using the output names in your batch file. normally there is a /exp in there.
/prj:"I:\NEWBUSINESS\Import\Monarch Models\DAILY\140 - RETURN - URBUDB.xprj" "/pxall" /set:"Test"="True" /exp:"I:\NEWBUSINESS\Import\Monarch Models\DAILY\name of your files" /T
I put /T as that is where your data would be if in summary /S, you can figure out that part.