Problem with SIS import and Course SIS ID

[roberto_solis08]

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.