3.1.49
16 August 2011
- Fixed issue with a leading space in front of MAILTO: keyword when ADDRINFO: keyword is used in the user defined data.
3.1.48
29 January 2010
- Added option for sending emails via Outlook. This was a fix for Outooks security patch that was causing Outlook to prompt the user to click on allow for every email being sent out on their behalf.
3.1.47
20 May 2009
- Added process ID to IFS temp file name when downloading *USERASCII spool files. This will ensure the file name is unique and another instance will not pick it up by mistake.
3.1.46
5 September 2006
- Changed FileExists to FileExistsAPI in MapiSendMail log routines to try and troubleshoot a random "Too many files" error in the log.
- Changed some integers to longs in MapiSendMail.
3.1.45
29 August 2006
- Added trace point code to MapiSendMail log routines to try and troubleshoot a random "Too many files" error in the log.
3.1.44
2006-08-16
Fixed problem with extensions not correct when sending the report to multiple recipients but in different output formats. It seemed to send to all recipients with the same extension even though the file would open if you changed the extension to what it should have been.
Fixed problem with the embeded subject line being truncated by one character if a line terminator was not encountered like a tilde.
Fixed problem with the Specific Search Criteria not being found if it was located on the last line of the report.
3.1.43
2006-07-31
Fixed problem with To Address when getting email address from User Defined Data and using MAPI. We now trim off any remaining blank spaces so it will send properly.
3.1.42
2006-07-16
Fixed problem with extension ending up as .DAT with reports that don't have EXT: in the user defined data. This bug was introduced at V3.1.40
3.1.41
2006-07-07
Added a Recipient Log database to keep track of all sent emails. This option can be enabled in the File/Settings on the Work Files tab.
3.1.40
2006-06-23
Added the ability to retrieve the output file extension from the spool file user defined data field. If it is not specified in the user defined data then we will use the appropriate default extension depending on the output format selected. Format of user defined data will be: EXT:PDF~
3.1.39
2006-06-09
Added DataImport Macro File Name and DataImport Macro name to the Output Queue List to be able to run an Excel Macro after running the DataImport conversion. The Macro File Name should be the entire path (example: C:\Program Files\Microsoft Office\Office\XLStart\Personal.xls) and the Macro Name should be something like (example: PERSONAL.XLS!testmacro).
Added user data and user defined data values to log file.
3.1.38
2006-05-12
Fixed problem with DataImport Mask path being placed ito the Ouput format column in the Output Queue List.
3.1.37
2006-04-12
Fixed problem with multiple spool file keywords not being replaced in the Macro File Name and Macro Name fields. We now replace every instance instead of just the first keyword found.
3.1.36
2006-03-30
Changed the temp file name when downloading PDF files from an output queue.
3.1.35
2006-03-02
Added Message Text to MAILRPT command. This text will come before any other text from a defined Message Text File.
Note: The Message Text can not contain CRLF. Note: WINSPOOL library version 3.61 or above is required.
3.1.34
2006-02-17
Added ability to place the spool file keywords @SPOOL, @USERDATA, @JOBNAME, @FORMTYPE, @USERID and @DATETIME in the Macro File Name and Macro name fields. These keywords will be replaced with the associated spool file value.
3.1.33
2006-01-20
Added ability to place MAILFROM: in the user defined data field of the spool file. A tilde (~) needs to be placed at the end of the from address in order to ignore any data after the from address.
3.1.32
2006-01-09
Added DataImport Macro File Name and DataImport Macro name to the Email Recipient List to be able to run an Excel Macro after running the DataImport conversion. The Macro File Name should be the entire path (example: C:\Program Files\Microsoft Office\Office\XLStart\Personal.xls) and the Macro Name should be something like (example: PERSONAL.XLS!testmacro).
3.1.31
2005-11-23
Added a Report Description field to the Output Queue List. The Email Recipient List will override this option. This Report Description will end up being the Subject line of the outgoing email.
Moved After Processing code to it's own module.
3.1.30
2005-11-22
When the "Scan User Defined Data When MAILRPT is Enabled" setting is checked and the recipeint list is being used the user defined data field was still being scanned for the MAILTO: keyword even if the MAILRPT API was not enabled. Fixed problem so it works properly.
3.1.29
2005-11-16
When using @USERDEFINED for the Standard Attachment File Name we will not truncate it to 10 characters. We now take the entire value.
3.1.28
2005-11-15
Added the ability to use @USERDEFINED in the Standard Attach File Name. The Standard Attach File Name is used when using MAPI for sending the email. The user defined data field needs to have the keyword ATTACHNAME: followed by the desired attachment name but without the extension. The Standard Attach File Name setting should look like @USERDEFINED.SPL
3.1.27
2005-11-01
Added logging to show the TCP/IP API loading and unloading.
3.1.26
2005-10-31
Added the ability to substitue @USERID, @JOBNAME and @FORMTYPE for the first part of the Spool File Temporary Work File name.
Example: c:\wspesr32\@USERID.TMP
3.1.25
2005-10-10
Added Disclaimer Text File option to Recipient List. The option was added before but there was no place to enter it in the Recipient List.
3.1.24
2005-09-28
Added ini setting to load and unload TCP/IP API after each download pass.
3.1.23
2005-08-03
Made the Help/Contents menu go to the RJS user guide web page.
3.1.22
2005-07-06
Added functionality to send reports through Castelle SMTP gateway via SMTP. 2) Made Email Recipient field 255 characters instead of 50 characters.
3.1.21
2005-06-16
Made the availbe number of email addresses that can be used in the User Defined Data field from 10 to 20.
3.1.19
2005-05-02
Added PDF No change, PDF No Data Copy and PDF No Annotation switchs to both the output queue level and the recipient level. An encryption password must be used in order to use PDF Encryption settings with PDF files.
3.1.18
2005-04-14
Added the ability to retrieve the attachment extension from the user defined data field when the output format is set to TXT. If and extension is not found in the user defined data the original value is used. The syntax is case sensitive. (Example) EXT:CSV~
3.1.17
2005-04-12
Added the ability to disable printing when using the PDF Encryption to both the output queue level and the recipient level. The recipient level will override the output queue level and the File/Settings will override both since it is a global setting. An encryption password must be used in order to disable printing with PDF files.
3.1.16
2005-03-24
Fixed problem where PDF files being emailed from an output queue had a .dat extension instead of PDF which was in the user defined data field. This problem was introduced at version 3.1.11.
3.1.15
2005-03-08
Added the ability to allow more than 10 characters for the attachment name when using the @USERDEFINED as the attachment name. Allow Long Attach File Names has to be enabled otherwise it will only use 8 characters from the user defined data field.
3.1.14
2005-03-04
Fixed problem where it would use the same subject line for every email when using the embeded subject option.
When using @USERDEFINED for the attachment name the spool file name will be used if nothing was found in the user defined data field.
3.1.13
2005-03-01
Added @USERDEFINED to be substituted in the attachment name. In the File/Settings the Spool File Temporary Work File must be:
C:\WSPESR32\@USERDEFINED.TMP
Standard Attach File Name must be:
@USERDEFINED.SPL
The spool file user defined data will need the keyword ATTACHNAME: followed by the desired attachment name without the extension followed by a tilde "~".
3.1.12
2005-02-28
Added the ability to turn off email address validation. This allows user to put Exchange email addresses without the @ symbol in the user defined data field in order to use the Exchange address book without getting errors.
3.1.11
2005-02-18
Modified the number of characters used in the user defined data field from 150 to 255. This resolves the problem of the user defined data field being truncated when many email addresses and the subject line are placed the the user defined data field.
3.1.10
2005-02-15
Added Postscript to PDF via Adobe Distiller option. This will allow us to handle reports from companies such as Createprint. The following must be done to enable the Postscript to PDF option:
- Adobe Acrobat Distiller V4.0 or above must be loaded on the PC.
- Create data area WSPDISTILL with the following command: CRTDTAARA DTAARA(WINSPOOL/WSPDISTILL) TYPE(*CHAR) LEN(50)
- Enter the access code provided by RJS.
- Enable the "Enable Postscript to PDF via Distiller" setting.
- Use "PSC" as the output type for the output queue.
3.1.9
2005-01-18
Added setting to processes unselected reports with After Processing Option. If the After Processing option is set to Mark reports it will mark unselected reports with *SKIPPED.
3.1.8
2005-01-17
Added setting to mark unselected reports with *SKIPPED. This way large reports in the queue that aren't being emailed to a user won't continue to be downloaded when using Specific Search Criteria.
3.1.7
2004-11-05
Adjusted PDF encryption selection at the output queue level.
3.1.6
2004-11-02
Fixed problem with PDF encryption at the output queue level. Now if one output queue has PDF encryption enabled they all won't be enabled.
3.1.5
2004-10-26
Added PDF Encryption Option to Output Queue level. To encrypt a PDF, the following must occur: "PDF" must be selected for the output type at outq level or recip.
NOTE: Does not currently work with MAILRPT or embedded email addresses. Encrypt PDF must be selected along with a password on the "Edit Email Recipient List" or "Edit Output Queue List" screen.
3.1.4
2004-08-31
Added the ability to retrieve the email address and subject from the user defined data field even if ADDRINFO: is not in the user defined data field. Changed the delimeter for multiple user defined MAILTO: address from ~ to a ; It should be formatted as MAILTO:test@test.com;test2@test.com~
3.1.3
2002-07-30
Fixed problem where the Report Description field from the Recipient Table was not becomming the subject line in the email as expected. It was being ignored.
3.1.2
2004-07-30
Added the ability to place up to 10 email addresses in the user defined data field of the report. The syntax is as follows: MAILTO:test1@test.com;test2@test.com;test3@test.com~ This example will send the report to 3 recipients. The syntax to include the subject line is as follows: SUBJ:This is a test~MAILTO:test1@test.com;test2@test.com~ This example will send the report to 2 recipients with "This is a test" in the subject line.
3.1.1
2004-07-16
Added the ability to place up to 10 email addresses in the ADDRINFO;MAILTO: in the user defined data field. The email addresses need to be delimited by a "~"
3.1.0
2004-07-13
Added the ability for the email subject to be embeded in the report. The option for "Subject In Report" has to be enabled in the Output Queue List and has to be formatted in the report as follows: SUBJ: This is a test subject line~
3.0.99
2004-04-30
Removed Timelocking for EXE
3.0.98
2004-04-26
Changed the temporary IFS directory to /RJSTEMP so we aren't writing temp files to the root of the IFS.
3.0.97
2004-04-24
Added the abilty to remove the report Page Count from the subject line. In the wspesr32.ini there is a new setting "SubjectPageCount=1". It is set to 1 (enabled) by default. If the user does not want the page count in the subject line, open the file wspesr32.ini and change the SubjectPageCount=1 to SubjectPageCount=0.
3.0.96
2004-04-24
Added the abilty to use @FORMTYPE, @JOBNAME and @USERID for the Standard Attach File Name. These key words will be replaced by the appropriate spool file attribute as the Standard Attach File Name.
3.0.95
2004-04-20
Added an option to move the report if it fails to email. There is a setting are in the wspesr32.ini file. By default they are set to: MoveErrorReport=0 MoveErrorQueue = RJSERR MoveErrorLibrary = QGPL
3.0.94
2004-03-08
Fixed problem with Specific Line to Search. This way if they upgrade from an previous version that didn't have this column it won't get an error 13 since the field is null.
3.0.93
2004-03-05
Added Specific Line to Search to the email recipient list. When this column is 0 then it will use the Number of Lines to Check instead. Otherwise it will only check the one line number specified.
3.0.92
2004-03-05
Fixed problem where the Email Report Server would give a -2 error when using the ADDRINFO;MAILTO: ;SUBJ and converting to DIW format because it couldn't find the mask.
3.0.90-3.0.91
2004-03-01
Added error checking and trace point info to Lotus Notes OLE mail send logic. We should now get a real message back from the Lotus Notes Email API if sending via the Lotus Notes client fails.
3.0.89
2004-02-09
When using authenticated SMTP, we now release and reload the SMTP object before sending each email message. This insures that a fresh copy of RJSSMTPA.EXE is loaded for each outbound email message.
3.0.88
2004-01-07
Removed 20 second delay to the HTP which was added on version 3.0.83
3.0.87
2004-01-05
Enabled PCL to PDF encryption for the MAILRPT command in the WINSPOOL library so PDF files can be encrypted. Requires: RJS PDF Encryption API Update WINSPOOL library V3.56 or above
3.0.86
2003-12-30
Removed 3D buttons from main screen. This should solve problems on PC's with low video memory
3.0.85
2003-12-26
Enabled Text to PDF encryption for the MAILRPT command in the WINSPOOL library so PDF files can be encrypted. Requires: RJS PDF Encryption API Update WINSPOOL library V3.56 or above
3.0.84
2003-12-26
Changed HTML to PDF call to use a .HTM extension instead of using .DTM. This was causing HTML files to render incorrectly. It was creating PDF files that had raw HTML tags in the PDF instead of the rendered HTML.
3.0.83
2003-12-11
Added 20 second delay to the HTP conversion to accomodate large HTML reports.
3.0.82
2003-12-10
Because of the addition of handling binary reports, we need to now scan the user defined data for the specified strings within the user defined data because binary reports have EXT: at the front of the user defined data field.
Reports where there was no email address in the user defined data, however there was other info in the user defined data, we were trying to email the report, however there was not a valid email address being selected, thus causing an email error.
Tweaked the ADDRINFO; logic to scan the user defined data for the ADDRINFO; string because ADDRINFO; may not be in pos 1-9 if the user defined data starts with EXT: which means this report is priobably a binary PDF spool file.
3.0.81
2003-09-26
Added trace points 1436 and 1437 in HTP conversion. Hopefully this will show where the error 99 is happening.
3.0.80
2003-08-12
Added On Error Resume Next to timer event to hopefully prevent sporatic unhandled Error 52 problems.
3.0.79
2003-08-01
Enabled report skipped messages to be able to be sent via SMTP. This function was previously not enabled for SMTP email. Still not enabled for secure SMTP yet. Added HTP output type to allow embedded HTML reports to be converted with the RJS HTML to PDF converter. The HTML to PDF converter must first be enabled via the "Enable Embedded HTML to PDF Report Convert" option from the Settings screen. The HTML to PDF converter and Adobe Acrobat Writer V4.0 or V5.0 are also required for this option. This is a great way to generate HTML reports on the AS/400 and then convert them to PDF for mailing. Added HT1 output type to allow embedded HTML reports to be sent through the email report server as an HTML file attachment. If HT1 is selected, all spool data is downloaded and run through the TXT converter. The resulting file attachment will have a .HTM extension and will contain the raw formatted HTML from the spool file.
Note: Using embedded HTML in an AS/400 report requires some HTML knowledge. Cascading style sheets with page breaks should also be used to insure that embedded HTML prints properly.
3.0.78
2003-05-16
Fixed problem introduced in V3.0.77. If the user ID info was swapped, the report download would fail because the AS/400 spool file was created with the original user ID, not the swapped one.
3.0.77
2003-05-15
If user defined data field contains a value of SAVEUSER:, we will then look for a corresponding value to tell the email report server to switch the user ID field with the appropriate value. This allows users to use extended select on reports that were processed by the RJS Infoprint Integrator.
Valid values:
-
- FORMTYPE - Form type is swapped with user ID during report processing.
-
- USERDATA - User data is swapped with user ID during report processing.
Once user ID is swapped, the new value is used for all extended select criteria processing.
3.0.76
2003-04-08
When using regular SMTP, we now release and reload the SMTP object before sending each email message. This insures that a fresh copy of RJSSMTP.EXE is loaded for each outbound email message.
3.0.75
2002-12-08
Test changes added and removed. testing outbound SMTP email addressing issues.
3.0.74
2002-12-08
Binary report files that have a spool data type of *USERASCII and an output priority of '9' in the queue will be automatically mailed in their ASCII format. These files represent binary PC files or electronic forms that have been respooled to an output queue in their raw PC format for emailing.
3.0.73
2002-10-02
Implemented SMTP from address for outq.
Implemented SMTP from address for email recipients.
Implemented disclaimer message text file for outq.
Implemented disclaimer message text file for email recipients.
Fixed MAILRPT so the disclaimer message can be set using MAILRPT CL command. This was added in V3.0.61, but probably was not working correctly.
Disclaimer message supported in SMTP and MAPI email routines.
3.0.71-3.0.72
2002-09-25
Implemented SMTP from address for outq.
Implemented SMTP from address for email recipients.
Implemented disclaimer message text file for outq.
Implemented disclaimer message text file for email recipients.
Fixed MAILRPT so the disclaimer message can be set using MAILRPT CL command. This was added in V3.0.61, but probably was not working correctly.
Disclaimer message supported in SMTP and MAPI email routines.
3.0.70
2002-08-05
Added PDF Encryption Option to Batch Report Server.
To encrypt a PDF, the following must occur:
- "PDF" must be selected for the output type at outq level or recip. NOTE: Does not currently work with MAILRPT or embedded email addresses.
- Encrypt PDF must be selected along with a password on the "Edit Email Recipient List" screen.
Requires: RJS PDF Encryption API Update
3.0.69
2002-07-22
Implemented NotesOLESendMail2 to load and unload the Lotus Notes OLE email object after sending each mail message. Some customers have experienced Lotus Notes client lockups during mailing and this may help.
Note: This is an experimental change for now and we may revert back to leaving the object loaded if users still have Lotus Notes lockup issues.
3.0.68
2002-05-21
Added From Email Address to Output Queue List.
Note: This only works with SMTP emailing.
3.0.67
2002-05-13
Fixed DOS character replacement to not replace /,\, or : The file paths were being replaced incorrectly when @USERDATA was used for the work file path, thus causing errors.
3.0.66
2002-05-10
We now replace illegal DOS characters in work file namesif found. This should prevent problems when users get illegal DOS characters placed in the user data field for a spool file and @USERDATA is being used to generate the work file name. Users were getting "Error 52 - Bad file name or number" errors when this would happen.
If @USERDATA is being used to generate work file name,substitute spool file name for @USERDATA value if no user data found. This should prevent attachment names of @USERDATA.PDF, etc. from getting out incorrectly.
3.0.65
2002-03-22
Added INI settings to allow DataImport Report Converter to call the DataImport EXE instead of using it's DLL calls. A few people have had conversion problems when using the DataImport Report Converter DLL version. The two most prevalent problems are: On Windows 2000 with Japanese language, XLS spreadsheet conversions create a corrupted XLS file.
When using Reference Points and Line Tags in a mask, sometimes the results are inconsistent. DIWEXEPath=C:\DIW (DataImport Path) DIWUseEXE = 1 (0=Use DLL, 1=Use DataImport EXE) DIWWindowMode = 1 (Do Not Change)
3.0.64
2002-02-22
Added library list setting to allow users to add selected libraries to the WinSpool/400 job library list. This is helpful if users are going to be using AFP overlays and fonts and the libraries are not in the default user library list.
3.0.63
2002-02-20
Fixed the "Initialize DataImport Object for Each Conversion" switch setting to work correctly. If this switch is enabled, the DataImport Report Converter will be loaded and unloaded automatically after each translation is run. Apparently there is a memory buffer issue where the report converter can potentially carry over data from the first line of the previous conversion if the converter is not loaded and unloaded from memory first. This is the first time we have seen something this weird. It appears that this can happen when many reference points and line tags are used on a report. Enabling this setting should resolve the problem.
Also changed the "Initialize DataImport Object for Each Conversion" setting to default to being enabled on a new installation or when the DataImport Report Converter is initally enabled.
3.0.62
2002-02-06
Fixed the check to see if the Reform Spooler is active. We now check for a Reform window title starting with the word "Spooler" or containing "Reform Spooler". If either case is found, we assume the Reform Spooler is already active, so we do not attempt to start it.
3.0.61
2002-02-06
"Secure SMTP error 27107 Invalid parameter passed to function" error was occurring when using secure SMTP without a Email user id and password. This is because the Secure SMTP option was initially set up only to handle secure SMTP settings where a user ID and password are being passed to the SMTP server. No change has been made to the secure SMTP API yet. It will be changed to allow non-secure SMTP as well.
Added "Message Text File" parameter to the MAILRPT CL command so that text messages can be included along with the report attachments when they are sent via the MAILRPT API command. If "Message Text File" is not entered or if the selected Message Text File doesn't exist, no text message will be included.
Note: The Message Text File option will be added to the "Edit Outq Email Recipient List" screen and the "Edit Output Queue List" screens in the future.
Software updates required: -WINSPOOL library V3.42 or above
3.0.60
2001-11-28
Fixed problem with MAPI profile popping up when secure SMTP is enabled.
3.0.59
2001-11-11
Version 6.0 OCX Updates must be applied before installing this version or future versions of the Email Report Server software. The OCX updates can also be installed from the V6OCXUPD directory on the RJS October 2001 CD or later.
Added support for secure SMTP emailing. This will help customers who use MS Exchange or another secure SMTP mail server and mail relaying will not work without logging in via SMTP authentication. In order to use the secure SMTP support, the following must occur:
- Install RJS Secure SMTP Email API V1.0.1 or above.
- Enable the "Use Secure SMTP Email Server" setting on the File/Settings screen.
- Enter an email user and password on the File/Settings screen.
- Added stub support for MS Exchange CDO for future implementation of CDO emailing if needed.
Requires: RJS Secure SMTP Email API Update V1.0.1 or above
3.0.58
2001-10-04
Allow "Use Specific Selection" fields to be hidden if the user unchecks the "Allow Use Specific Search Criteria for recipients" check box on the "Work Files" tab of the "File/Settings" screen. If the specific selection settings are not visible, users cannot mistakenly enable them.
3.0.57
2001-10-03
Added new "HTX" output type to support embedded HTML for HTML text message-based reports. If "HTX" is selected, the report is converted to ASCII text with line/page breaks and then mailed as part of the body text of the email message. The email message will be sent with the "text/html" mime type so that any email programs or browsers that can render HTML will be able to view and print the HTML message. This feature allows customers to place embedded HTML into an AS/400 spool file report and have the HTML automatically delivered in an email message. This is a great way to deliver invoices, statements, etc.
Note: Currently only the RJS SMTP mail API can be used for embedded HTML conversion. MAPI, VIM or Lotus Notes OLE email are not currently supported for embedded HTML.
Requires: RJS SMTP Email API Update V1.0.14 or above
3.0.56
2001-08-16
Changed AFP to PDF and AFP to TIFF license check to user the native converter licensing as expected. Requirements: -WINSPOOL library V3.38 -Access codes for Native AFP to PDF or Native AFP to TIFF converters in library RJSCONVERT.
3.0.55
2001-08-09
Added PPP timelock processing.
3.0.54
2001-03-17
Enabled Native AFP to PDF and Native AFP to TIF converters.
- Native AFP to PDF output type is "NAP".
- Natie AFP to TIFF output type is: "NAT".
These converters currently use the same licensing as the Document Server.
- "Native AFP to TIFF Converter" setting must be enabled for TIFF.
- "Native AFP to PDF Converter" setting must be enabled for PDF.
3.0.53
2001-01-17
Enabled Native AFP to PDF and Native AFP to TIF converters.
- Native AFP to PDF output type is "NAP".
- Natie AFP to TIFF output type is: "NAT".
These converters currently use the same licensing as the Document Server.
- "Native AFP to TIFF Converter" setting must be enabled for TIFF.
- "Native AFP to PDF Converter" setting must be enabled for PDF.
3.0.52
2001-01-30
Enabled Native AFP to PDF and Native AFP to TIF converters.
- Native AFP to PDF output type is "NAP".
- Natie AFP to TIFF output type is: "NAT".
These converters currently use the same licensing as the Document Server.
- "Native AFP to TIFF Converter" setting must be enabled for TIFF.
- "Native AFP to PDF Converter" setting must be enabled for PDF.
3.0.51
2001-01-06
Added friendlier software expiration message so users know to check their AS/400 user ID/password or FTP server status when they are getting an expiration error from the software. 99% of these errors happen when a users AS/400 user ID and password has expired and needs to be changed or the AS/400 user profile has become disabled for some reason.
3.0.50
2001-01-05
When launching the REFORM software under Windows 95, the Email Report Server receiveds an Overflow error. This was resolved by changing the return code from the call from an integer to a long decimal.
3.0.49
2001-01-04
Added Amyuni Printer Name and Work File settings and removed soft coded YYYYMMDD work files. The YYYYMMDD work files are not needed since we monitor for the completion of each conversion with the Electronic Forms product.
Added additional ability to recognize a Subject or TO: email address in the user defined data. This option will only work correctly if the User Defined Data field in the AS/400 report is formatted as follows:
- ADDRINFO;SUBJ:Test Report;MAILTO:test@test.com.
In this example, the report subject will be: "Test Report". The email address will be: test@test.com. The SUBJ: or MAILTO: keyword can be omitted if the user does not wish to extract an email address or subject line from the ADDRINFO; data line for either of the values.
Example:
ADDRINFO;MAILTO:test@test.com
This example only extracts the email address.
Example:
ADDRINFO;SUBJ:Test Report
This example only extracts subject line.
MAJOR ENHANCEMENT: Carriage Returns are no longer allowed in the entry grids. This should allow the report servers to work a lot better because users can no longer inadvertently enter an invisible CR/LF on a data line, thus causing problems.
3.0.48
2000-12-20
Don't start Reform unless Reform conversion is enabled. Users were getting a "File Not Found" error preventing the Report Server from starting if Reform wasn't loaded.
3.0.47
2000-12-09
Added Reform Automatic Startup if enabled. Also added Reform EXE directory setting.
3.0.46
2000-12-04
Added "AllowHardExit" INI setting. This setting is enabled by default and can currently only be changed manually through the WSPESR32.INI file. The setting allows the program to exit without displaying a "Server is Active" dialog. This is useful if a NT server or 95/98 PC is rebooted each night because the reboot would otherwise display the "Do you want to exit?" dialog box.
Added ability to recognize a subject on the user defined data. This option will only work correctly if the User Defined Data field in the AS/400 report is formatted as follows:
ADDRINFO;SUBJ:Test Report
In this example, the report subject will be: "Test Report".
3.0.45
2000-11-10
If a Document Server downloaded file is smaller than our minimum file size, we will set the error flag for the download causing the download to fail and the report to get returned to it's original output queue and get reprocessed. We have seen at least 1 problem where a customer will get periodic downlaod failures when using Document Server. Even though a small file actually gets downloaded, the data is corrupted. This our attempt to resolve this issue.
Added switch to allow date to be turned off in the email subject line.
3.0.44
2000-11-10
Correctly log VIM32 errors numbers so we don't have to turn on the Display Error message flag.
3.0.43
2000-07-22
Correctly log VIM32 errors numbers so we don't have to turn on the Display Error message flag.
3.0.42
2000-07-22
Added Wait before and after deleting Document Server temp files. User was getting a Error 70 - Permission Denied when deleting files.
3.0.41
2000-06-22
Fixed problem introduced in V3.0.39. If @SPOOL was used for the report attachment names, the actual file name being sent was @SPOOL.TXT, @SPOOL.ZSP, etc. when the file should have been named based on the spool file name.
3.0.40
2000-05-31
Added option to send message to AS/400 system operator QSYSOPR or selected AS/400 user id if an error occurs when emailing reports with WinSpool/400 ERS.
3.0.39
2000-04-07
Added @DATETIME keyword for file attachment names. If @DATETIME is placed in the "Standard Attach File Name" field or the "Compressed Attach File Name" field the attachment will be named as follows: Eyyyymmddhhmmss.ext.
Example:
E20000407160100.PDF
This is helpful to prevent duplicate file names if users are detaching their reports from their email system.
3.0.38
2000-03-02
Added ability for Document Server to copy a file after it's been downloaded from the AS/400 instead of simply moving the file. This will help the scenario where Document Server in loaded on one data drive and the Email Report Server is loaded on a different data drive.
3.0.37
2000-03-02
Added ability to delimit MAILTO: address lines with a ~ on the right side in order to ignore additional data on the right side of the print line that doesn't belong to the MAILTO: data. Normally the user should place MAILTO: address data data on a data line with no additional data, but in some cases the user has no control over the situation such as when using report writers.
Note: Up to 10 email addresses.
3.0.36
2000-01-11
Added recipient selection logging. This will help troubleshoot in situations where incorrect recipients are getting selected.
3.0.35
1999-12-21
Completed initial implementation for allowing the user to assign an email recipient by putting a single email address into the user defined data field. The following settings must be enabled for this to work.
- Use MAILRPT API switch must be enabled for outq entry.
- "Scan User Defined Data when MAILRPT enabled" setting must be checked on the settings screen.
- An email address must be placed in the user defined data field for a report.
- The output format will be derived from the outq entry.
Requires: WinSpool AS/400 Library V3.11 or above WinSpool TCP/IP API's - V1.2.7 or above
3.0.34
1999-12-02
Completed initial implementation for the DataImport code to load/unload DIW report converter after each pass. This code was added because Norwest was having sporatic problems with the DIW Report Converter. If this doesn't resolve their problem, we may have to look at their masks to see if that might be what is causing the problem.
3.0.33
1999-12-02
Removed test message box from V3.0.32
Started on DataImport code to load/unload DIW report converter after each pass.
Added time delay option for delaying emailing for a specified number of seconds after each pass. This was added to handle an odd situation with the Novell Groupwise 5.2 mail server. If mails are sent back-to-back in some cases, the mail will get dropped by the Groupwise SMTP Server.
3.0.32
1999-11-06
Added test message box.
3.0.31
1999-11-06
Ignore files in the "OPN" status in the output queue.
Fixed problem where error number/message desc didn't get properly logged in the log. The error number was always being set to 0.
3.0.30
1999-11-01
"ONCE" parameter still wasn't working correctly. Had to add a few flag resets to the RunOnce routine so the downloading would run correctly.
3.0.29
1999-11-01
If "ONCE" parameter was passed to the program, we were always starting the MAPI Mail API even if it wasn't enabled for use. We now only start the MAPI API if none of the other mail API's are chosen.
3.0.28
1999-10-26
If AFP was chosen at the output queue level, and also at the email recipient level, download RAW AFP/IPDS spool file via TCP/IP. This allows users to email reports for use with the Client Access/400 AFP Toolbench Viewer.
3.0.27
1999-10-05
Wait specified number of seconds for file to get released before renaming the file. This will hopefully insure that the Document Server has released the print file and prevent sporatic errors during the file rename process.
3.0.26
1999-10-05
Added a switch to determine if we will use long file names when substituting @SPOOL & @USERDATA, etc.. to attach file name. The setting is called: "Allow Long Attach File Names".
3.0.25
1999-09-16
Added support for page values from AS/400 to be extracted and passed to the PDF Report Converter.
NOTE: If V1.0.15 of the PDF Report Converter is not installed, users will get an INFOWARN: message in the log when a report is converted to PDF. This message can be ignored or the user can download the PDF Report Converter V1.0.15 and install.
To use Auto Page Scaling, the "Use AS/400 Line/Char Per Inch Page Scaling" setting must be enabled in the PDF Report Converter V1.0.15 or above.
3.0.24
1999-08-12
Added a switch to be able to ignore the WSPHOLD command. and use CHGSPLFA instead when we need to return a report to its original outq if it was moved to a writer queue. In cases where customers really want reports to print they don't want the reports going on hold. WSPHOLD was designed mainly for use with AFP/IPDS reports being sent to the print writer.
3.0.23
1999-08-05
Make sure filetype gets returned to ASCII format beforegetting a list of MAILRPT recipients. This prevents apossible problem if a RAW spool file was downloaded priorto retrieving the MAILRPT Email Recipient list for the selected report.
3.0.22
1999-08-02
Fixed misspelling of "Criteria to Scan for" in email recipient list.
3.0.21
1999-07-22
Added new "MSG" output type for SMTP. If "MSG" is selected, the report is converted to ASCII text with line/page breaks and then mailed as part of the body text of the email message. Currently only the MAPI & SMTP mail versions work with this API.
Requirements: WinSpool AS/400 Library V3.11 or above WinSpool TCP/IP API's - V1.2.7 or above RJS SMTP API - V1.0.6 or above
3.0.20
1999-06-29
Log number pages emailed to log file .
3.0.19
1999-06-29
If Display Job Log is enabled, we now also create a job log for TCP/IP users when the AS/400 access code is checked. This allows us to track TCP/IP related errors
Added a new setting: "Enable Wildcard Report Description Assignment" to allow report descriptions to be assigned by entering a wildcard value instead of the actual matching User Data. Some users have situations where a partial user data value is used with significance, so the new setting will allow them to adequately assign report descriptions.
Example: Reports have user data of RPT105 & RPT106 yet the spool file name is QSYSPRT. In the report description table the entry would look like the following: Spool File: QSYSPRT User Data: RPT10
3.0.18
1999-06-09
Implemented PCL to PDF Options Setting. Requirements: WinSpool AS/400 Library V3.11 WinSpool TCP/IP API's - V1.2.7
3.0.17
1999-06-03
Added support for downloading RAW Unformatted Report files. These files can be displayed with the IBM AFP/IPDS Viewer included ith CA/400. The IBM AFP/IPDS Viewer must first be connected to Windows by associating the .AFP extension with the IBM AFP Viewer program:"C:\Program Files\IBM\Client Access\AFPViewr\ftdwinvw.exe
Added support for downloading PCL files and reformatting them as PDF files. This will allow us to handle EZ Print, Optio and other packages that create PCL output.
Requirements: WinSpool AS/400 Library V3.11 WinSpool TCP/IP API's - V1.2.7
3.0.16
1999-05-30
Added support for downloading RAW Unformatted Report files. These files can be displayed with the IBM AFP/IPDS Viewer included ith CA/400. The IBM AFP/IPDS Viewer must first be connected to Windows by associating the .AFP extension with the IBM AFP Viewer program:"C:\Program Files\IBM\Client Access\AFPViewr\ftdwinvw.exe
Added support for downloading PCL files and reformatting them as PDF files. This will allow us to handle EZ Print, Optio and other packages that create PCL output. Requirements: WinSpool AS/400 Library V3.11 WinSpool TCP/IP API's - V1.2.7
3.0.15
1999-05-21
Soft Coded the following substitution values for the report descriptions:
- @SPOOL - Spool File @USERDATA - Spool File User Data
- @JOBNAME - Spool File User Data
- @FORMTYPE - Spool File User Data
This allows users to put custom information into the email subject line based on keywords.
3.0.14
1999-05-21
When marking or moving a report to another output queue we now surround the FORMTYPE with single quotes. This will keep the CHGSPLFA command from failing when we're trying to MOVE or MARK a report after it's been sent and the form type has spaces in it. The AS/400 always requires single quotes around a value with spaces in it.
3.0.13
1999-05-18
Enabled Lotus Notes OLE Mail API Setting. In order to use this setting, the user must have the RJS Lotus Notes Mail API DLL loaded on the PC. The Lotus Notes Mail API DLL is: RJSNMAIL.DLL
If SMTP, VIM32 or Notes OLE Mail Settings are changed we insure that only one of the options is enabled at a time.
3.0.12
1999-05-12
Soft Coded the following substitution values for the mask file names:
- @SPOOL - Spool File @USERDATA - Spool File User Data
- @JOBNAME - Spool File User Data
- @FORMTYPE - Spool File User Data
This allows users to minimize the number of email recipient entries when using DataImport (DIW) or the Custom User API Options (API).
Fixed soft coding problems for the above keywords when API is selected. Only the spool file name was being substituted for the command line regardless of whether @SPOOL,@USERDATA,@JOBNAME or @FORMTYPE was used.
3.0.11
1999-04-29
If polling interval is >= 59 than we default to 59. This prevents runtime error 52 from occuring if the polling interval is 60 or greater.
Fixed unmonitored error messages in RunDownload routine so they display correct text descriptions.
Added new "MSG" output type. If "MSG" is selected, the report is converted to ASCII text with line/page breaks and then mailed as part of the body text of the email message. Currently only the MAPI mail version works with this API.
3.0.10
1999-04-10
Extract print type from report info *IPDS, *SCS, *AFPDS, etc.. This helps us determine if HPT will work when converting a report.
Native Host Print Transform now works correctly.
Requirements: WinSpool AS/400 Library V3.04 WinSpool TCP/IP API's - V1.2.3
3.0.9
1999-04-05
All maintenance screens now insure that a record has been properly updated before a screen can be exited or any additional maintenance can be done. This should prevent record errors during maintenance. The problem was most evident on the Outq/Email Recipient Maintenance screen where entries would get shifted from one output queue to another if a different record was selected without first updating the current record that was being maintained.
3.0.8
1999-03-15
Added to Custom API Command. The RJS Supplied OLE Server Sample or the user can specify a global command line for each queue which the can pass the following substitution values to: Substitution Keywords are: @MASKFILE - DataImport or DIW Mask File. @MASKOUTPUTTYPE - DataImport or DIW Mask Output Type. This will now allow us to use the same mask fields we use for DataImport to pass a mask file name to Monarch as well.
3.0.7
1999-03-01
Added additional trace points to solve problem at TracePoint 500.
3.0.6
1999-02-15
Added functionality to get FROM email address from the AS/400 MAILRPT API command if used, otherwise the default return address is used.
3.0.5
1999-02-01
Added Native Host Print Transform without using Emulator.
NOTE: This functionality does not work correctly yet.
3.0.4
1999-01-15
Added logic to convert report to TXT with line spacing before running the DIW Convert. This is optional. We can also run DIW with the PRTCTL version of the downloaded text file as long as the DataImport Mask has been created correctly to account for the Print Control Characters. Moved MAPI/VIM passwords & VIM Post Office to options tab. Removed Mail program from settings. Removed File Manager from Settings. Fixed DataImport Mask Selection problem. When selected, the mask name would come back to the output type field, thus causing an error when saving a record.
3.0.3
1999-01-06
Resolved user error getting error at TracePoint 1410. Changed the DataImport values being passed to SelectEmailRecipsFromReport so if they are NULL we convert to blanks. This error should have only been occurring when using embedded email addresses.
3.0.2
1998-12-15
Get rid of system tray icon before we exit.
3.0.1
1998-12-03
Removed DAO 2.5/3.0 Compatability Module. This was causing an ActiveX 429 Error when running on some Windows 95/NT PC's.
3.0.0
1998-11-02
Initial 32-Bit Code Conversion. Added DataImport API processing.
Added SMTP Object for Emailing. Added System Tray Icon. Moved maintenance menu options to main form. When running in System Tray, minimize hides form and the form reappears when selected or right-clicked.
Also added start/End option to right click menu. WNSPIP32.DLL now runs in-process and we can set a switch in the INI to run WNSPIPEX.EXE out-of-process if we have problems with the WinSpool/400 API. Use WSPHOLD command to return reports to original output queue. The command first holds the report on the queue and then moves it back to its original queue. TIFF Conversion currently supports AFP Conversion Only. We are using AS/400 Host Print Transform to create the TIFF's Added TIFF to PDF Conversion via Acrobat Writer (Host Print Transform Only).
Changed default extension for work file to TMP. In some cases if the temp file has a SPL extension and the output format was also SPL the work file could get inadvertantly deleted.
Implemented Custom API Command. This functionality can be called using the RJS Supplied OLE Server Sample or the user can specify a global command line for each queue which the can pass the following substitution values to:
Substitution Keywords are:
- @INPUTFILE - Input PC File
- @OUTPUTFILE - Output PC File
- @SPOOL - Spool File @USERDATA - Spool File User Data
- @JOBNAME - Spool File User Data
- @FORMTYPE - Spool File User Data Output
Queue level output format is only used with embedded email addresses. All other recipient information is keyed in the Email Recipient Table and the output format is also set at that level. Enabled MAILRPT API command.
2.1.00
1998-09-06
Completed AFP/IPDS Enabling for PCL,TIFF,PDF, AFP/IPDS Printing will initially be handle by the Lognet OnePrint Client Emulator. We will be using the GhostScript API to handle the Postscript to TIFF or PDF conversion. If the user is using Postscript, we will use the HP 5P/5MP Printer Driver. If the user wants the documents in RAW PCL format, we will use the HP Laserjet 4 Printer Driver.
Added Ability to Override Report Descriptions. A user can now assign a report description in the Email Recipient. This is handy if the Report Description Table cannot be correctly used to assign a report description.
Completed Initial AFP/IPDS Enabling AFP/IPDS Printing is handled via a LPR/LPD Print Emulator or the Lognet OnePrint Client Emulator.
2.0.10
1998-08-12
Added VIM Login/Logout to RunOnce routine.
2.0.09
1998-08-18
Problems using Specific Criteria Select. Customer has a situation where they are using REG S and REG SE as criteria. They want to be able to scan on an additional blank space after REG S so the entries can be differentiated.
2.0.08
1998-06-03
Fixed timer problem. The WaitMinutes process churns the CPU, so I removed it in favor of using the timer routine which will fire every minute and will tell us whether to continue processing. This should improve PERCEIVED CPU utilization a lot.
Fixed attachment file nameing for Lotus Notes/cc:Mail. Instead of using WSPESRV.ZSP as the ZIP file name, we will now use the gblAttachFileZipName. This will resolve a problem with Lotus Notes and cc:Mail where the .ZSP file was always ending up with the name WSPESRV.ZSP regardless of whether @SPOOL or @USERDATA was specified. This should make the zip attachment file name more consistent with the MAPI version.
2.0.07
1998-06-01
Made changes to prevent the @SPOOL replacement from causing errors.
2.0.06
1998-05-20
Enabled HTML conversion option. Report Descriptions are also being passed so the HTML has a title based on the standard Subject Line in the Email Message.
2.0.05
1998-05-20
Removed EOF check when checking for Email Addresses. This was causing addresses on the last line of the report page to get skipped if a report was less than the number of lines being scanned.
2.0.04
1998-04-17
If the Email addresses were being selected from within a report, Compression=True was always the setting, so reports would always be sent with a .ZSP extension, even if the output queue compression setting was turned off.
2.0.03
1998-03-28
If @USERDATA is specified in the work file fields, the work file name will now match the first 8 characters of the spool user data.
2.0.02
1998-03-23
Fixed problem in RunDownload2 with logging and zipping. If logging was turned off, the user wasn't receiving the reports in Zipped format even when compression was enabled.
Open log file in SHARED mode.
2.0.01
1998-02-01
Fixed minor bug when selecting report addresses from the report header. If no address entries existed for a queue, the "ReDim Preserve" in the SelectEmailRecipsFromReport() subroutine would fail because the UBound() function got an invalid index because no entries existed in the array. Added a ReDim(1) to the array after it's erased and this resolved the problem.
2.0.00
1998-02-01
Upped the version to V2.0
1.20
1998-01-10
Added consolidated Output Queue/Email Recip Entry Screen.
Removed subroutine completely RunDownload() from the code.
After processing userdata value of *SENT is now soft coded so it can be changed.
Email addresses can now be embedded directly in AS/400 reports. We check the first 150 lines of a report for the addresses. This is a software coded value in variable gblReportLinesToRead. This is a major feature improvement !!!!
Report selection can now be made on selected fields such as: Spool File Name, User Data, User ID, Form Type, Job Name This is a major feature improvement !!!!
Report can be scanned for selected criteria. If the criteria is found, the report is sent to the selectedf user(s). This will possibly eliminate user coding in reports which are not easily separated based on Spool File Name, etc..
Report selection field display can be toggled on/off for basic users, so they don't have to see the extended selection fields.
Added MAPI browsing for Email addresses.
Mail messages are now flagged with MAILOK or MAILERR in the log.
Maintenance grids now user colored text.
Removed old buttons and code in routines: cmdStartEmailServer,cmdStopEmailServer,cmdPasuseEmailServer
Added ability to use @SPOOL on the work file, so we can name the work file placed in the ZIP with the spool file name. This was done mainly for Lotus Notes users such as NBTY who are distributing reports to be unzipped and used with Monarch. In their situation, they don't want the files to overwrite when unzipped, and the spool file name will give them the PC file uniqueness they need.
Added multiple AS/400 system support.
Removed following global parameters: gblSystem, gblAS400User,gblAS400Password
Adobe Acrobat PDF file Support has been implemented.
RTF Support has been implemented.
All ZIP files now contain an extension which matches the File Type field in the output queue list.
Added a switch to omit extended job info from the subject line.
Changed WSPESRV.SPL work file to REPORT.SPL so it wouldn't inadvertently delete the WSPESRV.PDF which is part of the Email Report Server Docs. Oops..
1.19
1998-01-05
Added logging code for CHGSPLFA under TCP/IP. A sutomer is having problems with the Move to output queue option on the output queue.
Added display job log option for TCP/IP. A joblog will be created after each polling cycle.
Added a function to clear the log file after it reaches a certain size.
We have NOT implemented the PDF or RTF conversion yet.
1.18
1997-12-08
Added VIM32 support for 32-Bit Lotus Notes and cc:Mail.
Started on enabling automatic file conversion to RTF format. This requires the WinSpool/400 RTF Report Convertor to be loaded on the PC as well.
1.17
1997-10-02
If @SPOOL is specified in the work file fields, the work file name will now match the first 8 characters of the spool file name.
1.16
1997-10-02
Maintenance screens now go full screen. Also added Audit Trail Email Address to settings screen. The code for the Audit Trail Email address hasn't been implemented yet.
1.15
1997-09-02
Made a small change to RunDownload2 routine. The trace point now shows up in the error messages as well as the log file. I also made the unmonitored error message friendlier as well :-)
1.14
1997-08-25
Made changes to check for a date separator of "." in position 102 of the outq listing. It seems some foreign users use a "." as the date separator instead of the "/".
1.13
1997-07-28
Added user data to Report Description Table. Now users can select reports based on Spool File Name and User Data.
1.12
1997-07-07
Added FORM TYPE to subject line.
Major code change to add TCP/IP support to software.
1.11
1997-07-07
On First Pass, Run before going into Wait State. People setting the timer for 60 minutes cannot run the software until the timer condition is met.
1.10
1997-07-07
Enabled 32-Bit Router Support. Simply made 32-Bit router switch visible.
NOTE: We need the 32-Bit OLE Server WSP32OLE.EXE in order to use 32-Bit support. This is currently shipped as part of WinSpool/400.
1.09
1997-05-19
Added 32-bit router support to Email Report Server. The 32-bit router field is currently invisible.
1.08
1997-05-19
Rearranged settings screen and made bigger.
Added entry fields for: Attachfile Name, Attached Zip File, and 32-Bit Router Usage. The ability to change the report file names was paramount because some users ran into extension comflicts with other programs.
The 32-bit router field is currently invisible.
Fixed database maintenance so records update when OK is clicked and a record hasn't been saved.
Added error handling code when checking for database existence and the database doesn't exist.
Added ZIP File Compression options to Email Report Server. Password protection is handled at the Output Queue level or the Recipient Level.
1.07
1997-04-11
Soft coded the attachment file name so the user can change the "attachfile" INI setting to set the actual file attachment name. If this INI setting is left blank, the Email Report Server will change it to AS400RPT.SPL.
Added switch for alternate subject line where the date is displayed before the subject line in the Email message.
1.06
1997-02-01
Added Email User/Password Automation to Email Startup. We encrypt the password with the crypt() function. (This doesn't work right with MS Exchange.)
Added confirmation message switches to settings.
Created Email Report Server Maintenance: WSPEMNT.
1.05
1996-12-24
Soft coded file numbers in RunDownload routine. This was causing problems.
1.04
1996-11-21
Added trace points to RunDownload code. They will give us better error tracking in the log file. I also added the FreeFile command to the log file number retrieval code in the RunDownload code.
1.03
1996-11-13
Removed timelock and added AS/400 security checking.
1.02
1996-06-14
Added the following settings options:
- Log messages.
- Truncate blanks spaces.
- Log file name.
These new options will help minimize download file size and will help to spot problems when running in production mode.
1.01
1996-05-21
Changed Email address parsing routine so it looks for a "~" instead of a comma because customers such as Mosler use a comma as part of the Email address and the email parsing routine was chopping the Email recipient name in half.
