Data import process
In order to save our users the time they would have to spend on lengthy transfers of their data from their existing files and systems, we have developed a feature that is able to automatically bulk import data from files into our application with just a few clicks.
Currently it is possible to import employee and attendance data.
How you can import your file data into Speybl
The data import function can be found in the menu item "Import", in the section "Import data". Here you can create your own import templates or use one of the templates we have already prepared for you. These templates are prepared for importing data from selected attendance systems that are frequently used. If you use another system for which there is no template available, you can create a template yourself and manually select the data you want to import into the application from that system.
However, if you only want a one-time upload, such as a table with employees and their data in an MS Excel spreadsheet file, you can choose to upload the file without a template. In this case, simply upload the desired file to the selected space and start the import process.
Import process flow
After uploading the file, the application will show you a preview of the file, where you can find the first few lines of data from the imported file. Based on this data, you can verify that this is indeed the file you want to import into the application.
Another function of this preview is to select the columns with the required data from the file you want to upload to the application.
Importing employee data from a file
To illustrate, let's use an example. You are uploading a required file that contains data about individual employees. The application will show you the columns in the preview, for which you can choose whether or not you want to import them into the application. You can choose only the data that is important to you and avoid importing data that you do not want to record for employees. You can therefore decide which data you want to import for employees (e.g. full name of the employee, personal data, address, etc.).
Data that can be imported for employees
It is possible to import data for an employee with the data that can be found on the employee detail in our application. These sections are: personal data and basic data (the first two sections on the employee detail), as well as addresses, contact persons and data about the employee's position (displayed on the employee detail in the "Position and structure" tab).
Data you can import for attendance
Within the attendance import, you can import the start and end values of a given attendance (from when, to when), type of attendance (at work, HO, vacation, and so on), etc.
Importing this data will be used to import attendance already recorded elsewhere into the Speybl environment.