20 May 2009
20 April 2009
20 February 2009
Added Send to Monarch Translate output format option. This output format will work with *SCS reports and PDF reports from an output queue.
If an WINSPOOL.SHR file is created in the same directory as the WINSP400.EXE program file, the program will create a separate INI file for each Windows network user ID in the program directory and all temp files will also be written separately for each user. This will allow the program to be run in shared mode on a network.
Made the default skin to be winaqua.skn instead of b-studio.skn.
Changed append option so it does not increment the file counter until after it has downloaded all selected files.
Added Pasive FTP option to the File/Settings menu
Added Send to RJS Text Layer Designer output format
Added *LINE to preview support
Removed text wrapping when Previewing.
Fixed problem with the stacking of pages for Electronic Forms Designer. It will now use the AS/400 report page length for the basis for the number of lines instead of using the *PRTCTL characters.
Fixed problem with the resizing of the Report Preview form.
Added a Stack Pages option when converting to Eforms. This option will allow multiple pages to be combined into one page for bringing into the Eforms Desinger.
Added a Preview option. This will allow the user to right-click on a report and select Preview. This will open the report as a temp file in a new window.
Added two new INI settings:
enablerefresh - Allow refresh button to be used for outq list. enablepulldownprotect - Don't allow output queue names to be manually entered in the rtv outq list.
removed UCase$ on the txtUserID and txtPassword. This is no longer needed with OS400 V5R2
Added the Postscript to PDF Conversion output type. If they select this option they will need to have the full version of Adobe Acrobat with the Acrobat Distiller installed.
Changed the default paths to "DataImport Report Translate Cmd", "Default DataImport Mask Directory", DataImport Report Masking Cmd", and "WinView/400 Command Line" to reflect DataImport 6 and WinView/400 32 bit.
Enhanced ability to add multiple system names to settings. I enlarged it to 40 instead of 20
Changed name to WinSpool/400 Report Download
Added the ability to apply skins to WinSpool. Also changed the settings from Tab Control to Tab Strip to better handle the skin addition
Wait selected number of settings before launching after download.
Added debug launch view setting. This will pop up the command line which is supposed to get called as well as the file name that should be launched for viewing when View After Download is enabled.
Added code to test Launch File and Loop. Customer was having problems launching Excel files after download and conversion to Excel using DIW.
Also added 3 second delay after DataImport completes. Without the short delay, the FindExecutable API would not always find the program to call after passing hte file name to FindExecutable. Apparently if there is still a file lock on a file, FindExecutable can possible fail.
Aded XLS output type for DataImport 6.0
Fixed settings to handle page rotation correctly when outputting a text report to "PDF" report format and the "Use AS/400 Line/Char Per Inch Page Scaling" setting is enabled in the PDF Report Converter.
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.
Removed code to test Launch File and Loop.
Added code to test Launch File and Loop. Customer was having problems launching PDF files after download.
Added CSV output type for DataImport.
Added downbload to "WinView/400 Page Index format". This is a new ASCII file format that adds all report page break information to the end of the report file after it's been downloaded. This allows WinView/400 to open large reports much quicker.
Note: This format requires WinView/400 32-Bit V1.74.0 or above for viewing reports created in this format.
Changed AFP to PDF and AFP to TIFF license check to user the native converter licensing as expected.
Added Send to Report Index Editor option to allow users to determine the exact position of report index keys within a report file.
Created RJS Notepad program to be the report index editor program. Program name: RJSNOTE.EXE
Added extension counter formatting to allow customers to use short extensions in file names. New Settings are "Max Counter Value" and "Counter Format"
Added ability to launch Electronic Form Designer.
Added ability to append to ASCII files only.
Removed delete option from the screen by default. It can be enabled by changing the AllowDelete option to 1 in the INI file.
Added ability to manually download AFP to PDF and AFP to TIFF using the Native converter technology.
Automatically set focus to Get List Buttons when List by Queue or List by User is selected.
Changed default path for Email File Attachment Mgr. The program is now installed with WinSpool/400.
Added @DATE & @TIME keywords for output file prefixes.
Added WinSock API Switch for Remote Commands. This should prevent timeouts on long running CPYSPLF commands for large reports.
Added invisible INI setting called MaxPages. If this value is set in the WINSPL98.INI file, WinSpool 98 will enforce a page limitation for downloading AS/400 reports.
Added LPI/CPI ability for using the new PDF Report Converter functionality for handling AS/400 LPI/CPI. Requires: PDF Report Converter version 1.0.17 or above.
Added tracepoint code to FORM_Main load routines. This allows us to track any possible errors that might occur during startup such as errors with COMCTL32.OCX, COMDLG32.OCX, TABCTL32.OCX or SBARVB.OCX.
If not using template file names The output file name wasn't getting set correctly if the template file naming was turned off. This would show up as an Error 5 - Invalid procedure call or argument.
Changes template file name to a combo box and added @FORMTYTPE, @SPOOL, @JOB and @USERDATA to the list.
Added support to use the old numeric extensions if the "Use Numeric Template Output File Extensions" setting is enabled.
Changed maximum number of selected reports to 10000 from 4000. Customer could get a "Subscript out of range" when selecting more than 4000 reports for downloading.
Added support for Launching Excel after running "DataImport Translate" option. There are also optional parameters for calling an Excel Macro after the Excel file has been opened.
We now automatically call the Text to Columns Wizard when a report is downloaded and sent directly to MS Excel. This allows the user to parse a spool file into columns if they want.
Added support for HTML Page Length during conversions.
Added @USERDATA and @FORMTYPE to spool file name replacement for the template file name.
Added soft coded ZIP extensions.
If the MS Word Command Line is empty, the Word document will be launched using the .DOC extension.
If the MS Word Command Line is not empty, the Word document will be launched using the MS Word command line.
Added flag to allow the Send to MS Word option to call MS Word via a command line call the the .DOC file instead of using OLE to call MS Word. This was done to prevent OLE Automation Errors in some situations.
Implemented Help Contents
Implemented PCL to PDF Options Setting.
Added ability to save User ID/Password in the INI settings file, however we don't want this feature generally available, so the following entries have to be added manually to the WINSPL98.INI to make this work.
[Settings] UID=JOE (or whatever your user ID is) PWD= (or whatever your password is)
These entries also are not encrypted, so be aware of this when this option is used.
Added support for downloading RAW Unformatted Report files. These files can be displayed with the IBM AFP/IPDS Viewer included with 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.
Added a switch to allow us to turn on the DSPJOBLOG setting whenever it's necessary to view a job log.
Added setting for enabling the RJS DataImport Report Convertor ActiveX for testing.
If the RJS DataImport Report Convertor is installed, users can test with the entire DataImport Translation enabled during testing. No 100 record limit - Used only for customer testing. This is not to be used in a production environment. The user must typically have DataImport installed on their PC and must disable the RJS DataImport Report Convertor setting.
We now pass most recent file to DataImport Mask and Monarch when setting enabled.
Added more meaningful error messages if report convertors not found on error 429 (ActiveX).
Added *.ZIP to delete report filtering.
Initially released WinSpool 98 Code
Added report zipping and deletion to report selection and download.
Changed maximum number of selected reports to 4000 from 1000. Customer was getting a "Subscript out of range" when selecting more than 1000 reports for downloading.
Added error check to make sure the first report is highlighted in the selected report list before downloading. If the first report wasn't highlighted, it was possible the output PC file would be duplicated thus causing a file replace message to show up.
Default the Email Command Line value.
Added @JOB to output PC file name substitution.
Modified Download and Reformat AS/400 reports. It can now call the Email feature after reformatting reports.
Modified @SPOOL keyword to include 10 character spool file names.
Moved spool date next to spool file on spool file listing screen.
Added file replacement confirmation dialog.
Added "File extension" setting. The extension counter now goes into the tail end of the file body. Example: SPOOL123.PRN. This used to look like SPOOL.123. People using Monarch will appreciate this change.
Pass filename to Notepad. Changed Monarch and DataImport error messages.
Fixed misspelling of retrieve on Rtv Spool File List. Also added field which we can later use to filter report lists based on user ID.
Report Reformat Utility wasn't working correctly when running the Download and Reformat option with TCP/IP enabled. I fixed the problem.
Fixed Spool Date/Time Display for TCP/IP Spool Listing.
Fixed User Data Display with TCP/IP Spool Listing.
Added hidden switch for the TCP/IP commands so we can force the FTP server to print a job log if we need one. The hidden switch needs to be manually placed in the INI file. The INI setting is DSPJOBLOG.
We now also delete file WSPL021P after retrieving a list of all output queues. We were having problems with FTP security between user sessions because the AS/400 keeps FTP sessions active even when a user signs off.
Release of VB 5.0 version V2.30. Version 2.30 now supports 16/32-Bit APPC and 32-Bit TCP/IP.
Sporatic Runtime error 380 when downloading multiple reports from the AS/400. It turns out because of the few extra blank records which sometimes get downloaded with a report, the gauge percentage sometimes slips over 100%. If this happens, we now check for it and set the gauge to 100% if it goes over 100%.
Added double quotes around the Monarch command line parameters so long file names can be passed correctly. DataImport Mask seemed to work OK without adding the double quotes.
Moved Common Dialog control onto a 3d panel so we can determine where the Common Dialog box will popup. We couldn't do so by placing the Common Dialog control onto the Main form.
Software will now pass the currently open file into Monarch and DataImport.
Added ability to pass most recent file name downloaded to both the DataImport Mask tool and Monarch.
Reset template counter if it exceeds 999.
Fixed status bar because it was giving us an "Overflow 6 error" if the total record count exceeded 32767 (Integer Size).
Added the special @SPOOL option for the template PC file name. If @SPOOL is entered for the template file name, WinSpool/400 will use the first 8 characters of the spool file name as the PC file name.
Made the use of template file extensions optional.
Fixed background colors of the list boxes so they work correctly with different color schemes such as Plasma Power Saver.
Fixed help so it gets called correctly from help menu.
If the user changed paths while running WinSpool/400 the help file could not be loaded.I set it up so the help file path is automatically set the same as the EXE path. This way the help file should always be found.
Took the word ERROR out of the error messages which occur if a program is not loaded on a user's PC. This way they don't semantically interpret it as a valid error.
Added the ability to disable outq/splf listings, settings, dataimport, monarch, file manager, editor, and user options. The INI entries must be manually set to "0" to disable the individual option(s).
Enabled the usage of the new download function which uses the EHNTFW.DLL for downloading files from the AS/400. The EHNTFW.DLL API is much faster than the EHNAPPC.DLL. The new download function can be enabled from the settings section. NOTE: An updated version of the WINSPOOL library and WNSPLAPI.DLL is needed to appropriately handle the EHNTFW API calls.
Cleaned up the pop-up menu options as well Added DataImport to the menu as well as Monarch. Removed the Visual Translator option from the menu.
Added reformat option for calling a report reformat utility directly from within WinSpool/400. I also added a work file parameter to hold the temporary spool file when using the Download and Reformat option.
Added default option for PC command to run after downloading. The macro @JOB inserts the spool job name into the PC command line. @SPOOL inserts the spool file name. @FILE inserts the output PC file name.
Added spool file viewer using the EMEDIT.VBX custom control. The editor control now fills the client area on the main window.
Added ability to select information from a spool file. A page range can be selected or the report can b scanned for selected information.
Added ability to Email spool files if the user purchases the WinSpool/400 Email add-on option.
Disabled ability to select information from a spool file and hid the button. The new WinSpool/400 API library is not ready yet, so we don't want to introduce the selected information functionality yet.
Added message box if no spools were selected for downloading or Emailing on the Download All Selected and Download and Mail buttons.
Version 2.05 was not checked at 640 x 480 resolution so it had to be fixed to fit within 640 x480 correctly.
No QPRTSPLQ entries were being shown in spool list box. They were being filtered from the spool lists because QPRTSPLQ entries are used when listing spool files.
Added option WNSPLAPI.DLL to enable and disable PeekMessage loop in order to try to solve Netware for SAA Problems with Garbage appearing in a spool file.
Added option to enable/disable completion percentage timer on cometion status screen. This will prevent the completion status from being shown.
Fixed print control character label on settiungs screen so the whole thing displays.
Removed exit option from popup menu.
Fixed pulldown on retreive output queue list box so it will always parse the outq & library names correctly.
Fixed list box on Download Screen. The scrolling headings were not lining up correctly with the spool file list. This function should now be resolution independent.
Fixed button positioning so the buttons don't look like they're about to fall off the screen in the spool file listing screen.
Added option to automatically display the download dialog after the outq or user list is retrieved from the AS/400.
Added option to keep the users out of the change settings option. The "chgset" INI entry must be manually set to "0" to disable the change settings option.
Added option to keep the download window open after a download is complete. This preserves the currently selected spool files and keeps the user from having to reselect.
Fixed download CANCEL option to set a Global cancel flag, so a multiple spool file download will cancel correctly when selected.
Added option(s) to protect the output queue or spool file information on the Rtv OutqList and Rtv Spool List change settings option. The "chgoutq" and "chgsplf" INI entries must be manually' set to "0" to disable the individual option(s).
Added option to default the user ID from the router for the Rtv Spool List option. The "dftuser" INI entry must be manually' set to "1" to default a user ID.
Added double-click signon/signoff option to main window.
There was a reference to WSPL_RtvSpoolFileAppend in the download spool file procedure. This was being tested and should not have been in the code yet.
Changed capitalization on messages and also changed duplicate messages to be more meaningful.
WinSpool/400 now uses MLIST.VBX for the list box. This eliminates the limitation we previously had on downloading spool files. The previous limit was < 300 spool files. This was due to the VB list box limitations.
User ID and Password security were added.
Tool tips were added.
Support for DataImport was added to the RUN menu as well as two user defined menu options where the user can specify the menu text as well.
Fixed startup screen label width. In some cases, the WinSpool/400 text was being cut off. Made label wider and also.
Fixed icon underline to automatically extend all the way across the screen. In 1024x768 mode, the line didn't always extend all the way across the screen.
When multiple spool files were selected, the output PC file name would not stay if the user clicked to another spool entry after making changes to an entry from the selected list.
Window placement was being screwed up after download completion because of enabling/disabling forms. I fixed this so it should be semantically correct. There is still a small anomaly when preview is chosen, because the download windows stays open after a preview of a spool file.
Soft coded version info and added user defined command lines for all run options.
Still have questions? We can help. Submit a case to Technical Support.