/
AXIODIS standard MIA streams
AXIODIS standard MIA streams
For a reminder, AXIODIS MIA connector is able to support a lot of formats to be interfaced with 3rd systems as for instance :
- WS (Web-service)
- CSV
- TXT
- XML
- Database (SQL Server, Oracle, MySQL, DB2, ...)
- ...
This page describes how to use standard MIA streams provided by AXIODIS (CSV format) in order to be able to import easily and quickly standard data for Axiodis :
- Logistic sites and constraints
- Products and constraints
- Resources (drivers, trucks, trailers, ...) and constraints
- Transport operations
- ...
AXIODIS standard MIA streams (CSV)
Axiodis propose a set of standard streams to import quickly and easily data into AXIODIS based on the following :
- Those streams are automatically deployed and proposed in the Axiodis standard installation
- Those streams are build to import CSV files (easy to build from and with an Excel file)
- A macro is provided to convert files automatically in CSV format for AXIODIS (for instance when built with Excel)
- The "XML" file corresponds to the MIA stream automatically deployed on Axiodis Server by the installer ("...\Axiodis6\Installation_Name\data\mia\flux" by default)
- The "xlsm" file corresponding to the template of the file to use to import data (from another excel file for instance) with a legend describing how to use it
Standard streams download
Please visit the /wiki/spaces/APT/pages/574226516 to download the standard streams and tutorial.
Standard streams description
Name | Theme | Description | Type |
---|---|---|---|
01 - Import LOGISTIC AREAS | Logistic areas | Standard CSV stream to import logistic areas in Axiodis | CSV MIA stream |
02 - Import LOGISTIC PROFILES | Logistic sites | Standard CSV stream to import logistic profiles in Axiodis | CSV MIA stream |
03 - Import LOGISTIC PROFILES CHARACTERISTICS | Logistic sites | Standard CSV stream to import logistic profiles characteristics in Axiodis | CSV MIA stream |
04 - Import TIME PROFILES | Logistic sites | Standard CSV stream to import time profiles in Axiodis | CSV MIA stream |
05 - Import PRODUCTS FAMILIES | Products | Standard CSV stream to import product families in Axiodis | CSV MIA stream |
06 - Import PRODUCTS | Products | Standard CSV stream to import products in Axiodis | CSV MIA stream |
07 - Import SITES GROUPS | Logistic sites | Standard CSV stream to import sites groups in Axiodis | CSV MIA stream |
08 - Import SITES | Logistic sites | Standard CSV stream to import logistic sites in Axiodis | CSV MIA stream |
09 - Import LOGISTIC SITES AREAS | Logistic sites | Standard CSV stream to import the logistic areas of the sites into Axiodis | CSV MIA stream |
10 - Import PROVIDERS | Resources | Standard CSV stream to import providers in Axiodis | CSV MIA stream |
11 - Import VEHICLE TYPOLOGIES | Resources | Standard CSV stream to import vehicle typlogies in Axiodis | CSV MIA stream |
12 - Import VEHICLE TYPOLOGIES CHARACTERISTICS | Resources | Standard CSV stream to import vehicle typlogies characteristics in Axiodis | CSV MIA stream |
13 - Import TRUCKS | Resources | Standard CSV stream to import trucks in Axiodis | CSV MIA stream |
14 - Import TRUCKS AREAS | Resources | Standard CSV stream to import trucks logistic areas in Axiodis | CSV MIA stream |
15 - Import DRIVERS | Resources | Standard CSV stream to import drivers in Axiodis | CSV MIA stream |
16 - Import DRIVERS AREAS | Resources | Standard CSV stream to import drivers logistic areas in Axiodis | CSV MIA stream |
17 - Import TRAILERS | Resources | Standard CSV stream to import trailers in Axiodis | CSV MIA stream |
18 - Import TRAILERS AREAS | Resources | Standard CSV stream to import trailers logistic areas in Axiodis | CSV MIA stream |
19 - Import TRANSPORT OPERATIONS | Transport operations | Standard CSV stream to import transport operations in Axiodis | CSV MIA stream |
20 - Import TOs CHARACTERISTICS | Transport operations | Standard CSV stream to import transport operation characteristics in Axiodis | CSV MIA stream |
21 - Import TRUCKS + TYPOLOGIES | Resources | Standard CSV stream to import trucks and typologies in Axiodis Lite | CSV MIA stream |
22 - Import ORDERS + SITES | Global stream | Standard CSV stream to import Transport Operations, Sites and Products in Axiodis Lite | CSV MIA stream |
99 - Import ROUTE TEMPLATE | Route template | Standard CSV stream to import route template in Axiodis | CSV MIA stream |
Menu options to import data in Axiodis
In "Data and Constraints" module, an option is available in each screen to import data from a standard CSV stream by selecting the corresponding file (logistics areas, logistics sites, products, drivers, trucks, ...).