Versions Compared

Version Old Version 3 New Version Current
Changes made by

Michelle Cabaya

Amy Mangueira

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Import Audit Log lists imports and results. Here you can find information on your integration import into spatch the Operations App such as making sure the import was successful if there were any failures and errors, or when the import was processed.

To get to the Import Audit Log go to X Stream Maintenance > Import Audit Log.

...

Field Name

Description

Process Date

The date and time that the activity occurred.  For example, with a Type of ASN, this time represents when the file imported route stops into the system.

Import PKID

Unique ID number, associated to each activity. 

Customer ID

The customer ID associated to the activity.

LastProcessedTime

The date and time that the import was last processed. This is updated after every order/route stop is imported.

Type

The type of import:

  • ROWS: Order import done by using the Remote Order Web Service.

  • ON_DEMAND: Order import.

  • CANCELED: Order import that was canceled and removed from the system.

  • ASN: Route stop import.

  • UNPOST: Route stop import that was unposted from the system

.ImportPKID: Critical error. You will need to contact Technical Support to troubleshoot this type

  • .

Total Successful

Total number of successful orders or route stops imported. Updates per every order/route stop imported.

Total Failed

Total number of failed order or route stop imports.

TotalConsolidated

Total number of consolidated orders or route stops imported. Updates per every order/route stop posted.

IP Address

IP address of where the files were imported from.

If a CANCELED or UNPOST action is taken, this field will display the username of the person who completed the action.  

Import File Name

Directory path to the processed folder where the imported file is located.

If a CANCELED or UNPOST action is taken, this field will display information about the ASN or ON_DEMAND entry removed, including the corresponding Import PKID for the work. 

Errors

A clickable icon that will bring up a window providing the error information if there were any errors when processing, or the XML post info for a ROWS type. 

Alternate Lookup

Alternate Lookup of the customer associated with the import. See Customer Alternate Lookup.

How to View Imported Orders or Route Stops

  1. Go to Maintenance > Import Audit Log.

  2. Click the action menu for the imported orders or route stops and select the Find… that you want to view.

Action Menu

ASN menu:

  • Find Imported Route Stops

  • Unpost Imported Route Stops 

Warning

Unposting imported route stops will delete the imported route stops, and cannot be undone.

On-Demand menu:

  • Find Imported On-Demand Orders

  • Remove Imported On-Demand Orders 

Warning

Removing imported on demand On-Demand orders will delete the orders, and cannot be undone.

...

To view the error text double click on the link in the Errors column. This will open the ImportError.txt file in Notepad ++. 

Tip

Quick Tips

  • Any routed imports that fail due to a deadlock will be unposted to prevent partial stops from being created. You can re-run the failed file to complete the import.

  • For ASN or On-Demand type imports, find "<ErrDescription>".

Troubleshooting

Expand
titleErrDescription: Processing orders not allowed outside your customer list

Problem:  The Internet User for the integration does not have permission to create orders or route stops for the specified Customer ID.  Internet User credentials are required to authenticate the request to insert orders and route stops into your system for a given customer.

Solution:  Open the Internet User record (Maintenance > Internet Users), used for the integration in question.  Check the "Allowed Customer Accounts" list, and ensure the checkbox is marked for all additional customers to be used for the integration configuration.

...