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.

See Getting Started for the standard import steps, and Excel File Format for the expected file structure.

Sample file	Purpose
example-import.xlsx	Standard import sample — use this first to set up master data
example-asis-import.xlsx	ASIS import sample — use this after the standard import is done

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 must contain two sheets: Flows and Opened Facilities. In both sheets, row 1 is treated as the header and data begins from row 2.

Flows Sheet

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

Opened Facilities Sheet

Column	Type	Values	Required	Description
Facility	String	-	Required	Facility name that is open in the ASIS network (must match a registered Facilities.name)

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.
• Open facilities are taken from the Opened Facilities sheet, not inferred from the Flows sheet.
• Any facility with non-zero flow must be listed in Opened Facilities. Facilities marked Include in the registered master data are always treated as open.
• 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	2 sheets
Prerequisites	None	Standard import must be completed first
Result handling	Results generated after running optimization	Results registered directly at import time