File Transfer Tips and Troubleshooting
File Transfer Tips and
Troubleshooting
U2 Data Management Solutions 1099 18th St., Suite 2500 Denver, CO 80202 Phone: 303.294.0800 FAX: 303.293.8880
Contributors Kenny Brunel, Alan Buckley, Trevor Grover, Tim Rasmussen, Ed Robb,
David Robertshaw, Susie Siegesmund
U2 DATA MANAGEMENT SOLUTIONS
Contents Checking the Version of the Host Routines ........................................................................1 Debugging Binary File Transfers......................................................................................... 3 Exploding Multi-valued Fields Horizontally ......................................................................5 File Transfer Problems When using Pick D3......................................................................9 File Transfer Restrictions ...................................................................................................10 How to Disable File Transfer Options on the Run Menu in wIntegrate 3.0 and 98........12 How to Use FTP to Transfer Files .....................................................................................18 How Translation Works when Importing a File ...............................................................24 Importing ASCII (Flat) Files to Lotus or Excel ................................................................29 Importing Multi-Valued Attributes....................................................................................32 Large Files Won't Import....................................................................................................34 Left-Justifying Numeric Values During an Import...........................................................35 Number Conversion and Normal/Reformat Mode Options During an Import ...............38 Problems Parsing Data During a File Transfer .................................................................44 Problems Transferring Files After Client Upgrade...........................................................48 Problems with File Transfers on UniVerse .......................................................................49 'Unable to Find Target Session Window' ..........................................................................50 Using ASC Format When Importing or Exporting...........................................................52 Using FIX Format When Importing or Exporting ............................................................54 Using Kermit for File Transfers.........................................................................................56 Using the Report Wizard ....................................................................................................59 What 'Mode' Does When Importing Data .........................................................................68
- I -
U2 DATA MANAGEMENT SOLUTIONS
wIntegrate Tech Tips
Checking the Version of the Host Routines
Often, problems encountered when transferring files with wIntegrate are a result of mismatched versions of the host routines compared to the wIntegrate program running on the PC. Common problems include Check Sum errors, and other "peculiar" behavior. Follow these simple steps to check the versions of wIntegrate on both the host and the PC.
Checking the version of wIntegrate on the PC:
From the wIntegrate Main Menu, click on the Help menu item and select the "about" option. The welcome screen will be displayed with information about the license, including the version of wIntegrate.
- 1 -
U2 DATA MANAGEMENT SOLUTIONS
Checking the version of the wIntegrate program on the Host:
At the TCL prompt type WIN.TRANSFER. This will display: 868ConnectOK
Anything you type now will not be echoed to the screen, so type carefully. Type: 742Version (Note that the "V" is uppercase) You will now see some text displayed looking something like:
316PVER3.0.05 27/11/97 (UD) The highlighted portion of this, VER3.0.05 is the version of the host routines installed on that system. If the host routines are older than the version of the program you're running on your PC, you must upgrade the host routines. For instructions on installing the wIntegrate host routines, please refer to the "Using wIntegrate" manual. To get back to the TCL prompt, press enter once and then type:
215END (Note that "END" is all uppercase)
- 2 -
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.