Importing ASIS Data

TIP

ASIS import lets you load your current (as-is) supply chain flows as result data, so you can compare them directly against optimized results.

What Is ASIS Import?

ASIS import registers actual transportation flows as results against a scenario that already has network configuration data imported. This lets you see the as-is network alongside the optimized network in Analytics and Maps screens side by side.

Prerequisites

The target scenario must have data already imported via the standard import before you can use ASIS import. If location, product, and transportation mode master data are not registered, the import will fail.

Import Steps

1. Open the Data tab.
2. Click Upload ASIS data in the left-hand menu.
3. Click CHOOSE FILE, select your ASIS flow Excel file, then click Import.

TIP

Download the sample ASIS Excel file to use as a starting point.

Excel File Format

The ASIS import file consists of a single sheet (any sheet name is accepted). Row 1 is treated as the header; data begins from row 2.

Column Specification

Column	Type	Values	Required	Description
From	String	-	Required	Origin location name (must match a registered Locations.name)
To	String	-	Required	Destination location name (must match a registered Locations.name)
Product	String	-	Required	Product name (must match a registered Products.name)
Mode	String	-	Required	Transportation mode name (must match a registered Transportation Modes.name)
Flow	Float	-	Required	Flow quantity (must be 0 or greater)
Flow Unit	ProductUnit	pcs	Required	Unit for the flow quantity

Validation Rules

• From, To, Product, and Mode must all match master data already registered in the target scenario.
• Rows with duplicate (From, To, Product, Mode) combinations will be rejected.
• Flow must be a non-negative number; negative values are not allowed.
• The backend also checks flow conservation, supplier capacity limits, and other constraint consistency.

Differences from Standard Import

	Standard Import	ASIS Import
Purpose	Register network topology, costs, and constraints	Register current flow actuals as results
Sheets	20+ sheets	1 sheet
Prerequisites	None	Standard import must be completed first
Result handling	Results generated after running optimization	Results registered directly at import time