Excel format for synchronizing data using interfaces

Excel format for synchronizing data using interfaces

Using an interface requires a fixed data structure. This article describes the structure of the Excel format.

Structure for manual upload of an Excel file

In the detail view of the interface, an Excel sync template can be downloaded, which contains the required data structure. Copy the data from the external application into the sync template.

Notes:

  • The Excel column “ExternalId” (column A) must contain unique values. Relatics stores these values in a system property for the corresponding elements. When an Excel file update is presented, Relatics uses ExternalId to determine if a model object needs to be created, updated, deleted, or remain unchanged.
  • The Excel values ​​must follow the same rules that enforce manual entry specific to the property type in which the information is stored.
  • Dates in the Excel file must be set in the Excel date format for correct interpretation.
  • The decimal sign of number values has to be a point.
  • To map an externally managed type relation the Relatics element ID must be used. To account for multi relations, use enters between the Relatics element IDs.

Request a demo

Fill in our form and one of our colleagues will contact you as soon as possible to schedule a demo.

Please enable JavaScript in your browser to complete this form.
Please enable JavaScript in your browser to complete this form.

Download the whitepaper

Please enable JavaScript in your browser to complete this form.
Addresss

Get in touch

Fill in our form and one of the Relatics members will contact you as soon as possible. Do you prefer contact by phone? Please call us at +31 180 413 047.
Please enable JavaScript in your browser to complete this form.