Menu Path: System Administration Imports Orders Order Import
Import orders from external files.
Use Order Import to import sales orders instead of manually entering orders in Order Entry. You can import orders from a single file, or a batch of files.
For import format information, see Order Import Format.
To import orders:
Select the Batch radio button if you want to import orders from multiple files in a batch. If you want to import orders from a single file, leave the Single radio button selected.
Select whether you want to validate and import a file, or only validate a file.
If you want the import log file to only include errors, select the Log Errors Only check box.
If you want to use pricing entered in the import file instead of existing pricing, select the Override Price Lookup field.
If you selected the Batch radio button in step 1, enter the location of the files in the Import Directory field, and continue to the next step. If you left the Single radio button selected in step 1, enter the path and file name of the import file in the Import File field, and skip to step 10.
If you want to email the import report, enter the email address in the Email field.
Enter the file extension of the import files in the Import Extension field.
Enter the path and folder to which to move import files that successfully import in the Success Archive Directory field.
Enter the path and folder to which to move import files that do not successfully import in the Error Archive Directory field.
Click the Print Options tab, and select output options for the import report.
Click the Import or Validate button in the ribbon to start the import and/or validation process. The Importing dialog box appears. The import log is output based on the options you selected in step 10.
If the import file format is not correct, the import is not completed.
You can import from the following file types:
Excel (.xls, .xlsx, .xlsm, or .xlsb)
Note If you import from an Excel workbook that contains multiple worksheets, data is only imported from the first worksheet in the workbook.
comma-separated list (.csv)
text (.txt)
data (.dat)
Note To import a .csv file, enter your data in Excel, and then save the worksheet as a .csv file. Each field in a .txt or .dat file must be separated by a caret (^) character. There should be no spaces between each field in a .csv, .txt, or .dat file.
Button |
Description |
Exit |
Click this button to close the Order Import window. |
Import |
Click this button to start the import process. This button is only available if you select the Validate And Import radio button. |
Validate |
Click this button to start the validation process. This button is only available if you select the Validate Only radio button. |
Import Override Maintenance |
Click this button to display Import Override Maintenance, which allows you to set the default processing and file type options for the import window. |
Field or Button |
Description |
Select one of the following options:
|
|
Select one of the following processing options:
|
|
Select this check box to only include errors in the import log file. If this check box is cleared, the log file also includes warnings and status notifications. NOTE If you select this check box, import orders via Scheduling Assistant, and output to email, email is only sent if there are errors. If you clear this check box, import orders via Scheduling Assistant, and output to email, email is sent for all import processes, including successful imports. |
|
If this check box is cleared, prices are determined as if the order was manually entered. Select this check box to determine prices as follows:
Note Zero is different than blank.
|
|
Enter the path and file name containing the data to be imported, or click the Lookup button to navigate to and select the file. This field is only enabled if you select the Single radio button. |
|
Enter an email address to which to send the import report, or click the Lookup button to select the email address. This field defaults to the email address entered in the Email field in Customer Service Control Maintenance. This field is only enabled if you select the Batch radio button, and only used if you select the Email radio button on the Print Options tab. |
|
Enter the path and folder that contains the files you are importing, or click the Lookup button to navigate to and select the folder. This field defaults to the folder entered in the Import Directory field in Customer Service Control Maintenance. This field is only enabled if you select the Batch radio button. |
|
Enter the file extension for the import files. This field defaults to the file extension entered in the Import Extension field in Customer Service Control Maintenance. This field is only enabled if you select the Batch radio button. Example txt |
|
Enter the path and folder into which to move import files that successfully import, or click the Lookup button to navigate to and select the folder. This field defaults to the folder entered in the Success Archive Directory field in Customer Service Control Maintenance. This field is only enabled if you select the Batch radio button. |
|
Enter the path and folder into which to move import files that do not successfully import, or click the Lookup button to navigate to and select the folder. This field defaults to the folder entered in the Error Archive Directory field in Customer Service Control Maintenance. This field is only enabled if you select the Batch radio button. |
|
Enter the path and folder into which to save part of import files that successfully import, or click the Lookup button to navigate to and select the folder. This field defaults to a subfolder called segment in the folder entered in the Success Archive Directory field in Customer Service Control Maintenance. This field is only enabled if you clear the Require Complete Order Validation check box. |
|
Enter the path and folder into which to save part of import files that do not successfully import, or click the Lookup button to navigate to and select the folder. This field defaults to a subfolder called segment in the folder entered in the Error Archive Directory field in Customer Service Control Maintenance. This field is only enabled if you clear the Require Complete Order Validation check box. |
|
Select this check box to only import orders if there are no errors during the import process. If this check box is cleared, order import files can be partially imported with successfully imported order data saved to the folder entered in the Success Segment Directory field, and data for orders with errors saved to the folder entered in the Error Segment Directory field. Example An order import file contains 600 orders. There are errors for 30 of the orders. If you select this check box, none of the orders are imported. If you clear this check box, 570 orders are imported and 30 are not imported. This check box is selected or cleared by default based on whether the Require Complete Order Validation check box is selected or cleared in Customer Service Control Maintenance. |
Field or Button |
Description |
Select one of the following output options:
Note If you select this option and are importing a batch of orders, you can enter the email address to which to send the import report in the Email field on the Main tab. If you do this, you are not prompted to select recipients.
|
|
Output File Type |
|
Specify File Name |
|
Output Directory |
Enter the location for the output report, or click the Lookup button to navigate to and select a location. This field is only available if the Specify File Name check box is cleared. |
Output File Name |
|
Excel Format Name |
|
Format Maintenance |
Click this button to display Excel Format Maintenance, which allows you to set up Excel formats. This button is only available if you select the Excel radio button. |
Save As Type |
|
Include header |
|
Delimiter |
|
Enclosing Character |
|
Printer |
|
Process |
Select whether the task is run now or run by Scheduling Assistant. If you select the Schedule radio button, you can specify when the task occurs, and optionally set up an alert to be created when the task completes. These radio buttons are only enabled if the Disable Scheduling Assistant check box is cleared for your user ID in User Profile Maintenance. Note If you select the Schedule radio button, you cannot output to the screen. |
Time |
|
Date |
|
Task Occurs |
Select one of the following options:
These radio buttons are only enabled if you select the Schedule radio button. |
Frequency |
These radio buttons are only available if you select the Every radio button. |
Day of Week |
|
Repeat Every X Days |
|
Repeat On |
|
Repeat Every X Minutes |
|
Triggering Task Id |
|
Triggering Task Name |
|
Triggering Task Description |
|
Task Description |
|
Scheduling Assistant Queue |
Enter an active Scheduling Assistant queue for the task, or click the Lookup button to select a Scheduling Assistant queue. This defaults to the default queue for your user ID. This field is only enabled if you select the Schedule radio button, and you are assigned to a queue other than the Default queue. |
External Email |
|
Screen Alert |
|
Internal Email |
|
Report Files |
This grid displays report files set up for the report, and is only available if report files are set up for the program in Report File Maintenance. This grid includes the following columns:
|