| Table of Contents |
|---|
For a reminder, AXIODIS MIA conector 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 Ressources
- 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 proposed in a CSV format 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 "xlmXML" file correspond corresponds to the MIA stream automatically deployed on Axiodis Server by the installer ("...\Axiodis6\Installation_Name\data\mia\flux" by default)
- The "xlsm" file correspond 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
...
| N° | Name | Theme | Description | Type | ||
|---|---|---|---|---|---|---|
| 01 01 - Import LOGISTIC AREAS | Logistic areas | Standard CSV stream to import logistic areas in Axiodis | CSV MIA stream | |||
| 02 02 - Import LOGISTIC PROFILES | Logistic sites | Standard CSV stream to import logistic profiles in Axiodis | CSV MIA stream | |||
| 03 03 - Import LOGISTIC PROFILES CHARACTERISTICS | Logistic sites | Standard CSV stream to import logistic profiles characteristics in Axiodis | CSV MIA stream04 | |||
| 04 - Import TIME PROFILES | Logistic sites | Standard CSV stream to import time profiles in Axiodis | CSV MIA stream | |||
| 05 05 - Import PRODUCTS FAMILIES | Products | Standard CSV stream to import product families in Axiodis | CSV MIA stream06 | |||
| 06 - Import PRODUCTS | Products | Standard CSV stream to import products in Axiodis | CSV MIA stream07 | |||
| 07 - Import SITES GROUPS | Logistic sites | Standard CSV stream to import sites groups in Axiodis | CSV MIA stream stream | |||
| 08 08 - Import SITES | Logistic sites | Standard CSV stream to import logistic sites in Axiodis | CSV MIA stream | |||
| 09 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 | |||
| 10 | 10 11 - Import VEHICLE TYPOLOGIES | Resources | Standard CSV stream to import vehicle typlogies in Axiodis | CSV MIA stream | ||
| 11 | 11 12 - Import VEHICLE TYPOLOGIES CHARACTERISTICS | Resources | Standard CSV stream to import vehicle typlogies characteristics in Axiodis | CSV MIA stream | ||
| 12 | 12 13 - Import TRUCKS | Resources | Standard CSV stream to import trucks in Axiodis | CSV MIA stream | ||
| 13 | 13 14 - Import TRUCKS AREAS | Resources | Standard CSV stream to import trucks logistic areas in Axiodis | CSV MIA stream | ||
| 14 | 14 15 - Import DRIVERS | Resources | Standard CSV stream to import drivers in Axiodis | CSV MIA stream | ||
| 15 | 15 16 - Import DRIVERS AREAS | Resources | Standard CSV stream to import drivers logistic areas in Axiodis | CSV MIA stream | ||
| 16 | 16 17 - Import TRAILERS | Resources | Standard CSV stream to import trailers in Axiodis | CSV MIA stream | ||
| 17 | 17 18 - Import TRAILERS AREAS | Resources | Standard CSV stream to import trailers logistic areas in Axiodis | CSV MIA stream | ||
| 18 | 18 19 - Import TRANSPORT OPERATIONS | Transport operations | Standard CSV stream to import transport operations in Axiodis | CSV MIA stream | 19 | 19 - Import TRUCK CALENDARS |
| 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 XLS file CSV stream to import trucks calendars and typologies in Axiodis Lite | XLS local file | |||
| 20 | 20 - Import DRIVER CALENDARS | Resources | Standard XLS file to import drivers calendars in Axiodis | XLS local file | ||
| 21 | 21 - Import TRAILER CALENDARS | Resources | Standard XLS file to import trailers calendars in Axiodis | XLS local fileCSV 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 CSV stream by selecting the corresponding file (logistics areas, logistics sites, products, drivers, trucks, ...).