When importing data to Silverbucket it is vital to keep the structure identical to the example datasheet to ensure a flawless import:
- First row contains the names of the headers - it is not necessary to edit the first row.
- Second row in your file is where your data starts to get imported
- Columns need to be in the same exact order as in the examples
- Rows after the default structure's last column are never read / handled when importing
- Never have hidden columns in your data sheets
What data is this integration used for
- Competencies and categories for these competencies
After import you can find the integrated data in the admin view's Competencies tab. Competencies can be added to users of Silverbucket to map their skills and abilities in the company.
Integration's data fields
col. A
B
Name of the competency
Name of the competency category
The example file in the screenshot will integrate / create the following:
Add a caption...
1) a competency called 'English language' under the 'Language Skills' category
2) a competency called 'JAVA' under the 'Coding Skills' category
3) a competency called 'PYTHON' under the 'Coding Skills' category
4) a competency called 'Customer Relations' with no category
5) Row 6 is not handled; competency is not filled in the data
Rules & basic principles of this integration
- If competency's category is missing from Silverbucket, the category will be added to Silverbucket in addition to the competency
- If competency is already created in Silverbucket with the same exact competency name and competency category the row will be skipped
- If competency is already created in Silverbucket with the same exact competency name without competency category, the competency is added to the system without any category
- Duplicates are detected by names of the competency. Same goes for category.
If the data structure was correct, you can see the outcome in Silverbucket right after the upload. Navigate to the admin-view and its 'Competency' tab, for example: