Difficulty: starter
Content
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 Workplace.
Access the import connector via the import button on the startboard. Alternatively, it can be accessed via the navigation menu: configuration>import.
Open the import connector by clicking on the “reference”.
Download the template.
Fill out the template, convert it to a CSV file, and upload the import file to Workplace.
If there is missing data in the dataset, Workplace will skip these missing values.
It is important to fill in the first column of the template. This is a key value that the other data is connected to.
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.
Access the export connector via the export button on the startboard. Alternatively, it can be accessed via the navigation menu: configuration>export.
Open the export connector by clicking on the “reference”.
Click “Run” to trigger the export connector.
Summary
Exercise
- #NA
Search