Skip to main content
Skip table of contents

Import / Export

General

A variety of data can be read into or output from the system via Import / Export. To prepare for an import, the desired data type should first be exported to match the data structure of the Excel, XML or JSON file.

Import XML and JSON files, see chapter Interfaces > Setup interface. Under Interfaces > General there is an overview of all fields of the data in the “COGLAS WEB WMS mapping.xlsx” file. In the other tabs, e.g. articles and delivery orders, are examples of. JSON, XML and CSV files are available.

Alternatively, you can use the export to get live examples from your system.

In column A of the Excel file, only one of the following keywords may be used:

Keyword

Description

CreateOrModify

Creation of a new data set or to change a existing data set

Delete
(delete data set)

The delete function must be used with care to avoid data loss. In case of any ambiguity, you should consult COGLAS Support in advance.

image-20240315-085559.png
image-20240315-085611.png

Field-Mapping Tool

The mapping tool is used to import a customized Excel file. The tool can be accessed via the frontend under System → Import/Export and gives the user the possibility to map a customer-defined Excel table (with defined columns) with the Coglas-side columns.

image-20240315-085813.png
image-20240315-085841.png

Functionality

Button

Description

Here you can import the Excel table by drag and drop. Alternatively, you can also import the file via the document icon.

If the filed file is not correct, you can delete it with the trash icon and import it again.

There are 3 message types (Articles, Goods in orders, Customer orders) which can be imported. When the selection is made, the column names headers that are important in Coglas for the particular message type appear.

There is the distinction between mandatory columns that must always be mapped. Other fields are optional and can be mapped.

You can click on the field and then move it to the corresponding column with which you want to map the header.

You can also undo the assignment with one click and select another field with drag and drop.

Blue = value in the Excel table
Orange = column name in the Excel tableThese markings are for illustrative purposes.

With “Import file” the data attachment of the assignments will be imported.


Facilities

A customer-specific Excel table is read in and a message type is selected:

image-20240415-112244.png

Warnings

Reference

Description

Not all required fields have been assigned

Mandatory fields must be assigned. Required fields are circled in red.

Processing of the message failed

This message appears when values in the Excel table are not formated correctly or there are problems with the Excel table.


→ back to COGLAS processes
→ back to COGLAS menu

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.