Sep 26 2014

Automated emailing of completed UBE PDF/CSV files

VN:F [1.9.22_1171]
Rating: 5.0/5 (2 votes cast)

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.

Job PDF Distribution for sharing

Object Specs (more available on request)



Published under the license.

VN:F [1.9.22_1171]
Rating: 5.0/5 (2 votes cast)
Automated emailing of completed UBE PDF/CSV files, 5.0 out of 5 based on 2 ratings
(Visited 737 times, 6 visits today)

About the author

John Danter

Keen airsoft enthusiast with over 13yrs JDE development experience


1 ping

Skip to comment form

  1. Diwakar Dwivedi

    How would you be handling the truncated version names or missing version titles due to the 30 character limitation of the job field OBNM_VERS_JOBNBR_PDF ?

    This bug is fixed only on the later versions of 9.1.

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  2. John Danter

    As long as the VERS and OBNM are no longer than 8 chars then yes this should fine

    I did this on 9.0 but so far haven’t come across an issue as all our versions are only 8 long

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  3. apndy

    can’t find the source code of B550002, Can you share it to me? thank you.

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
    1. shaviz

      Could you pls share B550002 source code.

      VN:F [1.9.22_1171]
      Rating: 0 (from 0 votes)
  1. Pes 2013 Blus Ps3 | Evnavi - PES 2013 Download | PES 2014 Download | PES 2015 Download - Evnavi

    […] Source : http://www.pes-patch.com/2014/12/pes-2015-ps3-paul2478-option-file-v2-bles-blus-blas.html Tags : [ps3] paul2478 pes 2015 (bles/blus/blas) – pesgaming forums, [ps3] paul2478 pes 2015 (bles/blus/blas) pes 2015 completed files. […]

Leave a Reply