Herby Tessadri, Sales Manager
For almost all data that is entered into the crossbase database via user interfaces, mass data import via Excel files is also possible. Users can carry out these imports independently without having to rely on external support. There are two procedures for preparing the Excel files:
To import BMEcat files, a field mapping to the typical BMEcat fields is created:
The data can be visualized using a BMEcat viewer. The import profile can be saved so that similar imports can be carried out repeatedly.
When importing data from Excel or BMEcat files, a validation is carried out. This checks whether the data type, number format and value range are correct and whether text markups are XML-compliant. If new items are imported, they can first be created in a NEW folder and later classified in more detail. The result is summarized in a log file. An e-mail notification can be triggered in the event of errors.
Typically, larger data imports are first imported into a test system and the result is roughly checked. This is cumbersome and inaccurate. For this reason, crossbase offers a simulation of the import with automatic testing options. After the simulation, it is reported which data is new, changed or removed ("DELTA") and which data remains unchanged.
A column to be imported represents a field to be defined in the database. It is assigned to a structure and a level. For example, it is possible to import the content of the cells of a column into the product structure on the Product Group or Item level.
The content to be imported can be classified, for example as characteristics (weight, dimension, material, ...), prices (gross price, net price, ...), texts (short text, description, application, ...), illustrations (product photo, drawing, ...) and product relations (accessories, spare part, ...)
The content of a column can be edited according to certain rules (e.g. replacing, deleting or adding text parts as well as converting numbers using formulas).
Different parameters can be recorded.
Import can be done automatically. To do this, some parameters can be be configured, such as connection data, the source directory with files and target directory for the log file.
Germany
crossbase mediasolution GmbH
Otto-Lilienthal-Straße 36
71034 Böblingen
+49 7031 9880-700
office@crossbase.de
Austria
crossbase mediasolution GmbH
Konrad-Doppelmayr-Straße 15
6922 Wolfurt
+43 5574 64880-39
office@crossbase.at
© 2024 crossbase mediasolution GmbH
We respect your privacy
AThis website does not use cookies to collect visitor data or behavior!