Forum Discussion
Possible problems with periodic sync aproach?
Thanks for the quick answer. I know that the sections stay intact but what about the students if in the new CSV-files there is no mention of the section listed in previous CSV-files. Here is the scenario:
Sync 1 with CSV files batch 1: Section A (SIS ID 11111) with students
Sync 2 with CSV files batch 2 (same sync profile as Sync 1): Section B (SIS ID 2222) with students . In the batch 2 there is no mention of Section A in the section CSV file nor the student enrollment or teacher roster CSV files!
What will happen to Section A after Sync 2 is run?
- Section A will be gone and students too (I beleive this will not be the case)
- Section A will be there but with no students
- Section A will be there with the students
So, I want to find out how does the comparison actually work between different CSV-files :)
Hi Jarkko,
If I understand your question correctly, you want to make sure the groups that SDS creates from the CSV file from your student information system will not go away when you do a new sync.
One of the designs of School Data Sync is to make sure it does not over-write or delete anything. While a group may change (for example, if a student leaves a school or gets added mid-term), SDS will not delete the group. However, if you remove any or all users from a group in your SIS, then that change will be reflected the next time SDS Sync runs.
So the answer to your question depends on the data that is in the new CSV file you sync.
for example:
If you create a section in September called "Science 101", the members of that section (teachers and students) will be added to the group in Office 365 called "Science 101". (The actual group will have a unique SIS ID). If a student gets added in October, the group will be automatically updated with the new student next time SDS sync runs. If a student leaves the class, they will be removed.
Now it is January, the start of a new term. There is a new group of students in Science 101. The most common scenario is your SIS ID for that section is unique, and a new group will be created for science 101. The old group will remain until you, as the tenant global administrator, take action to remove it.
If you re-use the exact same SIS ID for Science 101 in January that you used in September, then I expect all the old group members would be removed. This is something I would need to test/verify since the more common scenario is the SIS uses a different SIS ID.
The disadvantage to SDS not removing groups is that in some cases you may want them to be gone.
If you want to remove users or sections, here is some more information on that:
- Here is a SOC article which walks through removing users - https://support.office.com/en-us/article/Delete-a-user-from-your-organization-D5155593-3BAC-4D8D-9D8B-F4513A81479E
- If you want to remove users in bulk, PowerShell is the way to go. Use the https://go.microsoft.com/fwlink/?linkid=842230 PowerShell cmdlet
I hope this helps,
Matt McGinnis
Thanks for the quick answer. I know that the sections stay intact but what about the students if in the new CSV-files there is no mention of the section listed in previous CSV-files. Here is the scenario:
Sync 1 with CSV files batch 1: Section A (SIS ID 11111) with students
Sync 2 with CSV files batch 2 (same sync profile as Sync 1): Section B (SIS ID 2222) with students . In the batch 2 there is no mention of Section A in the section CSV file nor the student enrollment or teacher roster CSV files!
What will happen to Section A after Sync 2 is run?
- Section A will be gone and students too (I beleive this will not be the case)
- Section A will be there but with no students
- Section A will be there with the students
So, I want to find out how does the comparison actually work between different CSV-files :)
My sincere apologies for the inexcusably late response. For some reason I'm no longer getting the notifications for responses on the forum- I need to fix that.
In your scenario, you have control over what happens.
your "option 1" will not happen- SDS will not remove the group if the group no longer exists in the CSV file.
If your "section" CSV file for 11111 is updated in the new CSV and the teachers and students are removed, they will be removed from the group.
If you "section" CSV file makes no reference to section 11111 at all, then it will be retained with all members still there.
We are working on additional end of term functionality and will have more information and details in the coming months. Stay tuned!
thanks,
Matt McGinnis
Hi!
"If you "section" CSV file makes no reference to section 11111 at all, then it will be retained with all members still there."
I have to disagree about that one. If there is no reference to section 11111 at all, then students are removed. I have tested this.
So I would say, that the correct answer is: "2. Section A will be there but with no students"
If that is not way you wan't it, you have to change your query so that also archived (Primus?) sections are still in the csv file.
br Tapio Aalto