Email Report Server/400 is ready for V6R1/V7R1 of i5/OS, starting with version 2.59

General email performance note: ERSBUFFER data area can be set from the default value of 512 to some value such as 4096 or 10000 to improve SMTP throughput.

2.90.0

2015-12-18

  • The minimum OS/400 compatibility is now V6R1

2.89.5

2015-07-20

  • Fixed a bug with the MAILSPLFJ command where it was losing the email MIME content type

2.89.4

2015-03-25

  • Updated PDF version used in conversions

2.89.3

2014-7-28

  • Fixed IFS File names were the limit was 100 characters and is now 255 characters.
  • Created a FAXPORT dtaara so faxes can now be sent to a different port. Default is 25.
  • Created CHGPRDLIB command to change product library on all commands.
  • Added @TIME keyword. Can be used wherever other key words are used.
  • Fixed broken help msg in ERS101R.
  • Added programs LOGPRG and LOGPRG3 for purging of ERSLOG00 file.
  • Fixed problem with *DEFAULT report description.
  • Fixed MAILSPLFJ were it was not keeping MSG text properly.
  • The PDF converters did not handle the pipe (|) character correctly. This is now controlled by a data area (REPLCHAR). It defaults to a pipe, but can be changed to whatever character the end user is not using. Possibilities would be a tilde (~), reverse quote (`) or some other character which is not used.

2.89.2

2013-1-18

  • Improved the editing of email addresses in the maintenance programs.
  • Fixed bug in the monitor program with GROUP: names complaining that there was no @ in the name.
  • Made MAILOUTQ handle spool files in same way as MAILSPLF. EXT: and ATTACHNAME: are now honored. Different names and types are now possible.

2.89.1

2012-10-01

  • Fixed bug introduced in 2.89. If no MAILTO: was defined in the User Defined Data for a spool file an error flag would get set. It would then go through all it’s normal processing but at the end it would see the error flag set and not do the post processing. If the move to error out queue was set up, it would move the spool file to the error out queue.
  • Fixed a typo that would show up in the job log when extracting an attachment file name from the User Defined Data of a spool file.

2.89

2012-05-02

  •  Changed FAXBCKSND command email address   format to allow formatting using the following format:  9999999999@faxdomain.com where fax domain comes from FAXDOMAIN data  area. Did this because Faxback 8.7 now uses the MS SMTP Service which needs a normalized  email address format.  New address format is enabled if the FAXADDRFMT data are is set to: *FORMAT2 FAXADDRFMT value is blank by default which will use existing fax format.
  • Added ability to password protect compressed files when sent through a monitor. Added password to both Email Recipient List (opt 4) and Output Queue List (opt 3). If Compress = Y, then a window is displayed asking for password.
  • Added @spool, @userdata, @jobname, @formtype options to ATTACHNAME:.
  • Fixed problem of LICERR if just fax licensed and not ERS.
  • Fixed problem if Msg Body = '.', replaced spaces. A period in the msg is invalid.

2.88

2011-12-20

  • Changed monitor (ERSMON) to run different MAILSPL cmds. The dtaara ERSSPLCMD controls this. The default value is MAILSPLF. It can be changed to MAILSPLFJ. These are the only 2 options. If it is something else it will revert to MAILSPLF.
  • Changed MAILSPLFJ to work with hosted email servers. Prerequisite for this feature: JVM version 1.5 (or greater) OS400 V5R3M0. This was mostly a change in the Java class with additional parms passed in from MAILSPLFJ.
  • Changed MAILSPLF/MAILSPLFJ to allow attachment name to be whatever the end user wants. There are 3 ways of setting this and in this priority: 1. ATTACHNAME:xxxxx~ in the user defined data of a spool file. 2. ATTPREFIX parameter of MAILSPLF/MAILSPLFJ 3. ERSATTACH dtaara
  • Added dtaara ERSJVM to allow running different JVMs. The default is /QOpenSys/QIBM/ProdData/JavaVM/jdk50/32bit.

2.87

2011-11-7

  • Fixed problem that placing a $ in Subject or Msg caused the rest of the text to be dropped.
  • Fixed backslashes not properly handled in PDF conversion.
  • Fixed the MAILSMTP 10 minute alarm to now be user configurable.
  • Fixed IMGSERVER error using user defined embedded command.
  • New Functionality: HTX and MSG2 report conversions added to MAILSPLFJ.

2.86

2011-03-04

  • Fixed new PDF special character logic introduced in V2.85 to scan for backslashes and convert to \134 before scanning for other special characters. This should prevent inadvertently replacing backslashes inserted for other special character values such as:
( = \050
) = \051
' = \047
* = \052
/ = \057
. = \056
: = \072
- = \212
+ = \053

This was causing some odd special character conversion results.

  • Fixed numeric overflow error in the PDF converters. This occurred in spooled files with a single line on a single page.

2.85

2010-09-19

Updated PDF converters to replace \ with \134 in PDF files. This will allow PDF files to accurately display backslashes. Backslashes are normally an escape character in PDF files.

2.84

2010-08-19

  • Changed FAXRFXSND to replace blanks with periods in /fax (TO: fax) & /o (TO: company).

2.83

2010-07-02

  • Added USEJAVA parm to the MAILSPLSEL command. If USEJAVA parameter is set to *YES, the MAILSPLFJ command will be used instead of MAILSPLF so CC and BCC can be used. Comma delimiter is added automatically to the end of each email address for TO, CC, BCC.
  • Updated PDF converters to make sure that if an *SCS spool file has a line skip instead of a space on the last line we calculate the correct line spacing and print the last line in the correct location.

2.82

2010-3-29

Removed extra / from voice phone field when faxing using FAXRFXSND with an address format of *FORMAT1 and entering a voice phone number. Was causing error when faxing via RightFax server if voice phone was entered. This was a typo in our code in V2.81.

If ERSSETFAX setting is set to *RIGHTFAX, the fax monitor was attempting to send out as if faxes were going out of the Castele Faxpress server even though RightFax was set. FAXMON will now pick the correct fax server type.

Note: When faxing via FAXRFXSND, the outbound fax emails may fail if the company name or voice phone have spaces in them.

2.81

2010-3-26

Added FAXRFXFMT data area to control the RightFax fax address formatting when sending to SMTP server when faxing via FAXMON or FAXRFXSND commands.

RightFax email format setting choices are *FORMAT1 or *FORMAT2:

Value - *FORMAT1 (Default)

Format:

</pn=ToName/voice=ToVoice#/fax=ToFax#/o=CompanyName@domain.com>

Example:

</pn=ToName/voice=9999999999/fax=9999999999/o=CompanyName@domain.com>

Value - *FORMAT2

Format:

(ToName / ToVoice#)<ToFax#^company=Company Name@domain.com>

Example:

(ToName / 999999999)<9999999999^company=Company Name@domain.com>

2.80

2010-3-4

Added FAXRFXSND command to send faxes via RightFax SMTP gateway.

Enabled RightFax in fax monitor.

Command ERSSETFAX updated to set RightFax as the default for RJSWRKOUTQ and RJSWRKSPLF commands. This will allow interactive faxing from output queues to FaxBack Server out of the box. Call with the *RIGHTFAX option to set up for use with RightFax.

Command ERSHOSTFAX should be called with RJS_RIGHTFAX as option to set the new default TCP/IP host name.

A host table entry of RJS_RIGHTFAX pointing to the RightFax SMTP server will need to be created via the GO CFGTCP menu, Option 10.

If using RightFax faxing option, we will automatically route faxes to the RJS_RIGHTFAX host name when @RJS_RIGHTFAX or @rjs_rightfax is found within the users email address.

Setting up for RightFax server usage.

1.) Install RightFax SMTP gateway and assign it a domain name such as fax.rjssoftware.com.

2.) Set FAXDOMAIN data area to match the RightFax SMTP domain via CHGDTAARA.

3.) Create a Host entry via GO CFGTCP, option 10. Call it RJS_RIGHTFAX. Point it to the IP address of the RightFax SMTP server.

4.) Set FAXHOST data area to RJS_RIGHTFAX via the following command:

ERSHOSTFAX OPTION(*SET) SMTPHOST(RJS_RIGHTFAX)

5.) Set default fax server data area ERSSETFAX via the following cmd:

ERSSETFAX OPTION(*SET) OPT(*RIGHTFAX)

2.79

2010-2-4

Added two new message formatting options to allow the formatting of text and HTML messages into high quality embedded text emails.

Added MSG2 output type to send spool file as an embedded text message without any page breaks. This option always uses CPYSPLF with PRTCTL(*NONE). The basic customer issue was that Microsoft Outlook was not appropriately rendering line and page breaking. This is a MS Outlook rendering issue, not an email formatting issue. This option normally won't improve the look of an embedded text message email, but customer asked for this as an option so we provided it. In general we recommend using the HTX option listed below instead of using MSG2 when you need formatted email messages.

Added HTX output type to send spool file as an embedded HTML message. This option always uses CPYSPLF with PRTCTL(*NONE). This option will allow customers to create spool files that simply contain HTML information for distribution. This is a great way to control email formatting including colorizing emails, changing font sizes and styles, embedding HTML links into the email and more. This option pretty much handles any HTML document formatting available. The spool file must contain properly formatted HTML information.

2.78

2010-1-6

Changed FAXMON command to have default fax server host be *DEFAULT instead of RJS_FAXBACK OR RJS_FAXPRESS. When *DEFAULT is specified the fax smtp host is pulled from the FAXHOST data area.

2.77

2009-12-18

Added PDFFONT data area to control which font is put into a PDF file. Default font value is Courier. Change the PDFFONT data area value to Courier-Bold to make report fonts bold. This may be required when sending reports via a fax server such as Castele Faxpress for document clarity.

2.76

2009-12-14

Note: Existing Castele Faxpress customers need to follow the notes under: Setting up for Castele FaxPress server usage if any of their settings get changed or they do a default Email Report Server installation. The default fax server is now FaxBack. Castele users must always verify that the FAXHOST data area is RJS_FAXPRESS and the default ERSSETFAX data area says *FAXPRESS. These should get carried over correctly during a library upgrade, but the steps are documented below.

Enabled FaxBack fax server support in fax monitor. FaxBack is now also the default fax server. Also default data area ERSSETFAX to *FAXBACK to support this change. *FAXPRESS was the old default.

Command ERSSETFAX updated to set Faxback as the default for RJSWRKOUTQ and RJSWRKSPLF commands. This will allow interactive faxing from output queues to FaxBack Server out of the box.

Command ERSHOSTFAX changed to set FaxBack TCP/IP host name. The RJS default host name will be RJS_FAXBACK. A host table entry pointing to the FaxBack server will need to be created via the GO CFGTCP menu, Option 10.

If using FaxBack faxing option, we will automatically route faxes to the RJS_FAXBACK host name when @RJS_FAXBACK or @rjs_faxback is found within the embedded email address.

Setting up for Faxback server usage.

1.) Install Faxback SMTP gateway on Windows server and assign it a domain name such as fax.rjssoftware.com.

2.) Use CHGDTAARA to set the FAXDOMAIN data area value to match the FaxBack SMTP domain from 1.)

3.) Create a Host entry via GO CFGTCP, option 10. Call it RJS_FAXBACK. Point it to the IP address of the FaxBack SMTP server.

4.) Set FAXHOST data area to RJS_FAXBACK. via the following command: ERSHOSTFAX OPTION(*SET) SMTPHOST(RJS_FAXBACK) You should be able to ping the FaxBack server by typeing PING RJS_FAXBACK from the iSeries command line.

5.) Set default fax server data area ERSSETFAX via the following cmd: ERSSETFAX OPTION(*SET) OPT(*FAXBACK)

Setting up for Castele FaxPress server usage.

1.) Install Castele Faxpress SMTP gateway on your Castele FaxPress server.

2.) Create a Host entry via GO CFGTCP, option 10. Call it RJS_FAXPRESS. Point it to the IP address of the FaxPress SMTP server. You should be able to ping the Faxpress server by typeing PING RJS_FAXPRESS from the iSeries command line.

3.) Set FAXHOST data area to RJS_FAXPRESS. via the following command: ERSHOSTFAX OPTION(*SET) SMTPHOST(RJS_FAXPRESS)

4.) Set default fax server data area ERSSETFAX via the following cmd: ERSSETFAX OPTION(*SET) OPT(*FAXPRESS)

Embedded fax address handling This is a re-summarize of the FAXTO: logic added in V2.52/V2.53. Users can set a FAXTO: value in the first 100 lines of a report or in the user defined data field for a spool file. This keyword is used to extract the fax recipient info for a report. The report will get faxed when when the FAXMON command is used to monitor an output queue. The format of the FAXTO: keyword is as follows:

FAXTO: <ToPhone#>;<ToName>;<ToCompany>;       
      <VoicePhone>;<FromEmailAddress>;       
      <MessagetextLinem>;~                   
Sample embedded FAXTO: fax address line:      
FAXTO: 999-999-9999;Joe Jones;RJS Software;   
       888-888-8888;from@test.com;            
       This is a test fax;~

Note: The above samples are two lines, but the entire FAXTO: string must be on the same line.

2.75

2009-11-15

Updated several of the output queue monitor CL programs to correctly handle 6 digit spool files. Created a new edit program to correctly zero suppress the spool numbers before passing to converters. Some users were getting a MCH3601 error with a substring out of range when processing reports with a 6-dibit spool number.

Added user space check to outq monitor to avoid extraneous joblog entries. New program ERSUSRSPCC.

2.74

2009-11-05

Added capability to send short attachment names with MAILSPLFJ command. Normally there is a unique temp file name generated with the appropriate user prefix. There is a new data area named SHORTTEMP. If set to *NO, MAILSPLFJ works as designed. If set to *YES, MAILSPLJ will generate a short name in the /RJSTEMP folder when sending. This does have the potential to create file name collisions, however when SHORTTEMP is enabled, we lock the ERSLOCK data area exclusively so that only a single instance of the MAILSPLFJ can be running at a time. If a second call to MAILSPLFJ starts and has to wait more than 5 seconds to get a lock on the ERSLOCK data area, the second call to MAILSPLJ will fail. When SHORTTEMP is enabled, MAILSPLFJ should be run in a single threaded fashion.

WARNING: It is not recommended that users enable the SHORTTEMP data area unless they absolutely need full control of attachment naming with MAILSPLFJ. Under normal circumstances it is best to let MAILSPLFJ generate unique attachment names.

2.73

2009-10-29

Updated Enterprise Fax functionality to enable the ability to send faxes via TIF instead of PDF. No special steps required other than library upgrade.

2.72

2009-9-20

Changed default installation ERSBUFFER value from 512 to 5000 for SMTP throughput improvement.

Enabled the ERDISCLAIM handling in MAILSPLFJ so users can add disclaimer messages to outbound messages. See V1.55 for notes on how it works via the ERDISCLAIM and ERSDMSG commands.

Changed MAILSPLFJ command to allow soft coding of attachment name prefixes similar to MAILSPLF. Report prefixes are taken from the ERSATTACH data area so outbound email messages can create report prefixes similar to MAILSPLF. See V1.28 & V1.96 for notes on the available values for soft coding attachment prefixes via ERSATTACH.

If ERSATTDATE data area is set to *YES, report attachment prefixes will look like following: REPORT-yymmddhhmmss.pdf

If ERSATTDATE data area is set to *NO, report attachment prefixes will look like following: REPORT-yymmddhhmmss-jobuserjobnbr.pdf

Since this is also the name of the temp file we create we added several IFS object checks to make sure we don't see any duplicate file names getting created causing MAILSPLFJ to abort when ERSATTDATE is set to *YES and multiple jobs run the MAILSPLFJ command at the same time.

NOTE: If you enable ERSATTDATE by setting to *YES and run into abnormal MAILSPLFJ send failures because of duplicate file naming issues with MAILSPLFJ, you should set ERSATTDATE to *NO so that we create a more unique file name for mailing. This note only relates to the MAILSPLFJ command.

Leaving ERSATTDATE set to *NO is the recommended setting for most customers.

2.71

2009-9-17

Updated PDF converters to handle line spacing correctly at the last line of a report. No report data was being lost. This was just a cosmetic change to make sure the last line spaces correctly.

2.70

2009-8-3

Updated MAILSPLFJ command with the new Native DataImport Converter command (CPYSPLDIW) available in the Native Converter library V1.52. The Native DataImport converter works in conjunction with a web service to convert documents to MS Excel, MS Access, Dbase and any other DataImport supported conversion format. See V2.66 fix list notes for more info.

2.69

2009-7-26

Updated ERSATR02 to change RCVVAR buffer length to 1600 from 1306. This seems to have been causing a teraspace error from the ERSATR2 command call. This is most likely the real solution to the problem caused in V2.68.

Implemented new MAILSPLFJ command to send reports via java email API. This command calls a java program to send email messages. Requires Java JDK version 1.4. MAILSPLFJ allows for CC and BCC parameters to be passed.

Implemented ERSJAVAEN command to restore RJS Java objects to the IFS.

Note: This command must be run before usingthe MAILSPLFJ command.

Implemented new VFYJDK command to verify if the Java JDK 1.4 is loaded on the iSeries.

2.68

2009-4-14

Include ERSATR01 and ERSATR02 source code. Had an odd problem where customer went to V6R1 and ERSATR02 would die if user called MAILSPLF command from custom programs, but worked fine in ERSMON output queue monitor. We placed source for ERSATR02 on their system and then the failure went away. Very odd.

2.67

2009-4-13

Added option to prevent output queue monitor ERSMON from failing when calling MAILSPLF if no default value is specified for an email recipient for the DataImport Output Type in the Email Recipient list. If a customer upgrades from an older version of RJSERS, the DataImport output type default value may be blanks. If we detect a blank entry when running the output queue monitor, we default the DataImport Output Type to XLS8

2.66

2009-3-24

Updated MAILSPLF command and output queue monitor to support processing reports with the new Native DataImport Converter command (CPYSPLDIW) available in the Native Converter library V1.52. The Native DataImport converter works in conjunction with a web service to convert documents to MS Excel, MS Access, Dbase and any other DataImport supported conversion format.

The Output Data Type parameter on the Edit Email Recipient List program should be set to DIW when converting with DataImport converter.

The program also has field entries for the DataImport Mask IFS file and the various DataImport conversion types. Use XLS8 as the default output type. We recommend storing DataImport mask files in an IFS folder named: /RJSDIW.

Note: Prior to using this option, make sure to test the CPYSPLDIW command with a DataImport mask to make sure it works as expected.

2.65

2009-1-5

Updated MAILOUTQ command so that it retrieves the ERSPCLCMD1 - ERSPCLCMD4 data area values. These data areas are used to pass custom PCL to PDF commands when converting PCL to PDF. MAILOUTQ is now consistent with MAILSPLF when converting PCL spool files to PDF.

2.64

2008-11-09

Updated ERSATR and ERSATR2 commands so that they no longer update position 512 of the LDA (Local Data Area). This was causing problems for customers who still use the LDA to store runtime information.

2.63

2008-11-07

Added RMVTEMP data area check to MAILOUTQ. If RMVTEMP set to *NO and the MAILOUTQ command is run, an entry will be placed in the joblog after each file is mailed. The joblog entry will have an INFOTEMPFILE: entry followed by the temp IFS file name. This feature was added for debugging temp attachment files being sent out. The temp file can be copied to a PC via an IFS share, FTP or operations navigator and sent to RJS for review. Also the temp IFS files WILL NOT be deleted so RMVTEMP should be set back to *YES after testing. Normally the RMVTEMP data area should be set to *YES unless debugging.

2.62

2008-11-04

Added PDF header data area PDFVER. This now controls the PDF version set in the PDF header. Default - %PDF-1.5. Default value used to be 1.3. If the data area is blank or missing, the PDF converter will use %PDF-1.3 as the default.

2.61

2008-04-10

FAXCASTELE command now supports the RMVTEMP parameter for removing temp files.

FAXMON command supports the RMVTEMP data area value.

2.60

2008-04-08

Added RMVTEMP data area that determines whether temp files get removed or not. RMVTEMP data area value defaults to *YES which normally deletes temp report files after emailing. If set to *NO and the output queue monitor is run, an entry will be placed in the joblog after each report file is mailed and the temp file WILL NOT be deleted from the /RJSTEMP IFS folder. The joblog entry will have an INFOTEMPFILE: entry followed by the temp IFS file name. The IFS file can be downloaded to the PC for viewing if you have a Windows share created over the /RJSTEMP IFs folder or the file accessed via operations navigator or WRKLNK.

Ex: INFOTEMPFILE:/RJSTEMP/REPORT123456.PDF

This feature was added for debugging temp files being sent out.

MAILSPLF also has a RMVTEMP parm on it to control temp file deletion if customer is using the MAILSPLF command standalone. The RMVTEMP parm can manually be set to *NO on the MAILSPLF command.

2.59

2008-02-01

NOTE: Minimum OS/400 release is V5R1.

2.58

2008-1-14

This has been supported for a while, but wanted to add to the fix list.

Added PDF converter to library build that handles zero line spacing. Program name: ERS019R. This program handles zero line spacing correctly.
To use zero line spacing within a PDF document, change default PDF converter from ERS008R to ERS019R. This setting is stored in the ERSPDFPGM data area.

  • Setting for PDF Converter that Handled Zero Line Spacing

CHGDTAARA DTAARA(RJSERS/ERSPDFPGM) VALUE(ERS019R)

  • Old Default PDF Converter Setting

CHGDTAARA DTAARA(RJSERS/ERSPDFPGM) VALUE(ERS008R)

2.58

2007-04-12

Added FACSYSSND command for FacSys Fax Server fax users. This command can be used to fax reports via the FacSys Fax Server if the customer is licensed for FacSys and the Enterprise Fax Software.

Fax Address Format: <ToName@ToCompany@Tofax>

Customer needs to pass ToName, ToCompany and ToFax formatted exactly as desired.

FacSys example fax address format

DislayName@CompanyName@+1 (XXX) 5551234

2.57

2006-11-09

Added ERSLISTUSR command to allow user to be able to list spool files to an output file by user and other spool filters.

Added RTVLSTUSPL command to allow user to be able to retreive the spool file information for a user's last created spool file no matter what job it was created in. This was created because we have a customer who is running report creation programs from a java system and when this happens, the java program creates the actual spool file under user QPRTJOB instead of the actual user job that created the report. RTVLSTUSPL allows us to cross the boundaries of all jobs and be able to determine the most recently created spool file for a user. This command can be used instead of ERSNUM when retrieving the most recent spool file before calling a command such as MAILSPLF. **NOTE: ERSLISTUSR and RTVLSTUSPL can run slowly if a single user has a lot of spool files on the system, so only use these commands if you are keeping your systems clean in terms of number of spool files left online per user.

2.56

2006-10-23

Added separate authenticated SMTP data areas for emailing and faxing. This allows email users to turn on authenticated SMTP without fax servers such as Castelle Faxpress being adversely affected because Castelle does not use authenticated SMTP.

Note: You should typically never need to change these settings, even if your Email Report Server/400 email authentication is enabled because most fax servers DO NOT require authenticated SMTP.

New data areas: FAXUSER, FAXPASS, FAXSECURE New commands: FAXUSER - Set fax SMTP user and password.

Ex: Set authenticated faxing user/password

FAXUSER OPTION(*DSP) SMTPUSER(userid) SMTPPASS(password)

Enable authenticated faxing:

FAXSECURE

Enable fax SMTP authentication example:

FAXSECURE OPTION(*DSP) ENABLE(*YES)  

2.55

2006-10-12

Added MSG output type to MAILSPLSEL command. Even though the MAILSPLF command already supports the MSG output type, the MAILSPLSEL command screen ERS109 was not allowing MSG to be used for an output type.

2.54

2006-03-13

Added FAXBCKSND command for Faxback Enterprise fax users. This command can be used to fax reports via the Faxback Fax Server if the customer is licensed for Faxback and the Enterprise Fax Software.

Added FAXDOMAIN data area. This data area should hold the domain name used by the customers Faxback server SMTP gateway. The value in FAXDOMAIN will be appended to the phone number of all faxes sent with the FAXBCKSND command.

Added BRACKETS parm to MAILSPLF and MAILSMTP2 commands. If set to *YES, the <> brackets are automatically placed around an email address. If *NO, no brackets are automatically placed around an email address. This was added for customers who want to be able to use the MAILSPLF command to email documents with the Faxback fax server. Default = *YES. If brackets are set to *NO, the To Name may not show up correctly on Faxback cover pages.

Fax address format:

(Friendly Name)<999-999-9999^company=company name@faxback.com>

2.53

2005-11-18

Added ability for users to set an embedded MSGTEXT: keyword in the report data or user defined data field to set the message text when embedding email addresses in the report or the user defined data field. The MSGTEXT: keyword can be placed anywhere in the first few pages and must be formatted as follows:

MSGTEXT: This is a test message;~

Sample embedded email address line:

MAILTO:to@test.com;~MSGTEXT:Daily Sales;~

Added ability for users to set an embedded message text keyword in the report or user defined data field when using the FAXTO: keyword to set fax recipient info in the report or user defined data. The message text parm is the 6th parameter in the FAXTO: data string. The FAXTO: info must be formatted on the same line as follows:

FAXTO: <ToPhone#>;<ToName>;<ToCompany>;<VoicePhone>;<FromEmailAddress>;<MessagetextLinem>;~

Sample embedded FAXTO: fax address line:

FAXTO: 999-999-9999;Joe Jones;RJS Software; 888-888-8888;from@test.com;This is a test fax;~

Fixed FAXTO: problem if user forgot to pass voice phone. If so, the from email address was getting stuffed into the voice phone field. We now handle all blank parms if passed as blanks to FAXTO:

2.52

2005-10-30

Added ability for users to set an embedded MAILFROM: keyword in the report data or user defined data field to set the from address when embedding email addresses in the report or the user defined data field. The MAILFROM: keyword can be placed anywhere in the first few pages and must be formatted as follows: MAILFROM: test@rjssoft.com;~ Sample embedded email address line: MAILTO:to@test.com;~MAILFROM:from@test.com;~. When using ERSMON, the From Address field must be set to *DEFAULT in order to scan the banner text.

Added ability for users to set an embedded from fax user email address keyword in the report or user defined data field when using the FAXTO: keyword to set fax recipient info in the report data or user defined data.The from fax email address is the 5th parameter in the FAXTO: data string. The FAXTO: info must be formatted on the same line as follows:

FAXTO: <ToPhone#>;<ToName>;<ToCompany>;<VoicePhone>;<FromEmailAddress>;~

Sample embedded FAXTO: fax address line:

FAXTO: 999-999-9999;Joe Jones;RJS Software;888-888-8888;from@test.com;~

2.51

2005-07-06

Updated POPFAX1R log entry format.

2.50

2005-06-24

On the MAILOUTQ command, *USERID may now be entered in the "To Email Address" field.

On the MAILOUTQ command, CSV is now a valid conversion type. The parameters MASKNAME and MASKTYPE were also included.

When upgrading from one release to another, the ERSUPG command will now restore the fax log.

2.49

2005-06-21

For those person using the option identified in version 2.47, the correction has now been made that will allow the log entries to be written to the fax log rather than the email log.

If someone upgraded from a previous version of Email Report Server/400 or Enterprise Fax Server to versions 2.45 to 2.48, and they had data in either the fax or email log, the data would not properly convert. That has been corrected. However, if someone is currently on version 2.45 - 2.48 and they upgrade to 2.49, their log files will not properly convert.

Corrected the problem encountered with release 2.48 that resulted in an error when MAILSPLF was used to write to the email log file. Also corrected a problem that resulted in security checking being bypassed in MAILSPLF.

2.48

2005-06-16

The log for Enterprise Fax Server has now been expanded to have more detailed fields in it. Also, faxing entries will be written to only the fax log. Previously there were also some entries written to the email log.

2.47

2005-06-13

Updated FAXCASTELE to create a RPTID on each outbound fax so that this can be used to read Castelle completion emails for fax success or failure. We created a POP/400 exit program called POPFAX1C to handle the adding of inbound fax status emails to the ERSLOG00 file. Will need to change to use FAXLOG00 file after FAXLOG00 file is extended. Created new FAXID00 file to track spool file info for an outbound fax.

2.46

2005-05-25

Updated PDF converter program ERS019R to correctly handle zero line spacing without messing up the fonts. When overlaying 2 zero space lines, the font would get garbled.

2.45

2005-05-25

Added fields to the ERS log file, made changes so all writes to the file are done through ERSLOG001

2.44

2005-05-17

Added ability to override page orientation to Enterprise Fax Server. The option works the same for fax processing as it does for Email Report Server/400. The parameters can either be entered on the FAXCASTELE screen or within Report Splitter. On the FAXCASTELE screen, the User Defined Option has been added. This actually consists of 3 10-character fields. In the first, enter either *PORTRAIT or *LANDSCAPE. In positions 11 - 20, enter the font size override (values are 1 - 20). In positions 21 - 30, enter the line space override. Suggested values are 8 (80 col portrait), 7 (132 col landscape) and 6 (198 col landscape). NOTE: All three parameters must be entered. If you are entering these parameters into Report Splitter, they are entered on the Edit Report Distribution Settings screen. The same 3 parameters are used.

2.43b

2005-04-11

Updated library to handle LPAR's 10 or above for license checking.

2.43

2005-04-07

Corrected upgrade program to copy back the following data areas: ERSATSIGN, ERSERROR, ERSERRORQ, ERSSENDID .

2.42

2005-04-03

Removed bare linefeed code from MAILSMTP6L and MAILSMTP9L. Bare linefeeds were occurring if the ERSMSGID or ERSSENDID data areas were enabled and MAILSMTP6L or MAILSMTP9L were being used to encode the messages.

2.41

2005-01-03

Updated MAILSPLF command to correctly set file attachment names when zipping with the PKWARE ZIP for iSeries. Was causing a 00001 error in the joblog.

2.40

2004-12-19

Re-imported ERSMON001 source code into source code management and compiled into V2.40. The V2.38 update got missed in the 2.39 build.

2.39

2004-12-17

Added RMVTEMP flag to MAILSPLF command. Defaults to *YES. If changed to *NO, the temp work files in /RJSTEMP will not get deleted. This can be used to troubleshoot IFS Authority issues.

2.38

2004-12-02

Deleted code that, in certain situations, assumed the user-defined data area was an email address even though the keyword MAILTO: was not included. Persons that were using the user-defined data area to specify a mail-to address without the keyword MAILTO: will need to enter that keyword.

2.37

2004-11-29

Added new parameter Attachment Name Override on the MAILOUTQ screen. This lets the user override the name that would otherwise be given to the attachment. In addition to a specific text name, the kewords @SPOOL, @JOBNAME, @FORMTYPE, @DATE, @TIME, @USERDATA and @USERID may be used.

2.36

2004-11-04

Added output type parm to the FAXCASTELE command call from the fax monitor so fax types other than PDF can be sent.

2.35

2004-10-06

Added output type parm to the FAXCASTELE command so that users can specify HTML as the output type for a fax. This allows them to include logos and other HTML links in an outbound report.

2.34

2004-09-18

Set user's IFS authority so they can delete IFS objects correctly. There is a bug in V5R3 OS/400 that is giving the IFS owner *RWX access, but they cannot delete any temporary work files they create during processing. Added new data area ERSSETAUT. If the ERSSETAUT data area is set to *YES, we will set the IFS authority so they can delete the files correctly. If ERSSETAUT is set to *NO, default user ownership authority is assigned to all IFS files created by user applications.

2.33

2004-08-18

Changed ERSUPGC program to always update the QUSRSPLA data area to 1600 when the library is upgraded. This can prevent hard halt errors from program ERSMON001 if the QUSRSPLA value is not 1600. Changed ERSUPGC program to always do a grant object authority at the tail end of the library upgrade steps to insure that *PUBLIC users have access to the Email Report Server by default. Changed ERSMON001 to not try and check the User Defined Options offset info if a spool file happens to get deleted while processing a list of spool files from a selected outq. The following hard halt error was occurring from ERSMON001 (outq monitor) if a spool file got deleted while being processed: "The target for a numeric operation is too small to hold the result."

Added ERSEXT10C/ERSEXT10R to build process. Since these programs were not in the build, the ALTMOVE: setting added in V2.27 would not have worked until upgrading to V2.33.

2.32

2004-07-09

Created ERSSUBJPAG data area. If set to *NO the report page count will be omitted from the email subject line. This is a global setting and is either enabled or disabled.

2.31

2004-07-03

Updated ERSDUPSPL to allow a new user ID value to be set during spool file duplication *CURRENT will set the user ID to the current user ID copying the report. *SAME will set the user ID to the original spool user ID. Any existing user ID can also be specified. Also updated error handling so that CPF errors will be generated if a copy fails.

2.30

2004-06-25

Added "Reply To" address at the email recipient level.

2.29

2004-06-09

Added code to SMTP email program to insure that sockets are getting closed after an email failure. This can eventually lead to the inability for a job to send any more emails if the job gets a lot of connection failures.

2.28

2004-05-27

Minor internal change. No description available.

2.27

2004-05-21

Added data area ERSXTSEL to set the default extended selection criteria value to Y or N when entering email recipient info. Default=N Added ALTMOVE: keyword to output queue monitor to allow users to specify an alternate output queue to move a report to after processing if the *MOVE option is enabled for an output queue. This provides more granular control over the move after processing option.

2.26

2004-05-19

Added data area ERSDOMAIN. Set to user domain value: Ex: rjssoft.com. When set, the outbound message ID header will contain the users actual domain name instead of @RJSERS. Some Spam blockers look at the message ID value when scanning emails.

2.25

2004-05-19

Added ten user defined fields to the email address book so users can store custom report distribution settings in the Email/Fax Report Server address book.

2.24

2004-05-10

Added option to send Message-ID: header when sending outbound email messages. Some spam scanners look for a message ID and have problems if an email does not have a unique Message-ID: header. If data area ERSMSGID is set to *YES, message headers will be sent in the email body. If ERSMSGID = *NO, no Message-ID: headers will be included in outbound emails. ERSMSGID = *YES by default.

2.23

2004-04-19

Added ability to force upper case email addresses when entering names in the Email/Fax Address book. Created a data area named ERSUPPER to enable this setting. If ERSUPPER = 'Y', email addresses are auto converted to upper case when records are added or deleted.

Added F4 prompting to the Edit Email Recipient list to allow addresses to be looked up and selected from the Email/Fax Address book.

2.22

2004-04-19

Added CRLF to startxref line in PDF converter to resolve outstanding Blackberry issue where Blackberry users could not view PDF files generated with Email Report Server/400.

2.21

2004-04-16

Changed PDF headers from 1.2 to 1.3 for the PDF type header. Some customers were having problems with Blackberry's not liking the 1.2 header type.

2.20

2004-04-12

Added from email address to FAXCASTELE CL command. This will allow user programs to determine which Castelle account an outbound fax will be associated with.

Added fax tables and data areas to the upgrade program.

2.19

2004-04-09

Created ERSATTDATF data area to allow the date info to be formatted when the ERSATTDATE setting is enabled for the attach file names. Users can specify any of the following values to set the attachment date format as defined in the CVTDAT to date format setting: *MDY,*DMY,*YMD,*JUL,*JOB,*MDYY,*DMYY, *YYMD,*CYMD,*ISO,*USA,*EUR,*JIS,*LONGJUL Default value: *JOB

Fixed Pointer not set for location referenced error generated when ERSDEBUG was added to the MAILOUTQ command in V2.16.

2.18

2004-03-26

Fixed all PDF converter versions to calculate landscape page widths correctly. when using *COR page scaling. The landscape setting had been calculating page width as 8.5 instead of 11 which is what it should be for landscape.

2.17

2004-03-18

Changed all PDF converter versions to now use actual page length and page width when calculating size for *COR page scaling.

2.16

2004-03-16

Enabled ERSDEBUG processing for MAILOUTQ command so users can troubleshoot mail relaying problems.

Changed ERSIGCDTA data area to *NO. Data can shift by 1 character on CPYSPLF.

2.15

2004-03-03

Addes WINANSI encoding to all PDF files. This will allow PDF files to handle German or other international character sets.

2.14

2004-02-19

Fixed problem with unmonitored CPF9898 messages causing a hard halt if the MAILSPLF command fails during processing. This error was introduced in V2.10.

Updated MAILSPLF command to support either the built-in zip compression or the ASI PKZIP compression product as an alternative.

Created ERSZIP1 command to interface with ASI PKZIP compression product. Requires ASI PKZIP V4.0 or above to work with IFS.

Created ERSASIZIP & ERSZIPLIB commands for ASI PKZIP compression product setting.

Created ERSASIZIP and ERSZIPLIB data areas to handle the ASI zip settings. ERSASIZIP - contains *YES/*NO setting to enable or disable zip compression. ERSZIPLIB - contains ASI PKZIP library name.

Created ERSZIP2 command to interface with ASI PKZIP compression product. Requires ASI PKZIP V5.0 or above to work with IFS.

Created ERSZIPVER data area. If set to 4, we're using PKZIP 4.0. if 5, we're using PKZIP 5.0.

2.13

2004-02-11

Added computer output reduction (*COR) to program ERS019R to allow the PDF converter to better anticipate the lines per inch (LPI) and characters per inch (CPI) within a report.

2.12

2004-02-10

Fixed PDF converter to correctly stay in Portrait mode if a report is exactly 80 characters wide.

2.11

2004-02-06

ADDED EMRECIP5 LOGICAL FILE BY SPECIFIC SELECT

2.10

2004-01-29

Fixed MAILSPLF command. Was causing an error after successfully mailing to all users when GROUP: was used in the email address parameter.

2.09

2004-01-26

Added log option for MAILOUTQ command.

Added new message ERS1098 to handle timeout message received when sending report via MAILSPLF and the data area ERSMAILSPM is set to *YES.

2.08

2004-01-05

Added ERSIGCDTA data area. If set to *YES, the text based report converters can copy double-byte data (DBCS). If set to *NO, double-byte data cannot be included in report attachments.

2.07

2003-12-26

Added ability for the MAILSPLF command to return specific messages upon error sending an email message. If data area - ERSMAILSPM is set to *NO, a CPF9898 message is returned upon any error. If data area - ERSMAILSPM is set to *YES, messages ERS1003 - ERS1026 will be sent if an email error occurs. It is also still posssible for the CPF9898 message to be returned for various errors as well so both ERS1001-ERS1026 and CPF9898 should be monitored in user programs. Users can use the following command to view the ERSxxxx message descriptions: WRKMSGD MSGF(RJSERS/ERSMSGF),

2.06

2003-12-26

Added Table of Contents parameter to the MAILOUTQ command. If enabled, a report description is listed in the message text for each report attachment. Report descriptions are looked up in the report description table.

2.05

2003-12-23

If converting to CSV format and using embedded emil addresses, the Email Report Server monitor was not correctly selecting the report mask.

2.04

2003-11-18

Changed ERSLIST to create temporary file with *NOMAX for record count.

Added embedded fax number support via FAXTO: keyword embedded in report text or within the user defined data spool attribute.

2.03

2003-11-01

Added RJS enterprise fax output queue

2.02

2003-10-06

Added return receipt, delivery confirm and high priority request settings to MAILOUTQ command.

2.01

2003-09-23

Added return receipt, delivery confirm and high priority request settings to MAILSPLF command and Email Recipient List table.

Changed QUSRSPLA data area default from 1411 to 1600 so we pick up the user defined options correctly. Thes fields are used for overriding spool file info.

Added spool overrides to PDF converter.

Page Orientation Override values:

    • PORTRAIT = portrait page orientation
    • LANDSCAPE = landscape page orientation
  • Font Size Override (1-20)
  • Line Space Override suggested values:
    • 80 col portrait = 8
    • 132 col landscape = 7
    • 198 col landscape = 6

1.99

2003-08-27

Added 600 second timeout on SMTP connections in MAILSMTP2L and MAILSMTP8L. Changed from 30 seconds.

1.98

2003-08-07

Added 30 second timeout on SMTP connections in MAILSMTP2L and MAILSMTP8L.

If using Castelle FaxPress option, we will automatically route faxes to the RJS_FAXPRESS host name when @RJS_FAXPRESS or @rjs_faxress is found within the users email address.

1.97

2003-07-13

Updated ERS018R so that it now handles the *COR output for auto scaling. The PDF files created with ERS018R are also now re-saveable. If ERS008R is used with *COR, the PDF files could not be re-saved. The ERSPDFPGM setting must be set to ERS018R for this setting to work.

1.96

2003-07-11

Expanded ERSATTACH data area from 15 to 100. Users can now put any of the following keyword combinations in the ERSATTACH data area and the MAILSPLF and MAILOUTQ commands will build the report attachment file name prefixes based on the actual spool values that match the replacement keywords.

  • @SPOOL - Spool File Name
  • @USERDATA - Spool User Data
  • @USERID- Spool User ID
  • @JOBNAME - Spool Job Name
  • @FORMTYPE - Spool Form Type

Ex:

@SPOOL_@FORMTYPE_@USERDATA

will create a report file prefix that looks similar to the following: QSYSPRT_FRM001_USRDTA1.PDF

Added form type, user data and user defined data to the email report server log entries.

Reports that get skipped now get added to the Email Report Server log file with the OKSKIP event code.

Report description text has been expanded to have 25 lines instead of 7 in the report description table.

Fixed address book entry so that group name can be changed when a record is changed. Group name field was previously protected during change mode.

Fixed possible problem with report being marked as *SENT or processed after processing if the report was not sent to any users and GROUP: was specified to send the report to an address group from the address book.

Changed To email address PARMS to 255 characters for MAILSPLF and MAILOUTQ.

Fixed problem with MAILSPLF logging. Was logging an incorrect email address in the log if more than 1 recipient was selected. However the email was still being sent to the correct email recipient.

Added initial Castelle FaxPress integration via the FAXCASTELE command. This command can be used to fax a spool file from the AS/400. A Castelle FaxPress server and the Native Fax license must be purchased before using FAXCASTELE.

Command ERSHOSTFAX added to set Castelle TCP/IP host name. The RJS default host name will be RJS_FAXPRESS. A host table entry pointing to the FaxPress server will need to be created via the GO CFGTCP menu, Option 10.

Command ERSSETFAX added to update the RJSWRKOUTQ AND RJSWRKSPLF commands to point to the WinSpool Fax Report Server fax command or to the Castelle FaxPress command FAXCASTELE for interactive faxing of reports.

1.95

2003-07-10

Fixed Email Report Server recipient validation. Was causing errors if user updated a field in the email recipient list in change mode. The validation process was releasing the record before the record was updated.

1.94

2003-07-03

Added Y/N validation to the Email Recipient entry program to insure that when extended specific select are enabled, the right value is entered.

1.93

2003-06-08

Updated MAILSPLF command as well as the output queue monitor to allow users to embed the contents of an email message as message text within the email message. If a report conversion type of MSG is specified, the report will be sent out as embedded text within the email message.

1.92

2003-06-08

Updated ERS019R spool file converter program to correctly output the last line on the report if it is a zero spaced line. In some cases users were losing one or two values on the last line of the report when converting to PDF via the ERS019R PDF conversion program.

1.91

2003-05-12

Updated ERS005 command to handle spool files larger than 16 megs. Now we can download any size raw spool data file. ERS005 now calls program ERS0052CL instead of ERS005CL. If a user has problems, the ERS005 command can be switched back to call program ERS005CL.

1.90

2003-05-06

Changed ERSSENDID default to *NO after customer testing provided this setting resolves sender ID issues.

1.89

2003-05-06

Added setting to allow sender ID to be omitted from outbound email messages. The ERSSENDID command should be used to change the setting to *NO if users do not want a sender ID being sent as part of the outbound SMTP message. This command was added because some users were running into issues with outbound emails supposedly not being sent with a from email address. Some mail systems were misinterpreting the sender ID mail headers. Default = *YES

1.88

2003-04-26

If an output queue does not exist, the output queue monitor no longer exits. The monitor will continue running and will log an error in the error log.

If a report is still being spooled and the report is not on hold, we will no longer try to email the report until the status is no longer OPN. This would cause email error messages unnecessarily in the log file.

If data area ERSERROR is set to *YES, we will now move a report right away to output queue RJSERROR in QUSRSYS so that it does not continue to get processed. If data area ERSERROR is set to *NO, a report will continue to get mailed until it is sent or removed from the output queue.

1.87

2003-03-24

Changed PDF converter default scaling from *NONE to *COR for page scaling.

1.86

2003-01-08

Added ability to enable computer output reduction (*COR) to allow the PDF converter to better anticipate the lines per inch (LPI) and characters per inch (CPI) within a report. This setting will maximize the use of the page and will result in larger more readable font sizing on the PDF files.The following command must be run to enable computer output reduction in the PDF files: CHGCMDDFT CMD(ERS008) NEWDFT('PAGESCALE(*COR)')

1.85

2003-01-08

Fixed "Use Specific Select" option so it will correctly scan for selection criteria if only 1 row is selected for number of lines to scan option. Prior to this version 0 or at least 2 lines must be selected in order for this option to work.

1.84

2003-01-08

Changed order of MIME headers in outbound email messages. Customer installed new virus scanning software that seems to be re-ordering the From/To email address info if not found in a specific order within the email headers. This was causing some Yahoo email accounts to receive mail messages without a From address. The new header order will be: Sender ID, Mime Header, Date, Subject, From, To, Content Type. AS/400 SMTP server sends headers in the following order when SNDDST is used: <No Sender ID>, Mime Header, Date, Subject, From, To, Content Type. The ERSBASE64 data area must be set to MAILSMTP6L when using the new settings.

1.83

2002-09-30

If user defined data field contains the RPTUSER: keyword we will parse the user ID from the user defined data field and then look up the associated from email address in the address book if found.

Added ability to look up the default from address by placing *USERDEF in the from address field in the MAILSPLF and ERSMON commands. This will check for the RPTUSER: keyword in the user defined data field and if found will look up the user in the address book to determine the from email address to use.

1.82

2002-09-23

Soft coded @ sign check on MAILSPLF, so users using non-US code pages will not get errors when we check the @ sign in the email addresses.

Created ERSATSIGN command to allow users to set the appropriate @ sign value for their system.

Address Book Entry now uses the ERSATSIGN data are when validating email addresses.

Created user API to go and look up local ATSIGN values in the address book based on the selected AS/400 user ID. This command us used by MAILSPLF, MAILOUTQ and EMR104.

The CL command is: ERSUSERAT

1.81

2002-09-14

Major Change: Implemented the ability to handle up to 999999 spool file entries per AS/400 job. This is to comply with V5R1 update to allow this.

Note: If users are using any of the report server commands such as MAILSPLF, ERSNUM, ERSDUPSPL, etc. in their own programs, they will need to test their programs to make sure the programs don't need to be updated to handle the new 6 digit spool file numbers.

1.80

2002-09-02

Added initial F1 help panel implementation to selected commands.

1.79

2002-08-26

Added F4 prompting back into MAILSPLF. Somehow the choice program had been removed from the MAILSPLF command prompt.

Created user API to go and look up an email address in the address book based on the user name/desc in the address book

THE CL COMMAND IS: ERSNAMKEY

1.78

2002-08-20

Added new PDF converter program to create PDF files that allow zero spacing.

Added ability to look up the default from address by placing *RPTUSER in the from address field in the MAILSPLF and ERSMON commands

1.77

2002-07-19

If user defined data field contains the MASKNAME: OR MASKTYPE: keyword we will parse the mask name information for the email message from the user defined data field.

1.76

2002-07-16

Changed MAILSPLF to combine message data passed in with disclaimer message text to form a combined message that contains text and general disclaimer information.

1.75

2002-06-29

If user defined data field contains the SUBJECT: keyword, we will parse the subject for the email message from the user defined data field.

1.74

2002-06-26

Report monitor now only checks first five characters of the user data field when determining if a report is already *SENT. This resolves problems when a reports user data has a value appended to the *SENT value by another spool processing application other than the Email Report Server. Reports were getting selected for processing even after they were already sent because of this.

Example problem user data: '*SENT+1'

1.73

2002-06-13

Changed ERSBASE64 data area to default to using the MAILSMTP6L setting which means that when mails are sent with the MAILSPLF command a CR/LF will be sent after each line instead of just a LF. This can cause a 00020 error or data corruption errors from some mail servers. This will typically happen with the Microsoft SMTP or ESMTP service.

1.72

2002-05-27

Created MAILSPLSEL command to allow users to prompt and select email address info when interactively emailing a report.

1.71

2002-05-22

Added ERSDUPSPL command to duplicate spool entries.

1.70

2002-05-06

Changed Base64 block count from 18 to 16 in MAILSMTP5L and MAILSMTP6L. Some customers were complaining of long line errors from mail servers such as iPlanet. When this happened, no attachments were delivered. This is an experimental change.

1.69

2002-04-09

Added new PDF converter program to create PDF files that are updateable. Also added ERSPDFPGM data area to tell the email report server which PDF converter to use. If set to ERS008R, the regular PDF converter is used. If set to ERS018R, the new PDF converter will be used.

Added option to allow "Use Specific Select" to be automatically used if "Use Extended Select" is enabled and criteria is entered for the Use Specific Select.

1.68

1899-12-30

Changed outq monitor program to correctly handle the emailing of electronic forms where the user defined data field is formatted as follows: Example: EXT:PDF~MAILTO:sales@rjssoft.com It was pulling the entire string as the email address, thus causing 00019 errors.

1.67

2002-02-25

Changed ERSATTDATE default from 'report' to '*no'. This wasn't causing a problem. It was just a semantic change.

1.66

2002-02-23

If a spool file is created with an OUTPTY of '9' and the data type is *USERASCII, data will be extracted in RAW spool file format and the file extension will be extracted from the user defined data field. Example: EXT:PDF~MAILTO:test@rjssoft.com~ This option enables the Winspool/400 Electronic Forms Print Server to convert reports and send them back to an outq for mailing via Email Report Server/400.

1.65

2002-02-22

Added new option to ERSMON command. if the from email address = *OUTQ for selected OUTQ and the from email address for the queue is not blanks, set the from email address from OUTQ entry, otherwise we will use the *DEFAULT from email address setting.

Added new option to ERSMON command. if the from email address = *RECIP, use the from email address from the email recipient entry. otherwise check the output queue entry for a from email address. If both recipient and OUTQ from addresses are blank we will use the *DEFAULT from email address setting.

1.64

2002-02-21

Added ability to parse multiple MAILTO: addresses from the user defined data report attribute field if set. Example: MAILTO:addr1@domain.com;addr22@domain.com~

1.63

2002-02-18

Added ERSDOMNAM and ERSDOMNAM2 cmds. These commands allow for the import of email recipient names from the domino NAMES.NSF file. the commands create a recipient entry for the selected extended user id and output queue based on the domino short name. the domino short name must match a valid as/400 user id. Note: requires license for RJS domino API'S

Added EMRECIP3 logical file by email. Added EMRECIP4 logical file by USERDATA.

Modified edit email recipient screen to allow position to by OUTQ or email address.

1.62

2002-02-15

Added EMRECIP2 logical file by user id.

1.61

2002-02-05

Changed paragraph spacing defaults for the RTF converter. 80 char - 9pt 132 char - 8pt 198 char - 8pt

If a spool file is named "IFSDOC", the doc will be extracted in raw spool file format and the form type will become the file ext. this option enables the winspool electronic forms print server to convert reports and send them back to an OUTQ for mailing.

Implemented updated version of ERSUPGC, so data areas should not get blanked out if the data area didn't exist in the old library.

1.60

2002-01-22

Fixed command key display for edit email recipient list. It wasn't showing on screen.

Added implementation of CSV converter within the MAILSPLF command and also the outq monitor. The CSVconverter is a separately licensed option for the email report server.

Added ERSUPG command to upgrade settings to new library if installed.

1.59

2001-12-27

Changed page size from 9 to 4 in the edit email recipients screen. This resolves the problem of incorrect paging when more than one page of email addresses exists.

Added page size for *LETTER or *A4 paper to the RTF converter. Also added paragraph point spacing for 80, 132 or 198 column reports to rtf converter.

1.58

2001-12-14

Created ERSSUBJDAT data area. If set to *NO the report date will be omitted from the beginning of the subject line.

1.57

2001-12-05

We now write the from/to email address info and subject line into the joblog for tracking purposes.

1.56

2001-11-30

Added auto page scaling option to PDF converter if the page scaling parm default gets changed to *AUTO. This will auto-scale pdf file sizes based on page length/width/lpi/cpi.

1.55

2001-11-27

Added ERSDISCLAIM data area which will be used to allow users to have a hard-coded disclaimer message get sent out with each report attachment when MAILSPLFor MAILOUTQ is used. The ERSDMSG data area will hold the actual disclaimer message text. Also added cmds: ERSDISCLAIM & ERSDMSG

Added message text fields to report desc table. If message text is entered for a report desc entry, the message text is sent along with the selected report. Added ext user data, spool file and job to edit email recipient list screen.

Added ext user data, spool file and job name to Edit Email Recipient List screen.

1.54

2001-11-21

If ERSATTDATE data area value = *YES, we will add a date/timestamp to the report attachment name when mailing a report with MAILOUTQ. Example: REPORT-73001084500.pdf

1.53

2001-11-08

Implemented MAILKEY: processing for up to 20 email addresses per report. Settings for the max line count are stored in data area ERSMAILTO. If MAILKEY: is specified, the user defined email address key will be extracted from the report header and the associated email address will be located in the address book by searching based on user key. Addresses in report must be enabled for the specified output queue for this to work.

Fixed MAILOUTQ command so it will no longer return error 00099.

1.52

2001-11-01

Added secure smtp option to report server. If ERSSECURE is set to *YES, the software will use "AUTH PLAIN" security to authenticate to the remote smtp server. Our testing was done with MS Exchange, but this should also work with other smtp servers that support smtp authentication. ERSUSER is used to set smtp user/password info to authenticate to the selected smtp server. Commands created: ERSSECURE, ERSUSE

Added ERSLOGOUTQ option to direct debug logs to a selected output queue.

Added ERSAFTER option to determine whether to perform the selected after processing option on all reports or only on reports where the report was sent successfully to all recipients. *NO -Perform after processing only on reports sent successfully to all email recipients. *YES - Perform after processing on all reports, even if there were errors sending a report to one of the selected recipients.nly

Increased report subject line size from 50 to 100 characters in output queue monitor processing.

1.51

2001-10-16

Added ability to look up the default from address by placing *USERID in the from address field in the MAILSPLF and MAILOUTQ commands. *USERID is the new default for from address as well.

Created user api to go and look up an email address in the address book based on the user defined key in the address book. The CL command is: ERSUSRKEY

Created user api to go and look up an email address in the address book based on the selected as/400 user id. The cl command is: ERSUSERID

1.50

2001-10-12

Added email address lookup prompt to MAILOUTQ command.

1.49

2001-10-12

Added Email Address Book support. Email addresses can now be stored in the address book for interactive and group address emailing. If using a group email address, the format is as follows: GROUP:GROUPNAME. When a group name is selected for an email recipient. Each recipient in the group list will receive a copy of the selected report.

1.48

2001-08-07

Fixed CPYAFPPDF command to keep it from locking up when called from a java environment the RJSTIFF service program has been compiled for release V4R1 compatibility. We changed it 01 to V4R2 compatibility and it now works. Java was added to the AS/400 in V4R2.

1.47

2001-07-28

If ERSATTDATE data area value = *YES, we will add a date/timestamp to the report attachment name when mailing a report with MAILSPLF. ** Example**: report-073001084500.pdf.

Created ERSATTDATE data area and CL command these will support the ability to set a date and time in the outgoing attachment name in the MAILSPLF command.

Write an entry to the email report server log after emailing a report with the MAILSPLF CMD. The write to log setting defaults to *NO.

1.46

2001-07-09

Made a change to LPAR checking code to insure we don't get a decimal data error at stmt 227 when checking partitions.

1.45

2001-04-30

Added LPAR access code checking option.

Updated MAILSMTP2L program to correctly recognize if an SMTP server will not accept mail relaying when sending email messages. Also added a few other misc. SMTP status checks to insure a message gets correctly forwarded to the selected SMTP server.

1.44

2001-04-30

Extended ERS005 converter to handle 100-character IFS path instead of 50. The AS/400 command and CL program had not been updated from 50 to 100 the last time this was fixed.

1.43

2001-04-13

Changed MAILOUTQ and ERSLIST commands to allow report selection filter by job number.

1.42

2001-03-01

Changed all setting commands to default to *DSP instead of *SET.

1.41

2001-02-20

Changed RTF, PDF, and HTML converters to scan up to 200 lines for the longest report line during conversion.

Enabled specific report selection. This allows us to scan a text report for a select data value and if the value is found the report will get emailed to the selected RECIP. *NOTE*: when this option is used, the report will get scanned for each potential email recipient, thus this setting could cause a performance problem if used against large reports that have many email recipients.

Added ability to send a message to QSYSOPR when an error occurs sending a report via email. This will help trouble shoot potential problems by notifying the AS/400 operator upon errors. Created ERSMSGQ data area and command.

When converting AFP to PDF with command ERS0063, we will now retry the TIFF to PDF conversion up to 2 times if it fails. Sometimes the TIFF to PDF conversion fails for no reason and works the second time it's called very bizarre.

1.40

2001-02-02

Added print control character handling to MAILSPLF command for "SPL" output type.

Created MAILOUTQ command and associated programs. Does not currently support zip compression. (beta version) PGMS/CMDS: MAILOUTQ, MAILOUTQC, MAILOUTQC2, MAILOUTQC3, MAILRTNC, ERS020, ERS020C, ERS020L, ERS021R, MAILOUTQR1.

Fixed text converters so that they correctly merge zero line space info. We swapped the merge fields around because the fields were getting merged in the incorrect order. We also now write the last line of a report if it contains zero line spacing.

1.39

2001-01-25

Allow lower-case entry in the user data field in the email recipient entry program.

1.38

2001-01-02

Added new Base64 encoding program to handle the MS IIS 4.0 SMTP server on NT 4.0. This is a cloned version of MAILSMTP5L that uses CR/LF instead of LF when encoding the email messages. The NT 4.0 mail service would garble messages if the CR/LF wasn't used and a file attachment was being sent new program name: MAILSMTP6L.

Also created ERSBASE64 data area to hold the appropriate Base64 encoding program name. Options: MAILSMTP5L -or- MAILSMTP6L **NOTE**: to use MAILSMTP6L, the data area ERSBASE64 must be changed from MAILSMTP5L to MAILSMTP6L.

1.37

2000-12-28

Created command ERSLIST to list spool files from a selected OUTQ to an *OUTFILE. This is a utility command and not currently used by any of the ERS/400 programs.

1.36

2000-12-28

Spool entry length is now picked up from the user space so the 82/88 setting will not be needed. This eliminates the need for the QLISTLEN data area programs changed: ERSMON001, ERSMOV001.

1.35

2000-12-27

Changed sender ID from email address back to RJSSMTP in MAILSMTP2L. This was causing the following error only with the AS/400 SMTP server: 501 syntax error. Start domain start domain with an alphabetic character.

1.34

2000-12-22

Added ability to change default data buffer when sending emails. This may prevent lockups if a user runs into a WIERD lockup condition PGM affected: MAILSMTP2L/MAILSMTP2C.

Created ERSBUFFER data area and CL command to set the data buffer data area.

1.33

2000-12-15

Added option to not print the debug report when running debug mode - MAILSMTP2C.

Created ERSDBGPRT data area and CL command to set the data area.

Fixed ERSMON001 so that if a report gets deleted from an OUTQ while we are processing it will not kill the OUTQ monitor.

1.32

2000-12-11

Added debugging code to MAILSMTP2 to help determine mail server connection information.

Created ERSDEBUG data area and CL command to set the data area.

Created debug version of MAILSMTP2L called MAILSMTP2D.

1.31

2000-12-08

Extended ERS005 converter to handle 100 character IFS path instead of 50.

Created ERSASIZIP and ERSZIPLIB data areas to support the ASI PKZIP compression product.   

1.30

2000-12-06

We now retrieve the *DEFAULT MAILHOST from the data area if sending an email message notifying a user that their report was too large for emailing. PGM: ERSMONC4. Users would get a 0002 message when attempting to send a MSG from ERSMONC4.

1.29

2000-12-05

Added ability to pass flag settings to the PCL to PDF converter. These are set via the new ERSPCLCMD command and they are stored in the ERSPCLCMD1, 2, 3, 4 data areas.

1.28

2000-12-04

Added date MM/DD/YY format and page counter to outgoing report email subjects.

Changed MAILSPLFC to create file attachment names based on the following spool file keywords: @SPOOL, @USERDATA, @JOBNAME, @FORMTYPE. The special keyword value must be set in the ERSATTACH data area for this to take effect.

Created ERSATTACH data area to hold report attachment name prefix. Also created ERSATTACH command to set this value.

1.27

2000-12-01

Added *REL option to after processing options to release a spool file after it has been processed by report monitor.

1.26

2000-11-21

Added job/user/job number to temp file names to prevent potential work file naming conflicts.

1.25

2000-11-10

Replace { } characters with brackets when performing an RTF conversion. This prevents errors when opening an RTF report if it has an unmatched bracket in the report data reports any more.

Added new zero line spacing logic to the TXT, HTML, RTF and PDF text converter Programs. Data should not get lost on the reports any more.

1.24

2000-11-01

Added the ERSMOVOUTQ command to allow users to move selected spool files from one OUTQ to another.

1.23

2000-10-31

Added the following substitution keywords for the subject lines in an email: @SPOOL, @USERDATA, @FORMTYPE, @JOBNAME.

1.22

2000-10-30

If user defined data contains the 'subject:' keyword the email subject will be extracted from the user defined data field.

1.21

2000-10-05

Fixed NTS002 txt converter to prevent -0002 errors if a data line is blanks.

Modified MAILSMTP5L to use email address instead of "RJS SMTP mailer" text for the sender: when sending Base64 messages.

1.20

2000-09-13

Fixed ERSDATE to format dates correctly. Also re-enabled dates in MAILSMTP5L.

1.19

2000-09-13

MAILSMTP5L BASE64 file conversion now takes place in its own activation group. This was to resolve issues where ERSASCII would cause an error if run 256 times.

1.18

2000-08-24

Created ERS0062 to replace ERS0061 for TIFF conversion. ERS0062 writes output to the IFS and uses the QDLS folder only as a temp path.

Substituted command ERS0062 for ERS0061 when doing TIFF conversions with MAILSPLF. ERS0062 uses a random work file name in the work shared folder and also copies the final resulting file to an IFS path.

Created AFP to PDF command ERS0063 and also added the AFP to PDF handling to the MAILSPLF command if an *AFPDS spool file is chosen to be mailed.

Added code to move objects from TIFFLIB to library RJSERS.

Implemented RJSWRKOUTQ & RJSWRKSPLF commands. WRKMRPT command now uses RJSWRKOUTQ command.

Implemented MAILTO: processing for up to 20 email addresses per report. Settings for the max line count are stored in data area ERSMAILTO.

Created ERSEXTR, ERSEXTC and ERSPARSEC to support MAILTO: address extraction from text reports.

Created ERS010C program. It now writes host print transform conversions directly to the IFS instead of a shared folder.

Modified MAILSPLF command to check for an @ in the email address.

Changed all commands to create temp work files in the /RJSTEMP ifs directory. Created command ERSTEMP to do so.

Replaced ERS0063 with CPYAFPPDF in MAILSPLF command. PDF converter is a separate purchase item for now.

Soft coded the SMTP port number. Some customers don't use port 25.

Added ERSPORT command to set and display the ERSPORT data area.

1.17

2000-08-10

MAILSPLF command now correctly passes date info to email message.

Created ERSDATEC program.

1.16

2000-08-04

Added PCL to PDF conversion option to MAILSPLF command.2) Added ERSATR command to MAILSPLF to determine report type when PDF is chosen for data type.

1.15

2000-08-01

Fixed problem with the MAILSPLF command not correctly editing spool file numbers greater than 99. We edit the spool file numbers to remove leading zeros. This was causing errors if converting AFP reports or extracting raw spool file data.

Added ERSWORKDIR data area to library. This will be used when we start using a work directory for converting reports.  

1.14

2000-06-30

Added PRDLIB PARM to ERSNUM command.

1.13

2000-06-27

Fixed problem where line space/skipping wasn't picked up on the last record. This change was only made to NTS002 which is the ASCII text PRN converter. We will not change the other converters unless asked.

1.12

2000-06-22

Bumped SMTP send buffer to 40960. This might improve throughput.

1.11

2000-06-21

Added PRDLIB PARM to RJSERS menu.

1.10

2000-05-26

Created ZIPEXT data area and added PKZIP compression to the MAILSPLF command.

All mail in the MAILSPLF command now gets encoded as Base64 before begin sent.

Added compression FLD EM0015 to file EMOUTQ.

Added compression FLR ER0022 to file EMRECIP.

Converted RJSERS menu to use UIM.

Added ERSHOST command to set and display the MAILHOST data area.

Added ERSFROM command to set and display the FROMADDR data area.

Added ERSZIPEXT command to set and display the ZIPEXT data area.

Added *DEFAULT option to ERSMON command to retrieve default from mail ADDR from the FROMADDR data area.

Added *DEFAULT option to ERSMON command to retrieve default SMTP mail host from the MAILHOST data area.

Added *DEFAULT option to MAILSPLF command to retrieve default from mail addr from the FROMADDR data area.

Added *DEFAULT option to MAILSPLF command to retrieve default SMTP mail host from the MAILHOST data area.

Fixed problem in ERSMON001. The output queue monitor was not looking at the email recipient activation flag to determine if an email recipient is activated or deactivated.

1.09

2000-05-05

Added email address table: EMADDR and logical files EMADDR01/EMADDR02.

1.08

2000-04-20

Added mail delay parameter to MAILSPLF command.

1.07

2000-03-20

When converting to PDF, scan for '\)' and replace with '\134)' if found This should prevent errors in case of a slash and PAREND found on the right side of a report data line.

1.06

2000-03-09

Modified ERSMON001 to correctly skip reports marked *SKIPPED and to mark a report as skipped if it was skipped. Reports weren't getting marked as skipped. ERSMONC3 was also modified for this fix.

Major enhancement to add C-based base 64 encoding for TIF/PCL attachments. This should speed up conversion and prevent us from getting data corruption when binary files are sent via email.

Created program MAILSMTP5L. We also make a copy of the ERSASCII service program to handle ASCII conversion.

1.05

2000-03-03

Modified WRKMRPT to use the *NONE option on the CPYSPLF command. We ran into a customer who had changed the CPYSPLF command to *FCFC for print control characters. This was causing a problem for the work splwrk1 file used by WRKMRPT.

Enabled maximum page filtering option.

Created program ERSMONC4 to go with it for sending message skipped message.

Fixed ERSMON001 so that it correctly selected email recipients by OUTQ. It was selecting all email recipients regardless of which OUTQ they were set up for. It should now correctly select e-mail recipients when using the OUTQ monitor.

1.04

2000-02-18

Added LIBASCII service program and enhanced Base64 encoding.

1.03

2000-02-18

Added ZEROSPC PARM to ERS004 Command.

Added FROMADDR data area for the from email address default. Code has not been implemented yet.

1.02

2000-02-08

Added ERSNUM command and programs.

1.01

2000-02-07

Removed WINSPOOL library references in SPL100.


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: August 09, 2018