Set Drop File Import Options

This topic applies to System Options Maintenance (XM) options for automating the import of BOMs, EDI 820s, EDI 850s, Manifests, Projects and XML updates.

Whether or not you automate data import via drop files, you can run import programs from the PowerShift menu. The options you set when you run an import program interactively override the options you set for automated imports.

Information about the import process, validation, and file format is included in the following topics:

Interface Requirements:

Drop file interfaces each require three native directories (i.e., work, drop, and archive)
The *SECURE password must have access to the work, drop and archive directories
Different applications can share work, drop and archive the directories; a file prefix should be used to identify file type. See File prefix.
When the interface is first activated or if the configuration is changed, you will need to restart the interface or shutdown and restart PowerShift.

Interface Options:

Set these options for your enterprise:

Field Name	Type / Max Length	Action / Description
Drop file interface active?	Optional	Select if you want to actively poll a drop file directory to automate importing data.
Drop files logging?	Optional	Select if to include information for troubleshooting interface issues. Leave blank unless directed by PowerShift Support.
Interface admin email	Required 128 alphanumeric	Enter the email address of the person who should receive error messages regarding the interface. These are not data-related errors; rather, they pertain to problems with the incoming file (e.g., the file is not formatted correctly) or setup issues (e.g., the user does not have access to the drop file directory specified).
Interface admin device	Required	Select the device to use for interface errors. The device must be email (device type L Email) with 6 HTML in body of the email selected as the Email attachment format in Output Device Maintenance.
Work directory	Required 3 alphanumeric	Enter the directory to which drop files are copied for the use with the update program.
Drop directory	Required 3 alphanumeric	Enter the directory into which files are "dropped" (i.e., this is the directory that PowerShift will poll for drop files).
Archive directory	Optional 3 alphanumeric	Enter the directory to which drop files are archived. Archived files can be viewed in the Interface Log Inquiry (WLOG) program. If you do not specify an archive directory, the drop file is not retained.
Archive base path	Conditional	Enter the location of the archive directory.
File prefix	Required 3 alphanumeric	Enter the prefix for import files. These standard prefixes are recommended: BOM for bill of material XML for XML MAN for manifest 820 for EDI 820 850 for EDI 850 PSI for projects
Delimited or Fixed length	Required	Select D Delimited if data in the drop file is delimited; select F Fixed length if the data is in fixed length fields.
Field delimiter	Conditional 1 alphanumeric	If the data in drop files is delimited, enter the field delimiter such as the \| (pipe character). Enter T if the file is tab-delimited.
Polling interval	Required 4 numeric maximum	Enter the number of "system" seconds for the interval between checks for drop files. An entry of 0 is treated as 10.
Device for log/reporting	Conditional	Select the device to use for transaction logs (i.e., number of records successfully processed) and reports from the interface. The device must be email (device type L Email) with 6 HTML in body of the email selected as the Email attachment format in Output Device Maintenance. Note If you do not want a log sent, leave both Device for log/reporting and User ID for log/reporting blank.
User ID for log/reporting	Conditional	Select the user ID of person who should receive transaction logs (i.e., number of records successfully processed) and reports from the interface. Note If you do not want a log sent, leave both Device for log/reporting and User ID for log/reporting blank.
Device for data errors	Required	Select the output device to use for data-related errors. The device must be email (device type L Email) with 6 HTML in body of the email selected as the Email attachment format in Output Device Maintenance.
User ID for data errors	Required	Select the user ID of person who should receive notification of data-related errors found during the import (e.g., vendor number is invalid, purchase order already exists).
Default user ID	Required	Select the user ID to use as the default user ID.
Default branch	Optional	Select the branch to use as the default branch.
The bill of material and manifest import interfaces also prompt for:
XMAP format	Required 10 alphanumeric	The format specified in Format Mapping Maintenance (XMAP) for the incoming files. Applicable to bill of material and manifest import only.

Choose the appropriate options:

To	Do This
Set additional options	Click Other info. This button is only available for EDI 850 drop file options. See EDI 850 Options.
Change an option	Move the cursor to the appropriate field and make the required change.
Exit without changing these options	Click Cancel.
Print these options	Click Print. See Print an Inquiry.
Accept these options and exit	Click OK.

Choose the appropriate options when you click OK or Cancel:

To	Do This
Display a category of options	Highlight the line and click Select or double-click the line.
Exit the program	Click Exit.