4 Replies Latest reply: May 15, 2014 10:06 AM by Data Kruncher RSS

    Batch File help

      Monarch Pro 5.02

      Windows XP

       

      Basically I'm trying to setup a batch file to open a project and export the table view to add to a database overwriting the existing table.

       

      I can get the batch file to open the project or monarch but it doesn't recognise any commands (/exp, /exptable, or even /rpt /prj) I've tried using the BAT tool I found through the forums but no luck.

       

      So here are my two different attempts so far.

       

      Using Just the Project[/B]

      @echo off

      "C:\Location\Unknowns.prj" /exp:"C:\Location\Unknowns.mdb" /expfileopt:add /exptable:"Unknown"

      /CODE

      Will open the project (Report, Model, in table view) correctly but does not export.[/I]

       

       

      Using the Excel BAT creator[/B]

      "C:\Program Files\Monarch\Program\Monarch.exe" /rpt:"C:\Location\Report.rpt" /prj:"C:\Location\Unknowns.prj" /mod:"C:\Location\Unknowns.mod"  /T  /exp:"C:\Location\Unknowns.mdb" /expfileopt:add /exptable:"Unknown"

      /CODE

      Just open's Monarh.[/I]

       

       

      Any help would be appreciated.

        • Batch File help
          Data Kruncher

          I suspect that you need to add the /exptableopt: parameter. With it you'll need one of:

          overwrite

          append

          skip

          /LISTI'll have to look at the Excel program later on.

           

          Kruncher

            • Batch File help
              Data Kruncher

              Actually, hold that thought. I just noticed that you're using Monarch v5.02.

               

              The parameters /exptable:, /exptableopt: and /expfiltopt: only take effect with Monarch v8 and later.

               

              If you really need to take advantage of these tools regularly to work as efficiently as possible, and I'd highly recommend that you do (and you clearly intend to do so), then it sounds like it's upgrade time for you.

                • Batch File help

                  Haha... Yeah it is beyond time to upgrade but its not up to me.

                  I do have a machine with v8.02 that I could use. The only issue is only a few of us have access to that machine, but it could be done still. Lets say I go that route...

                   

                  So I would need to use xprj projects? And what syntax would I have to change then.

                   

                  Thanks for the quick replies!

                    • Batch File help
                      Data Kruncher

                      No, the syntax would not change.

                       

                      You don't have to use .xprj instead of .prj, but if you make any changes[/I] to the project or the model then you must[/B] save them as .xmod and .xprj and[/B] revise the batch file.