For reminder, AXIODIS MIA conector 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 (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 correspond to the MIA stream automatically deployed on Axiodis Server by the installer ("...\Axiodis6\Installation_Name\data\mia\flux" by default)
- The "xlsm" file correspond to the template of file to use to import data (from another excel file for instance) with a legend describing how to use it
For further informations, please have a look on this tutorial 00 - How to use standard streams.pdf
Standard streams download
| Standard streams | Axiodis Release | Comments |
|---|---|---|
| Axiodis CSV standard streams v6.8.0.0.7z | 6.8.0.0 | Includes "xlm" files (MIA streams) and "xlsm" files (templates files to import data from Excel) |
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 stream |
| 04 | 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 stream |
| 06 | 06 - Import PRODUCTS | Products | Standard CSV stream to import products in Axiodis | CSV MIA stream |
| 07 | 07 - Import SITES GROUPS | Logistic sites | Standard CSV stream to import sites groups in Axiodis | CSV MIA stream |
| 08 | 08 - Import SITES | Logistic sites | Standard CSV stream to import logistic sites in Axiodis | CSV MIA stream |
| 09 | 09 - Import PROVIDERS | Resources | Standard CSV stream to import providers in Axiodis | CSV MIA stream |
| 10 | 10 - Import VEHICLE TYPOLOGIES | Resources | Standard CSV stream to import vehicle typlogies in Axiodis | CSV MIA stream |
| 11 | 11 - Import VEHICLE TYPOLOGIES CHARACTERISTICS | Resources | Standard CSV stream to import vehicle typlogies characteristics in Axiodis | CSV MIA stream |
| 12 | 12 - Import TRUCKS | Resources | Standard CSV stream to import trucks in Axiodis | CSV MIA stream |
| 13 | 13 - Import TRUCKS AREAS | Resources | Standard CSV stream to import trucks logistic areas in Axiodis | CSV MIA stream |
| 14 | 14 - Import DRIVERS | Resources | Standard CSV stream to import drivers in Axiodis | CSV MIA stream |
| 15 | 15 - Import DRIVERS AREAS | Resources | Standard CSV stream to import drivers logistic areas in Axiodis | CSV MIA stream |
| 16 | 16 - Import TRAILERS | Resources | Standard CSV stream to import trailers in Axiodis | CSV MIA stream |
| 17 | 17 - Import TRAILERS AREAS | Resources | Standard CSV stream to import trailers logistic areas in Axiodis | CSV MIA stream |
| 18 | 18 - Import TRANSPORT OPERATIONS | Transport operations | Standard CSV stream to import transport operations in Axiodis | CSV MIA stream |
| 19 | 19 - Import TRUCK CALENDARS | Resources | Standard XLS file to import trucks calendars in Axiodis | 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 file |
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, ...).