|September 25, 2014
||MMAIL trial version
||A 30 days free trial version has been made available for V5R3 and subsequent releases. Sources have been removed from this trial version.|
|September 4, 2014
||A new parameter, ZERODSP (Display zero values) was added to commands XLSGEN, XLSXGEN, WEBXLSGEN and TABLEXLS . A similar input variable was made available to CGI program WEBXLSTABL. When ZERODSP(*NO), the numeric cells (of a generated Excel spreadsheet) containing zero display nothing, instead of a zero. This can ease the spreadsheet reading when a large number of numeric cells contain zero.|
|August 28, 2014
||A new command, FRCFILTER, allows to force a database filter for all users other than the originator. See this page.|
|August 22, 2014
||Majour update to command SENDMIME.|
|August 13, 2014
||Major revision of the utility. Added support for triggers.|
|June 24, 2014
||Command XLSTABLE now enabled to process - besides stream files - also distributed stream files.|
|May 28, 2014
||Fixed the case where in command UNZIP an IFS path name contains embedded blanks.|
|March 18, 2014
||Command IFSTOOL/READDIR has a new parameter, MASK, which allows to report back only the stream files with names matching a given pattern. Read about it at this page.|
|March 17, 2014
||New AMailer enhancement in receiving incoming mail messages: images embedded in the message body are now regularly displayed when reading the message and are also made available as attachments.|
|March 14, 2014
||Provided documentation about implementing Internet mail-boxes on IBM i, see this page.|
|March 8, 2014
||New command RPTXLSGEN provides detail information about the workbooks created from the current job.|
|March 6, 2014
||"Ad-Hoc" program regeneration no longer sensitive to database file creation / last-change date changes: mandatory for production boxes without ILE-RPG compiler.|
|March 6, 2014
||"Ad-Hoc" program regeneration no longer sensitive to database file creation / last-change date changes.|
|March 2, 2014
||Improved POP3 client interface.|
|February 25, 2014
||Service program CGIDEV2/CGISRVPGM2 was added new subprocedure WrtSectionToStmf(). This procedure may be used to generate on the IFS large stream files exceeding 16 MB. See this page.|
|February 8, 2014
||Removed limit of 500 characters for conversion of character strings to spreadsheet text-cells (commands XLSGEN, XLSXGEN and TABLEXLS).|
|February 6, 2014
||Provided examples of stacked charts, see this page.|
|January 30, 2014
||Fixed the interface to IBM INFOPRINT SERVER, after detecting problems with V6R1.|
|December 18, 2013
||This new utility is now equipped with 6 types of charts (Line, Radar, Bar, Polar, Pie and Doughnut). A new powerful CGI program (named CHARTIT) allows to generate the desired type of chart, with the desired data, at a cost of a few minutes.|
|December 13, 2013
||This is a new utility that demostrates how you can generate fabulous HTML5 graphs with your CGI programs. Have a look.|
|October 10, 2013
||POP3READ & MMAIL
||A new feature allows to get e-mail messages also from SSL POP3 servers.|
|September 10, 2013
||It was found that command EMLPTUMSG was sending the message only to the first addressee. That has been corrected.|
|September 3, 2013
||New parameter JUNK(*YES) on command ZIP/ZIP prevents recording of directory names.|
Also compression of full IFS directories now supported on command ZIP.
|August 24, 2013
||Command ENDJOBS/ENDJOBS is no longer sensitive to the OS/400 release. It works from OS/400 release V5R3 on. See this page.|
|August 3, 2013
||MMAIL & AMailer
||- Removed bug causing accumulation of useless stream files in IFS directory /mmail/work.|
- Fixed AMailer modules and subprocedures dealing with detachment of BASE64 encoded message bodies and attachments.
|June 16, 2013
||SMS messages can be sent through an e-mail message to a SMS Gateway, see page MMail: E-Mailing SMS messages.|
|May 21, 2013
||A new command, EMLTXTSTMF, allows to create and send an e-mail message starting from a text stream file. Attachments are of course supported.|
|May 19, 2013
||*** This is the first V5R3 release of MMAIL.|
This release features a new way of retrieving the local time zone and more parameters for command EMLPTUMSG (e-mail an impromptu message).
|May 18, 2013
||Fixed the management of parameter RTNPTH (return Path) in all programs related to commands EML... and STREML... .|
*** This is the last V5R2 release of MMAIL.
The next releases will be for V5R3.
|April 13, 2013
||New command EMLPTUMSG allows to send an inpromptu message (maximum length 5000 characters) up to 50 e-mail addresses. See this page.|
|March 11, 2013
||Error messages reported via e-mail from command RCVMSGQ are now correctly formatted and can be read without any problems.|
|February 25, 2013
||Fixed Header Table support - Utility FIXHDTAB is now documenting and supporting a new fabulous JQuery plugin, DataTables from SpyMedia. Read about it.|
|February 18, 2013
||Provided documentation about E-Mail/SMTP Authentication. Check out this IBM Software Technical Document.|
|February 10, 2013
||A new parameter, RUNBATCH(*YES), allows command IFSTOOL/READDIR to submit its execution to a batch job. In this case, the library of the results data base file DIRLIST is no longer QTEMP and can be assigned by the user. Parameter RUNBATCH(*YES) is recommended whenever huge IFS directories are processed. For more information, see this page.|
|December 30, 2012
||Two new CGISRVPGM2 subprocedures - DspStmf() and DnlStmf()- allow to send a stream file to the browser / download it. Check out this page.|
|December 22, 2012
||A new small utility featuring a command able to end multiple jobs in a single shot. See this page.|
|December 18, 2012
||New command EMLHTML2 allows to create and send a mail message having an HTML stream file as body and attaching up to other 30 stream files. See this page.|
|November 5, 2012
||Updated three modules of service program SOCKETMAIL. See the MMAIL change log.|
|October 30, 2012
||A new command, SplPdfCvt, allows to pre-define spl-to-pdf conversion parameters for ...EML... commands.|
See this page.
|September 12, 2012
||MMAIL commands EMLSPL, STREMLSPLF, STREMLSPL2, SENDMIME and SPLFTOPDF may now take full advantage of all the fancy features available in the spool-file-to-PDF conversion IPDF free utility. See commands CSVIPDF/CREATEIPDF and MMAIL/IPDFCMDPRO on this page.|
|September 4, 2012
||A great FREE product from Orati Systems, IPDF, is now supported through MMAIL EML... commands for converting spool file to PDF's. For more information about this feature, see this page.|
|August 30, 2012
||Provided support for parsing very large spreadsheets (more than 10,000 rows).|
|August 20, 2012
||Unability to report stream files larger than 2,147,483,647 bytes has been removed.|
|August 9, 2012
||National characters support:|
- if the selected character set (see command MMAIL/CHARSET) is UTF-8, in EML... mail messages the names of the sender and of the recipients are encoded in UTF-8.
|July 10, 2012
||National characters support:|
- if the selected character set (see command MMAIL/CHARSET) is UTF-8, in EML... mail messages the subject is encoded in UTF-8.
|July 6, 2012
||National characters support:|
- MMAIL is now supporting character sets other than ISO-8859-1, uncluding UTF-8.
Therefore MMAIL is now able to send mail message bodies in languages like Czech, Hungarian, Polish, Norwegian, Swedish, etc.
Character set UTF-8 is recommended. Use command MMAIL/CHARSET to set your default character set.
|June 15, 2012
||MMAIL commands EMLMSG, EMLSRCM, EMLSPL, EMLSPL2, EMLSAVF, EMLSTMF and EMLSTMF2 use a source member for the text of the message body and the related programs execute a STRSEU command to edit the source member.|
The following enhancement has now been provided.
If command STRSEU is not available (a very common case on production boxes, where PDM is not installed), the EML... programs, instead of STRSEU, send a display file screen that allows the user to edit the source member text. If the user presses F3 from this screen, then command EDTF is executed.
|June 9, 2012
||MMail allows not only to send mail messages, but also to receive mail messages addressed to given user accounts.|
This can be done through the MMAIL-integrated utility named "AMailer".
Incoming mail messages can be received and processed through a local program on a IBM System i box.
Both Internet and System i locally defined user accounts are supported.
AMailer" provides tools to define such accounts.
System i locally defined user accounts are supported through "AMailer" generated user profiles.
However, a System i box can be already supporting mail exchange among local users using existing user profiles.The good news is that now "AMailer" is also able to generate its mail accounts by referring to existing system profiles.
In this way, already existing local mail user environments may take advantage of processing through local programs the incoming mail to local accounts.
|May 16, 2012
- Improved *ESCAPE message processing in commands XLSCONVERT and XLSTABLE
- Added sample CGI program UPLANDRUN (Upload a spreadsheet from PC and run XLSTABLE for it), see this page.
|May 7, 2012
||Rcdfmt of SYSTEMS file was added fields for three STRTCPFTP command parameters: CCSID, PORT, SECCNN.|
|May 2, 2012
||In commands XLSGEN and XLSXGEN, the maximum number of user-defined cell styles has been raised from 494 to 10,000. See this page.|
|April 28, 2012
||The main ODF utility command, ODSTR (Start Object Distribution), has been enhanced to support transmission up to 300 remote systems.|
The selection of the remote systems to be engaged has been inproved through
- a remote systems list, to chose from
- optional selection of all the available remote systems
- optional selection of remote systems via generic names.
|April 18, 2012
||Fixed subprocedure random by replacing call to API CEERAN0 with a call to API Qc3GenPRNs for pseudorandom numbers generation.|
|March 21, 2012
||It was found that CGIDEV2 supports a maximum of 50 output variables in a HTML row. This restriction was due to local subprocedure "SetupArrays" in module XXXWRKHTML. That procedure now has been changed to support up to 500 output variables in a HTML row.|
|March 13, 2012
|March 4, 2012
||Some important updates:|
- Added ability to update/delete the selected database record when non-unique keys are used.
- Fixed positioning after record add/update.
- Fixed ad-hoc program generation when null capable fields are involved.
|February 29, 2012
||Updated subprocedures MimeSplpdf and MimeImbAtt so that the names of the attached PDFs are no longer suffixed with a 5 digit number (e.g. "QPDSPLIB_97813.PDF" will now be "qpdsplib.pdf").|
|February 7, 2012
||"HttpOnly" flag in Set-Cookie HTTP header now supported by subprocedure CrtCookie.|
|January 28, 2012
||This is a jQuery plugin that allows to keep the table headers steady while a table is being scrolled. It also allows the user to display only selected columns of the table. The tool is documented at this page.|
|January 26, 2012
||Implemented Table Fixed Header feature, based on a JsQuery plugin.|
|January 20, 2012
||Now truly compatible with V5R2.|
|January 15, 2012
||Added more examples of CGI programs generating XML speadsheets. See this page.|
|January 5, 2012
||Added command MMAIL/UPDMMLIB. It allows to update a MMAIL cloned library (originally created with command MMAIL/CRTMMLIB) with fresh software from the last installed release of library MMAIL. See this page.|
|December 31, 2011
||New MMAIL release fixes|
|December 25, 2011
||Commands CGIDEV2/REBIND and CGIDEV2/DUPSRVPGM may help when installing the latest CGIDEV2 over a previous CGIDEV2 version. See this page.|
|December 22, 2011
||Subprocedure encode2 now supports also encoding of characters to decimal entities (besides conversion to named entities). New subprocedure decode2 supports decoding of named and decimal entities.|
|December 20, 2011
||This is a jQuery based tool that allows to pick up dates and move them into input fields of a form. See this page.|
|December 16, 2011
||Command TABLEXLS now supporting also SQL views.|
|December 16, 2011
||WRKDBF now supporting also SQL views.|
|December 10, 2011
- "Bottom" positioning now provides a full page of records, instead of showing just the last record.
- Fixed "bottom" positioning for packed and date key fields.
- Fixed the display of negative signed and packed key fields.
|December 1, 2011
||Provided parameter DEC-POS for formulas. Example:|
< data type="formula" dec-pos="3" > .
|November 26, 2011
||WRKDBF now supporting also UCS-2 (data type "G") database fields.|
|November 25, 2011
||Command TABLEXLS now supporting also UCS-2 (data type "G") database fields.|
|November 18, 2011
||User name and password lengths increased from 20 to 100 characters.|
|November 17, 2011
||User name and password maximum lengths were increased from 20 to 100 characters, thus supporting, for instance, e-mail addresses as user names.|
|November 17, 2011
||One bug fixed ( encoding not always complete if > 1 character to encode ) + improved performance on command DB2XML.|
|November 16, 2011
- Parametr DIR in commands READDIR and SEARCH now supports a generic path name (ending with an *)
- SEARCH command now able to scan also Unicode stream files.
|October 28, 2011
||A new parameter (IGNDIRS) on command READDIR (Report the contents of a directory) allows to neglect up to 100 sub-directories.|
|October 27, 2011
||Full recovery feature now available with parameter RECOVERY in commands XLSGEN, XLSXGEN and TABLEXLS. Especially useful when facing JVM memory problems during generation of large worksheets. Read about it.|
|September 29, 2011
||It is now possible to insert images (for instance a logo) in message bodies of EML... commands, by simply specifying the images to be displayed.|
As an example, if you want to display a boat image, just insert something like this in any point of your message text:
< img src="http://www.easy400.net/mmail/image/0002378.gif" >
|September 21, 2011
||Added three procedures to service program CGICBLDEV2/CGICBLDEV2:|
- QAppHtmlToStmf Append the HTML buffer to a stream file
- QChkIFS Check an IFS object
- QLowfy Convert a character string to lowercase characters.
|September 13, 2011
||Fixed an important bug in the *LK record filtering process.|
|September 5, 2011
- Provided a User Guide
- Added new powerful operator *LK ("like") for record filtering.
|August 30, 2011
||A new parameter ("anchor") has been added to the data type PICTURE.|
It establishes the behavior of a picture when
For more information, see this page at topic Picture resizing and relocating.
- the cell is resized
- a new column or a new row is added to the worksheet.
|August 28, 2011
||Provided a parameter to zip (compress) attached spool files (either converted to PDF or not).|
This feature applies to commands: EMLSPL, EMLSPL2, EMLSPLX, EMLSTMF and EMLSTMF2.
|August 26, 2011
||Improved maintenance features (rename / move / delete) of WEB program FUPLOAD3.|
|August 17, 2011
||Subprocedure AppHtmltoStmf() (Append html output buffer to an existing stream file) was added to service program CGIDEV2/CGISRVPGM2 as per request to the Easy400Group.|
|July 24, 2011
||Added some code to subprocedures ZhbGetInput and ClrHtmlBuffer to handle exceptional uncontrolled cases of memory trashing.|
|July 16, 2011
- Parameter LOG in commands XLSGEN, XLSXGEN and TABLEXLS
- Keyword COLUMN-MAXWIDTH for XLSGEN tag <cell>
- Ability to define formulas VSUM/HSUM/VAVG/HAVG over a previous series of cells containing formulas
- Spreadsheet name length forced to 30 max when XLSX workbooks generated.
|July 12, 2011
||Subprocedures GetHtmlIfs and GetHtmlIfsMult of service program CGICBLDEV2/CGISRVPGM2 are now supporting Unicode (CCSID 1208) stream files. Unicode support for subprocedure WrtHtmlToIfs was made available in May 2009.|
|June 13, 2011
||Steady Headers is a special feature of the CgiWRKDBF utility. It allows to keep the column headers steady, while the table is being scrolled.|
This feature is driven by the server CGI program, after receiving information from the browser about the screen height.This piece of information is acquired when the utility is started from its first page, while no such information used to be made available when the utility is started on its second page via URL
Thats has now been fixed.
Note for FireFox users - FireFox 4.0 has dropped the support for the HTML tags TBODY and THEAD, in the sense they are no longer interpreted as block-groups (as tag DIV does).TBODY and THEAD tags are the base for handling Steady Headers. As a consequence, the Steady Headers feature no longer works with FireFox 4.0, while it still works with I.E. 9.0 .
|June 11, 2011
||It was found that MMAIL utility CVTSPLFPDF (while able to convert to PDF *SCS and *AFPDS spool files) will fail in converting to PDF *IPDS, *AFPDSLINE and *LINE spool files|
(Error message: QwpzHostPrintTransform failed : CPF6DF8 hptopt = 30).
On the other site it was found that MMAIL utility CVTSPLSTMF, besides converting *SCS spool files, has no problems in converting to PDF *IPDS, *AFPDSLINE and *LINE spool files.
We have therefore updated subprocedure MimeSplfPDF in such a way that, when requested to process a PDF conversion for an *IPDS, *AFPDSLINE or *LINE spool file via CVTSPLFPDF, it calls CVTSPLSTMF instead.
|June 10, 2011
||New features for cell border support:|
See this page.
- Parameter CELLBORDER for commands XLSGEN, XLSXGEN and TABLEXLS.
- Keyword border for XLSGEN tag <cell>.
|April 9, 2011
||This ZIP release fixes potential problems in displaying the result from a ZIP or an UNZIP command.|
|March 25, 2011
||Subprocedures GetHtmlIfs and GetHtmlIfsMult are now supporting Unicode (CCSID 1208) stream files.|
|February 21, 2011
||Added more features:|
- A <HEADER ...> XLSGEN opcode to generate print headers and footers
- New features for command TABLEXLS and pgm WEBTABLEXL:
- multiple database files input
- multimember file support
- screen headers and print headers.
|February 14, 2011
||Added keywords UNDERLINE and ITALIC for the XLSGEN control statemenf <data ...>, see this page.|
Added HYPERLINK support for <data type="formula">, see here.
|February 10, 2011
||Added parameter CELL-WIDTH to the XLSGEN control statement <cell ...>. This allows to establish the size in pixel of a spreadsheet cell (and the column it belongs to). See this page.|
|February 2, 2011
||Added controls to prevent users from using system user profiles (like QSECOFR) not allowed to run submitted jobs or FTP jobs.|
|January 31, 2011
|Released new versions of the two utilities. They provide better parameters for converting the queried data to the desired output format. The major part of the enhancements are focused on the CSV output format.|
The new version of WEBSQL requires the new version of DB2XTOOLS to be also installed.
|January 14, 2011
||Fixed some problems in EML... commands validity check programs when FROMADDR(*DIRENT) specified. For details, please see this forum posting.|
|December 18, 2010
||If you did not use Ajax so far, you may be interested in our method. Take a look at our Ajax pages.|
|December 6, 2010
||Added a "freeze pane" feature to keep heading rows steady when scrolling rows. See new parameter FROZEN in commands XLSGEN, XLSXGEN and TABLEXLS. Check out page http://www.easy400.net/hssfcgi/html/page2.htm.|
|November 27, 2010
||Added command ODRCV (Receive Objects from a Single Remote System). See this page.|
|November 20, 2010
||Validation of files to be uploaded is now possible both at client and at server side, see this page.|
|November 17, 2010
||This is a new utility, based on DB2XTOOLS. It provides a way to define, from the WEB browser, an SQL query on System i databases. The user can then request to convert the result of the query to a PC format (XML, HTML, CSV or TXT) and display it through the appropriate MS Office utility. See this page.|
|November 12, 2010
||A new exciting WEB feature makes using this utility very simple, in converting database files to XML, HTML, CSV and TXT formats. Display of results on the WEB browser is at the touch of a button. See this page.|
|November 3, 2010
||The FUPLOAD program FDNLOAD, supporting the download of whatever stream file, was found unable to download stream files larger than 16 Megabytes. Luckily, a Scott Klement's suggestion provided the way out, so that now downloading any size stream file is possible in the FUPLOAD utility.|
|October 29, 2010
||Added support for Spooled File Actions.|
If your system is at least at release V6R1, on command WRKSPLF (and other commands dealing with spool files), you may install more options (A, B and C) to e-mail spool files or to save them as IFS stream files (text or PDF).
For detail information see this page.
|October 15, 2010
|Utility XLPARSE has been merged into XLPARSE2. XLPARSE has been withdrawn. XLPARSE2 provides a way to import Excel spreadsheets to IBM i databases. Both extensions XLS and XLSX are supported. XLPARSE2 requires V5R3, v5R4 or a subsequent release. For detail information see page http://www.easy400.net/xlparse2/html/page1.htm .|
|October 11, 2010
|The XLSTABLE target database file can now be a multimember file, and a target member can be specified.|
Numeric spreadsheet cells can now be received also on database character fields.
|October 8, 2010
||Fixed severe error that was inhibiting mail sending.|
|October 7, 2010
||Fixed a problem that was causing command XLSGEN to fail on V5R4.|
|October 4, 2010
||Subprocedures QZhbGetVar and QZhbGetVarUpper of service program CGICBLDEV2/CGICBLDEV2, when called from COBOL program, no longer work with OS/400 release V6R1.|
Reason is that those subprocedures return a 32767 char variable, while the COBOL program is usually expecting a shorter character variable.
This is why those two subprocedure have now been changed and now return a 1000 char variable. COBOL programs calling those subprocedures should be changed accordingly.
|October 1, 2010
||This is a major release, providing color support for EXCEL spreadsheet cells. See this page.|
|September 23, 2010
||Added an exit point to subprocedure SendMail. This allows an user-program to validate any message from MMAIL. See this page.|
|September 16, 2010
||Now supporting background colors in column headers of a spreadsheet.|
|September 13, 2010
||It is now possible to transfer via FTP PUT command all or selected members of a file.|
|September 8, 2010
||Fixed a problem (pgm WARNLSTRLS) that was spoiling e-mailing response time.|
|September 6, 2010
||In this HSSFCGI release, the size limit of 16MB for the XLSGEN XML-like stream file input to commands XLSGEN / XLSXGEN, has been dropped.|
|August 26, 2010
||A new version of this utility (library DB2XTOOLS) has been made available by Antoon van OS, The Netherlands. See this page.|
|July 12, 2010
||Support for XLSX Excel spreadsheets has been added.|
|July 5, 2010
||New important feature. Command TABLEXLS allows to generate an XLS Excel Spreadsheet from any database file. See this page.|
|June 15, 2010
||HSSFCGI (the utility that allows to create .xls Excel spreadsheets) now supports any formulas compatible with Excel 2003.|
|June 1, 2010
||Fixed a small bug related to memory deallocation - It was preventing some messages from being correctly received.|
|May 25, 2010
||This is a new CGI utility for maintaining validation lists. See this page for documentation.|
|May 11, 2010
||A fix was added to XLSGEN program. It was not closing the stream file containing the .xls workbook just created. That did not allow the stream file to be copied or moved.|
|April 16, 2010
||Solved an old problem related to the replacement of an ad-hoc program when the record format of the related database file is changed.|
|March 18, 2010
||XLPARSER2 is the successor of XLPARSE. It allows ILE-RPG programs to read not only XLS, but also XLSX Excel spreadsheets. See this page.|
|March 7, 2010
||Added command XLSTABLE. It allows to read an Excel XLS sheet as if it were a database file. In this way an Excel XLS sheet can now be read by any program language, RPG III, RPG IV, C, COBOL, ... what you have.|
See this page.
|February 15, 2010
||New features added:|
See also this page.
- Alternate background colors for table rows, for easier reading
- Record marker, to change the background color to all fields of a record
- Add alike record, to create a record similar to the one selected for update.
|February 3, 2010
||This is a new utility (Virtual Save & Transfer), which allows to perform saves on virtual tapes and to transfer the save data to another system where they can be stored on real tape volumes. For detail information see this page.|
|January 21, 2010
||Fixed the following bug: only the first 5 key fields of database file record formats were recognized as key fields.|
|January 19, 2010
||POI 3.6 - installed on XLPARSE January 5, 2010 release - was found unable to process a customer .xls spreadsheet, while POI 3.2 was able. As a consequence, POI 3.2 was put back into XLPARSE.|
|December 23, 2009
||The following enhancements were added: |
See this page for details.
- New parameter PMTRSTCMD (Prompt Restore Commands) in command ODSTR allows to prompt the restore commands that will be run on the target systems.
- Command RTVODSTR retrieves, prompts and runs a previous ODSTR command.
- Command RERUNODSTR re-runs a previous ODSTR command.
- Command ODDSPLOG has now options to run commands RTVODSTR and RERUNODSTR.
|November 30, 2009
||A new release, including several fixes and enhancements, is available. Check out this page.|
|November 24, 2009
||WRKDBF is now featuring a "Steady Table Headers" technique. Instead of scrolling the whole browser page, you just scroll the table rows (the records). Field headers no longer move.|
This is what you have been used since ever with OS/400 subfiles.
Wow, now also available for HTML tables!
|November 3, 2009
||Improved support for error TCP7531 (Output buffer damaged).|
|November 2, 2009
||ODF (Object distribution Facility) is a new utility for maintaining multiple IBM System i's. Read about it at this page.|
|October 24, 2009
||A new utility that investigates all the ILE programming pieces of an application library, finds out the relations among pieces and provides several inquiry screens that will help in your application maintenance duties. A life-saver for ILE programmers.|
See this page.
|September 15, 2009
||Several fixes. See this page.|
|September 8, 2009
||Improved performance about 5 times.|
|September 4, 2009
||Bug fixed. Pgm ZIP/ZIP was accepting a max of 5 files to be zipped instead of 50.|
|September 1, 2009
||New feature: Add/Remove a user-defined filter on database records.|
|August 16, 2009
||The utility now supports also adding, updating and deleting database records. See this page.|
|August 4, 2009
||This utility allows to browse through your Internet browser any iSeries database file. See this page.|
|June 30, 2009
||New MMAIL imbedded utility STRMONIFS allows to perform automated distribution of PDF stream files. See this page.|
|June 22, 2009
||Now supporting the V6R1 AFP to PDF transform. See this page.|
|June 12, 2009
||CGIDEV2 & MMAIL
||Added commands ZIP and UNZIP - They execute in the QSHELL environment.|
|May 21, 2009
||A new file upload program ("fupload2") has been made available. Much simpler than the previous one, it can be easily customized. Oustanding performance. Multiple uploads possible in a single shot. Read about.|
|May 21, 2009
||Added a feature that allows PC file upload with no effort. See this page.|
|May 2, 2009
||Are you still missing ZIP and UNZIP commands on the iSeries? Get them installed in a few seconds. Check out this page.|
|April 22, 2009
||This is another utility for generating Excel spreadsheets from programs. It supports inclusion of images in a spreadsheet (the other utility, XLSCGI does not support graphics). Read about it at this page.|
|March 26, 2009
||A new utility for CGIDEV2 programmers. It allows to generate and send to the remote browser Excel spreadsheets. Read about it at this page.|
|March 25, 2009
||Added command EDBG (Enhanced debug) - Makes you faster in starting debugging CGI programs, but not only them.|
|March 10, 2009
||XLPARSER4 is the name of a Scott Klement's tool for reading Excel spreadsheets with ILE-RPG. We have wrapped that ingenuous code with some interface in library XLPARSE. That makes absolutely easy for everyone to get Excel spreadsheet reading done. Read this page.|
|February 19, 2009
||Added subprocedure UrlEscSeq, see this page.|
|February 19, 2009
||Taking advantage of the last CGIDEV2 release.|
|February 4, 2009
||"Translate message descriptions used in DDS" - It provides a quick way to translate to another national language the message descriptions used in display or printer files.|
|February , 2009
||Detachment of e-mail messages attachment is now synchronous (instead of parallel) for command PRCUSRMAIL .|
|January 2, 2009
||Fixed a packaging error that was causing troubles when installing on a V5R2 box.|
|December 18, 2008
- Whenever error message TCP7531, the related HTTP server PGM-QZSRCGI job is ended
- Error messages logged to CGIDEBUG file are now showing - if applicable - the name of the involved CGI program.
|December 18, 2008
||V6R1 proof version. The only problem was with command MMAIL/MNGSPLF.|
|December 3, 2008
|Added a new feature to Active Defense. It allows a better defense against unauthorized FTP logon attempts.|
|November 6, 2008
||This is the successor of the star-utility db2xtool which was designed to generate HTML / CSV / XML / TXT scripts from DB2 databases.|
Db2xtool2 results in easier operation and more power. Minimum OS/400 release is V5R3.
|October 10, 2008
|The following enhancements were added:|
- Minimum OS V5R2
- For FTP, it is now possible to define a limited number of IP addresses allowed to logon.
- For FTP, it is now possible to restrict given user profiles within the initially assigned current directory.
|October 7, 2008
||A new parameter (PREFORM) was added to commands EMLMSG, EMLSPL, EMLSPLX, EMLSAVF, EMLSRCM. When PREFORM(Y) specified, the message body is displayed as pre-formatted text. This allows to properly align columns of embedded text-tables.|
|September 28, 2008
||This is a new utility. It allows to perform saves and to zip the save files directly on the iSeries. A command to unzip directly on the iSeries is also available.|
Documentation at this page.
|September 8, 2008
||New tools to add hyperlinks to HTML stream files. See command addhyperl and subprocedure addhyper.|
|August 30, 2008
||Command CVTSPLFPDF now allows to specify PDF conversion parameters such as paper size, orientation and margin. Two new commands (SETSPLFPDF and SETSPLSTMF) allow to specify PDF conversion parameters for CVTSPLFPDF and CVTSPLSTMF when they are implicitly executed from EML... commands. See this page.|
|August 25, 2008
|The FTP logon exit program (for exit point QIBM_QTMF_SVR_LOGON) was added the feature to set |
for the FTP session associated to a given user profile.
- the initial NAMEFMT
- the initial CURLIB or the initial HOMEDIR
This is driven by three new fields added to the FTP user profile authorization records (file SECTCP/USRPRF).
|August 21, 2008
- Fixed an error in the subprocedure that decodes a quoted-printable string.
- Command EMLMSG is now supporting a null message body. In such a case, the message will contain just the subject.
- Content-type: multipart/alternative now supported for the message body.
That allows the message body to be available both as text/plain and as text/html. The choice is then up to the preferences specified for the receiving mailer. See subprocedure MimeImbTxtF in page http://www.easy400.net/mmailh/srvpgm.htm#P066. Most EML... commands are now using this technique.
- Changed USER parameter in command MNGSPLF. It was defaulting to *ALL, now it defaults to *CURRENT .
|August 20, 2008
||A new parameter - IGNSTMF(*NO/*YES) - was added to command IFSTOOL/READDIR. If IGNSTMF(*YES) specified, the generated list of IFS objects does not include the stream files. That may help, when listing complex IFS directories: just the existing subdirectories would be listed.|
|August 12, 2008
|Fixed displays of HTTP logs.|
|July 30, 2008
||This is a new utility, that may help in controlling small emergencies on your system. Please refer to e-police main page.|
|July 6, 2008
||A new utility supporting conversion of IFS strings and stream files from one code page to another code page, Unicode included. Read about it on this page.|
|July 1, 2008
||Local installation files are no longer kept in library QUSRSYS. They are now maintained in library SECTCPDATA.|
|July 1, 2008
||Same as SECTCP. Local installation files are no longer kept in library QUSRSYS. They are now maintained in library SECTCPDATA.|
|June 19, 2008
||It is now possible to require that any outgoing message is sent by blank (blind) copy to a given distribution list, thus implementing a potential company auditing requirement. For details, see SendMail subprocedure, note 2, Mandatory blank copies (blind copies).|
|June 14, 2008
||A new utility for translating HTML stream files to other national languages, see this page.|
|April 16, 2008
||This release includes a change to subprocedure WrtHtmlToStmf, suggested to the Easy400Group in order to overcome some problems related to the new line control character.|
|April 2, 2008
||Improved pgm MMAIL/PRCUSRMAIL. This program is an example of how to receive and process the incoming mail with your programs. Suggestions provided by Norbert Gaberle, Austria. See this page.|
|March 8, 2008
||Predefined text header for EML... commands, see command EMLHEADER.|
|March 3, 2008
||Doesn't need any longer to run with job CCSID 37.|
|March 1, 2008
||A new parameter added to command STREMLSPLF allows to select the spool files to be e-mailed from their user-data, instead of their names. See this page.|
|February 19, 2008
||Fixed bug. Would not write a record to file POP3MAIL if the "From:" e-mail address in the received message not within acute parenthesis < ........... >|
|February 12, 2008
||Command CVTSPLSTMF now provides appropriate spool file conversion to PDF also for job-CCSIDs other than 37.|
|December 21, 2007
||New command EMLSPLX for e-mailing spool files. It includes the same parameters as command EMLSPL. However:|
- An overall conversion to PDF option is available
- A parameter (PDFUTILITY) is available for selecting among the available conversion utilities
- If conversion utility CVTSPLSTMF is selected, parameters for assessing the PDF layout are also prompted.
|December 15, 2007
||Fixed some problems with multiple attachmentsand with Content-ID. Flagged incoming messages not yet completely processed.|
|November 14, 2007
- Footer option added to Tools
- UTF-8 decode supported
|November 3, 2007
- BASIC- Predefined text footer for EML... commands, see command EMLFOOTER
- AMailer- When receiving messages with dual presentations (text and html), the html presentation is now selected, instead of the text one.
|October 30, 2007
||MMAIL - AMailer
||This is a major release that provides far better performance in displaying message bodies.|
For details see page What's New in MMAIL.
|October 22, 2007
||Some fixes on POP3READ file fields: subject, from, to.|
|October 17, 2007
||LogInOut is a new utility which provides a solution for application driven Login/Logout to/from WEB sessions. In other words, it is an alternate solution to that of using HTTP directives based on user profiles or validation lists for restricting the access to sensitive applications.|
|October 11, 2007
||Fixed a potential problem with the data queue "unique" name in program READDIR.|
|September 14, 2007
||Added command SETMAILLIB. This command populates a user library with the objects needed for developing MMAIL-based ILE-RPG programs.|
|August 27, 2007
||Troubleshooting topic added to MMAIL initial page. As a troubleshooting tool, CGI program DSPQZMFDTA (Display QZMF journal entries) has been made available.|
|August 21, 2007
||MMAIL - AMailer
||Added the Out-of-office tool. See this page.|
|August 10, 2007
||A new parameter (PDFNAME) has been added to command EMLSPL. It allows to assign the desired name to the generated PDF stream file.|
|July 8, 2007
||MMAIL - AMailer
||A new large utility has been made available in MMAIL: AMailer.|
AMailer is a free open-source WEB_Mail application for the iSeries.
It supports multiple users, both Local and Internet.
As with any other PC-based commercial mailer, users may receive and send mail messages, including attachments.
Please refer to the AMailer tutorial for more information.
|May 31, 2007
||New release available for V5R1 - Some performance enhancements. Measurements: CPU usage 22 times lower, response time 4.5 times shorter.|
|May 9, 2007
||New command sendmime was made available. It allows to mail -through a single MIME message- a combination of different types of objects: |
Up to 100 different pieces (objects) can be sent for each type of object.
- IFS stream files
- Database files
- Source file members
- Spool files
- Spool files converted to PDF
The MIME message can be sent up to 100 receivers.
This command was contributed by Paul Manners, United Kingdom.
|May 2, 2007
||Application Driven Protection - Some small changes to sample program LOGON, to make it more flexible for user customization.|
|April 3, 2007
||It was found that some undue (control) characters were generated in the texts of the received e-mail messages. That was due to API QDCXLATE, which is no longer used.|
|March 1, 2007
||Fixed a bug in subprocedure MimeSplPdf (used by command EMLSPL). The bug was generated in the January 19th release. MimeSplPdf was no longer able to convert a spool file to PDF when the preferred conversion tool happened to be CVTSPLSTMF.|
Besides it was found that in some cases the PDF's generated by CVTSPLSTMF within MimeSplPdf subprocedure could not be processed by Adobe (error 110). That was also fixed.
|January 19, 2007
||Subprocedure MimeSplPdf can now receive an optional parameter, the name to be assigned to the PDF file. This may result to more understandable names, when spool files converted to PDF's are attached to MIME messages. The code was contributed by Carlo Arnaboldi, Italy.|
|January 11, 2007
||Please note that the minimum OS/400 release to install MMAIL is V5R1. In the current release a fix has been added for boxes running V5R1. Command MMAIL/CHGJOBCSID used to call API QLGRTVDC (to compute the default CCSID from system value QLANGID). However, this API was made available with V5R2. An alternate solution has now been provided for V5R1 installations.|
|January 8, 2007
||A fix was applied to subprocedure pop3login which was entering a never ending loop in the case where the user or the password were rejected by the pop server.|
|December 21, 2006
||A new open source utility, an ILE-RPG POP Client allowing to receive and store on IFS directories mail messages from any POP Server, provided you know user names and passwords. See this page.|
|September 25, 2006
||A more recent version of command CVTSPLFPDF was made available. Command MMAIL/CVTSPLFPDF is based on two libraries: HPT and TIFFLIB. A more recent version of those two libraries was downloaded from site UZAEMON's Homepage.|
|September 13, 2006
||New MimeRtnPth subprocedure allows to generate MIME header Return-path. This header allows to specify an e-mail address where error messages (bounce messages) should be returned to. See page http://www.easy400.net/mmailh/srvpgm.htm#Q04.|
Warning. Programs referring service program mmail/sendmail may bump out after reinstalling library MMAIL and need to be re-compiled.
|August 11, 2006
||Command MMAIL/STREMLSPLF was added two more parameters in order to support the name and the e-mail address of the sender.|
|August 5, 2006
||Some users found that MIME files containing just attachment(s) but no message body used to be rejected by SPAM filters of receiving mailers. This was found to be due to a flaw in subprocedure "MimeImbNul (Imbed a null body)". That subprocedure was not providing a boundary delimiter.|
|July 28, 2006
||Command MMAIL/RESEND was fixed. It will no longer try to resend stream files in directory /mmail/temp other than mmail-generated MIME files.|
|July 26, 2006
||A bug was fixed in subprocedure "MimeSplPdf" (Convert a spool file to PDF and attach it to the MIME file). This procedure used to bump out when the spool file could not be found. In such a case, now this subprocedure would return without attaching the spool file and an error message would be logged on the external message queue.|
|May 22, 2006
|A design change has been implemented.|
In previous releases, the only user profile allowed to define SECTCP protections was QSECOFR. In many iSeries installations, however, QSECOFR user profile is not really accessible.
In this release, the only user profile allowed to define SECTCP protections is a USRCLS(*SECOFR) user profile identified during SECTCP installation.
Please note that installation of the new release of WSECTCP has as a prerequisite the installation of the new release of SECTCP (previously installed releases of SECTCP are no good for the new release of WSECTCP).
|May 2, 2006
||After the sending of an e-mail, the MMAIL service program was entering a delay job of 5 seconds. That was done to fix some unknown errors in the QTMMSENDMAIL API when subject to high frequence messaging.|
That delay job has now been removed. Instead, a timestamp is saved after a message has been sent. On the next message, the service program computes the time elapsed since the last previous message, and it makes sure it is at least 5 seconds.
In this way, users sending interactive messages would experience a better response time.
|February 15, 2006
||Two new WEB utilities made available. They allow a WEB user to work with spool files and writers. See this page.|
|February 11, 2006
||Fixes asked by some customers:|
- Fixed the srvpgm used by the Windows utility
- Some EML... commands were sending messages with attachments but without message body. An empty message body is now generated when no message body requested by the user. This should take care of some odd behaviors of the receiving mailers, as an user did report.
- The new 5250 utility MNGSPLF did run into problems when issuing commands CHGSPLFA or WRKSPLA with an OS/400 release older than V5R1, because the CRTDATE parameter was not supported. The installed OS/400 release is now tested, and the CRTDATE parameter is now provided from V5R1 on.
|January 9, 2006
||Several changes/ enhancements:|
- Minimum OS/400 req. now V4R5 (was V5R1)
- PDF manual available at http://www.easy400.net/mmail/manual/MMAIL_Manual.pdf
- Search engine available; maybe used for other sites
- command SPLTOPDF to convert spool files to PDF via your favorite conversion tool
- command MNGSPLF similar to WRKSPLF, but providing new input parameters, and allowing for spool file e-mail, and conversion to .txt, .html, and .pdf stream files.
|December 31, 2005
Blank copy adressees should not be reported in the destination headers of a MIME file. They should just be mentioned to the SendMail subprocedure.
In order to explain how this can be implemented, all the programs invoked from MMAIL/EML... commands have been updated in order to fulfill such "bcc" requirement.
|November 3, 2005
- On charge utility AFPTOOL is no longer distributed by MMAIL. It is still supported by MMAIL, but it should be downloaded from site BVS tools
- internal subprocedure rtvbndr (retrieve part boundary delimiter) was returning a blank boundary delimiter when not preceded by the internal subprocedure setbndr (set part boundary delimiter). The internal subprocedure setbndr is called by user subprocedure MimeMultiP, while the internal subprocedure rtvbndr is called by user subprocedures MimeWrtB (add a boundary record), MimeImbAtt (imbed or attach an IFS file), and MimeClose (Close a MIME file).
This used to result to the wrong MIME files (not understandable by the receiver) whenever the process building the MIME file was not using subprocedure MimeMultiP.
This is now fixed: in such cases a default part boundary delimiter is generated.
|August 18, 2005
||In the Easy400Group, Tom Graham reported that on V5R3 command CvtSplfPdf was receiving a QwpzHostPrintTransform error.|
After much investigation, he found that program HPT/SPL2STMFRP was missing to initialize some fields in a routine.
Tom Graham fix is included in this MMAIL release.
|August 17, 2005
||Version 1.3.0 of the Windows utility made available. See page www.easy400.net/mmailh/wmimemenu.htm .|
|August 12, 2005
||The installation procedure now allows also for Apache HTTP directives.|
|August 12, 2005
||Updated Apache HTTP directives.|
|August 5, 2005
||There was a problem with turkish language. In the multipart delimiter, the double quotes in BOUNDARY="..." were converted to Ü. The result was that the receiving mailer could not understand the subsequent headers, such as "Content-type: ...".|
The problem was fixed in this release.
|August 3, 2005
||EASY400 user profile no longer needed to run WebAct (iSeries WEB Access Toolkit).|
|August 1, 2005
||Changed the multipart delimiter. It was suspected being the reason for failures of some receiving mailers. The multipart delimiter now|
See procedures setBndr and rtvBndr in RPG module XXXMIME.
- has a different layout
- is no longer static, is dynamically built.
|July 29, 2005
||IBM has assigned maintenance and support of CGIDEV2 to the IBM profit center Client Technology Center.|
As a consequenceCGIDEV2 in no longer available for download from this Easy400 site (the download page provides a link to the CTC)All CGIDEV2 support should be asked to the CTC person in charge for that, Rich Diedrich.