[wetech] Destiny - PowerSchool updates

425 views
Skip to first unread message

Sue Salzsieder

unread,
Sep 14, 2012, 3:25:13 AM9/14/12
to wetech -- Wisconsin PK-12 Educational Technology List, Wisconsin Educational Media and Technology Association (WEMTA)

Does anyone use PowerSchool to update their Destiny database nightly?  If so, would you please give me a contact who knows what to do?  I’d like my technology person to talk with them and borrow the script/program needed.  We are still updating once during the late summer, then adding each new student during the rest of the year.

 

Thanks in advance for your time!

 

Sue E. Salzsieder Wisconsin library symbol small

Library Media Specialist

5/6th Grade Technology Teacher

Chilton Elementary & Middle Schools

421 Court ST

Chilton. Wi  53014-1162

920-849-3176  su...@chilton.k12.wi.us

 

---

You are currently subscribed to wetech as: wetech-gar...@googlegroups.com.

To unsubscribe go to: http://www.dpi.wi.gov/imt/wetech.html

Tom Hafemann

unread,
Sep 14, 2012, 9:34:21 AM9/14/12
to wetech -- Wisconsin PK-12 Educational Technology List, (WEMTA), Wisconsin Educational Media and Technology Association
Hello all,
 
Sorry to hijack this thread.  There are a number of us who use Destiny as our library system.  We have been talking all summer long about how Destiny doesn't have any really good integration into any SIS, directory system, etc.  While many of us have 'made it work' through scripts and piecing it together, we got to thinking that we really should put pressure on Follett, collectively, to play nicely with the rest of the integration world so that we do not have to piece a system together that kinda works for us.  It really isn't that hard and not much effort needs to be made to open up their system for two way communication of adding and removing students.
 
Maybe we can get a GAMS-like utility for Destiny?  :)
 
Tom


>>> Sue Salzsieder <su...@chilton.k12.wi.us> 9/14/2012 2:25 AM >>>

Does anyone use PowerSchool to update their Destiny database nightly?  If so, would you please give me a contact who knows what to do?  I’d like my technology person to talk with them and borrow the script/program needed.  We are still updating once during the late summer, then adding each new student during the rest of the year.

 

Thanks in advance for your time!

 

Sue E. Salzsieder Wisconsin library symbol small

Library Media Specialist

5/6th Grade Technology Teacher

Chilton Elementary & Middle Schools

421 Court ST

Chilton. Wi  53014-1162

920-849-3176  su...@chilton.k12.wi.us

 

---

You are currently subscribed to wetech as: Thaf...@csd.k12.wi.us.

If this is an unsolicited spam message, please click this link to report it: Report Spam


Confidentiality Notice: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.
CAUTION:
Internet and e-mail communications are CSD (Campbellsport School District) property.   CSD reserves the right to retrieve and read any message created, sent and received.  CSD reserves the right to monitor messages by authorized CSD students, employees, and volunteers at any time without any further consent.
All CSD email may be subject to open records laws.
For your safety, this message has been scanned by Campbellsport's security gateway.  Portions of this message may have been altered or deleted as our SMTP policy dictates.  For more information, please contact the CSD @ 1-920-533-8381 x1259

IMAGE.gif

Cory Calvert

unread,
Sep 14, 2012, 3:13:38 PM9/14/12
to wetech -- Wisconsin PK-12 Educational Technology List
A few years ago, I put some time into writing a customized XSLT file to handle our Destiny data import.  I have only had to modify a student patron in Destiny by hand once or twice since then, due to their student ID changing.  We use Skyward, but you should be able to do the same thing with any student record system, so long as you can get it to generate a CSV file with the fields that you need for each student, and put the file somewhere where you Destiny server can access it.
 
There is some documentation on the import process and how to write the XSLT file on your Destiny server in the \Follett\FSC-Destiny\fsc\transform\doc directory.  The documentation is helpful, but if you want to do anything sophisticated, you will probably need to get a book or some other reference on XSLT.  The import process, which gets triggered as a scheduled task in Windows, will take your CSV file, turn it into a very basic XML file, and then process that with the XSLT to generate the file that will actually get imported into Destiny.
 
Also, the way that LDAP works in Destiny is really, really "stupid," for lack of a better term.  Rather than searching your directory to find the correct context of the user account when logging in, it wants the full context in the LDAP server setup.  This means that you either have to have your user accounts in a single container in your directory, or you have to have a separate patron type in Destiny for each user OU, with each of those having a separate LDAP server configuration.  You can work around this if you store some of the context information to find an account in a user defined field in the patron record.  You can reference the user defined fields an include them in your LDAP server configuration to build the user DN, like this:  cn=${USERNAME},ou=${UD1},ou=Students,o=WSD
 
I have attached the XSLT file that we use.  It will not work for you without modifying it fit your own environment and matching up the Destiny fields to the correct field numbers in your Power School export, but it should be a good place to start.

 
Cory Calvert
District Network Administrator
Waterloo School District
813 North Monroe Street
Waterloo, WI  53594
(920) 478-3633 ext. 4505
>>> Sue Salzsieder <su...@chilton.k12.wi.us> 9/14/2012 2:25 AM >>>

Does anyone use PowerSchool to update their Destiny database nightly?  If so, would you please give me a contact who knows what to do?  I’d like my technology person to talk with them and borrow the script/program needed.  We are still updating once during the late summer, then adding each new student during the rest of the year.

 

Thanks in advance for your time!

 

Sue E. Salzsieder Wisconsin library symbol small

Library Media Specialist

5/6th Grade Technology Teacher

Chilton Elementary & Middle Schools

421 Court ST

Chilton. Wi  53014-1162

920-849-3176  su...@chilton.k12.wi.us

 

---

You are currently subscribed to wetech as: calv...@waterloo.k12.wi.us.

---

FSCStudent.xsl
Reply all
Reply to author
Forward
0 new messages