2.0.171
29 March 2010
- Fixed issue with removing file extension when output file name contains a period.
2.0.170
24 March 2009
- Enabled PCL output type to work correctly when the AFP/IPDS to PCL format is enabled and the WinSpool AFP to PCL Converter is licenses and PCL is selected for the output type. Reports are run through Host Print Transform and transformed based on the Manufacturer Type and Model setting on File/Settings/AFP-IPDS Tab.
2.0.169
9 October 2007
Fixed issue with temporary downloaded spool file being copied to the destination path instead of the converted file when using PSC as the output format.
2.0.168
2006-09-21
Added ability to specify @YEAR, @MONTH and @DAY in the Output Directory path. These keywords will be substituted with the Year, Month and Day values from the spool file.
2.0.166
2006-04-14
Made the file name contained in the compressed file the actual output file name specified by the user instead of just naming it REPORT and the extension.
2.0.165
2006-04-12
Fixed problem with multiple spool file keywords not being replaced in the Macro File Name and Macro Name fields properly.
2.0.164
2006-04-11
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.
2.0.163
2006-03-03
Fixed problem with the Mark option for the After Processing wasn't placing the formtype value in single quotes.
2.0.162
2006-02-24
Added .ini setting to enable or disable the creation of the output directory if it doesn't already exist. The default will create the directory.
2.0.161
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.
2.0.160
2006-02-15
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~
2.0.159
2006-01-23
Fixed problem if the user does not place a space between semicolons when using IMGSERVER: or WEBDOCS: in the user defined data field of the spool file.
2.0.158
2006-01-05
Added DataImport Macro File Name and DataImport Macro name to the Output Directory List to be able to run an Excel Macro after running the DataImport conversion. 2) Fixed problem if an error is returned when converting report to DataImport output format we didn't move on to the next report.
2.0.157
2005-12-08
Added additional logging information for FileNet.
2.0.156
2005-12-07
If spool file download failed, we will bypass any conversion processing and jump to the end of the outq read loop. We were getting odd results. When a spool file download failed because it was open, we didn't check GetSpoolRtn, so we would still try to process the last created temp report file even though the download failed.
2.0.155
2005-12-02
Fixed problem with the Move option for the After Processing wasn't placing the formtype value in single quotes.
2.0.154
2005-11-15
Added the ability to extract the Output File Prefix from the user defined data when using the ATTACHNAME: keyword. We will use what is following the keyword as the Output File Prefix. The file name can not have an extension. Example: ATTACHNAME:FILENAME~
2.0.153
2005-11-15
Added ability to write index file for WebDocs for iSeries if the IMGSERVER: keyword is found in user defined data field. Following substitute keywords can be used to set keys based on info in User Defined data field in AS/400 report:
- @USERDEFTITLE - Doc Title From User Defined Data
- @USERDEFDOCTYPE - Doc Type From User Defined Data
- @USERDEFKEY1 - User defined key
- @USERDEFKEY2 - User defined key
- @USERDEFKEY3 - User defined key
- @USERDEFKEY4 - User defined key
- @USERDEFKEY5 - User defined key
- @USERDEFKEY6 - User defined key
- @USERDEFKEY7 - User defined key
- @USERDEFKEY8 - User defined key
- @USERDEFKEY9 - User defined key
- @USERDEFKEY10 - User defined key
The user defined data needs to be formated as:
IMGSERVER:Doc itle;Index1;Index2;Index3;Index4;Index5;Index6;Index7;Index8;Index9;Index 10;Doc Type;
2.0.152
2005-10-18
Added the ability to place multiple email addresses delimited by semi-colons in the Notification Email Address field in the Table Entry/Edit Output Directory List.
We now delete the temporary work files at start and the end of the download pass.
2.0.151
2005-10-03
Ignore files in the "OPN" status in the output queue.
2.0.150
2005-08-31
Added After Processing option to the Output Directory Level.
Moved the After Processing option code to their own routine.
2.0.149
2005-08-17
Fixed problem with ADF, NAT, NAP and PSC output format where the temporary work file was ending up in the destination location with the correct extension instead of the actual converted report.
2.0.148
2005-08-03
Made the Help/Contents menu go to the RJS user guide web page.
2.0.147
2005-07-07
Moved the DataImport conversion to it's own routine.
Moved the AFP to TIF conversion to it's own routine.
Moved the AFP to PDF conversion to it's own routine.
Moved the RTF conversion to it's own routine.
Made the Exchange Report Server functional.
2.0.146
2005-06-02
Added more available parms when creating ImageRight Indexes
2.0.145
2005-05-20
Fixed problem if the Output Queue level PDF Password was Null. Now we replace it with blank.
2.0.144
2005-05-16
Updated FTP fields to the Output Directory database if they didn't already exist.
2.0.143
2005-05-05
Updated the INX creation so it doesn't wait for another cover page report before creating the INX file.
2.0.142
2005-04-22
Updated the spacing of the Drawer and DocType for ImageRight in the .inx file.
2.0.141
2005-04-22
Implemented misc PDF encryption settings at the Output Queue and Output Directory levels. These settings will only work when PDF encryption is enabled for a selected recipient.
- Disable PDF Prining - If enabled, PDF's cannot be printed from Acrobat.
- Disable PDF Changes - If enabled, PDF's cannot be changed/saved from Acrobat.
- Disable PDF Data Copy - If enabled, PDF data cannot be copied from Acrobat.
- Disable PDF Annotations - If enabled, annotations cannot be added to PDF's.
2.0.139
2005-03-03
Added return code parm to PDF conversion routine to pass error codes back to main processing.
2.0.138
2005-03-01
Removed server license checking.
2.0.135
2005-02-10
Added ability to name output files using the User Defined Data field of the report. This way the file can be imported and indexed into Image Right using the file name. The following settings must be set:
- UseFileNameForImageRight=1 in the wspbch32.ini file.
- User Defined Data field syntax:
IMGRIGHT:index1;index2;index3
- Keywords @IR1 through @IR20 can be used in the Output File Prefix in the Output Directory List.
Made the Output File Prefix field in the Output Directory List a max of 255 characters.
2.0.134
2005-02-04
Added additional error logging before copying file to final destination directory.
2.0.133
2005-01-20
Added ability to send email notification when report download fails.
2.0.132
2004-12-17
Fixed problem where the report would still be processed with the After Processing option even if the report was not downloaded due to a file lock.
2.0.131
2004-11-30
Fixed problem intoduced at version 2.0.130 where the downloaded PDF file will not open and says it is corrupt.
2.0.130
2004-11-29
If the destination file is currently in use the file will not be overwritten and the process will move onto the next report without stopping.
2.0.125
2004-08-03
Added the ability to specify @USERDEFINED for the Output File Prefix however, the Output Directory path and the User Data field can not be more than 255 characters which is the path length limit for Windows. If we find illegal DOS characters we will replace them with thealue in the File/Settings on the Work Files tab.
2.0.124
2004-07-30
Added the ability to pass the parameter STARTMIN to start and minimize the product.
2.0.123
2004-07-21
Added ability to send the FTP location in the Email Notification. This way the correct FTP path will be sent to the recipient. The prefix of the FTP path is set in the Settings on the Email Notification tab.
2.0.122
2004-07-15
Added ability to retrieve indexes for ImageRight from the User Defined Data field. The line has to start with IMGRIGHT:
2.0.121
2004-06-22
Fixed a problem with writing to the wspindex file if not sending to Notes, sending to FTP or Imaging.
2.0.120
2004-05-19
Fixed scan/replace to replace field 5 not 1 when extracting field data from user defined data.
2.0.119
2004-05-19
Added ability to write index file for WebDocs if the WEBDOCS: keyword is found in user defined data field.
Following substitue keywords can be used to set keys based on info in User Defined data field in AS/400 report:
- @USERDEFTITLE - Doc Title From User Defined Data
- @USERDEFDOCTYPE - Doc Type From User Defined Data
- @USERDEFKEY1 - User defined key
- @USERDEFKEY2 - User defined key
- @USERDEFKEY3 - User defined key
- @USERDEFKEY4 - User defined key
- @USERDEFKEY5 - User defined key
- @USERDEFKEY6 - User defined key
- @USERDEFKEY7 - User defined key
- @USERDEFKEY8 - User defined key
- @USERDEFKEY9 - User defined key
- @USERDEFKEY10 - User defined key
2.0.118
2004-03-23
Added ability to write index file for RJS Document Imaging. This will create a file with the same name as the converted report only it will have a .rdx extension. This file will contain the following:
[DocSettings]
DocFile= 'The output file name of the converted report'
DocFolder= 'The specified RJS Imaging folder path'
DocType= 'The specified RJS Imaging document type'
DocTitle= 'The specified RJS Imaging document title'
DocIndex01= 'The specified RJS Imaging index 1'
DocIndex02= 'The specified RJS Imaging index 2'
DocIndex03= 'The specified RJS Imaging index 3'
DocIndex04= 'The specified RJS Imaging index 4'
DocIndex05= 'The specified RJS Imaging index 5'
DocIndex06= 'The specified RJS Imaging index 6'
DocIndex07= 'The specified RJS Imaging index 7'
DocIndex08= 'The specified RJS Imaging index 8'
DocIndex09= 'The specified RJS Imaging index 9'
DocIndex10= 'The specified RJS Imaging index 10'
This file can be viewed with Notepad
2.0.117
2004-03-10
Soft Coded the following substitution values for the report descriptions:
- @SPOOL - Spool File Name
- @USERDATA - Spool File User Data
- @JOBNAME - Spool File Job Name
- @FORMTYPE - Spool File Form Type
- @USERID - Spool File User ID
- @DATE - Spool File Date
- @TIME - Spool File Time
2.0.116
2004-02-26
Added ability to create output directory if it doesn't already exist. They can use a drive letter or a UNC path. You can also use keywords (@SPOOL,@FORMTYPE, etc.)
2.0.115
2003-12-19
Binary report files that have a spool data type of *USERASCII and an output priority of '9' in the queue will be automatically captured in their ASCII format. These files represent binary PC files or electronic forms that have been re-spooled to an output queue in their raw PC format for archiving.
2.0.114
2003-12-02
Updated RunDownloadMult routine to prevent an Unmonitored Error if the report conversion process fails.
2.0.113
2003-11-02
When "No file extensions on output files" setting is enabled, file prefixes are no longer converted to upper case. Original case settings are preserved.
2.0.112
2003-11-02
When "No file extensions on output files" setting is enabled, file prefixes with dots "." in them would be incorrectly truncated when the first dot was encountered. Logic was changed to check file name from right to left instead of left to right to correctly extract the entire file prefix.
2.0.111
2003-10-02
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.
Removed some old code for 16 bit downloads from the RunDownload Routine to make room for2.0.111 changes.
2.0.110
2003-09-25
ImageRight Index Files now don't get renamed from .TXT to .INX until the FZZENDPGP spool file is found. This will help keep policy reports together for Jewelers. Removed "C" before policy group number.
2.0.109
2003-09-15
Fixed use specific select so it does not skip reports if the scan data is on the last line of the report.
2.0.108
2003-09-14
Added ability to set the zip file passwords at the output directory level if compression is enabled for an output queue. Added Image Resave for the ImageRight custom index output option. Jewelers Mutual needed to resave TIFF images created with the AFP to TIFF converter at 200 DPI. ** Note: Requires Image Resave ActiveX EXE and also Eastman Imaging Pro to work.
2.0.107
2003-08-29
When using Wildcards with starts with "Ex:TST*", all reports were being selected.
2.0.103
2003-06-30
Added On Error Resume Next to timer event to hopefully prevent sporatic unhandled Error 52 problems.
2.0.95-2.0.102
2003-06-09
Various troubleshooting items for setting ImageRight Indexes.
2.0.94
2003-03-26
Removed code at trace point 17411. Was trying to add user defined data field to access database when ODBC index waqs enabled, thus causing the following error: 3020 - Update or CancelUpdate without AddNew or Edit.
2.0.91
2003-02-28
Added user defined data index field. This is for customers who use the Web Report Server to set filter criteria by User Defined Data. We also capture user defined data in WSPINDEX.MDB as well. The first time this version runs, the user defined data gets added to the report archive catalog table.
Note: This may take a little while if a customer has an existing index and the file is large.
2.0.90
2002-12-24
Added ability to send generic email message from Batch Report Server instead of sending a specific one after reports have been delivered.
2.0.89
2002-10-02
Fixed output directory browse button and mask browse button in the "Edit Output Directory List" screen.
2.0.88
2002-10-02
Implemented misc global PDF encryption settings. These settings will only work when PDF encryption is enabled for a selected recipient. PDF No print switch - If enabled, PDF's cannot be printed from Acrobat. PDF No change switch - If enabled, PDF's cannot be changed/saved from Acrobat. PDF No copy switch - If enabled, PDF data cannot be copied from Acrobat. PDF No annotations switch - If enabled, annotations cannot be added to PDF's.
2.0.87
2002-08-23
Added ImageRight custom index coding.
Note: If customer needs this functionality it is a chargable consulting item to use.
2.0.86
2002-08-23
Soft coded mask names to allow special keywords:
- @SPOOL = Spool File
- @JOBNAME = Spool Job Name
- @USERID = Spool User ID
- @USERDATA = Spool User Data
- @FORMTYPE = Spool Form Type
- @DATE = Spool Date
- @TIME = Spool Time
2.0.85
2002-08-23
Fixed report descriptions. The report desc was not showing in the report link email subject line if set in "Edit Output Directory List" screen.
Note: Removed additional APPC code because of procedure size limits.
2.0.84
2002-08-18
Added ability to email report notification to selected email address. If enabled, an email containing the file path is mailed.
NOTE: Only regular SMTP mailing has been enabled for this option. The following settings must also be enabled:
- Email Document Links to Reports
- Use SMTP Email Server
Requires: RJSSMTP Email API must be installed on PC
2.0.83
2002-08-05
Added "Lotus Notes Form" field to "Edit Output Directory Entry" screen. The field can be left blank or set to "Archived Document" to use the default Lotus Notes Form when sending a report to Lotus Notes, otherwise if a user customizes the Lotus Notes Report Server database, they can change the form name to match any form changes they have made.
2.0.82
2002-07-12
Added passive FTP setting when sending to remote FTP location.
Note: Started removing APPC code. Netsoft no longer supported.
Requires: WinSpool/400 TCP/IP API Update V3.xx.x, otherwise sending to remote FTP location may lock if passive FTP is required.
2.0.81
2002-07-12
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.
- Encrypt PDF must be selected along with a password on the "Edit Output Directory List" screen.
Requires: RJS PDF Encryption API Update
2.0.80
2002-06-12
Use specific selection enabled for output directory selection. A text sctring can be scanned for in the report header to determine the output directory entry for a report.
- The "Enable Use Specific Select" setting must be enabled on the settings screen for this to work.
- The specific selection criteria must be entered in the "Edit Output Directory List" screen.
2.0.79
2002-05-24
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)
Requires: DataImport Report Converter V1.0.3 or above
2.0.78
2002-05-16
Added pulldown option for output file prefix.
2.0.77
2002-05-02
Added "PS2" output type for companies that are using CreatePrint software for creating electronic forms. See instructions in V2.0.58 for enablement instructions. Additionally, the text converter program C:\WINSPL32\RFORMAT1.EXE must be run and the following option enabled in the File/Settings screen to allow zero line spaces in the *SCS Postscript spool files to be handled correctly. Enable - "Treat zero space lines as single spaced"
2.0.76
2002-05-02
Debug line added to display file names in log.
2.0.75
2002-02-28
We now add a log message when an index record is added to SQL Server.
2.0.74
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.
2.0.73
2002-02-14
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.
2.0.72
2001-11-17
Added initial SQL Server Report Archive catalog implementation coding to allow report index information to be stored in a SQL server database for use with the Web Report Server. This solves a potential limitation problem when using the MS Access report archive catalog database to store report index entries. A few customers found that MS Access had a limitation of 40 complex criteria within the report access table.
To use the MS SQL Server option:
- MS SQL Server User must have MS SQL Server 7.0 or MSDE 7.0 loaded on PC.
- An ODBC data source must be created to point to the SQL server.
- The ODBC data source should be named: WSPINDEX
- The WSPINDEX SQL database must be created on the SQL Server using the options in the File/Settings/SQL Server Tab.
- Batch Report Server Setup Change
- ODBCSettings INI setting in WSPBCH32.INI = 1 (This enables the File/Settings/SQL Server Tab to be seen)
- Enable the "Enable SQL Server Report Archive Catalog" setting under File/Settings/SQL Server Tab.
- Enter the SQL Server DSN, Database and User ID/Password. If using MSDE, the default settings should work fine.
Settings:
- Specify a SQL Server Data Source name (DSN). Default: WSPINDEX
- Specify a SQL Server database name. Default: WSPINDEX
- Specify a SQL Server User ID. Default: sa
- Specify a SQL Server Password. Default: <blank>
Added project reference to DAO objects Version 3.51 to support the DAO workspaces used to support ODBC access to SQL Server databases. Shortened descriptions for tabs on the settings screen to accomodate the new SQl Server tab.
2.0.71
2001-10-13
Added initial MS Exchange Report Server implementation coding to allow reports to be stored in MS Exchange Public Folders. The initial implementation supports up to 3 folder levels.The folder format must be as follows:
Folder1/Folder2/Folder3
Note: The "All Public Folders" root level folder is already implied in the folder path.
To use the MS Exchange Report Server option:
- MS Outlook Setup User must have MS Outlook 97 or above loaded on PC.
- A MS Exchange settings profile must be created for the user.
- A MS Exchange Public Folder must be created via the MS Outlook "View/Folder List" menu option.
- The user must have authority to add to the public folder.
- Batch Report Server Setup Install "MS Exchange Report Server" on PC.
- Enable the "Enable Send to MS Exchange Report Server" setting under File/Settings.
- In "Edit Output Directory List" screen, change following settings: Enable "Output to MS Exchange" check box.
- Specify a MS Exchange Profile for login via MS Outlook.
- Specify the MS Exchange Public Folder to send reports to.
2.0.70
2001-10-13
Customers can now specify "PRN" for output type. This is handy for Monarch users who want to archive reports with the "PRN" file extension. Version 6.0 OCX Updates must be applied before installing this version or future versions of the Batch Report Server software. The OCX updates can also be installed from the V6OCXUPD directory on the RJS October 2001 CD or later.
2.0.69
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.
2.0.68
2001-08-09
Fixed exit icon for new buttons. It was a stoplight.
2.0.67
2001-07-20
Fixed exit icon for new buttons. It was a stoplight.
2.0.66
2001-06-30
Fixed exit icon for new buttons. It was a stoplight.
2.0.65
2001-06-30
Added caption setting to allow a unique caption to be displayed for each running report server instance.
2.0.64
2001-03-17
Added Reform Backup Directory clear setting. If this setting is filled in we will automatically clear the C:\WSPEFORM\BACKUPS directory prior to downloading each "FRM" report. REFORM automatically creates a backup of each file and this can cause the users hard disk to fill up.
Added nicer browse folder setting for selecting the output PC directory.
Replaced 3D buttons on main screen with built-in VB buttons. A few customers were reporting odd behavior with the 3D buttons. Usually this can be caused by an odd video card.
2.0.63
2001-03-02
Fixed logic implemented in V2.0.62. The logic was flawed when sending the User Defined Data subject to the Lotus Notes document title. If the user defined data was *NONE, we were setting it in the Domino Document Title.
2.0.62
2001-03-01
Added ability to recognize a document title based 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 title will be: "Test Report".
2.0.61
2001-03-01
Enabled Native AFP to PDF and Native AFP to TIF converters.
- Native AFP to PDF output type is: "NAP".
- Native AFP to TIF 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.
2.0.60
2001-01-30
Enabled Native AFP to PDF and Native AFP to TIF converters.
- Native AFP to PDF output type is: "NAP".
- Native AFP to TIF 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.
2.0.59
2001-01-16
Added optional parameter 4 to the command line to allow selection by output queue name. If an outq name is passed, only that selected output queue will be processed during download processing.
Example Command Line:
C:\WSPBCH32\WSPBCH32.EXE ONCE SAMPLES
This example runs the Batch Report Server process one time and selects only reports from outq SAMPLES.
Added the ability for "Extended Report Selections" to accept wildcard values instead of hard-coded single values if the "Allow Wildcards for Extended Report Select" setting is enabled.
- Example Spool File Name: QSYSPRT
- Comparison value: QSYSPRT (Exact Match)
- Comparison value: QSYS* (Starts With)
- Comparison value: *QSYS* (Contains Selected Value)
2.0.58
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.
Major Enhancement Added ability to send a report file to a remote FTP location instead of sending to a local directory location. This update requires the following additional updates:
- WinSpool/400 TCP/IP Updated 1.2.18 or above.
- The new Batch Report Server Database WSPBCH3C.MDB.
Major Enhancement 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.
2.0.57
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.
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.
2.0.56
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.
2.0.55
2000-12-09
Added settings to replace illegal DOS characters in the user data field if found. This could prevent file names from getting created correctly if an invalid character is found in the user data field and the user data is used to set file name prefixes.
2.0.54
2000-12-04
Insure work file exists before attempting to copy. This will avoid file not found errors if Document Server download failed.
2.0.53
2000-12-04
Insure work file exists before attempting to copy. This will avoid file not found errors if Document Server download failed.
2.0.51
2000-08-01
Insure work file exists before attempting to copy. This will avoid file not found errors if Document Server download failed.
2.0.50
2000-07-31
Fixed comparison logic from 2.0.49 that caused this not to work correctly.
2.0.49
2000-07-31
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 download failures when using Document Server. Even though a small file actually gets downloaded, the data is corrupted. This is our attempt to resolve this issue.
2.0.48
2000-07-13
Added Wait after deleting Document Server temp files. User was getting an Error 70 - Permission Denied when deleting files. 2)Also added a spacer between each report download in the log file.
2.0.47
2000-07-06
Added extension counter formatting to allow customers to use short extensions in file names. New Settings are "Max Counter Value" and "Counter Format".
2.0.46
2000-07-06
Added Wait before deleting Document Server temp files. User was getting a Error 70 - Permission Denied when deleting files.
2.0.45
2000-05-20
Added FileNet Index Output setting. If the user places index info in the reports User Defined Data Field, we extract the info and create a text output file that matches the output file name with a .FNA extension. Each index value is delimited by a # character and up to 20 index values can be specified for a single user defined data field.
Example user defined data:
111111#222222#333333 gets converted to: 111111 222222 333333
FileNet reads index info sequentially from the index file. Each field is considered an individual index value.
2.0.44
2000-05-20
Added flag setting to allow users to create output files without file extensions.
2.0.43
2000-03-06
If user field 1 info is passed in, and the word PDFOPENINFO is found in the user 1 text, we will attempt to run the option to Set PDF Start Page and Zoom Level with Adobe Acrobat Exchange 4.0. This option will only work with PC's that are running Adobe Acrobat Exchange 4.0. This routine also requires a dedicated PC for operation because it uses SendKeys for some of the operations.
Sample User 1 Field:
PDFOPENINFO;3;150 (Keyword, Start Page, Zoom Factor)
This sample would start the PDF display at page 3 and set the zoom level to 150% for the PDF file.
NOTE: This option assumes that you are creating PDF's with the RJS PDF Report Converter configured to use with the Acrobat Exchange PDF writer. You will also need to install the RJS Acrobat Exchange ActiveX EXE program RJSACR32.EXE to use this.
2.0.42
2000-02-02
Added a new switch called:"Allow Multiple Destinations for Each Report". If this setting is enabled, the user can enter multiple destinations/mask criteria in the "Outq/Directory List" for a single report to be processed. When the report gets downloaded it can be processed to any of the selected locations without being limited to 1 destination directory. We duplicated the RunDownload routine and called it RunDownloadMult. This way we preserve all existing logic.
Prerequisites for using:
- The user will have to replace the Batch Report Server database with the WSPBCH3B.MDB file. This MDB has no new fields, but the index key on the database was changed to use the ID field, thus allowing multiple entries in the "Outq/Directory List" table for a single report.
- The user must enable the "Allow Multiple Destinations for Each Report" setting on the Settings screen.
NOTE: The Use Extended Criteria entries must be used when sending to more than 1 destination directory, otherwise reports will not get processed correctly because the Catch All entries will get eliminated from the list.
NOTE: When specifying the same report going to the same directory, the user MUST use a different report prefix to avoid report files from being overlayed inadvertently.
Fixed process so Excel messages don't get created unless an Excel macro is actually processed after running through DataImport.
2.0.41
2000-01-17
Page rotation wasn't working correctly. SetAS400PageSettingsPDF was in the wrong spot.
2.0.40
2000-01-17
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.
2.0.38-2.0.39
1999-11-06
Fixed problem where error number/message desc didn't get properly logged in the log. The error number was always being set to 0.
Added flag for using the WinSock Remote Command option when running AS/400 commands. This hopefully will help with odd user timeouts when an AS/400 command takes more than 10 minutes to run. This is a workaround for a problem with the Catalyst FTP Control timing out when waiting more than 10 minutes for a RCMD to complete.
Added Additional trace point code in RunDownload routine.
Added reset Database Path for data controls on main form and refresh the controls to see if this resolves sporadic 3043/3044 Errors. Requirements: WinSpool TCP/IP API's - V1.2.11
2.0.36-2.0.37
1999-12-28
If the Report Description is entered in the Edit Output Directory List screen we will also pass userfield1 & userfield2 to the Lotus Notes Report Server database.
2.0.35
1999-12-28
When job name is entered for Extended Report Selection we also now check the program name that created the spool file as well.
2.0.34
1999-11-22
When running the ExtractReportHeader code, the last line of the report was being cut off at EOF. Modified the End of File check to resolve this problem.
2.0.33
1999-10-29
If running Excel Macro, minimize BRS main window.
If column headings in grids are clicked, resort the grid based on the columns.
Added DataImport Mask Name Select on Edit Output Directory List.
2.0.32
1999-10-20
If Macro File Name and Macro Name was passed, check for the macro file existence.
2.0.31
1999-10-11
Improved message logging during Macro handling.
2.0.30
1999-10-11
Added MS Excel Macro Handling for DataImport users to be able to run an Excel Macro after running the DataImport Conversion.
2.0.29
1999-08-29
Added a flag to allow Host Print Transformation to be used for all reports in a queue whether they are AFP/IPDS or not. This allows customers who want to always convert to PCL format for printing to do so. This setting would be most applicable to a print service bureau.
2.0.28
1999-07-07
Enabled report description filtering using the following combinations of data values: Spool File Name/User Data Spool File User Data Job Name Form Type User ID The report filters are checked in the priority order listed above.
2.0.27
1999-07-03
If file extensions are disabled and an existing report file is found we now rename the existing file before overwriting it. The name is formatted as follows: Original File Name & - YYYY-MM-DD-HHMMSS & File Extension This should eliminate the possibility of overlaying existing reports if a duplicate is encountered when file extensions are disabled. The "Rename duplicate files" setting is enabled by default.
2.0.26
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.
2.0.25
1999-06-09
Implemented PCL to PDF Options Setting.
Users can now tell the Batch Report Server to not use file counters. WARNING: When file counters aren't used, the substitution keywords should be used for the File Prefix or the Extended Criteria should be used for report selection because duplicate file names will be automatically overwritten.
2.0.24
1999-06-08
Added support for downloading RAW Unformatted Report files. These files can be displayed with 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 PC output. Requirements: WinSpool AS/400 Library V3.11 WinSpool TCP/IP API's V1.2.7
2.0.23
1999-06-03
Added support for downloading RAW Unformatted Report files. These files can be displayed with 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 PC output. Requirements: WinSpool AS/400 Library V3.11 WinSpool TCP/IP API's V1.2.7
2.0.22
1999-06-02
Fixed problem with running Batch Report Server ONCE from the command line. We now set Appropriate Startup Flags to avoid the "Server Stopped During Processing" message at Trace Point 500 Requirements: Current Version of WSPBCH32.MDB - Same as V2.0.20 WinSpool AS/400 Library V3.10 WinSpool TCP/IP API's - V1.2.6
2.0.21
1999-05-30
Completed initial Document Server integration for AFP/IPDS printing. Requirements: Current version of WSPBCH32.MDB - Same as V2.0.20 WinSpool AS/400 Library V3.10 WinSpool TCP/IP API's - V1.2.6
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.
2.0.20
1999-05-22
Completed User Filtering for the Web Report Server. We filter on the following: SPOOLFILE, USERDATA, FORMTYPE, USERID, JOBNAME The User Access Table now has 2 new fields, so the user will be required to update to the following versions in order to use the new filtering:
Current version of WSPBCH32.MDB We added a few new fields to the User Access Table for the Web Report Server. The MDB update only affects Web Report Server users.
Web Report Server V1.0.3 3 Batch Report Server V2.0.20
2.0.19
1999-05-21
Changed Lotus Notes Report Server to Log the entire error message instead of just the error number. This will give us better visibility to Lotus Notes issues.
Started initial implementation of User Filtering for the web report server.
2.0.17
1999-05-19
If the User Field 2 data is entered in the output directory list with the following format we will extract the data info from a report heading and place the info into the Lotus Notes Report Date field. This allows users to extract date info from a report and assign the info to the report date. Format: DATE;Pagenum,PageLine,BegColumn,EndColumn Example: DATE;2;8;1;6 This example extracts the date from Page 2, Line 8, Columns: 1-6
NOTE: We do not verify the accuracy of the date info. This must be tested by the user. Lotus Notes WILL accept invalid date info without causing an error.
The extended text description must have at least 1 blank space or the following error could occur when downloading AFP/IPDS reports: Unmonitored error 3315 Field 'AS/400 Report Archive Catalog Table.Spool_ExtTextDesc Can't be a zero-length sting. Trace Point: 7500
2.0.16
1999-04-29
If polling interval is >= 59 than we default to 59. This prevents runtime error 52 from occurring if the polling interval is 60 or greater.
Changed all occurrences of DirExists to DirExists2. This prevents a work file of Z15:24, 21 September 2007 (Central Daylight Time)~~.ZZZ from getting created in the directory, thus causing problems for some user based directory monitoring processes.
Fixed unmonitored error messages in RunDownload routine so they display correct text descriptions.
2.0.15
1999-04-16
If an FTP output PC directory is entered we will copy the file to the AS/400 via FTP instead of using a regular directory copy. A regular directory will contain a backslash "\". An FTP directory will contain a foreward slash"/".
NOTE: The destination FTP directory has to currently be on the same AS/400 system as the reports being downloaded. Also, only Non-Zipped files will work with FTP currently.
If using the TCP/IP API and extracting the User Defined Data from a spool file, we will populate User 1 Field in the Lotus Notes Database with User Defined Data values from the spool file. If Notes is not used then this value will be placed into the Report Catalog Index in the Extended Text Desc Field which also holds the scanned report header info.
Requires: WinSpool AS/400 library - V3.05 WinSpool TCP/IP API's - V1.2.4
2.0.14
1999-04-15
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 as long as the following are loaded: WinSpool AS/400 library - V3.04 WinSpool TCP/IP API's - V1.2.3
Fixed drop down box for System Name on the Edit Output Queue List Screen.
2.0.13
1999-04-14
Full extended report select is now displayed on Edit Output Directory List.
Added "Allow Delete" option to Users Screen. This option controls deleting reports by user from the Web Report Server.
2.0.12
1999-04-12
Full extended report select is now displayed on Edit Output Directory List.
Added "Allow Delete" option to Users Screen. This option controls deleting reports by user from the Web Report Server.
2.0.11
1999-04-12
Added SPL to output type list on Output Queue List screen.
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.
2.0.10
1999-04-04
We can now use the User1 field on the Output Directory List screen to pass a comma delimited list of parameters to the RFORMAT1.EXE Text to TXT conversion utility shipped with WinSpool/400. The available parms are as follows:
- Printer Escape Sequence in hex mode (0A0D)
- Include page breaks (Y/N)
- Convert Hex Escape Sequence to ASCII (Y/N)
- Omit Number of Lines at Beginning of File (0-xx)
Requirements: RFORMAT1.EXE - V1.11
2.0.09
1999-04-03
We can now use the User1 field on the Output Directory List screen to pass a comma delimited list of parameters to the RFORMAT1.EXE Text to TXT conversion utility shipped with WinSpool/400. The available parms are as follows:
- Printer Escape Sequence in hex mode (0A0D)
- Include page breaks (Y/N)
- Convert Hex Escape Sequence to ASCII (Y/N)
- Omit Number of Lines at Beginning of File (0-xx)
Requirements: RFORMAT1.EXE - V1.11
2.0.08
1999-04-02
Parse the report description field to see if any user information was entered. This change was requested by a user to allow them to place user information into the Lotus Notes Database User 1 & User 2 fields.
2.0.07
1999-04-01
Added logic to convert a 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.
2.0.06 BETA
1999-02-20
Fixed century data problem with audit trail. Date was formatted as follows: 03/01/9919
2.0.05 BETA
1999-02-20
Moved maintenance menu options to main form.
When running in System Tray, minimize hides the 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).
Make sure system tray icon goes away before we exit.
2.0.04 BETA
1999-01-20
Added 1 second wait on DoEvents.
If year is 60-99, century is 1900 for TCP/IP Dates. If year is 00-59, century is 2000 for TCP/IP Dates.
Added System Tray Icon.
Replace file and directory name substitution keywords with appropriate spool values. @DATE = Spool File Data YYYYMMDD @TIME = Spool File Time HHMMSS
2.0.03 BETA
1999-01-18
We now trim the Lotus Notes Database name, attach file name, and server name so we do not get error 7027 when trying to write to a local notes database.
Added function GetOutputPCFileEx3. This is a modification of GetOutputPCFileEx2. The report file extension counter on the catch all record no longer gets incremented unless a file is actually sent using the catch all entry. Had to add a field to the Output Directory List Table called: ID. This field is used to quickly update the counter to the output directory entries without needing to know the composite key.
When running GetOutputPCFileEx3 to get the output directory entries, we now check for existing output files and flag an error if an output file already exist in the output directory with the selected PC file name. This will prevent overwriting files if users do not set up the selection criteria correctly.
2.0.02 BETA
1999-01-15
We now trim the Lotus Notes Database name, attach file name, and server name so we do not get error 7027 when trying to write to a local notes database.
Added function GetOutputPCFileEx3. This is a modification of GetOutputPCFileEx2. The report file extension counter on the catch all record no longer gets incremented unless a file is actually sent using the catch all entry. Had to add a field to the Output Directory List Table called: ID. This field is used to quickly update the counter to the output directory entries without needing to know the composite key.
When running GetOutputPCFileEx3 to get the output directory entries, we now check for existing output files and flag an error if an output file already exist in the output directory with the selected PC file name. This will prevent overwriting files if users do not set up the selection criteria correctly.
2.0.01 BETA
1999-01-12
Changed Extended Criteria Selection logic as follows: Added function GetOutputPCFileEx2. If a report is specifically set up with extended criteria, the extended criteria will be used to determine whether a report gets selected. If no selection is found and a catch all entry exists, the catch all entry will be used as the destination directory entry. If duplicate output directories are selected, an error is still flagged. Later we will add a switch to allow a report to be sent to more than 1 directory during processing.
2.0.00 BETA
1999-01-10
Initial conversion to 32-bit coding. Major internal processing changes to support the 32-bit VB 5.0 and also selective criteria.
1.15
1998-09-28
Fixed international date format problem. Added a date format field to facilitate international date formats of DMY or YMD.
1.14
1998-05-18
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.
1.13
1997-12-01
Added Web URL Field. This will allow us to tie into the Intranet/Internet Report Server to place all selected links on the specified Web Site. This will not be activated until the Intranet Report Server is released.
Added Extract Report Header fields and code. This will allow us to determine whether to extract the report header and place it into the Extended Report Description field.
1.12
1997-12-01
Removed multiple instance check. Some customers may want to run multiple instances of the program on the same machine.
1.11
1997-09-18
Added trace point error checking to the RunDownload routine. This should help pinpoint user errors which could be occurring during downloading of reports.
1.10
1997-09-18
Added trace point error checking to the RunDownload routine. This should help pinpoint user errors which could be occurring during downloading of reports.
1.09
1997-08-25
Added trace point error checking to the RunDownload routine. This should help pinpoint user errors which could be occurring during downloading of reports.
1.08
1997-08-25
Major code change to add TCP/IP support to software.
1.07
1997-07-07
Major code change to add TCP/IP support to software.
1.06
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.05
1997-05-27
Tweaked the 32-bit support so it's ready for TCP/IP implementation
1.04
1997-05-12
Added User Data selection to Report Descriptions table entry. Report Descriptions can now be assigned based on spool file/*DEFAULT User Data or Spool file/Selected User Data combinations.
1.03
1997-04-23
Added output catalog table to MS Access database. As reports are downloaded, a record is written to the Archive database.
Also re-enabled the report description menu.
Added archive maintenance to settings screen.
Enabled password protected ZIP compression for report downloads. It is set at the output queue level.
1.02
1997-04-16
Added output catalog table to MS Access database. As reports are downloaded, a record is written to the Archive database.
Also re-enabled the report description menu.
Added archive maintenance to settings screen.
Enabled password protected ZIP compression for report downloads. It is set at the output queue level.
1.01
1996-11-13
Created Batch Report Download program from WSPESRV.
1.00
1996-10-23
Created Batch Report Download program from WSPESRV.
