Sage 100

 View Only

  • 1.  Automating VI Job Log

    Posted 03-20-2019 09:05
    ​Has anyone ever found (or created!) a way to schedule the VI Job Log output? I'm scheduling a job to run nightly, and we'd like to run the report (errors only version) and save it to a PDF in a specified location. It would be even better if it could be emailed automatically to recipients, but we'll settle for anything that archives a copy without it getting overwritten the next night. TIA!

    ------------------------------
    Kathryn Foradori
    Schneider Downs & Co., Inc.
    Pittsburgh PA
    ------------------------------


  • 2.  RE: Automating VI Job Log

    Posted 03-20-2019 09:09
    Sage Alerts????  Just a WAG.

    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: Automating VI Job Log

    Posted 03-20-2019 10:17
    We have an enhancement that might help

    https://development.dsdinc.com/enhancement/vi-1001-enhanced-visual-integrator-log/




    ---------------------------------
    Jim Woodhead
    VP Professional Services
    DSD Business Systems
    San Diego, CA
    619-990-3946
    ---------------------------------





  • 4.  RE: Automating VI Job Log

    Posted 03-20-2019 10:27
    Alnoor might have something but I haven't had a chance to follow up on this SC post from a few weeks ago.
    https://sagecity.na.sage.com/support_communities/sage100_erp/f/sage-100-technical-and-installation-discussions/100540/custom-report-based-on-vi-job-logs/279947#279947

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 5.  RE: Automating VI Job Log

    Posted 03-20-2019 16:22
    Hey Kevin - Thanks for mentioning this. I finished / delivered the latest iteration of this Perform Logic a few weeks ago. It does the following:

    • Creates a human readable friendly version of the VI Job Log as a TXT file. It can alternatively export to a table (like a UDT) with rows and columns so you can do your own reporting.
    • Extracts only the Errors - Failed and the often missed Passed with Invalid Fields entries. 
    • Emails the TXT output to a UDT defined email distribution list. Alternatively use Visual CUT to sweep the file and email it yourself.
    • Allows you to customize the filename. Last one was: PID + Date + Time + CompanyCode + JobName + Compiled-Job-Name + .txt
    • Writes an entry to the Activity Log

    The only I don't have it doing that Kathryn mentioned is exporting to a PDF but that could be added.

    ------------------------------
    Alnoor Cassim

    Free Agent Developer and Consultant
    CallForHelp.biz
    Email: alnoor@callforhelp.biz
    Orange County, CA
    ------------------------------

    Original Message


  • 6.  RE: Automating VI Job Log

    Posted 03-20-2019 13:50
    Kathryn,
    ???????? We have looked at adding VI Perform logic to create a text file of exceptions with files name with Process/Date/Time.
    We had thought of exporting to text files for easy review/search etc.?? Would that work for you?

    Let me know what you would need in the Job-Log export and I'll let you know the MD mod price for that.

    --

    Friendly Systems, Inc.

    Sage 100 (Mas90/200), Sage 300 (Accpac), SageCRM
    Visit us on the web at www.friendlysystems.com
    Office:?? 678.273.4010 ext 4
    Mobile: 404.202.9065
    Fax:?????????? ??678.273.4012
    See our blog at www.friendlysystems.com/blog



    ------Original Message------

    ​Has anyone ever found (or created!) a way to schedule the VI Job Log output? I'm scheduling a job to run nightly, and we'd like to run the report (errors only version) and save it to a PDF in a specified location. It would be even better if it could be emailed automatically to recipients, but we'll settle for anything that archives a copy without it getting overwritten the next night. TIA!

    ------------------------------
    Kathryn Foradori
    Schneider Downs & Co., Inc.
    Pittsburgh PA
    ------------------------------


Related Content