Personalization, Customization and Productivity Tools

[mboldrick]

I've written a VI job to import new sales orders, which runs via command line. Where are errors (or other results) stored / presented? I'd like to have my triggering program return any errors (or an indication of success, if one is available).

Thank you,

Mike

[BigLouie]

It's in the VI folder, well duh

[BigLouie]

Note that this log file cannot be opened by Notepad or WordPad.  A gentleman by the name of Slade developed a way to read the file and have it sent to you. It was posted on the old Sage Talk. Maybe some of the old timers remember how.

[mboldrick]

---

BigLouie wrote:
Note that this log file cannot be opened by Notepad or WordPad.  A gentleman by the name of Slade developed a way to read the file and have it sent to you. It was posted on the old Sage Talk. Maybe some of the old timers remember how.

---

I assume you're referring to the M4T file with the same name as the VI import job. I had overlooked it until your previous post, after which I noticed that it was only semi-legible in notepad. I'll see if one of my more programming-savvy partners can parse the file.

Thank you.

[IBPIT · Accepted solution]

You can use the following perform logic in this thread to create a text file that is legible.

http://community.sagemas.com/sagemas/board/message?board.id=SageMAS90Success&message.id=20&query.id=...

[mboldrick]

Thank you Kemp!

[IBPIT]

No problem.

It is the process BL mentioned that was created by Slade.  We use it on a daily basis.

Don't forget to mark solved questions so others know there is a solution for the question.

[marker6789]

When I attempt to use your PL file, I get returned an Error #14: Invalid I/O request for file state on Line 0007.

It does create the .log file, but does not export the log to it.  Any ideas?

My .PL is:

log_file$="C:/Users/john.smith/Desktop/Export.log"
erase log_file$,err=*next
serial log_file$
open (hfn)log_file$
log_chn=lfo
lock(log_chn)
read (59,key="",dom=*next)
read record (59,end=*next)rec$; translate rec$," ",sep; write record (log_chn)rec$; goto *same
close (log_chn)
exit

Thanks!

[IBPIT]

I believe the issue is with the output location of the log file.  I am not sure if you can have it placed outside the MAS90 directory.  If you notice in my example, the output is going to a subdirectory of MAS90 on our server.

[marker6789]

Kemp, good idea!  I tried it placing the .log file in the textout folder, and I get the same results.  Which folder did you put the .pl file in?

Thanks!