Jenzabar SIS and Canvas data uploads

[rtyger]

I'd like to reopen this conversation.  We still do not have a working SIS data upload system due to issues related with the tables in our Jenzabar registration module and how that office is dropping students from courses (purging for non-payment, etc.) and then reinstating students.  The timestamping is not captured in a way that our script can read the newest, most accurate student enrollment data to upload into Canvas.  Does anyone use Jenzabar?  If so, could you become a consultant?  

[talway · Accepted solution]

Hello.  Are you still looking for an answer to your question or have you been able to resolve this?  I am not interested in being a consultant but I can share with you how our Jenzabar SIS integrates with Canvas.

[rtyger]

I think we finally have a very basic SIS upload to SFTP server process

working. We only create users, courses, and enrollments.

<http://dillard.edu/>

Dr. Rona Tyger

Director, Department of Academic Technology and Distance Education

Dillard University

P: (504) 816-4873 V: (504) 383-5603

E: rtyger@dillard.edu <email@dillard.edu> *W: *

http://bit.ly/AcadTech_DistEd

<https://www.facebook.com/dillarduniversity/>

<https://twitter.com/du1869?lang=en>

<https://www.instagram.com/dillarduniversity/?hl=en>

BLUE4ed <http://bleu4ed.org/> - Co-Director;

PRONOUNS: She, Her, Hers

Office: Alexander Library 222; @The DEAL Center, Alexander Library 220

aut viam inveniam aut faciam

On Tue, Jan 21, 2020 at 3:43 PM talway@westshore.edu <instructure@jiveon.com>

[stacey_duke]

Hi Tom! 

If you could please share any tips on creating CSV files to export from Jenzabar and upload into Canvas, I would be grateful. We are having some issues with course ids and course sections related to cross-listed courses. 

Stacey

[apitzner]

We would be interested in learning how you integrate between Jenzabar and Canvas.  We're using .csv sftp files and run into difficulties from time to time and would like to bounce best-practices and workflow logic around with others.

Thank you in advance!

[ellington]

Hello,

My name is Jeremiah Ellington I'm the systems administrator for Holy Names University and I would like to talk about how you are integrating Jenzabar and Canvas! Right now I'm running a custom integrating written in Python to move our current SIS ( Blackbaud on-prim ) course/enrollment information to Canvas via the SIS API flat file endpoint.

I will be working with Jenzabar very soon and would like to know much more about the processes you've worked out!

Thank you,

Jeremiah Ellington

Systems & Application Manager

Holy Names University

Oakland, Ca.

[AbdelkarimBetta]

can you please help 

[EricFeldhusen]

I'd be interested in seeing how you did this.
Eric Feldhusen

[TimPonder]

I know this is old but if the offer still stands I would appreciate speaking to you about this.

[ChatfieldDean]

We are also experiencing difficulty.  In our case, the csv export functionality to SFTP is now erratic after a recent upgrade. Unfortunately, the xml alternative produces a file with formatting that is incompatible with Canvas import requirements.

We discovered this when trying to solve the problem of having the SIS export lead to a student being converted to inactive status (rather than being deleted) from Canvas.  All grades and files associated with the user disappear and do not reappear upon reinstatement.  Still haven't solved that one.....

[p_vanrijn]

We are moving from Jenzabar ELearn to Canvas this year. We do not have the in-house knowledge to build out the sftp upload from scratch. Based on what I am finding in this post is that I am not alone in this quest. 

I would be extremely grateful if you would be willing to share your knowledge. I am also willing to hire someone as a consultant to set this up. I do have all the queries for the required data that needs to go to Canvas. I also would like to pull back mid-term and final grades into Jenzabar. 

Thank you.

Paul van Rijn
University of Valley Forge

[dgrobani]

You might want to post something on the community's Jobs Board.

[p_vanrijn]

We have Jenzabar and Canvas. Obviously, Jenzabar has done some of these integrations for their customers: They have a complete integration where the courses, users and enrollments are sent to Canvas and the final (and midterm (?)) grade come back into Canvas. We have a quote for this work from Jenzabar, but have not implemented. We still upload the csv files "manually".

[EricFeldhusen]

I'm still having the hardest time figuring out how to do the specific csv exports from within Jenzabar is my current problem.

Any suggestions on where to start?

Eric Feldhusen

[p_vanrijn]

3 sql queries by semester: Users, enrollments and courses formatted as per the Canvas sis import instructions. Output as csv. We then upload courses and users via the sis import. We then upload the enrollment as a "full batch" to the proper term. This adds/removes the proper accounts to courses.

[EricFeldhusen]

Would it be possible to get those Jenzabar SQL queries from you?