Hey Nathan,
That's a great tutorial on using the Data Export tool. You may run into an issue with the name of the files being exported as they will contain '/'s from the date setting (This happened to me). I updated the filename to using the following code which uses hyphens rather than a slash in the date:
FirstName +'_'+ LastName +'_'+ ID +'_' + RIGHTSTRING(CHARACTER(MeetingDate),4)+'-'+LEFTSTRING(CHARACTER(MeetingDate),2) +'-'+ SubString(CHARACTER(MeetingDate),4,2)+'_ESER'
My notes from the data export tool it's good but missing a few things I wanted:
1. It only exported powerschool forms. No attached documents (signed sheets etc...)
2. There is not an option to export uploaded files (Scanned IEP's etc..)
3. You have to set-up and run a separate export for each form type you want to export.
If you are looking to get the latest powerschool IEP and ESER document into Embrace this will work.
My Consulting Hat here:
I have also been working on this issue and have found a process to export a full archive from PowerSchool Special Programs, a folder for each student with all documents (PowerSchool forms, attachments, and uploads).
I have also been able to package an upload for Embrace for active students with those same documents (or a subset if you only wanted a fews years of information brought into Embrace). These files will go into the student "View/Upload Files" area.
This process has many steps using a few different tools. I would be happy to work with districts if they required this type of support. Please email
bra...@computerhands.com for more information.
Cheers
Brandon