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

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016