Synchronize data manually by uploading files using custom application integration

Synchronize data manually by uploading files using custom application integration

Other than Relatics, information can be managed in external applications. Of these external applications, some do not support the exchange of information between applications (e.g. via an integration using an API and/or webservices). To be able to use information from these external applications in your project, the custom Relatics interface can be the solution, which uses files as a medium. Copy the information from the application into an Excel file and offer this data to Relatics, which interprets and converts it into elements that can be used in your project.

Configure an interface for manual import*

  1. Create a new external type element.
  2. In the workspace menu, click on  Settings.
  3. Click on the menu  Application integration, then Receiving data.
  4. Click on New interface, choose Custom. This results in the dialog Create interfaces for receiving data (Custom).
  5. For the field Name, enter a singular noun that best represents the SE model object.
  6. For the field Type element, select the desired type element.
  7. For the field Initiator, select Power user (via upload).
  8. For the field Upload file type, select the desired format, such as Excel.
  9. Click Create. The interface is created and ready to be used.

Note:

  • An interface for upload an Excel file offers the option Generate template. This allows you to download an Excel file detailing the structure of the element type.

Upload a file*

  1. Create a file using the structure corresponding to the selected upload format.
  2. In the workspace menu, click on Settings.
  3. Click on the menu  Application integration, then Receiving data.
  4. In the Application integration overview, click on the interface.
  5. Click the  Upload button on the right side of the Upload log. This will open a file select dialog.
  6. Select the desired file. When no problems are found, new elements are created.

Note:

  • Elements that do not have a matching row (no matching ExternalId) in the presented file are deleted.
  • After a sync, a  response Excel file containing the externalid and a Relatics URL to the corresponding element can be downloaded.
* In the workspace, the user type of your user must be set to power user to enable this feature.