Student import toolkit fixes

"ORA-01843: not a valid month" when importing students
Imported students not enrolled in organization courses
Version 1.51 import component not compatible with version 1.50 programs

Date: May 1, 2001

Version affected: v1.51
Does not affect copies of WBT Manager 1.51 downloaded after May 1, 2001.

Symptoms:

"ORA-01843: not a valid month" when importing students

When importing students into an Oracle database using the student import toolkit component an error is returned for each student if there is a course assigned to the department and set to be assigned to all new students. The student is added successfully and they will be enrolled in the first course assigned to the department but no entry for new course enrollment will be created in the BEVENT table for reporting or billing purposes.

Cause: The date format routine was modified to use a format less sensitive to different country preferences. This change did not make it into the import component.

Imported students not enrolled in organization courses

When importing students they are not enrolled in courses assigned to their organization. They are enrolled in courses assigned to their department.

Cause: The import component was looking for courses assigned to a non-existent organization instead of the student's current organization.

Version 1.51 import component not compatible with version 1.50 programs

Custom import programs compiled against version 1.50 of the import component (wbtmanager2.dll) throw an error if they are used against version 1.51 unless they are recompiled. The error seen in Visual Basic would be "Class does not support Automation of does not support exepected interface".

Cause: Some of the CLASSIDs in the wbtmanager2.dll were inadvertantly changed when version 1.51 was built.

Correction:

There are two ways to install the corrected components:

The simplest way is to download the new version of the Student Import Toolkit from http://www.ielearning.com/wbt/support/files/importtools1512.zip. Then uninstall the version 1.51 import tools and reinstall the new version. The drawback to this method is that, with all of the support files, the installation set is almost 10MB in size.

The second method is to install the files included in this patch

This patch contains an updated version of wbtmanager2.dll, simport.exe, and wbtm_statusimport.exe (version 1.51.2) along with this html document.

After unzipping the patch file to a temporary directory:

unregister the existing version of wbtmanager2.dll

• start a command prompt (DOS) session
• change directories to where the dll is installed (default is C:\Program Files\Integrity eLearning\WBT Manager 1.5\Import Tools).
• enter the following command and hit return

c:\windows\system\regsvr32.exe -u wbtmanager2.dll (Windows 95/98)
c:\winnt\system32\regsvr32.exe -u wbtmanager2.dll (Windows NT)
c:\windows\system32\regsvr32.exe -u wbtmanager2.dll (Windows 2000)

Use the correct drive letter for the system drive in place of "c:"

Do not close the command prompt window, you will use it later.

copy the new versions of wbtmanager2.dll, simport.exe, and wbtm_statusimport.exe to the installation directory.

register the new version of wbtmanager2.dll

• enter the following command at the command prompt (from above).

c:\windows\system\regsvr32.exe wbtmanager2.dll (Windows 95/98)
c:\winnt\system32\regsvr32.exe wbtmanager2.dll (Windows NT)
c:\windows\system32\regsvr32.exe wbtmanager2.dll (Windows 2000)

Use the correct drive letter for the system drive in place of "c:"

Now close the command prompt window.

If you have custom import programs:

If you have custom VB import programs compiled against version 1.51.1 of wbtmanager2.dll you will probably have to re-compile them if you set a reference to wbtmanager2.dll within the VB project. If you used CreateObject when requesting import toolkit objects then you are probably ok.

We appologize for any inconvenience that this change may have caused. It is our intention to maintain binary compatibility between minor releases of the Import Toolkit component so that recompiles are not necessary in the future.