Updating datasets with new data in Kiplot is a quick and easy process.

💡 To edit any dataset, the dataset owner or an Admin user for Kiplot will need to grant you can edit dataset access prior to making any changes.

How to upload data to an existing dataset

1. Click on datasets page in the navigation panel
2. Use the search bar to find the dataset you want to update
3. Click Upload in the toolbar next to the dataset you wish to update

   

4. Either drag and drop the file you want to use to create the dataset or click the grey box to navigate and select the file that you want to use
5. Once the import is completed the import tool will turn green to confirm the file is valid and ready to upload
6. Click Upload

Kiplot analyses the data that’s being uploaded and generates a schema. This will determine which format the data will be stored in (e.g. as text or numbers). It’s important to remember that the data’s format will determine how the data can be used in a report (e.g. data must be saved as a number to appear on a scale and data must be saved as a date to appear on a timeline). Make sure the first row of your spreadsheet contains the column headings to be recognised in the upload.

Once the file has been imported the last step is to review the column mapping and the Schema. Most of the time, if your data data is structured in the same way, all you need to do is check that all the columns have been mapped (See point 1 below). It’s only if things have changed in some way that you need to follow further instructions.

1. Check the column names and data type have been imported correctly. You can make any adjustments via clicking the drop down menus
2. Click ‘edit schema’ to make further adjustments
3. Find the column where you would like to change the input type:
4. Once you’ve made changes, remember to scroll to the bottom of the schema editor and hit save
5. Once you’re ready, hit the ‘create dataset’ button to upload your data

   

Uploading Tips

1. If you delete columns in your spreadsheet that exist in the current dataset, it will still leave the column in the schema but it will not update the data for that column.
2. If the Unique Identifier (UID) in the shema and the upload do not match the upload will fail.
3. If your schema has multiple UID’s your upload will need to contain columns for all of them. You can check which columns are UID’s in your dataset by checking the Schema.
4. If you have duplicate rows in your spreadsheet the first row will be read and all duplicate rows ignored.