IBM i Series, Handbook

Page: 718 / 908

IBM Licensed Programs: Networking Products
688
iSeries Handbook
• The Data Transfer GUI now supports an “auto-run” option. This enables a user to
create a transfer request, and perhaps place an icon on the desktop for this request.
Then they can simply double-click the icon, and the transfer will “auto-run” without
additional user intervention. This transfer can also be placed in a start-up session.
• For PC file upload requests, a wizard (on the toolbar icon and on the Data Transfer
Tools menu) can be used to interrogate the PC file layout, present the user with a
recommended iSeries and file layout (that the user can modify), and create the new
iSeries database file definition to receive the uploaded file. Previously, users had to
determine and create the iSeries database file definitions on the iSeries before using
Data Transfer.
• Database information can now be inserted directly into a section of an existing HTML
file. This enables a user who has a Web page of text containing a section with
database data to “update” the data while leaving the rest of the Web page text intact.
Previously, the entire HTML file was replaced with a table containing the database
data.
• The ability to control truncation of trailing spaces when transferring ASCII text files is
now provided. Previously, Data Transfer truncated automatically trailing spaces.
• Support for new iSeries DATALINK commands for linking to HTML tables is now
available.
• New transfer profile types (.DTF and .DTT) have been created that are .INI file-based
and easier to use and service. The previous file types (.TTO, .TFR, .DT, and .RTO) are
also supported.
Data Transfer – New with V5R1
The features that have been added to Data Transfer are:
• For Microsoft Excel users:
– Support for Excel 2000 file types (8.0). These file types were also added to the Create
iSeries Database File wizard. This enables users to read and write records to multiple
sheets within a single workbook.
– An upload option (in addition to already available download option) was added. The
upload can be selected via a new icon/button on the Client Access toolbar, a new
menu option on the Excel “Data” pull-down menu called “Transfer Data To iSeries...”
and a new dialog similar to the current download dialog, which allows the user to
specify what data to upload and where to upload it.
– Support for numeric formula cells in Excel sheets. Previously the formula cells were
ignored, and the default value of the field type was used. Data Transfer now
determines if the formula is for a numeric value. If so, it pulls the result of the formula
from the cell and passes it to the iSeries database file. If the formula does not resolve
to a numeric value, Data Transfer continues to pass the default value for the cell type.