This entry deals with the issue of enabling E1 to email out completed jobs PDF or CSV files.
This is currently capable via OSA or BI but requires a developers busy little fingers to get each object UBE to email the completed file out of E1.
All UBEs in E1 write a record to F9861110, so we will use this fact to scan for completed jobs that we may or may email out. (this is controlled via a separate config file)
A new UBe will read over the F9861110 every 30 minutes (scheduled job) Each F9861110 record has a unique JOBNBR, so we will store the last read JOBNBR to F00022 for the next run. Next 30 min run the jobs are selected greater than the last saved JOBNBR
F9861110 also holds the OBNM_VERS_JOBNBR_PDF file name so we can use this to cross check the config table to see if this UBE VERS and USER combination (or whatever you want) is selected for emailing. If so the attachment is retrieved on the server and send via SMTP email, if not we just read the next F986110 record
Create a simple BSFN to get the print queue address using API GetPrintQueueDirectoryPathName (lpDS->szCommandString);
Feed this back to the UBE to concatenate the file name for attachment
The code is too long to post here so the attachment files have been added instead. Anyone wishing to gain further knowledge on this process are welcome to email/comment for assistance.
Object Specs (more available on request)