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.