locked
Complex Commands for Application Execution RRS feed

  • Question

  • Ok.  So I will stop here before opening up a ticket.  Znack you especially provide much insight.  Thanks.  Well anyway here is my question.  I have the application Monarch that is as I can gather more or less a database reporting tool.  The group here that uses this kicks off reporting using batch files.  Nearly 2000 of them.  Crazy yes.

    Well I have sequenced the latest version and this works fine with some modifications to the batch files.  I will provide both versions of the batch files here for your perusal.  This will not only show what we need to do but may provide someone with the assistance they need to get this or a like process working.

    What I am trying to find out if there is a way to incorporate any of this information into the sequenced app so that changes to thousands of batch files can be kept to a minimum.  This example I am told is a simple one with much more complex varieties in production.

    App-V 4.5

    Original batch file app loaded local:

    TITLE 4042 1
    ::
    @ECHO OFF

    del \\server\powerbuilder\rpms\r04042\4042.001 > NUL
    "\\server\powerbuilder\program files\monarch\program\monarch" \\reportserver\4042\4042.001 \\server\powerbuilder\rpms\r04042\r04042.xmod \\server\powerbuilder\rpms\r04042\4042.001

    bcp taxreporting..r04042 in \\server\powerbuilder\rpms\r04042\4042.001 -t; -T -S SQLSERVER\CONTROLSQL -c

    Same Process using batch file and App-V


    TITLE 4042 01
    ::
    @ECHO OFF

    del \\server\powerbuilder\rpms\r04042\4042.001 > NUL
    del \\server\powerbuilder\rpms\r04042\4042a.001 > NUL

    if not exist \\reportserver\4042\4042.001 goto end1

    "C:\Program Files\Softricity\SoftGrid for Windows Desktops\sfttray.exe" /launch "Monarch Pro 10 10"  \\reportserver\4042\4042.001 \\server\powerbuilder\rpms\r04042\r04042.xmod \\server\powerbuilder\rpms\r04042\4042.001

    :repeatcopy1
    move \\server\powerbuilder\rpms\r04042\4042.001 \\server\powerbuilder\rpms\r04042\4042a.001 > NUL

    if not exist \\server\powerbuilder\rpms\r04042\4042a.001 goto repeatcopy1

    bcp taxreporting..r04042 in \\server\powerbuilder\rpms\r04042\4042a.001 -t; -T -S SQLSERVER\CONTROLSQL -c

    del \\server\powerbuilder\rpms\r04042\4042a.001 > NUL

    :end1

    Most of what I need revolves around the launch of monarch.

    Thanks for any isight or a smackdown for a stupid question.

    B

    Friday, September 25, 2009 2:13 PM

Answers

All replies

  • Hello,

    As I see it, you want to change one line, or a part of a line, in loads of bat-files.

    Usually there are loads of programs that will make those mass-changes for you, just google around for a while and I am sure you will locate one that will fit.

    /Znack
    Friday, September 25, 2009 6:32 PM
  • If it's just a matter of making changes in 100 files in one shot, then Notepad++ is the best tool. And it's free!

    http://notepad-plus.sourceforge.net/uk/site.htm
    Friday, September 25, 2009 6:39 PM
  • It is not that easy.  I can mass edit in Textpad or Notepad++ and that is fine.  The problem apparently stems from how the application is called and what and how to pass the parameters to it.  Unless the person who created this missed something simple.  I will get a clarification on how what exactally happens.  As you can see there is a lot more "code" in the second example.  And this is a simple one.

    Thanks for your replys.
    B

    Friday, September 25, 2009 7:35 PM