tcl.export Verb: Access/DOS


Command tcl.export Verb: Access/DOS
Applicable release versions: AP/DOS, AP/Native
Category DOS (25)
Description converts Advanced Pick files on either AP/DOS or AP/Native systems to a DOS format in a DOS file.

"file.reference" is the source Pick file name.

"" is the item to transfer. If no item-id is entered, then the system will ask: "Selected Pick Item:".

"dir.path" is the path to the DOS directory into which the file is to be copied. If none is specified, it defaults to the current working directory.

"DOS.file" is the name of the MS-DOS file to which the Pick item will be copied. Complete pathnames must be used if the files are not to be copied into the current working directory. If the name of the destination file is not provided, the item-id is used as the name of the destination file.

If a directory is specified, no spaces may be specified between "dir.path" and "DOS.file". The directory must be preceded by a "". For example: c:pickdosfile.pik

By using an active select list, multiple items can be transferred.
Syntax export file.reference {(options}
to: {dir.path}{DOS.file}
Options c Concatenate Pick item(s) into one DOS file. Items will not be separated by any character, unless the E-option is used.
e Append item delimeter to each Pick item. Only takes effect when used with the C-option. The system will ask: "Enter record separator (in hex):" for a (single) separator character between items.
i Includes item-ids as the first attribute (field) in the destination file.
k Disables conversion of attribute marks to cr/lf characters. To convert attribute marks to some other (single) character, use the 't' option below.
n Sort items before exporting.
o Overwrite dos file, if a duplicate exists.
p Directs output to the system printer, via the Spooler.
s Use Pick ids as dos file names.
t translate specific (single) characters to new (single) characters. The system will ask: "Replace: ". The user enters the ASCII value (in hex) of the character to scan for. An entry of <cr> will quit the replace session. The system will then ask: "With: ". The user enters in the new replacing ASCII value (in hex). The system will ask for up to 15 additional characters to replace. If the same character is entered twice, only the most recent entry is used. The system will finally ask: "OKAY(Y/N): ". An answer of "Y" indicates all the entries are correct. An answer of "N" will wipe out all the entries and start over.
export cust * (cinokte
Preparing item to export, please wait...
[404] nnn items selected out of nnn items.
Enter DOS record separator in hex: 0c
Replace: FE
With   : 2C
Replace: FD
With   : 5F
Replace: <cr>
Selected pick item(s) to Dos File Name: B:CUST.DAT
Copying data to DOS, please wait...
   nnnnnn bytes copied
MS-DOS file 'B:CUST.DAT' created.

This will:
  export all the items in the pick file "cust",
  write it to the DOS file "CUST.DAT" on the B: drive,
  concatenate all the items into one file,
  export the item-id along with the attributes,  
  sort the cust file first before exporting,
  overwrite any previously existing DOS "CUST.DAT" file,
  don't convert attribute marks with a carriage return / line feed,
  replace all the attribute marks with a comma,
  replace all the value marks with the underscore character, and
  replace the item delimiter with a carriage return (but no line feed).
Related tcl.import