We have created the Some tips for when you are creating your CSV file To access the
You should then see the To begin importing your data, you will need to click the Once the file has uploaded, you can begin the data verification process, that will ensure that the data imported to iKnow is correct. You should see a screen similar to the following, if what you see is a lot of random characters, please check that the file you are attempting to import is in the correct format. The file must be in .csv format. Files in .xls or .xlsx format cannot be uploaded (you should be able to export a CSV file from Excel). You now need to verify the data that iKnow will import. If your CSV file has a header row that labels all the columns, i.e. First Name, Last Name, etc., you will need to tick the You will then need to check that the headers that iKnow has ‘guessed’ are correct. iKnow will attempt to correctly assign the right headers according to the content of the columns. There will be times that this is not possible, or that the system gets it wrong, there may also be some columns you don’t wish to include. You can make sure iKnow knows what is in each column, and which it should ignore, using the dropdown menus at the top of each column. If you want iKnow to ignore a column, you will need to choose Sometimes iKnow will select a header, but get it wrong, so you will need to change it. In the image below, iKnow has selected Once you are happy that all your column headings are correct, click the When the import is complete you will then need to verify the data that has been imported from your CSV file. You will see a screen with 6 tabs; The Campuses tab will show any campuses that are already in iKnow in Green. Any new campuses, i.e. campuses that are in the CSV file but not already in iKnow, will be in an editable text box so you are able to make any corrections necessary. If the details are correct, click All groups must be assigned to a
The Also, in the Simply click the relevant button alongside the person’s name and you will be able to check that the correct information is shown, and change it if necessary. If there are any people that have not been assigned campuses when you confirm the Once you have confirmed all your data, you are ready to complete the import process and add your people to your iKnow database. To do this, just click the Depending on the size of the file you are importing, this may take some time to complete. When the import is complete you will receive a message to on screen to let you know that your data has been imported. You can then return to your iKnow dashboard. |