As part of the ETL (Extract, Transform, Load) process it is necessary to transform and map the data from the exporting system to the importing system. The system provides visual tools to assist in this process.
Transforms allow you to format data so that it can be imported into the system. Transforms can be be as simple as trimming whitespace to more complex cases combining multiple fields and applying a formula before importing into LogiSense Billing.
Validations ensure the integrity of import data before beginning the import processs. Any field values that fail validation will not be imported and depending on your envelope definition the entire process can be rolled back.
LogiSense's data import process includes visual debugging tools to assist you. Using a sample import file it is possible to validate the data from the file and that the mapped system object is complete.