Can somebody help me out in learning about Projects and their use?
Also is there a way to apply multiple monarch models on the same report to get multiple reports. (excluding manual intervention like opening the report and dragging model on to the report and exporting it required format)
Thanks in adv...
Which version of Monarch are you using now? Your profile says V7. I can't recall whether V7 included the electronic version of the Learning Guide. If it does and it is installed on your machine (or network) it would be a good place to get an introduction to Projects. We can deal with specific question remaining once you have read the introduction.
For your second question - no you can't apply multiple models to the same report in the same Monarch session. However you can automate the process of applying a sequence of models to a report using a Batch file. See the Help file for Commands and also check out ******************** and the Batch File Generator available there.
If you also have programming skills you could consider writing a program rather than using the batch file should you choose.
See how far these suggestions get you and and then we can deal with any questions that are still not clearly answered.
agreeing with Grant, i usually use Batch Files to run multiple processes.
the beauty of the batch file is you can also rename files to add dates and other things like load data into MS Access and perform other things if needed. I use it at times to execute my Access Macros to run queries and then create output and place it in a designated network location.
You can take multiple files and use one model or project to link them but not multiple models like Grant said. I have a few processes where I take multiple files of the same data for different time frames and then load it into one project and create one end report as well.
a .bat file is a type of executable file. you can make that in the location you want to create the process by taking any file ie: a .txt file and just renaming it to .bat
then inside of it you should do things like I do which enables you to add the date to the file, if you don't want to do that, that is up to you as it normally helps daily having the file have a different date because you would be over-writting the previous day's file version.
what I normally do is as follows ( make sure to go to the control panel --> then to the Regional and Language Options --> then click on CUSTOMIZE --> click on the date tab on top right, and make sure your short date format = M/d/yyyy from the drop down and the date seperator is a / (once done, make sure to click on apply to save the settings)
I will provide you a sample as follows
this basically calls the Monarch executable and then i add a second process that renames the file.
keep in mind using a batch file .bat enables you to also run a Monarch xmod or project and directly send the data into MS Access if you want to run queries etc. It populates tables if you define them as well.
I am going to give you an example that I use to run a monarch and also send the data into MS Access.
I showed you a sample rename function as well but you will figure it out once you start playing with things.
you can name the files however you want them as long as you also use your export process properly. sometimes you don't use projects and just models, you can see this in the help file. The only difference would be there would be another line after the monarch.exe process called: /rpt:"
THE PATH YOU WANT and the file name followed example being\Input.txt"
and instead of a prj you would use a mod below
ECHO "Generating MDB..."
"C:\Program Files\Monarch\Program\monarch.exe" /set:"Test"="True" /prj:"
adonis\operations\MONARCH DOWNLOAD\Models & Projects\Cleanup.xprj" "/pxall" /exp:"
adonis\operations\MONARCH DOWNLOAD\Input Files\Validation.mdb" /expfileopt:append /exptableopt:overwrite /exptable:"Cleanup" /T
adonis\operations\MONARCH DOWNLOAD\Output Files\Validation.xls" "Validation_%MYDATE%.xls"
for some reason the : followed by an O makes a smiley face so keep that in mind that is what is said above.
Bob, you are not limited to using the command line for automating Monarch. If you feel more comfortable using VBA, you can program Monarch in VBA. You can download Monarch's Programmers Guide from url=http://www.datawatch.com/downloads/Monarch_8_Programmers_Guide.pdfProgrammers Guide[/url] and it gives you some examples to get you started.
Check out the forum as there are quite a few threads about it. There are several forum members that use VBA for automating Monarch and are willing to help. I use it as I find I am more comfortable using it.
agreed that is another option as well, I use batch files because of dummy proofing since some users are the ones who execute things and it is simpler then them potentially screwing up the potential vba process.
whatever works for him would be fine i guess, as long as he gets comfortable with it.
you can also use the windows task scheduler to automate running the process if you have files delivered daily in a location which basically creates automation without having anyone doing anything but look at the output.