Tip: Streamline your student data management with Intake. Find out more here.
All Pupils Are Showing Within the Intake Table and None Have Been Matched
This is caused by either the management ID or the borrower's forename or surname not matching up with the imported CSV file.
CSV Has Been Opened in Excel
Opening a CSV file in Excel applies formatting to the fields by default. Some of the fields, such as 'Management System ID' (MSID), will have any leading zeros stripped off. When your management system is SIMS for example, it nearly always contains leading zeros in this field, (001234). When opened in Excel, the leading zeros are removed (1234).
For example, a borrower has a MSID of 001234. A CSV file is imported, containing the number 1234 as the MSID as the CSV has been opened in Excel. No existing borrowers have the number 1234 so the pupil is thought to be new and stored in the Intake table.
If this issue matches what you are experiencing, we recommend clearing the intake table completely and recreating the CSV file. If you need to modify it, use a text editor such as Notepad instead of Excel.
Incorrect Management ID Field
Exporting an incorrect MSID can cause the borrowers to not match.
Open the file with Notepad and take a note of an existing pupil's MSID on one of the rows. Note that the name of this header may vary depending on the system it has been exported from ('ADNO', 'ManagementSystemID', 'Roll No' etc.).
Check the corresponding record in the Borrowers table, within the library system. If the two match exactly then this is not the issue. If they are completely different (for example, one contains letters) then a different field has been exported or the MSID has been reformatted. In this circumstance, the file will need to be recreated from the Management system and must include the correct field.
Changed Management Systems
It could be that since the last time an import was run, the management system has been changed. In the event of this happening, we can assist you by removing the MSID for all existing borrowers, meaning that the system will fall back to matching on Forename and Surname. Contact us for further assistance.
Forenames/Surnames Not Matching
If there is no MSID against the existing borrowers in the library system, the system will fall back to matching the pupils based on their forename and surname. However, if these fields do not match, then the system will not be able to match up the records in the CSV with those in the library system.
To ensure that the surname and forenames match exactly, check some of the records in the CSV (using Notepad) against some of the records in the library system. You may find that they do not match due to spelling mistakes or because the preferred or legal forename/surname is used. If this is the case then you will need to recreate the file ensuring that they will match, then re-import the CSV. If there are only one or two borrowers then it's likely easier to match them manually.
Mandatory Fields Missing Error When Importing
This error occurs when not all of the required headers are present on the first line of the CSV.
Certain mapping options require differently labelled headers, so make sure that at minimum, the mandatory fields are specified with the correct spelling. The system tells you the fields that are missing. Double check that the file has been created according to the guidance for your MIS.
In addition, this message is presented when the wrong 'mapping' option has been selected from the import window, particularly if there are many fields that show when clicking 'details' on the message. If this is the case, ensure that the correct import option is chosen when the file is imported.
There Is No Error Message but Data Is Showing in the Wrong Fields on One or More of the Rows
This issue can have one of two causes. The first is a comma being inserted in the wrong place. The second is because the column's headers have been labelled incorrectly.
Additional Comma(s)
If this happens, it can cause the data to become displaced, shifting the data across to the wrong field.
ManagementSystemID","Forename","Surname","DateOfBirth","Gender","TutorGroup","YearGroup"
"00056789993888","Joe","Bloggs","05/05/1985",,"Male","10Green","10"
The additional comma between the date of birth and gender fields would cause the data to offset, meaning 'Male' gets import into the TutorGroup field and so on.
One way to identify this is to use the 'find' function with the CSV open in notepad. Open the CSV and press 'CTRL' + 'F' on the keyboard. In the 'find' box, type ',,' and click 'Find Next'. This should highlight any double commas. Of course in some cases such as when the field is empty, this would be correct so you may have to check each occurrence for the problematic one(s).
Another situation where this can occur is when quotation marks are not used while importing address details. Often the first part of the address will be added into the first line with a comma (10, Downing street), when exporting this data to a CSV it adds an extra comma which knocks the data down a field.
ManagementSystemID,Forename,Surname,Address1,Address2,Postcode,DateOfBirth,Gender,TutorGroup,YearGroup
00056789993888,Joe,Bloggs,10, Downing Street,London,SW1A 2AS,05/05/1985,Male,10Green,10
The extra comma in the first line of the address means that all following fields are knocked down to the next, the postcode would be added to the date of birth, the date of birth into gender etc.
This can be corrected by putting quotation marks around the affected field. Open the file in notepad and locate any field where this has occurred and put quotation marks around the field in question.
ManagementSystemID,Forename,Surname,Address1,Address2,Postcode,DateOfBirth,Gender,TutorGroup,YearGroup
00056789993888,Joe,Bloggs,"10, Downing Street",London,SW1A 2AS,05/05/1985,Male,10Green,10
Incorrect Column Header
If the columns are not labelled against their respective fields correctly then it is easy to import data into the wrong field.
"ManagementSystemID","Forename","Surname","DateOfBirth","Gender","TutorGroup","YearGroup"
"00056789993888","Bloggs","Joe","05/05/1985","Male","10Green","10"
Notice that the 'Surname' ("Bloggs") is currently set to import into the 'Forename' field and vice versa. To correct, open the file with Notepad and alter the field headers.
Index Is Out of Range. Must Be Non-Negative and Less Than the Size of the Collection
This message occurs when attempting to import a CSV file into the Borrowers or Resources table rather than the Intake table. Import your CSV into the Intake table to resolve this issue.
Object Reference Not Set to an Instance of an Object
This message occurs when the CSV file has been imported into the Borrowers table rather than the Intake table or when no CSV file has been uploaded from the Import window. Import your CSV into the Intake table to resolve this issue.
The MLS-Eclipse (MLS Connect) job has been run but fails on error 10305
When a 10305 error is shown in the log file this means there is an issue with the SIMS User that has been specified to run the task.
Create a new user account with just the relevant 4 Group memberships as outlined in Sims .Net Account Prerequisites and rerun the job.
Login Failed For User Error When Trying to Run the MLS Connect Importer
This error commonly occurs when there has been a change to the login details for Xporter and your MIS.
- Open the Xporter Management console.
- Click 'Passwords' on the left-hand side.
- Click on the applied credentials and click 'Modify' on the right-hand.
Update the credentials from your MIS and then manually run the MLS Eclipse Job.
Emails Are Not Being Pulled From Sims via Groupcall Xporter as Expected
There are two things that need to be checked to resolve this issue:
- Emails need to be set as 'Primary' within SIMS.
- Check 'Emails' are ticked within MLS Importer Settings.
Bromcom Emails Not Syncing
Emails are not syncing, with no error message in the Groupcall error 'Log'.
Please ensure the emails on the Bromcom system have the email type set to 'Home'.
Please also ensure 'Emails' is ticked in MLS Importer Settings.
The Year 7 Students Are in the MIS but They Are Not in the Intake Table.
If you have Connect in place, please ensure the students are 'on-role' within SIMS and manually run the MLS Eclipse job.