Overview


The integration framework facilitates data exchange between Axacute and external applications or systems. You can process inbound and outbound transactions by using:-

  1. APIs -  Refer to Axacute Developer Portal for more information  
  2. Flat Files - Refer to the guide below

Types of flat files supported are:

  • CSV (Comma Separated Value)
  • XLSX

The following diagram shows how data is exchanged between Axacute and external system using Flat Files.


Figure 1: Integration Framework Diagram



Instructions to use inbound integration via Flat File 

The Inbound Integration used by any external/third party application consumes it to import data into your Axacute.


Step-by-step guide

  • Step 1: Download the templates
  • Step 2: Populate the content in the file template
  • Step 3: Import file into your Axacute


Step 1: Download the templates

  • Go here and download the "04-Import Templates" Excel templates.


Step 2: Populate the content in the file template

  • You may refer to the definition of the field here.
ListsFiles
MasterItem
MasterWarehouse
MasterIncoming/Outgoing
MasterMiscellaneous
MasterResources
MasterBill of Materials
TransactionPurchase Order
TransactionCustomer Order
TransactionTransfer Order
TransactionMaster Files
TransactionJob Orders
TransactionJob Routes
TransactionJob Materials
  • Save the file

Step 3: Import file into your Axacute

  • Open the Master list or Transaction list as you decide to import the data.
  • Click the Import button
  • Click the Choose File button to select your input file. At default, the wizard searches for .csv and .xlsx files.
  • Click the Import button attempts the import process.
  • This page indicates this file import task has been submitted for processing.
  • Please verify the status on Background Taskswhether the import was successful. 
    • If a Success remark appears, it was a success, 
    • Otherwise you may need to click on Action icon to review your input file for any errors.  

Instructions to use outbound integration via Flat File 

The outbound Integration used by any external/third party application consumes it to get data from your Axacute.


Step-by-step guide

  • Step 1: Export file from your Axacute
  • Step 2: Import file into external application


Step 1: Export file from your Axacute

  • Export from History Files
    • Open the Inventory or Production History list as you decide to export the data.
    • Select or fill in the Filter Criteria fields
    • Click the Filter button
    • Click the Export to Excel or Export to CSV button to export data from the results of the filter.
  • Export from Inventory Balance Report
    • Open the Inventory Balance Report form as you decide to export the data.
    • Select or fill in the Filter Criteria fields
    • Click the Generate button
    • Click the Export to Excel or Export to CSV button to export data from the results of the filter.

Step 2:  Import file into external application

  • Import file into external/third party application

Handling Date and Time Fields in Data Integration

When integrating data with Axacute, especially when dealing with APIs and Flat Files, it's crucial to maintain consistency in the representation and handling of date and time fields.


Best Practices for Date and Time Fields

  • UTC Format: Always use Coordinated Universal Time (UTC) for all datetime fields to avoid confusion caused by time zone differences.
  • ISO 8601 Standard: Follow the ISO 8601 format for datetime fields (YYYY-MM-DDTHH:MM:SSZ) to ensure compatibility and readability across systems.

Converting Local Times to UTC

Before submitting data to Axacute or processing data from Axacute, convert any local datetime values to UTC. This standardization facilitates smoother data integration and processing across different time zones.


Processing API Responses

When handling API responses or reading data from Flat Files, ensure that any datetime fields in UTC are appropriately converted to local time zones if necessary for display or further processing.