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
You are not allowed to follow up in this post.

Sign in to reply to this post.