PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 04/17/2015 1:04 PM by  mikeP
Report archiving/emailing
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
tambrosi
Enterprise System Analysis
Private
Veteran Member
(102 points)
Veteran Member
Posts:48


Send Message:

--
04/17/2015 11:15 AM

    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
    Private
    Private
    Veteran Member
    (407 points)
    Veteran Member
    Posts:151


    Send Message:

    --
    04/17/2015 12: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
    Enterprise System Analysis
    Private
    Veteran Member
    (102 points)
    Veteran Member
    Posts:48


    Send Message:

    --
    04/17/2015 12: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
    Private
    Private
    Veteran Member
    (407 points)
    Veteran Member
    Posts:151


    Send Message:

    --
    04/17/2015 1: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.
    You are not authorized to post a reply.