Add a File Device

The following fields are prompted when you opt to add or change a F File device in Output Device Maintenance (XDM):

Field Name

Type / Max Length

Action / Description

Device name

Display

The device name you specified

Device type

Display

F File.

Actual device name

Required
8 alphanumeric

Enter the name of the device in your QICWARE system configuration (CSV, HTML, TXT, etc.)

The system will check the status of this device to verify that it is a real device.

CSV, HTML and TXT device types launch the associated Microsoft Windows program.

Device description

Optional
40 alphanumeric

Enter a description for this device. This description displays to the right of device name when you select an output device in a print program.

URL

Optional
128 alphanumeric

Enter the base path if you have a file name that is longer than the File name field.

File name

Conditional
30 alphanumeric

Enter the name of the file you want to create or leave blank to have the program prompt you for a name.

For a PC file, enter the full path name; for example: A:\FILE, C:\EXPORT\FILE, C:\FILE.TXT, or C:\FILE.CSV.

For a QANTEL sequential file, enter only the file name (8 characters maximum); the system will open or create the file on your data directory. You specify this directory in the Directory name field.

For HTML output, the system assigns the next available file name if you leave the field blank.

Directory name

Conditional
3 alphanumeric

Enter the directory name if you are creating a QANTEL sequential file (file type Q) or leave blank to use the work directory entered in the Work file directory option in the System Options Maintenance (XM) program (Enterprise Options).

File type

Optional
1 alphanumeric

Select the type of file to export:

Q QANTEL sequential file
P PC file
T Text file

If you are using this device for export-import programs, select P PC file.

Erase or append

Conditional/Optional
1 alphanumeric

If you selected Q for File type, select E to erase the existing file or select A to append records to the existing file.

If you are using this device for export-import programs, select E.

File format

Required
1 alphanumeric

Select	For
1	Print format
2	CSV file
3	Delimited file (you select delimiter)
4	HTML file
8	PS Schema

Optional HTML header

Conditional

Enables custom formatting of the header in PowerShift-generated email. The file !HTMLHDR is included as a sample. PROGTTL$ is replaced by the name of the program that generated the email PRTSYS$ is replaced by a timestamp when the email is generated.

Optional HTML footer

Conditional

Enables custom formatting of the footer in PowerShift-generated email. The file !HTMLFTR is included as a sample.

Headings/Total option

Optional

Select which headings to print and whether to print totals:

Select	To
Y	Skip all headings and totals
C	Print column headings and totals
N	Print page headings, column headings and totals
E	Print column headings but do not print totals

Whether or not you can change the fields below is dependent on file type and file format selected:

Change negative sign?

Conditional

Select to place the negative sign (-) to the left of the number or leave blank to place it to the right.

If the negative sign is to the right, Microsoft Excel does not consider the data to be numeric.

If you are using this device for export-import programs, leave blank.

Incl carriage return?

Conditional

Select if you want to place a carriage return at the end or leave blank if you do not.

If you are using this device for export-import programs, leave blank.

Field delimiter

Conditional

Enter the field delimiter.

The system does not validate the delimiter. Good delimiter choices are | (pipe character) and ; (semicolon).

You should not choose a character that is likely to appear in your data, such as these numeric symbols: [, (, ), -, %,], or these special characters: ), @, #.

If you are using this device for export-import programs, leave blank.

Quote string fields?

Optional

It is recommended that you select this option for CSV output: it causes string fields that contain the delimiter (e.g., ABC Company, Inc) to be enclosed in quotation marks.

Choose the appropriate options:

To	Do This
Change a field	Move the cursor to the field and make changes. Click Apply.to accept the changes or click Cancel to reject the changes.
Enter notes for this device	Enter Notes. See Enter Notes.
Display change history for the device	Click Audit. See Display an Audit Trail. This button is available only if audit trail logging is activated for the Output Device Parameters (DEVICE) file.
Test the device	Click Auto Test. This function is not available for most devices.
Accept the data and return to the list of devices	Click OK.
Exit the program	Click Exit.