Once you have defined a mask and saved it to disk, you can perform a DataImport translation from a command line by using the following syntax:
DIW mask,input,output,type,display,confirm/A /C
For the parameters for the DIW command:
- Separate parameters with commas.
- To skip a parameter, type a comma in its place.
- The switches, /A and /C, are not positional and are not separated by commas.
- The only required parameter is mask, the mask file name. If no other parameters are specified, DataImport uses the parameters from when the mask was created or last saved. If a parameter is not specified either on the command line or in the mask, the translation cannot proceed. DataImport aborts the translation and displays a message that indicates which parameters are missing or invalid.
Parameters:
- mask - The mask file name, including the path if necessary. This is the only required parameter.
- input - The input file name, including the path and extension if necessary.
- output - The output file name, including the path if necessary. If you specify an extension, DataImport uses that extension instead of the normal one for the type of translation.
- type - Type of translation to be performed. You can choose any of the following types:
- For both version 5.0 and 6.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
- For version 5.0 only:
- DB35: Paradox 3.5
- DB: Paradox 4.0
- For version 6.0 only:
- XLS8: Microsoft Excel version 8.0 (97/2000/XP)
- MDB3: Microsoft Access 3.0 (97)
- MDB4: Microsoft Access 4.0 (2000/XP)
- XML: XML Table
- NVL: Named Value
- display - whether to display the output on screen during translation: Y for yes, N for no. The default is yes.
- confirm - 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 - append the output of the translation to the end of an existing output file.
- /C - combine the output of the translation into an existing spreadsheet output file.
Examples:
Example 1:
To perform a translation with the following parameters:
- Mask file name: MYMASK
- Input file name: DIDEMO.TXT
- Output file name: SALESDAT
- Translation type: XLS
- Display: Yes
- Confirm include/exclude: Yes
- Append to existing file
Use the following command line:
DIW MYMASK,DIDEMO.TXT,SALESDAT,XLS,Y,Y/A
Example 2:
To perform a translation with the following parameters:
- Mask file name: MYMASK
- Use the input file name specified in the mask
- Use the output file name specified in the mask
- Translation type: XLS
- Display: Default (yes)
- Confirm include/exclude: Default (no)
Use the following command line:
DIW MYMASK,,,XLS
Example 3:
To perform a translation with the following parameters:
- Mask file name: MYMASK
- Use the input file name specified in the mask
- Use the output file name specified in the mask
- Use the translation type specified in the mask
- Display: Default (yes)
- Confirm include/exclude: Default (no)
Use the following command line:
DIW MYMASK
Example 4:
To perform a translation with the following parameters:
- Mask file name: MYMASK
- Input file name: ORIGINAL.DAT
- Output file name: GOOD
- Use the translation type specified in the mask
- Display: Default (yes)
- Confirm include/exclude: Default (no)
- Combine the file
Use the following command line:
DIW MYMASK,ORIGINAL.DAT,GOOD/C