Prev
Next
Forums Integration / Customization S3 Customization/Development

Report archiving/emailing

 3 Replies
 1 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
tambrosi
Veteran Member
Posts: 55
Veteran Member
4/17/2015 3:15 PM

    Hello,  I am looking for ideas on how people handled the report archiving from batch run jobs.   We are Windows and SQL. Lawson Version 10. 

    I have searched thru the forums and looked at some of the ideas and some will work for us. I set up a custom COBOL program that can copy a prt file off to a archived location using the "Call System Command" process.  

    Would anybody know if there is any doc on using the "Call System Commands" , I looked around but could not find anything except what I found in the forums.

    Question I have:

    From the COBOL system commands, can you call a VB.net application, I have an application that copies and/or emails files already, and would like to incorporate that if possible. From .net I was going to attack the USERRPT table.   

    We are new to Lawson, very new so any ideas or possibilities would be appreciated.  

    Thanks.   

    mikeP
    Veteran Member
    Posts: 151
    Veteran Member
    4/17/2015 4:22 PM
      Are you doing this because running a batch job overwrites the print files from the previous run of the same job?

      Our first Lawson host was on an AS400. Apparently on that platform vanilla Lawson puts print files in unique folders, and never deletes them; they must be maintained outside of Lawson.

      When we moved to a Windows, we were a bit surprised that the overwrite "feature" was in place.

      The workaround is a vbscript assigned to a token that runs as the first step of specific jobs to save the print files from the previous run in a folder whose name includes a timestamp. Each job that needs to save print files must include that step. It doesn’t email, but that would be easy to add.
      tambrosi
      Veteran Member
      Posts: 55
      Veteran Member
      4/17/2015 4:32 PM
        Hi Mike, yes that is one of the major issues, the overwrite of reports. Would you be willing to share your vb script, along with how you set that up under Lawson jobs.
        That is exactly what I am looking for, if there is any doc on setting up that process, can you let me know where to look.
        tambrosi@gbp.com
        Thanks
        Terry
        mikeP
        Veteran Member
        Posts: 151
        Veteran Member
        4/17/2015 5:04 PM
          I didn't find much in the was of documentation at Lawson, had to muddle my way through most it, with help from members of this forum. I did make detailed notes. Send me a private message with your email (from left margin of this post), and I'll send you what I have. Might take a little bit, I'll need to check it all for sensitive info.