DataImport Translate Command Line (version 5 & version 6)
From Support
| If you have a question or seek clarification, please call Technical Support. |
Contents |
Problem:
Using DataImport via the command line
Solution:
Once a Mask has been defined and saved to disk, the translation can be performed using command line controls. Syntax:
DIW mask[,[input],[output],[type],[display],[confirm]][/A] [/C]
The command line parameters that follow the DIW command are positional and separated by commas. If a parameter is skipped, a comma must be used to hold its place. The switches, /A and /C, are not positional and are not separated by commas.
mask Mask File name, including the path if necessary. This is the only required parameter. If no other parameters are specified, the parameters specified when the mask was created (or last saved) will be used in the translation.
input Input File name, including the path and extension if necessary.
output Output File name, including the path if necessary. If an extension is specified, it will be used rather than the file extension DataImport normally uses based on the type of translation.
type Type of translation to be performed. Any of the following types can be specified:
Version 5.0
- WKS: Lotus 123 release 1 and 1A
- WK1: Lotus 123 release 2.x
- WK3: Lotus 123 release 3.x
- WK4: Lotus 123 release 4.x and 5.x
- WRK: Symphony release 1.0
- WR1: Symphony release 1.1, 1.2 and 2.x
- WKQ: Borland Quattro
- WQ1: Borland Quattro Pro
- WB1: Borland Quattro Pro 5.0 for Windows
- XLS: Microsoft Excel version 2.1
- XLS3: Microsoft Excel version 3.0
- XLS4: Microsoft Excel version 4.0
- XLS5: Microsoft Excel version 5.0 and 7.0.
- DBF: dBase III
- DBF2: dBase II
- DBF3: dBase III
- DBF4: dBase IV
- MDB1: Microsoft Access 1.1
- MDB: Microsoft Access 2.0
- DB35: Paradox 3.5
- DB: Paradox 4.0
- DAT: Clarion
- DIF: Columnwise DIF
- CDIF: Columnwise DIF
- SLK: SYLK or Symbolic Link
- PRN: Print Image
- HTM: HTML Table
- ASC: Comma separated with quotes around strings
- CSV: Comma Separated Variable
- SDF: Standard Data Format
- FXD: Fixed record format without delimiters
- TSV: Tab separated variables
- UDD: User-defined delimited
- TXT: ASCII text file
- LBL: Mailing label format
- WRD: Microsoft Word data document
- W50: Word Perfect 5.0 secondary merge file
- W51: Word Perfect 5.1 secondary merge file
Version 6.0
- WKS: Lotus 1-2-3 release 1 and 1A
- WK1: Lotus 1-2-3 release 2.x
- WK3: Lotus 1-2-3 release 3.x
- WK4: Lotus 1-2-3 release 4.x and 5.x
- WRK: Symphony release 1.0
- WR1: Symphony release 1.1, 1.2 and 2.x
- WKQ: Borland Quattro
- WQ1: Borland Quattro Pro
- WB1: Borland Quattro Pro 5.0 for Windows
- XLS: Microsoft Excel version 2.1
- XLS3: Microsoft Excel version 3.0
- XLS4: Microsoft Excel version 4.0
- XLS5: Microsoft Excel version 5.0 and 7.0.
- XLS8: Microsoft Excel version 8.0 (97/2000/XP)
- DBF: dBase III
- DBF2: dBase II
- DBF3: dBase III
- DBF4: dBase IV
- MDB1: Microsoft Access 1.1
- MDB: Microsoft Access 2.0
- MDB3: Microsoft Access 3.0 (97)
- MDB4: Microsoft Access 4.0 (2000/XP)
- DAT: Clarion
- DIF: Columnwise DIF
- CDIF: Columnwise DIF
- SLK: SYLK or Symbolic Link
- PRN: Print Image
- HTM: HTML Table
- XML: XML Table
- ASC: Comma separated with quotes around strings
- CSV: Comma Separated Variable
- SDF: Standard Data Format
- FXD: Fixed record format without delimiters
- TSV: Tab separated variables
- UDD: User-defined delimited
- TXT: ASCII text file
- LBL: Mailing label format
- WRD: Microsoft Word data document
- W50: Word Perfect 5.0 secondary merge file
- W51: Word Perfect 5.1 secondary merge file
- NVL: Named Value
display specifies whether the output is to be displayed on screen during translation: Y for yes, N for no. The default is Yes.
confirm specifies whether Include Line and Exclude Line treatments must be confirmed manually during the translation. Y for yes, N for no. The default is No.
/A-Appends the output of the translation to the end of an existing Output File.
/C-combines the output of the translation into an existing spreadsheet Output File.
Note :The only required parameter is the Mask File name. If no other parameters are specified, the parameters defined when the mask was created or last saved are used.
To specify some parameters and not others, include the intervening commas as place holders. This is necessary to indicate to DataImport which of the options you want to use. For example, if you want to use the name of the Input File stored with the mask, but want to change the name of the Output File, you would place two commas before the name of the new Output File. Otherwise, DataImport would interpret the file name as an Input File. Commas, however, are unnecessary as place holders before the /A and /C parameters.
If a parameter is not specified on the command line and the parameter has not been specified in the mask, the translation cannot proceed. In such cases when DataImport aborts the translation, a message is displayed on the screen to indicate the missing or invalid parameter(s).
Examples
Example 1:
To perform a translation from the command line using the following parameters:
Mask File name MYMASK Input File name DIDEMO.TXT Output File name SALESDAT Translation type XLS Display on Y (Yes) Confirm include/exclude Y (Yes) Append to existing file /A
The command line should read:
DIW MYMASK,DIDEMO.TXT,SALESDAT,XLS,Y,Y/A
Example 2:
To perform a translation from the command line, use the following parameters:
Mask File name MYMASK Input File name as specified in the mask Output File name as specified in the mask Translation type XLS Display on default to yes Confirm include/exclude default to no
The command line should read:
DIW MYMASK,,,XLS
Example 3:
To perform a translation from the command line, use the following parameters: Mask File name MYMASK Input File name as specified in the mask Output File name as specified in the mask Translation type as specified in the mask Display on default to yes Confirm include/exclude default to no The command line should read:
DIW MYMASK
Example 4:
To perform a translation from the command line, use the following parameters:
Mask File name MYMASK Input File name ORIGINAL.DAT Output File name GOOD Translation type as specified in the mask Display on default to yes Confirm include/exclude default to no Filecombine /C
The command line should read:
DIW MYMASK,ORIGINAL.DAT,GOOD/C
