@cdenesha

Every time I go through the steps to import, it states "all classes have been imported"

I'm integrated ASM already, and ASM has all of the right classes setup

Are you running the JSS locally? Make a backup before you do the ASM sync with users.. All users associated with a class you've already imported will come in on sync.. and you may not have the ability to verify the user matching with existing users. Personally I would consider deleting the classes and re-importing... if it is a small number. :)

The JSS is hosted with an external provider, so maybe that's causing an issue?

I've only setup 2 classes for now as a test, and have tried deleting and re-importing already. I just got the import done correctly, finally, so really would like to avoid any re-importing.

Kind of on a time crunch so might just create the 30 classes manually.

@Wheelspinning With regard to your "all classes have been imported" message, that will be displayed if there are no remaining classes left to import. It will also be displayed if there are simply zero classes to import (i.e. Apple School Manager sync hasn't occurred yet, or it is still in progress).

Have you verified that your Apple School Manager sync has occurred at least one time? When the JSS "syncs" with Apple School Manager, it is actually downloading a full copy of your Apple School Manager dataset. It may be that you've setup Apple School Manager to sync but it just hasn't happened yet?

Has anyone spoken with anyone at PowerSchool to confirm which fields they will be using with the integration with ASM?

The field list that was shared with me by our Apple SE is different than the one above, but requires fewer file modifications to create. That said my issue is person_id on the student and staff files are not unique using the ID field from PowerSchool.

I would like to know the exact field list that PowerSchool will be using in their Connector as well.

In my testing, a student with one person_id will become Inactive if they are uploaded with another person_id. Which makes sense because it is a different person according to the unique person_id.

If we choose the wrong fields for any of the unique IDs then we'll have a mess, inactive users unable to use their Managed Apple ID, classes and rosters invalid, etc. ('Oddly enough' if you then go back and use the original person_ids they do not become Active, you have to Restore them manually)

I raised the issue on Monday with my SE and with Apple Enterprise so we'll see what happens. I'm not deploying Apple School Manager until this is straightened out.

chris

@cdenesha
If person ID will affect who gets deactivated, I think the issue with [Teachers]ID is that in PowerSchool it's different for every single affiliation that the user has with a school. Teachers at two schools will have 2 IDs, but that's the ID that links sections and class enrollments to them. The only other ID would be in Users table for teachers that can maybe be linked to sections via teacher ID.

Our PS person said that when a nightly export happens you cannot do a Where clause and that everything in the DB would be exported for those fields - including classes from previous years.

How is he/she exporting the data? AutoSend? Because we have a ton of automated SQL-infused exports out of PowerSchool at any hour of day and night, and never had an issue with SQL filtering.

Anybody else having an issue with PowerSchool roster_id value to be in a format like x(y-z)?

That is how our period expressions are, and it appears that ASM import doesn't like it?
Even though the documentation just says it expects a string

Here's where I stand...
I imported my .csv's into ASM, I synced with the JSS, then imported. I went in and cleaned up my Users in the JSS. I kept all new users created from the ASM import and deleted any matching users that existed before the import. I also had to update all the Users email fields to reflect their true email addresses, since the real email addresses don't have "appleid." jammed in the front of the domain name, and/or a -1 concatenated on the back of their username.

The Classes generated look pretty good. Now we have roster changes and I'm not sure what to do to have them reflected in the JSS. We've had one user account added and one user account updated directly in the ASM, where the name was Jane Doe, but should have been John Doe, we also updated the AppleID to reflect the name change. Beyond that, the only thing that's changed is the roster info. Do I use the same set of .csv's that I originally imported into ASM and just tack on the roster changes after the original roster records? Do I delete the all the original records in rosters.csv and just add the roster's changed records? Can I leave the Classes as is in the JSS, do a sync and import again?

@Olson ASM is expecting a full dump of current data. For example if you leave out some students they become Inactive. I'm not sure exactly what will happen for roster changes, but if you deleted them all it would probably wipe out your Classroom students as they would no longer be linked. I would simulate a full current PS dump by adding the new entries at the bottom, and by deleting the rosters that the student is now no longer taking.

Leave all as is in the JSS, and during the sync any student in those classes will automatically be updated. You only need to import again if you have new classes or students not in a class.

We've managed to upload all our csv files successfully and the teacher can see their classes in Apple Classroom. The teacher and students are correct but the display names of the classes (inside the app) are not. It seems the names are getting mixed up with something. I've checked Casper and the Apple School Manager portal and the name is correct in both places.

Anyone know what might be causing this?

I've also noticed that the Classes display name in Casper seems to use the coursesID from the classes csv file.

How are you guys getting this information out of powerschool? I was advised by PS that all of this can be done via an AutoSend scheduled Export. Is this true? If not what method are you using?