Building Import/Export Utility
Last updated
Was this helpful?
Last updated
Was this helpful?
Xoro has a feature that allows users to import and export data seamlessly between external systems and Xoro by using customizable templates. These templates are designed to convert data to match the format required by Xoro, which eliminates the need for manual data manipulation using programs like Excel.
One of the most common uses of this feature is for managing external B2B orders. Typically, an external B2B system will generate orders in a .csv file that is not directly compatible with Xoro's data format. To address this, a specialized utility can be created, which will allow you to upload the B2B file export as-is into Xoro. This utility automatically maps the data to the appropriate fields in Xoro, allowing for a quick and efficient upload process.
Creating an import/export utility involves defining mapping details, such as the export entity, type, CSV file to map, utility name, and language type. Once the basic details are defined, you can then proceed to configure the specific field mappings.
To accommodate various business needs, these utilities can cater to different types of data operations, such as:
Order Upload
Wave Export
Inventory Export
Exporting of shipping waves, etc.
Entity
This field allows you to select the module for which you want to create the utility.
Utility Name
Enter a name for the utility. This will act as a unique identifier for the utility.
Language Type
You can code some of the values while creating the mapping. This field allows you to select the programming language (C# or Javascript) to code some of these expressions, in the expressions column.
Custom Export Format/Pre Import Script
If you wish to input a personalized script for utility creation, select this option, and a "Custom Script" screen will appear. This space allows you to compose the script for the utility.
Type
Select the utility type you want to create: Import or Export.
CSV Format
Select "Choose File" within this field to upload the file in the external format.
Edit External Format
Select this option to edit the values in the CSV file that you have uploaded.
Once you have selected the mapping details, click on "Map" to create a mapping between the external format and the Xoro format.
All the respective fields from the uploaded file will be populated in the "Mapping" section below.
Mapping Fields
External Format
This field captures the format of the external system to map.
Xoro Format
This field captures the format as it is on Xoro to map.
Expressions
If you intend to assign a value to a specific field, you can utilize this field to encode the desired value.
After the mapping of the columns is done, click on “Save”. This will save the data and create the utility.
If you believe you need a custom utility for your specific data integration needs, you can request one by:
Logging a support ticket.
Including a sample.csv file from your external system.
By doing so, the Xoro team can design a utility tailored to your unique data import/export requirements.
