You are viewing limited content. For full access, please sign in.

Discussion

Posted to K-12 Education

Discussion

Skyward qmlativ and Laserfiche

posted on October 16, 2023 Show version history

My school district is getting ready to change finance and SISs from PowerSchool/eSchool to Skyward qmlativ. Are any other districts using Skyward qmlativ with Laserfiche and do you mind if I contact you about your experience?  

 

Thanks,

 

John Rokenbrod

john.rokenbrod@bryanisd.org

(979) 209-1108

2 0
replied on October 17, 2023 Show version history

Hey, I can connect sure, but I'm thinking it would be helpful to put some of that info out here for other folks to benefit from as well. 

We have been doing 2 things primarily: pulling data out and staging it in our SQL tables. We pull quite a bit every hour. No big issues there (knocks on wood). We use a PowerShell script to pipe it into SQL. SQL runs the scripts via Agent as a light SSIS package. We were using SSIS to pull Skyward data, this is much simpler and faster. 

The other ultra cool thing we are doing is creating new records in Q. Only invoices so far: travel reimbursement and po/non-po invoices. That happens using the Workflow HTTP Web activity. 

We have quite a bit more in mind, but the method should all stay pretty much the same: pull with PowerShell and write with Workflow. 

I have a tight deadline to meet, so not much time to spare until Nov 1st. I'm curious to hear who else have been doing similar things in Q. Thanks!

0 0
replied on October 17, 2023

Chris,

 

Thank you for taking time to reply. Good luck with your deadline. 

 

John

1 0
replied on May 2

Hey Chris,

Interesting topic, when you used PowerShell to pull data out of PowerSchool was it via a PowerSchool API?

 

0 0
replied on May 2

This was from back when we were pulling from Skyward (here in Washington known as WESPaC). It was not an API but a pipe into their very archaic database. Not SQL. So not, PowerSchool but rather WESPaC. Almost everyone has left or is leaving the WESPaC platform to the newer version of Skyward named Qmlativ which has an API and is SQL driven. 

0 0
replied on May 2

Ah okay, I misunderstood your post.  We also query into Qmlativ via Linked Server.  But we're looking for a way to do that with PowerSchool data or at least access the data via an API or automated export.

 

0 0
replied on May 3 Show version history

Same here actually. If memory serves, I have another post out there asking about PowerSchool as well. We're just in the talking phase, no real action yet. Might be another 6 months before we have any traction.

0 0
replied on May 5

Makes sense, we just started using PowerSchool and still figuring it all out.  For the moment, we're just running "baseball card" reports to export test score data, but we'd like to eventually add automation (as always).  wink

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.