Google GSDS export from Sims

[neonetman]

I'm looking to configure Google School Directory Sync to populate our classroom classes from Sims. The article below mentions CSV's exported from Sims, but neither myself nor the data manager can work out how to get the right files in the right format for this

 

Can you help please?

 

https://support.google.com/a/answer/6032762

 

Cheers

 

Iain

[gh5000]

You name and format the files according toIMS OneRosterTMv1.0specifications. You must keep all the filesin the same directory as SDS.

[gh5000]

https://www.imsglobal.org/lis/imsOneRosterv1p0/imsOneRosterCSV-v1p0.html#_Toc421598317

[gh5000]

Let us know if you get it working.

[gh5000]

Think it'll probably need some external manipulation to get the CSV correct. For example the users file is going to have to be combined with students and staff as I don't think they can be output in one CSV from SIMS

[Arthur]

The following blog post by @rogerdnixon might help?

 

https://wpsit.blogspot.com/2019/09/syncing-google-classroom-to-mis-data.html

[Ditto]

You might also want to look at https://www.salamandersoft.co.uk/. They offer some free utilities as well as a paid for solution if you want to make things easier.

[gh5000]

Hi,

 

I managed to spend a little bit of time on this today. Fortunately, I've also got a SIMS school that I'm currently setting up G Suite for to play with.

 

Zip file contains a SIMS report definition to import to SIMS, and a powershell script that runs the SIMS reports to CSVs, manipulates the CSVs into the format required by GSDS and runs the sync. The idea being that this powershell file could be set to run daily.

 

Cheers

Gavin

 

GSDS Sanitized.zip

[neonetman]

Thanks for that Ghanel,

 

I get an error runnig the script:- C:\Program' is not recognized as an internal or external command, which I presume relates to the Sims path

[gh5000]

Thanks for that Ghanel,

 

I get an error runnig the script:- C:\Program' is not recognized as an internal or external command, which I presume relates to the Sims path

 

Hi,

 

Yeah I was having problems with that. Make sure you've double-quoted your path - $simsCommandReporterPath = '"C:\Program Files\sims\sims .net\CommandReporter.exe"'

 

And let me know

[Arthur]

I get an error running the script:- C:\Program' is not recognized as an internal or external command, which I presume relates to the Sims path

Shouldn't the path to CommandReporter.exe be?

 

"C:\Program Files (x86)\SIMS\SIMS .net\CommandReporter.exe"

 

The path in the PowerShell script is missing the (x86).

 

$simsCommandReporterPath = '"C:\Program Files\sims\sims .net\CommandReporter.exe"'

[gh5000]

Shouldn't the path to CommandReporter.exe be?

 

"C:\Program Files (x86)\SIMS\SIMS .net\CommandReporter.exe"

 

The path in the PowerShell script is missing the (x86).

 

$simsCommandReporterPath = '"C:\Program Files\sims\sims .net\CommandReporter.exe"'

 

It depends on where SIMS is installed on whatever computer you are doing it. On the server I wrote the script on it is just c:\program files\

[gh5000]

Shouldn't the path to CommandReporter.exe be?

 

"C:\Program Files (x86)\SIMS\SIMS .net\CommandReporter.exe"

 

The path in the PowerShell script is missing the (x86).

 

$simsCommandReporterPath = '"C:\Program Files\sims\sims .net\CommandReporter.exe"'

 

Also, I know you like your scripts so if there's anything to tidy that script up feel free!

[neonetman]

I did make a couple of tweaks to get the script running:-

 

Split the command reporter line into 2:-

 

$simslocation = 'C:\Program Files (x86)\sims\sims .net'$simsCommandReporterPath = '"CommandReporter.exe"'

 

Then inserted these lines before the first invocation of the reporter:-

 

$currLocation = Get-LocationSet-Location = $simslocation

 

I do however still get an error in the data file:-

 

[gh5000]

I do however still get an error in the data file:-

 

[ATTACH=CONFIG]55259[/ATTACH]

 

So some how you are probably still outputting a class that either has no students or has no teachers.

 

Can you look at that line and see if it refers to students or teachers?

 

You may need to tweak the SIMS reports to suit your school. I had tried to mitigate for this in the Enrollment-Students report by filtering for classes:

1. Where teacherId that was not null ie had a teacher

2. Classes had more than 0 students

3. And the id of the student wasn't null

 

Enrollment Teachers only give classes with a teacherId.

 

You'll need to see why you are getting classes with no student or teacher id in those two reports. If you can tweak the report to sort that then you should be ok. If not we might have to remove it with powershell in the script.

[neonetman]

So some how you are probably still outputting a class that either has no students or has no teachers.

 

Can you look at that line and see if it refers to students or teachers?

 

You may need to tweak the SIMS reports to suit your school. I had tried to mitigate for this in the Enrollment-Students report by filtering for classes:

1. Where teacherId that was not null ie had a teacher

2. Classes had more than 0 students

3. And the id of the student wasn't null

 

Enrollment Teachers only give classes with a teacherId.

 

You'll need to see why you are getting classes with no student or teacher id in those two reports. If you can tweak the report to sort that then you should be ok. If not we might have to remove it with powershell in the script.

 

I've done a fair piece of work this morning amending the files to correctly format the username as required by our system, and apart from that one line (which is indeed a teacher-less class), it is running flawlessly

 

Once our timetabler uploads the class change to Sims tonight it should all be great

 

Thank you again

 

- - - Updated - - -

 

So some how you are probably still outputting a class that either has no students or has no teachers.

 

Can you look at that line and see if it refers to students or teachers?

 

You may need to tweak the SIMS reports to suit your school. I had tried to mitigate for this in the Enrollment-Students report by filtering for classes:

1. Where teacherId that was not null ie had a teacher

2. Classes had more than 0 students

3. And the id of the student wasn't null

 

Enrollment Teachers only give classes with a teacherId.

 

You'll need to see why you are getting classes with no student or teacher id in those two reports. If you can tweak the report to sort that then you should be ok. If not we might have to remove it with powershell in the script.

 

I've done a fair piece of work this morning amending the files to correctly format the username as required by our system, and apart from that one line (which is indeed a teacher-less class), it is running flawlessly

 

Once our timetabler uploads the class change to Sims tonight it should all be great

 

Thank you again

[Areku]

Hi,I managed to spend a little bit of time on this today. Fortunately, I've also got a SIMS school that I'm currently setting up G Suite for to play with.Zip file contains a SIMS report definition to import to SIMS, and a powershell script that runs the SIMS reports to CSVs, manipulates the CSVs into the format required by GSDS and runs the sync. The idea being that this powershell file could be set to run daily.

Cheers

Gavin[ATTACH]55252[/ATTACH]

 

 

You should have more rep for this, Just got the scripts and reports working, just at a time when the head was starting to panic about lock down again (and the other specialist software vendors currently have like a 2 week lead time, salamander told me it would be christmas!)

Thanks.