Revision History for WinSpool/400 Electronic Forms Print Server

 

1.0.96

28 January 2011

1. Fixed issue with prompting for printer.
2. If prompt for printer is enabled and printer is specified, the report will print, but if a printer isn't specified then you'll be prompted
3. Changed default path for SPOOLER directory to use the SPOOLER path in the settings. The default has been changed to use the application folder
4. Changed default value for Print Copies to 1

1.0.95

2 August 2010

1. Fixed issue with upload return variable not being reset for all reports after an error occurs.

1.0.94

2 August 2010

1. Fixed issue with report not printing. Issue was introduced in version 1.0.92.

1.0.93

21 July 2010

1. If re-spooling processed forms and user sets copies to 0, the re-spooling was failing because of 0 copies being passed to the WSPLASCII command.

1.0.92

2 June 2009

1. Added the ability for prompting for a printer.

1.0.91

1 April 2009

1. 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~

1.0.90

1 April 2009

1. Added settings for "Use File Extension Counters" and "Rename Duplicate Files"

1.0.89

26 February 2008

Fixed probelm with the After Processing option of Move. The report would not get moved if the "Edit Form Print Output Directory List" entry was specified to use the "Use Output Queue Level Entry" option.

1.0.88

30 January 2008

Added addtional error notifications to be sent to "Error Email Address" if "Send Email on Error Reports" is enabled.

1.0.87

18 October 2007

Fixed problem with when the option "Log message to log file" was turned off, the application would fail.

1.0.86

2007-09-05

Added .ini setting EnableFileSizeMin. If set to 1 then the output file size will be checked against the FileSizeMin setting. If set to 0 the output file size will not be checked.

1.0.85

2007-05-31

Fixed problem with file counters not being added to output file names even if enabled.

1.0.84

2007-04-13

Fixed problem with addlitional forms not being uploaded with the correct HLD status

1.0.83

2006-12-26

User was getting Error 53 at tracepoint 350 when using the Peernet 7.0 TIFF Printer Driver. Apparently the Formdocs processing would finish and move on to re-spooling, however the actual report.tif file hadn't actually been created by the Windows printing subsystem yet. We had even enabled all the settings from the RJS KB article: "FormDocs: Converting to TIF via the Peernet TIFF IMage Printer 7.0 Driver" Most importantly the "Print directly to printer seting" should be enabled. We also sdded the "Seconds to wait before re-spooling" setting to force the print server to wait XX number of seconds before re-spooling a report to an iSeries output queue after being converted to TIFF with the Peernet TIFF Driver. This allows the Windows print spooler subsystem time to finish the print to TIFF processing and create the TIFF file. It seems that 2-3 seconds is adequate to complete TIFF printer processing.

1.0.82

2006-12-21

Fixed problem with print copies ending up as 0 when using Reform.

1.0.81

2006-12-18

Added ability to send email when Print Server is started and stopped.

1.0.80

2006-11-17

Fixed problem with reports not being respooled. Bug introduced at V1.0.79

Fixed problem when users have same Specific Search Criteria but different Extended Criteria. Now they won't get an error stating there are more than 1 destination.

1.0.79

2006-10-30

Added the ability to extract multiple FAXTO: lines from the report and place in the User Defined Data field of the uploaded file.

Added WebDocsQueue and WebDocsQueueLib settings to the .ini file. If these have values then we will extract the IMGSERVER keyword from the User Defined Data and upload directly to the queue specified in the WebDocsQueue parameter without any other info in the User Defined Data.

Added UploadIndividually setting to the .ini file. If this is set to 1 then we will extract the MAILTO and FAXTO information from the spool file and upload one copy of the spool file for each of the found recipients with no other info in the User Defined Data.

1.0.78

2006-10-16

Added the ability to extract FAXTO: information and place in the User Defined Data field of the uploaded file.

1.0.77

2006-10-13

Added User Defined Data value to be put into log file before uploading.

1.0.76

2006-09-22

Added Max Pages option in the Output Queue List. This will allow the user to limit the size of processed reports using the page count.

1.0.75

2006-09-06

Added more error message boxes to be displayed when Display Error Messages is turned on.

1.0.74

2006-09-01

Fixed problem with 0 byte temp files. We not test for 0 byte temp files before uploading so that it doesn't do the After Processing to the report.

1.0.73

2006-08-25

Added ability to output to a directory with .rdx files for WebDocs import. 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

Added an Output File Name field to the Edit Print Output Directory List so the user can either specify the output name or use the spool file atributes and a combination.

Added the ability to specify the spool file form type when upload back to an output queue. This is done by entering it into the Swap Form Type field of the Edit Print Output Directory List.

Renamed the field which specifies the form name to say Form Name.

Added a pull down box to the Print Copies field in the Edit Print Output Directory List. If the user selects the option of Spool File Copies Value or places -1 in the field we will use the spool file attribute Copies.

1.0.72

2006-08-24

Added ability to prompt for passwords and open .FDD files that are password protected. **NOTE: Requires RJSFormMerge.exe V1.0.11

1.0.70

2006-06-26

Added .ini setting to allow the user to set the minimum file size. This will ensure files below the specified size will not be uploaded. The .ini setting is in bytes.

1.0.69

2006-06-05

Fixed issue if not using embeded email addresses but have the MAILTO in the user defined data we were adding an extra MAILTO to the user defined data when we uploaded.

Removed extra tilde after the EXT: in the user defined data.

1.0.68

2006-05-10

Added ability to read multiple MAILTO lines in the spool file.

Added the ability to change the number of lines we scan for MAILTO. The default is 60.

1.0.67

2006-05-04

Fixed problem with After Processing being performed even if Additional Forms fail.

Fixed logic so error messages are logged when FormDocs is reloaded.

1.0.66

2006-04-06

Added TIF output format for use with printer driver.

Added PrintToFile .ini setting. This is for use with TIF output format if the TIF printer driver requires the output path and file name to be set in the printer driver itself instead of the Print Server passing it. The Output File Path must be the Print Server application path and the file name must be REPORT.TIF.

1.0.65

2006-03-24

Moved the report counter to the Start Button click so it gets initialized properly.

1.0.64

2006-03-24

Added ability to reload the FormDocs Filler after a specified number of reports or if an error occurs dusing the FormDocs conversion. If 0 is specified for the number of reports to process before reloading FormDocs, we will not reload it unless there is an error during conversion.

1.0.62

2005-11-23

Added error email notification capability.

1.0.61

2005-10-13

Added a trace point for trouble shooting FDC conversion.

1.0.60

2005-10-12

Fixed problem with data shifting up one line when spooling back to an output queue.

1.0.59

2005-10-03

Removed the use of machnm1.exe. A few customers were having some licensing issues.

1.0.58

2005-09-29

Removed the ability to run multiple instances of the Print Server. This is to prevent errors from each instance bumping into each other on program calls.

1.0.57

2005-09-28

Added the ability to add SUBJ: before the reports original user defined data value if an embeded subject is found in the report. This way the user can use an embeded subject line.

1.0.56

2005-09-14

If spool file download failed, we will bypass any conversion processing and jump to the end of the outq read loop.

1.0.55

2005-08-31

Added the ability to accept NULL for the Output Directory/After Processing Option. If the user doesn't fill in the After Processing Option in the Output Directory List then it will assume we are using the Output Queue List entry value.

1.0.54

2005-08-22

Added ini setting UseSignleQuotesOnUpload. If enabled the form type will be enclosed in single quotes so if the user has a dash in the form type of the original report the upload won't fail.

1.0.53

2005-08-03

Added the ability to copy file to a network or IFS directory.

1.0.52

2005-08-03

Made the Help/Contents menu go to the RJS user guide web page.

1.0.51

2005-08-02

Made the FormDocs Designer launchable from the Print Server if FormDocs is enabled in the settings.

1.0.50

2005-07-20

Added multiple copies to be used with FormDocs.

Added additional forms 2,3 and 4 to be used with FormDocs.

Removed un-needed conversion routines to make room for more code.

1.0.49

2005-07-13

Fixed problem when the new After Processing Option is added to the .MDB file. There was a problem because one of the new fields was defined as double.

1.0.48

2005-07-12

Moved UpdateDatabase routine from main form to wspeform1 module where the other update database was located.

1.0.47

2005-07-08

Adjusted Shut Down Time code to correctly shut down.

1.0.46

2005-07-05

Added After Processing option to the Output Directory Level.

1.0.45

2005-06-16

Added PSC Output Format for respooling to an output queue.

1.0.44

2005-06-15

Added spool file page count to log file.

1.0.43

2005-06-15

Enabled code for Shutdown Time in the settings. If a valid time other than 00:00 is entered then the Print Server will complete it's pass, wait the specified wait time and then shut down. If they stop and restart the Print Server it will shut down again at the same time the following day. This time is using a 24 hour clock.

1.0.42

2002-05-06

Added setting to enable the FormDocs Filler. This way it will only be loaded at startup instead of each conversion. This will resolve the FormDocs Filler splash screen from apearing during each conversion. Requires RJSFormMerge.EXE version 1.0.4 or above.

1.0.41

2005-03-13

Changed call to Rformat.exe when using FDC output format. Even if the user has set the Rformat utility to Omit CR/LF, our new function call will toggle the CR/LF setting so the merge processes correctly.

1.0.38

2005-01-06

Added a tilde between the MAILTO address and the original userdefined data.

1.0.24

2003-03-23

Added SingleInstance switch to INI. 0 = Multiple instances allowed 1 = Single instance allowed

1.0.23

2003-03-21

Added switch to disable Reform start message when only respooling reports converted by WinSpool Postscript to PDF converter. Simply make sure the "Enable Reform Report Conversion" setting is not checked. We now make sure that remote commands are converted from ASCII/EBCDIC before running after downloading a *USERASCII report such as a Postscript file created by CreatePrint. Otherwise an error message box with a bunch of @@@@@@@@@@@@ characters was popping up when converting from Postscript to PDF and re-spooling the PDF file to the AS/400.

1.0.22

2002-11-05

Added ability to swap user data value with any of the following when re-spooling to AS/400. This will allow Batch Report Server, Email Report Server or other products to filter on the new values set by the user. This setting can be found on the "Edit Form Print Output Directory List" screen as "Swap User Data"

Available swap values:

• @NONE - No changes to user data will be made when respooling.
• @FORMTYPE - Form Type will be set in user data.
• @JOBNAME - Job Name will be set in user data.
• @SPOOL - Spool File Name will be set in user data.
• @USERDATA - User Data will be set in user data. Same as @NONE
• @USERID - User ID will be set in user data.

Added ability to swap form type data value with any of the following when re-spooling to AS/400. This will allow Batch Report Server, Email Report Server or other products to filter on the new values set by the user. This setting can be found on the "Edit Form Print Output Directory List" screen as "Swap Form Type" Available swap values:

• @NONE - No changes to form type will be made when respooling.
• @FORMTYPE - Form Type will be set in form type. Same as @NONE
• @JOBNAME - Job Name will be set in form type.
• @SPOOL - Spool File Name will be set in form type.
• @USERDATA - User Data will be set in form type.
• @USERID - User ID will be set in form type.

Added ability to hold or release spool file for printing when re-spooling to AS/400.

Note: "Enable 1024 bye AS/400 command lines" must be enabled on the File/Settings screen and the WINSPOOL library and TCP/IP must be updated as listed below. Added ability to save spool file after printing when re-spooling to AS/400. "Enable 1024 bye AS/400 command lines" must be enabled on the File/Settings screen and the WINSPOOL library and TCP/IP must be updated as listed below.

• AS/400: WINSPOOL library V3.46 or above.
• PC: RJS TCP/IP API Update V1.2.28 or above.

1.0.21

2002-10-05

Soft coded database location for database field update when adding new fields.

1.0.20

2002-10-05

If spool file, user data, user defined data, form type or job name contains a single quote (') it will be replaced with a double quote to prevent errors when respooling to the AS/400. User can now specify number of copies when re-spooling and this will set the copies parameter on the newly created spool file when a report is spooled back to the AS/400 for printing. Requirements: AS/400: WINSPOOL library V3.46 or above. PC: RJS TCP/IP API Update V1.2.27 or above.

1.0.18-1.0.19

2002-08-28

If spooling back to outq, we will now copy the final format PDF or PCL file to C:\WSPEFORM\REPORT.DBG for debugging purposes. Customers have had problems with files supposedly getting corrupted when sent back to an AS/400 outq. This will help us prove or disprove whether there is a problem.

1.0.17

2002-07-26

If use data contains *SENT, reports will not get processed. Some customers were changing *SENT values to *SENT+1, *SENT01, etc. from their own applications, thus causing the print server to reprocess and reprint forms. Now we scan for *SENT in the user data. If *SENT is anywhere in the user data, a report will not get processed.

1.0.16

2002-07-08

If use data contains *SENT, reports will not get processed. Some customers were changing *SENT values to *SENT+1, *SENT01, etc. from their own applications, thus causing the print server to reprocess and reprint forms. Now we scan for *SENT in the user data. If *SENT is anywhere in the user data, a report will not get processed.

Added ability to use the following report prefixes for electronic forms when sending back to AS/400 outq. The functionality was not working as expected. Reports were only getting selected by spool file name. @SPOOL - Spool File Name @USERDATA - User Data @FORMTYPE - Form Type @JOBNAME - Job Name If any of these special values is used to name a report going to the spooler, the corresponding information from the AS/400 has to match the value of an existing electronic form definition.

1.0.15

2002-07-02

The print server can now handle sending command lines longer than 255 characters when spooling reports back to AS/400 output queues. The limit has been raised to the FTP maximum length of 1024 bytes per command called. The "Enable 1024 byte AS/400 command lines" setting must be enabled and the following updates must first be applied to the AS/400 and PC:

• AS/400: WINSPOOL library V3.46 or above.
• PC: RJS TCP/IP API Update V1.2.25 or above.

1.0.14

2002-07-01

The print server can now handle sending PCL files back to the AS/400 so the PCL can be converted for emailing or printed via an AS/400 attached HP LaserJet printer.

The following steps must be done to accomplish sending a PCL report back to an AS/400 output queue after form overlay processing:

• Create a new Windows printer driver using the same print driver as the HP LaserJet or other laser printer that is connected to the AS/400. (Example: HP LaserJet 4000)
• When creating the new printer driver settings in Windows, set up the driver to print to a "local port" named C:\WSPEFORM\WSPEFORM.AMU. Note: This name is critical to the PCL option working correctly with the Reform Spooler.
• Set up the Reform page settings for the selected Reform Electronic Form overlay to print to the new printer driver. Each form that will be sent back to an AS/400 output queue must have the printer set to this printer.
• In the "Edit Print Output Directory List" screen, set the output type to "PCL". If left blank, the output type will default to "PDF". If output type left blank for send to output queue, "PDF" will be assumed.

1.0.13

2002-02-21

Enabled additional form settings for each entry This will allow a customer to create additional copies of a document printed to another printer or to different trays in the same printer to simulate carbon copies.

Example: Customer wants to print original copy, pink copy and yellow copy of an invoice from different printer trays. The additional form entries are made on the "Edit Output Directory List screen. The field names are Aditional Form 2, 3, 4

Note: When using these settings, the extended output selection should be used so only the selected form is processed with this entry.

Example: Select only where spool file = INVOICE

1.0.10-1.0.12

2002-02-21

Fixes to support sending back to outq

1.0.9

2002-02-21

Enabled Reform Conversion to PDF and added ability to spool back to an AS/400 output queue if the "Spool to output queue setting is enabled in the "Edit Print Output Directory List" screen. "FRM" must be selected as the output type and also the "Enable Reform Report Conversion" setting must be enabled as well. This enables Reform electronic forms to be respooled to the AS/400 after conversion to PDF. The reports can then be emailed via Email Report Server/400 V1.63 or above.

Note: The PC must also have a version of the Adobe Acrobat PDF writer loaded in order for this to work. Adobe Acrobat can be purchased from Adobe Systems.

Enabled Postscript Conversion to PDF and added ability to spool back to an AS/400 output queue if the "Spool to output queue setting is enabled in the "Edit Print Output Directory List" screen. "PSC" must be selected as the output type and also the "Enable Postscript to PDF via Distiller" setting must be enabled as well. This enables support for postscript reports created by CreatePrint to be respooled to the AS/400 after conversion to PDF. The reports can then be emailed via Email Report Server/400 V1.63 or above.

Note: The PC must also have a version of the Adobe Acrobat Distiller loaded in order for this to work. Adobe Acrobat can be purchased from Adobe Systems.

Requirements: WINSPOOL library V3.42 or above. RJS TCP/IP API Update V1.0.20 or above. Email Report Server/400 V1.63 or above.

1.0.8

2001-12-28

Added ability to send multiple copies to spooler. This is done on the "Edit Print Output Directory List" screen.

When "FRM" is selected as output type it no longer changes to "TXT", although both "TXT and "FRM" output types will automatically send to the Reform spooler.

Added "PSC" output type, but not implemented yet.

Added new fields to "Edit Print Output Directory List" to support sending reports back to an output queue after processing. The processing to handle this has not been implemented yet.

Added ability to use the following report prefixes for electronic forms:

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

If any of these special values is used to name a report going to the spooler, the corresponding information from the AS/400 has to match the value of an existing electronic form definition.

Example: If the job name is RPT100 and @JOBNAME is selected for the report file prefix, there must also be an electronic form definition named RPT100.FOM created for the form designer.

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.

1.0.7

2001-10-31

Ignore files in the "OPN" status in the output queue.

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.

1.0.6

2001-10-31

Set the "After Processing Option" based on the screen selection made.

1.0.5

2000-11-28

Created Electronic Form Server program from WinSpool Batch Report Server V2.0.48. This program ties into the Reform print engine to create printed electronic forms.

1.0.0

2000-08-03

Created Electronic Form Server program from WinSpool Batch Report Server V2.0.48. This program ties into the Reform print engine to create printed electronic forms.