Versions Compared

Version Old Version 6 New Version 7
Changes made by

Jelle Roelofs

Jelle Roelofs

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Difficulty: starter

Content

Table of Contents
minLevel1
maxLevel1

Learning Objectives

After reading this article, you’ll be able to:

  • Access the template of a preconfigured import/export connector.

Import

The import functionality allows for a quick upload of large datasets into Workplace. By creating an import connector with import mappings, it is possible to specify in which data table the various data should be stored. It is also possible to set up the imports to be carried out periodically. For instance, one could set up the import of employee data at the start of every month. To create a new import connector with the corresponding import mappings see….. Article. A number of preconfigured import connectors are available in WorkplaceDefault imports are availablto import masterdata when setting up an environment. This allows for quickly filling the environment with for exampel: contacts, properties, and areas.

  1. Access the import connector via the import button on the startboard. Alternatively, it can be accessed via the navigation menu: configuration>import.

  2. Open the import connector by clicking on the “reference”.

  3. Download the template.

  4. Fill out the template, convert it to a CSV file, and upload the import file to Workplace.

Info

If there is missing data (empty cell) in the dataset, Workplace will skip these missing values.

Note

It is important to fill in the first column of the template. This is a key value that the other data is connected toduring the import.

Export

Similarily to the import functionality, the export functionality allows the for a quick download of large datasets from Workplace. It is also possible to configure a periodical download of data.

  1. Access the export connector via the export button on the startboard. Alternatively, it can be accessed via the navigation menu: configuration>export.

  2. Open the export connector by clicking on the “reference”.

  3. Click “Run” to trigger the export connector.

Automating an import or export

  • It is also possible to set up imports to be executed periodically from an FTP server.

  • Automated export can be set up to export date to: FTP servers and email.

Summary

Rw ui textbox macro

  • The import and export functionality is used to upload and download large number of data to and from Workplace.

  • Workplace comes with a set of predefined import connectors.

Exercise

  •  #NA

Search

Live Search