[Ils-source] r1457 - in trunk: addons/ccure addons/ccure/pre9000 addons/ccure/vws webapp/api/ccure/user/put

scribe at crosswire.org scribe at crosswire.org
Mon May 9 16:12:32 MST 2016 

Author: scribe
Date: 2016-05-09 16:12:32 -0700 (Mon, 09 May 2016)
New Revision: 1457

Added:
   trunk/addons/ccure/pre9000/
   trunk/addons/ccure/pre9000/README.txt
   trunk/addons/ccure/pre9000/ilsccureconnector.exe
   trunk/addons/ccure/pre9000/ilsccureconnector/
   trunk/addons/ccure/pre9000/ilsccurehook.dll
   trunk/addons/ccure/vws/
   trunk/addons/ccure/vws/README.txt
   trunk/addons/ccure/vws/SimpleMessageQueue-installer.exe
Removed:
   trunk/addons/ccure/README.txt
   trunk/addons/ccure/ilsccureconnector.exe
   trunk/addons/ccure/ilsccureconnector/
   trunk/addons/ccure/ilsccurehook.dll
Modified:
   trunk/webapp/api/ccure/user/put/index.jsp
Log:
Moved old CCURE integration to 'pre9000' folder
Created new vws folder for new CCURE with Victor Web Services integration module
Added README.txt which explains how to configure everything.
Added more locations to find workgroup



Deleted: trunk/addons/ccure/README.txt
===================================================================
--- trunk/addons/ccure/README.txt	2016-04-29 19:59:33 UTC (rev 1456)
+++ trunk/addons/ccure/README.txt	2016-05-09 23:12:32 UTC (rev 1457)
@@ -1,76 +0,0 @@
-# jobs.xml
-# Need to uncomment a scheduling job to run the CCURE
-#<trigger>
-#	<cron>
-#		<name>CCURELockedRecords</name>
-#		<group>ILSTriggers</group>
-#		<job-name>CCURERetryLockedRecords</job-name>
-#		<job-group>CCURE</job-group>
-#		<cron-expression>0 * * * * ?</cron-expression>
-#	</cron>
-#</trigger>
-#
-#
-#
-#
-#-----------------------------------------------
-
-
-
-#sysconfig.properties parameters with examples:
-
-# URL to exactly the root of the ILS, including port if necessary
-ILSURL=http://localhost:8081
-
-# hostname[:port] for the CCURE system
-CCUREHost=216.119.104.185:2500
-
-# CCURE user with ODBC rights
-CCUREDBUser=sysprogress
-
-# password for the CCURE user with ODBC rights
-CCUREDBPassword=manager
-
-# ----------------------------------------------------------------------
-# static ILS Role into which we place all new CCURE users in the ILS
-# unless CCURERoleField, below, is specified and contains data
-CCURERole=GA
-
-# CCURE Role Field Name which specifies into which ILS Role a new CCURE user
-# should be placed in the ILS. If parameter is not specified or the
-# field does not contain data in the CCURE database, then the above CCURERole
-# value will be used as the new ILS user's Role.
-CCUREFieldRole=Text14
-# ----------------------------------------------------------------------
-
-# ----------------------------------------------------------------------
-# static ILS Location into which we place all new CCURE users in the ILS
-# unless CCURELocationField, below, is specified and contains data
-CCURELocation=FAA
-
-# CCURE Location Field Name which specifies into which ILS Location a new CCURE
-# user should be placed in the ILS. If parameter is not specified or the field
-# does not contain data in the CCURE database, then the above CCURELocation
-# value will be used as the new ILS user's Location.
-CCUREFieldLocation=Text1
-# ----------------------------------------------------------------------
-
-# These parameters are optional if the defaulted values, given in the examples
-# below match your system.
-
-CCUREFieldAddr1=Text1
-CCUREFieldCity=Text2
-CCUREFieldState=Text3
-CCUREFieldZip=Text4
-CCUREFieldPhone=Text5
-
-CCURECourse.1=Security Awareness
-CCUREFieldCourseResult.1=Text15
-CCURECourse.2=SIDA
-CCUREFieldCourseResult.2=Text16
-CCURECourse.3=Authorized Signer
-CCUREFieldCourseResult.3=Text17
-CCURECourse.4=Non-Movement Area Drivers Training
-CCUREFieldCourseResult.4=Text18
-CCURECourse.5=Movement Area Drivers Training
-CCUREFieldCourseResult.5=Text19

Deleted: trunk/addons/ccure/ilsccureconnector.exe
===================================================================
(Binary files differ)

Deleted: trunk/addons/ccure/ilsccurehook.dll
===================================================================
(Binary files differ)

Copied: trunk/addons/ccure/pre9000/README.txt (from rev 1447, trunk/addons/ccure/README.txt)
===================================================================
--- trunk/addons/ccure/pre9000/README.txt	                        (rev 0)
+++ trunk/addons/ccure/pre9000/README.txt	2016-05-09 23:12:32 UTC (rev 1457)
@@ -0,0 +1,76 @@
+# jobs.xml
+# Need to uncomment a scheduling job to run the CCURE
+#<trigger>
+#	<cron>
+#		<name>CCURELockedRecords</name>
+#		<group>ILSTriggers</group>
+#		<job-name>CCURERetryLockedRecords</job-name>
+#		<job-group>CCURE</job-group>
+#		<cron-expression>0 * * * * ?</cron-expression>
+#	</cron>
+#</trigger>
+#
+#
+#
+#
+#-----------------------------------------------
+
+
+
+#sysconfig.properties parameters with examples:
+
+# URL to exactly the root of the ILS, including port if necessary
+ILSURL=http://localhost:8081
+
+# hostname[:port] for the CCURE system
+CCUREHost=216.119.104.185:2500
+
+# CCURE user with ODBC rights
+CCUREDBUser=sysprogress
+
+# password for the CCURE user with ODBC rights
+CCUREDBPassword=manager
+
+# ----------------------------------------------------------------------
+# static ILS Role into which we place all new CCURE users in the ILS
+# unless CCURERoleField, below, is specified and contains data
+CCURERole=GA
+
+# CCURE Role Field Name which specifies into which ILS Role a new CCURE user
+# should be placed in the ILS. If parameter is not specified or the
+# field does not contain data in the CCURE database, then the above CCURERole
+# value will be used as the new ILS user's Role.
+CCUREFieldRole=Text14
+# ----------------------------------------------------------------------
+
+# ----------------------------------------------------------------------
+# static ILS Location into which we place all new CCURE users in the ILS
+# unless CCURELocationField, below, is specified and contains data
+CCURELocation=FAA
+
+# CCURE Location Field Name which specifies into which ILS Location a new CCURE
+# user should be placed in the ILS. If parameter is not specified or the field
+# does not contain data in the CCURE database, then the above CCURELocation
+# value will be used as the new ILS user's Location.
+CCUREFieldLocation=Text1
+# ----------------------------------------------------------------------
+
+# These parameters are optional if the defaulted values, given in the examples
+# below match your system.
+
+CCUREFieldAddr1=Text1
+CCUREFieldCity=Text2
+CCUREFieldState=Text3
+CCUREFieldZip=Text4
+CCUREFieldPhone=Text5
+
+CCURECourse.1=Security Awareness
+CCUREFieldCourseResult.1=Text15
+CCURECourse.2=SIDA
+CCUREFieldCourseResult.2=Text16
+CCURECourse.3=Authorized Signer
+CCUREFieldCourseResult.3=Text17
+CCURECourse.4=Non-Movement Area Drivers Training
+CCUREFieldCourseResult.4=Text18
+CCURECourse.5=Movement Area Drivers Training
+CCUREFieldCourseResult.5=Text19

Copied: trunk/addons/ccure/pre9000/ilsccureconnector.exe (from rev 1447, trunk/addons/ccure/ilsccureconnector.exe)
===================================================================
(Binary files differ)

Copied: trunk/addons/ccure/pre9000/ilsccurehook.dll (from rev 1447, trunk/addons/ccure/ilsccurehook.dll)
===================================================================
(Binary files differ)

Added: trunk/addons/ccure/vws/README.txt
===================================================================
--- trunk/addons/ccure/vws/README.txt	                        (rev 0)
+++ trunk/addons/ccure/vws/README.txt	2016-05-09 23:12:32 UTC (rev 1457)
@@ -0,0 +1,66 @@
+This addon is for connecting a CCURE system which includes Victor Web Services
+to the iLS.
+
+I. Adding users from CCURE into the iLS:
+
+1) Configure an event in CCURE to output to a filesystem folder an XML file for a
+user when their personel record is created in the CCURE system.  The XML file
+should look similar to:
+
+<?xml version="1.0" encoding="utf-8" standalone="yes"?>
+<CrossFire culture-info="en-US" platform-version="2.40.8" product-version="2.40.8">
+  <SoftwareHouse.NextGen.Common.SecurityObjects.Personnel ImportMode="Default">
+    <Name>DRAIN, KENNETH LIAM</Name>
+    <GUID>37fa8d94-6103-438b-8a02-f032a3ef2d8b</GUID>
+    <ObjectID>58931</ObjectID>
+    <PartitionKey>$$Default$$</PartitionKey>
+    <UDF__JIA_ROLE_>Unlocked</UDF__JIA_ROLE_>
+    <SoftwareHouse.NextGen.Common.SecurityObjects.Credential ImportMode="Default">
+      <UDF__COMPANY_1_>JOHNSON CONTROLS</UDF__COMPANY_1_>
+    </SoftwareHouse.NextGen.Common.SecurityObjects.Credential>
+  </SoftwareHouse.NextGen.Common.SecurityObjects.Personnel>
+</CrossFire>
+
+2) Install the SimpleMessageQueue windows service using the installer in this
+folder onto the machine where the filesystem folder exists.
+
+3) Configure the SimpleMessageQueue service (from the Windows Control Panel)
+	a) to monitor the folder where CCURE will output XML files for new users.
+	b) to point to the iLS webservice to create a new user, e.g.,
+		https://www.mytrainingportal.net/airportXYZ/api/ccure/user/put/
+	c) in the Extra Param 1 field Parameter Name enter: ILSUSER
+	d) in the Extra Param 1 field Parameter Value enter your API user name
+	e) in the Extra Param 2 field Parameter Name enter: ILSPASSWD
+	f) in the Extra Param 2 field Parameter Value enter your API user password
+	g) in the Data Parameter Parameter Name enter: data
+	h) In the Remove Message From Queue Upon Successful Processing Determined By,
+		choose Service Response Starts With and enter: <success
+
+
+II. Returning test results back to CCURE from the iLS
+
+1) In the CCURE system, configure UDF field sets to receive the data:
+	a) UDF__TRAINING_COURSE_1_	- to receive the course name
+	b) UDF__TRAINING_DATE_1_	- to receive the course completion date
+	c) UDF__TRAINING_SCORE_1_	- to receive the user's score
+	d) UDF__TRAINING_RESULT_1_	- to receive PASSED or FAILED
+
+	e) repeat these fields using _2_ ... _n_ for n number of courses to be
+		returned to CCURE from the iLS.
+
+1) In the iLS System Management Panel
+	a) enable Web Service API
+	b) enter the URL to the iLS CCURE updatescore.vws webservice in the
+		Callback URL - Course Complete field, e.g.,
+		http://www.mytrainingportal.net/airportXYZ/api/ccure/updatescore.vws/
+2) In the iLS sysconfig.<companynumber>.properties file enter the Victor Web Services
+	configuration information
+	a) CCUREVWSRoot=https\://ccure.airportXYZ.com/victorwebservices/api
+	b) CCUREUser=Worgroup\\ccuremgr
+	c) CCUREPassword=xyzzy
+
+3) In the iLS database COURSE table, for each course which should report data
+	to CCURE, enter into the USERDATA column for that course
+	an integer which corresponds to the UDF fieldset number which should
+	receive the data for that course (fieldsets created in step II.1)
+

Added: trunk/addons/ccure/vws/SimpleMessageQueue-installer.exe
===================================================================
(Binary files differ)


Property changes on: trunk/addons/ccure/vws/SimpleMessageQueue-installer.exe
___________________________________________________________________
Added: svn:mime-type
   + application/octet-stream

Modified: trunk/webapp/api/ccure/user/put/index.jsp
===================================================================
--- trunk/webapp/api/ccure/user/put/index.jsp	2016-04-29 19:59:33 UTC (rev 1456)
+++ trunk/webapp/api/ccure/user/put/index.jsp	2016-05-09 23:12:32 UTC (rev 1457)
@@ -253,12 +253,27 @@
 
 		++errCode;
 		val = record.getValue("UDF__COMPANY_");
+
+
+		// again, code to look in multiple places for workgroup information
 		if (val == null || val.length() == 0) val = record.getValue("UDF__COMPANY_1_");
 		if (val == null || val.length() == 0) val = record.getValue("UDF__VQQ_CO_");
 		if (val == null || val.length() == 0) val = record.getValue("UDF__CRG_CO_");
 		if (val == null || val.length() == 0) val = record.getValue("UDF__JIA_COMPANY_");
 		if (val == null || val.length() == 0) val = record.getValue("UDF__CECIL_COMPANY_");
 		if (val == null || val.length() == 0) val = record.getValue("UDF__JAXEX_COMPANY_");
+		if (val == null || val.length() == 0) {
+			XMLBlock credentials = record.getBlock("SoftwareHouse.NextGen.Common.SecurityObjects.Credential");
+			if (credentials != null) {
+				val = credentials.getValue("UDF__COMPANY_");
+				if (val == null || val.length() == 0) val = credentials.getValue("UDF__COMPANY_1_");
+				if (val == null || val.length() == 0) val = credentials.getValue("UDF__VQQ_CO_");
+				if (val == null || val.length() == 0) val = credentials.getValue("UDF__CRG_CO_");
+				if (val == null || val.length() == 0) val = credentials.getValue("UDF__JIA_COMPANY_");
+				if (val == null || val.length() == 0) val = credentials.getValue("UDF__CECIL_COMPANY_");
+				if (val == null || val.length() == 0) val = credentials.getValue("UDF__JAXEX_COMPANY_");
+			}
+		}
 		val2 = request.getParameter("locationUserData");
 		int requestedLocation = -1;
 		if ((val != null && val.trim().length() > 0) || (val2 != null && val2.trim().length() > 0)) {

More information about the Ils-source mailing list