Bulk Import Data
This page explains how you can bulk import a variety of data into the Admin panel .
The Import data tool allows you to import excel files and/or image files into the admin panel in bulk. This includes:
- Users (Excel)
- Program (Excel)
- Company (Excel)
- Poster (Excel)
- Call to Action (Excel)
- Networking table (Excel)
- Push notification (Excel)
- 1.Login to the relevant Admin panel
- 2.Go to Settings --> Import data (you will now see the overview page of the importer)
- 4.Choose the option Excelsheet(s)
- 5.Either drag and drop the excel file or click into the selction the box choose the relevant excel file
- 6.Clickto continue
- 7.You will now need to choose what type data will be imported (This allows us to narrow down the mapping fields for you)
Now the file is ready to be mapped and imported into the system.
As shown in the image below there are 6 columns in the mapping page.
The table below describes the function of each column:
At the bottom of the mapping page there are 3 import settings. The table below explains their function:
Once all of the fields have been mapped and the settings are set you will then be able to click
The system will now start a test run of the import. At this stage nothing is imported, the system will check for/list any errors and an overview of what will be imported will be given.
If an error is found you will see the followin message:
Below this message you will first see Import statistics this will give you insight to what the sytem found when testing including what would be added, updated, not updated and the amount of errors found.
Following this you will see listed the Import errors. This will tell you what the error is and where the error can be found in the excel to fix.
You can then adjust your excel file accordingly and re-upload it. In case there are no errors, you can preview the import statistics:
If these results match your excel list, you can click on 'Confirm import' to save your changes to the admin panel.
You can import images for users, program items and company logos. When importing images for users, it is important to name the PNG or JPG files exactly the same as the names or external IDs of the users, so that they will be linked automatically by the importer. Otherwise, you will need to link them manually.
If you would like to import program item images or company logos, the names of the files should also match exactly to the company/program item names. When the images are ready to be imported, you can log-in to the admin panel and navigate to 'Settings' -> 'Import data' -> '+ New import' -> Image(s). Here. you can drag-and-drop your images and then scroll through to check that all the images have been linked correctly or link them manually:
Afterwards, you can scroll down and press on the 'Finalize' button to save the images to the admin panel.