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
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 PROVIDERS | Resources | Standard CSV stream to import providers in Axiodis | CSV MIA stream |
| 10 - Import VEHICLE TYPOLOGIES | Resources | Standard CSV stream to import vehicle typlogies in Axiodis | CSV MIA stream |
| 11 - Import VEHICLE TYPOLOGIES CHARACTERISTICS | Resources | Standard CSV stream to import vehicle typlogies characteristics in Axiodis | CSV MIA stream |
| 12 - Import TRUCKS | Resources | Standard CSV stream to import trucks in Axiodis | CSV MIA stream |
| 13 - Import TRUCKS AREAS | Resources | Standard CSV stream to import trucks logistic areas in Axiodis | CSV MIA stream |
| 14 - Import DRIVERS | Resources | Standard CSV stream to import drivers in Axiodis | CSV MIA stream |
| 15 - Import DRIVERS AREAS | Resources | Standard CSV stream to import drivers logistic areas in Axiodis | CSV MIA stream |
| 16 - Import TRAILERS | Resources | Standard CSV stream to import trailers in Axiodis | CSV MIA stream |
| 17 - Import TRAILERS AREAS | Resources | Standard CSV stream to import trailers logistic areas in Axiodis | CSV MIA stream |
| 18 - Import TRANSPORT OPERATIONS | Transport operations | Standard CSV stream to import transport operations in Axiodis | CSV MIA stream |
| 19 - Import TOs CHARACTERISTICS | Transport operations | Standard CSV stream to import transport operation characteristics in Axiodis | CSV MIA stream |
| 20 - Import TRUCKS + TYPOLOGIES | Resources | Standard CSV stream to import trucks and typologies in Axiodis Lite | CSV MIA stream |
| 21 - Import ORDERS + SITES | Global stream | Standard CSV stream to import Transport Operations, Sites and Products in Axiodis Lite | CSV MIA stream |
| 22 - Import DRIVER CALENDARS | Resources | Standard XLS file to import drivers calendars in Axiodis | XLS local file |
| 23 - Import TRUCK CALENDARS | Resources | Standard XLS file to import trucks calendars in Axiodis | XLS local file |
| 24 - Import TRAILER CALENDARS | Resources | Standard XLS file to import trailers calendars in Axiodis | XLS local file |
| 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, ...).