Gareth Horton
July 12th, 2002, 01:09 PM
Dale Hotchkiss wrote:
> I am currently working as a Database Manager using Monarch to bring various print and text files in from many different sources and then upload them into an Access Database. Currently I am using Monarch Version 4.** and am trying to figure out the best way to improve my system. At the moment it is overly complicated. I'm bringing in one file with information from 5 different companies. I then apply 5 different monarch models to the file one at a time exporting the information into Excel (I put it into Excel because I haven't had alot of luck importing directly into Access 2000 from my version of Monarch). From there I have to upload each of the five newly created files and add them to there respective tables one at a time. Needless to say I'm spending alot of time uploading information when I could be using that time to finess my database to give me more accurate and usefull information. My ultimate goal would be to have a system where I can point Monarch (or even just open the neede>>
> Thanks for your help,
> Dale
I also use Monarch V4. I have used the Autoscrp.exe to automate batch files. The advantage of using Autoscrp is that it will single step through a batch file. The disadvantage is that it supports only a small subset of DOS commands. The following is a batch file I have used:
cd"Program Filesmonarchprogram"
monarch c:monarchPublishdailyxf1.prj c:monarchexportdailyxf1.xls /t
monarch c:monarchPublishdailyxf2.prj c:monarchexportdailyxf2.xls /t
monarch c:monarchPublishdailyxf3.prj c:monarchexportdailyxf3.xls /t
"C:Program FilesMicrosoft OfficeOfficeEXCEL.EXE" "C:My DocumentsEXCELmacrodailyxfr.xls"
Monarch is automatically started and stopped with each step. After all 3 steps are complete the Excel file is opened. This file contains an Auto_Open macro that imports the data, formats it and produces a report then closes - all with one click.
If you're into programming, you can use Excel (or Access) to automate Monarch. I've been using this technique for a couple of years now with the reports we use. It really saves the user an extra step and limits our office on having train everyone in Monarch. I've even "re-created" the Files/Directory setup that Monarch uses in my solutions, with some improvement.
Datawatch has the Monarch Programmer's Guide that can be downloaded to get you started:
http://www.datawatch.com/litreq/Programmers_Guide.pdf
I've made my routine into a class module for easy object re-use.
Hope this helps!
-Nick
> I am currently working as a Database Manager using Monarch to bring various print and text files in from many different sources and then upload them into an Access Database. Currently I am using Monarch Version 4.** and am trying to figure out the best way to improve my system. At the moment it is overly complicated. I'm bringing in one file with information from 5 different companies. I then apply 5 different monarch models to the file one at a time exporting the information into Excel (I put it into Excel because I haven't had alot of luck importing directly into Access 2000 from my version of Monarch). From there I have to upload each of the five newly created files and add them to there respective tables one at a time. Needless to say I'm spending alot of time uploading information when I could be using that time to finess my database to give me more accurate and usefull information. My ultimate goal would be to have a system where I can point Monarch (or even just open the neede>>
> Thanks for your help,
> Dale
I also use Monarch V4. I have used the Autoscrp.exe to automate batch files. The advantage of using Autoscrp is that it will single step through a batch file. The disadvantage is that it supports only a small subset of DOS commands. The following is a batch file I have used:
cd"Program Filesmonarchprogram"
monarch c:monarchPublishdailyxf1.prj c:monarchexportdailyxf1.xls /t
monarch c:monarchPublishdailyxf2.prj c:monarchexportdailyxf2.xls /t
monarch c:monarchPublishdailyxf3.prj c:monarchexportdailyxf3.xls /t
"C:Program FilesMicrosoft OfficeOfficeEXCEL.EXE" "C:My DocumentsEXCELmacrodailyxfr.xls"
Monarch is automatically started and stopped with each step. After all 3 steps are complete the Excel file is opened. This file contains an Auto_Open macro that imports the data, formats it and produces a report then closes - all with one click.
If you're into programming, you can use Excel (or Access) to automate Monarch. I've been using this technique for a couple of years now with the reports we use. It really saves the user an extra step and limits our office on having train everyone in Monarch. I've even "re-created" the Files/Directory setup that Monarch uses in my solutions, with some improvement.
Datawatch has the Monarch Programmer's Guide that can be downloaded to get you started:
http://www.datawatch.com/litreq/Programmers_Guide.pdf
I've made my routine into a class module for easy object re-use.
Hope this helps!
-Nick