Difficulty: expert
Content
Learning Objectives
After reading this article, you’ll be able to:
Work through the general imports
Basics
Keep in mind: Here we go over imports in detail, for more on the basics check out What are imports and exports in Workplace?
The import functionality allows for a quick upload of large datasets into Workplace. By using import connector with import mappings, it is possible to specify in which data table the various data should be stored.
Default imports are available to import masterdata when setting up an environment. This allows for quickly filling the environment with for example: contacts, properties, and areas. By default we use filed in csv-format for our imports.
Where to find imports
Some default imports are explained in detail in the articles that describe how to set up a new Workplace environment Solution Based Rollout || UNPUBLISHED. In general, imports can be accessed by:
Pressing the Import button on the startBoard. Imports can also be accessed via the navigation menu: Configuration>Import.
Open the import connector by clicking on the “reference”.
For this article we guide you through the properties import: FMB-F-021. After clicking the reference this page will open:
Warning: If this import is not yet available in the list click: Generate default imports at the bottom of the import list. This will provide you with some general imports.
Importing data
Generate an import template by clicking: Generate import template
A file will be provided in the include at the bottom called Template import xxx.
To download the file click the download icon.
In theory we send out this excel file to the client and ask them to fill it in. But more on this later.
After receiving the file back from the client we save the file as CSV UTF-8.
Import the file by clicking import file.
Select file by clicking Select files.
Importing the files will continue in the background. When we click: Ok, we return to the import page.
In the right top corner the importing icon will show up, when clicking on it we can see the import status.
After the import finishes we can see the results by clicking the document icon in the top right corner.
On the document page select Advanced Search.
In the field Dates: linked from/until fill in today’s date. (If we would search without filtering we would end up finding all documents that have been imported in this import connector)
Open the import messages by clicking the magnifying glass, here we can also consult the file that has been uploaded. The messages shown explain what happened when importing.
Import connectors
Connector mappings
The import we discussed in the previous steps seems to be a single Properties import. However, almost all imports that are generated by default consist out of multiple import mappings. In this case we import property objects as well as the address object.
We can see this by navigating to the details tab
Scroll to the bottom include: Mappings
Connector settings
Only partner users can change this
Save documentes: Yes
Log: Yes
scheduling imports
Filling in import data
When filling in the import files there are a few things we need to keep in mind.
Every import mapping has different fields that have to be filled in.
Per mapping (object) we can open the mapping
We can then see what fields are being imported, in this example we will use FMB Property by clicking on the magnifying glass.
The fields where Key is set to: Yes are fields that are required for the import.
Key values are
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
Search