AnsweredAssumed Answered

Problem with SIS import and Course SIS ID

Question asked by Roberto Solis on May 27, 2019

Good morning, 

 

Recently, I started using batch mode to import courses and enrollments to Canvas. This would handle those students who switch courses by removing the student from the course. Then, I noticed an inconsistency with cross-listed courses (only courses that are cross-listed directly in our SIS).

 

Here is the code straight from the XML File

 

<group>
          <sourcedid>
               <source>PROD SCT Banner</source>
               <id>XLSA1201930</id>
          </sourcedid>
          <grouptype>
               <scheme>Luminis</scheme>
               <typevalue level="1">CrossListedSection</typevalue>
          </grouptype>
          <description>
               <short>Cross Listed Section Group</short>
          </description>
     </group>

 

Then, each course is added into the cross-listed section

<membership>
          <sourcedid>
               <source>Laredo Community College PROD SCT Banner</source>
               <id>XLSA1201930</id>
          </sourcedid>
          <member>
          <sourcedid>
               <source>Laredo Community College PROD SCT Banner</source>
               <id>30087.201930</id>
          </sourcedid>
          <idtype>2</idtype>
          <role roletype = "02">
          <status>1</status>
          </role>
          </member>
     </membership>

  30087.201930 refers to the course SIS ID which is one of the sections cross-listed.

<membership>
          <sourcedid>
               <source>Laredo Community College PROD SCT Banner</source>
               <id>XLSA1201930</id>
          </sourcedid>
          <member>
          <sourcedid>
               <source>Laredo Community College PROD SCT Banner</source>
               <id>30090.201930</id>
          </sourcedid>
          <idtype>2</idtype>
          <role roletype = "02">
          <status>1</status>
          </role>
          </member>
     </membership>

30090.201930 refers to the course SIS ID which is one of the sections cross-listed.

 

Up to this point, everything seems fine. However, when the course is created in Canvas, the course SIS ID shows XXLSA1201930. It is adding an extra X to the course SIS ID. 

 

Then, when I get a new file, I run the import in batch mode, and it is deleting the course from our Canvas instance. I tried to manipulate the file by adding an extra X, so that it shows XXLSA1201930, but I am getting a completely new course with an SIS ID of XXXLSA1201930.

 

We do not have an automated integration. We have to extract the files from banner daily. 

 

I like running this file in batch mode because it keeps course enrollments up to date. However, I have not been able to find a solution to this problem. 

 

Any advice or suggestion is greatly appreciated.

 

Thank you.

Outcomes