• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Web run notes

 3 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Thuy Thiem
New Member Send Private Message
Posts: 2
New Member
8/4/2008 1:31 PM

Good morning,

I try to extract the invoice attachment (invoice comments), but I get more than I'm looking for.  How can I get just the comment (red line)?  
 

 
 
Here is the result:

TITLE=Comments

D:0=Short paid $ 97.68 per buyer. The PO# set up this item (481-952) @ 16.27 per case. Invoice line#2 not matching to the po cost.

K:0=K1=0010&K2= 12134&K3=032-272292&K4=000&K5=0000

R:0=writeattach.exe?_OUT=TEXT&_PDL=PROD81&_FN=APINVOICE&_IN=APISET1&K1=0010&K2=++++12134&K3=032%2D272292&K4=000&K5=0000&_ATYP=C&_AUDT=A&_AK=zF03&_KS=zz&

C:0:0=ap 7/7 win

R:1=writeattach.exe?_OUT=TEXT&_PDL=PROD81&_FN=APINVOICE&_ATYP=C&_AK=zF03&_IN=APISET1&K1=0010&K2= 12134&K3=032-272292&K4=000&K5=0000&

C:1:0=Add

MSG=Success

ERRNBR=5000

 

Thanks!

Thuy 206-901-4222

David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
8/5/2008 9:58 AM
You should be using a cgi-lawson/getattachrec.exe WebRun call. Once you get this back, you have to parse out the section you want.
I used B=Cmt.indexOf("AttData") and E=Cmt.indexOf("/AttData") to figure out the beginning and end points and then Cmt.substr(B+23,E-B-32) to clean it up.
David Williams
Thuy Thiem
New Member Send Private Message
Posts: 2
New Member
8/5/2008 2:04 PM
Good morning David,

Where should I set up the B and E, in the message builder?

Thanks!

Thuy
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
8/12/2008 10:00 AM
If the variable "Cmt" is assigned to the getattachrec.exe results then Cmt.substr(B+23,E-B-32) would be the value added to the MsgBuilder.
David Williams