This is a collection of all the information you need to know, in regards to the data integration.
There are overall two sources of information that is relevant to feed into Qarma:
- Purchase order information that lets the inspector know which products to check, quantities, supplier information, ETD etc.
- Product data that data that enables the inspector to check that the product lives up to the specifications. Examples are barcode information, size, color, style, packaging as well as file attachments such as technical specifications, user manuals, assembly instructions etc.
Data
...
Data formats
We support the following file formats:
- CSV
- Excel
- XML
- JSON
Import It is important that we we can identify each order line can be identified in the data. So e.g. ; for example, Excel or CSV formats should have one row per order line. XML and JSON formats should have include one level for the order and then the , with individual order lines on the level below.
An example file is attached here. The , please download the file to see the examples. The yellow highlights are the basic and mandatory information - the rest will depend on the data fields of the source system and will be mapped accordingly in Qarma.
Transfer methods
The We offer various transfer methods are very flexible, including:
- Dedicated email
- FTP
- SFTP
- HTTP (webservice)
- HTTPS (webservice)
- DropboxHTTPS (webservice)
Data can be refreshed multiple times daily to ensure that information within Qarma remains consistently up-to-date.
What we need
The following 5 mandatory fields:
- Order number
- Item number
- Item name
- Ordre quantity
- ETD
Besides the mandatory fields, we also often find that the following information is relevant:
- Product category
- Country of origin
- Product details – Color, materials, full product description
- Product and carton dimensions
- Product and carton weight
- Product and carton barcodes
- Factory name
- Link to product images
- Attachments
How to
The integration will be handled by your dedicated Qarma Product Solution Manager, who will work with you to set up the integration. In most cases this can will be done with minimum amount of work from your side, after we receive the Account- data and configuration information.
Useful information in relation to data import
Duplicate orders
If an order already exists in Qarma, it will be updated if there is any new information in the data sheet you provide to the Qarma system (e.g. change of qty, date etc). It will match on The system will only update if it matches both the Order number and Item number and optionally an Order line id. It ID.
Furthermore, it will only update the information if the inspection has not yet started.
If one When is an Order Line ID necessary?
If an order has several times the same item number several times, there needs to be an order line id ID to identify the individual order lineitems.
Multiple data sources
The file-based integration Data import can handle multiple data sources. This could be any of the following information sheets. The following information is an example of data that needs to be processed together with the order list:
- List of suppliers (with - containing e.g. supplier address, contact information, sourcing responsible etc) that should be used for providing details about the supplier to the inspectorcountry etc.
- Additional order files (information - labels, package instructions, user manuals, product specifications etc) that should be part of the "inspection package" for the inspector.
- List of users and their responsibilities (- this allows Qarma to set automated notification and approval flows for inspection reports)
- Mapping between product categories in the order list and corresponding checklists in Qarma.
How to
...
- Qarma
...
- .
Attachments and files
If you your order or product data includes references to attachments, these can be retrieved and served out with displayed in the Qarma APPapp. We support retrieving attachments shared as Public URLs through HTTP/HTTPS and retrieving attachments through FTP/SFTP protocols for this purpose.
An For example could be that , attachments are linked to the an order in the your ERP system (e.g., Navision) , and can be made available for download on via an SFTP server. The PO information sent to Qarma will then have contain the path to the specific folder on the SFTP server where the file can be found, and it is automatically collected and shown to is stored, enabling automated retrieval and display for the inspector in the Qarma app.