Sample XML and CSV files
This section contains sample XML mapping definition and sample CSV files for Reader.
Sample XML mapping definition
<table-config>
<table name="READER" transaction-type="INSERT_UPDATE" key-fields="RDR_NAME" primary-key="RDR_ID">
<fields>
<field index="1" db-field="RDR_NAME" />
<field index="2" db-field="RDR_DESC" />
<field index="3" db-field="RDRGRP_ID">
<reference table-name="READER_GROUP" supplied-value="RDRGRP_NAME" resolve-to-field="RDRGRP_ID"/>
</field>
<field index="4" db-field="RDR_IP_ADDRESS"/>
<field index="5" db-field="RDRSTAT_ID" default-value="ON-LINE">
<reference table-name="READER_STATUS" supplied-value="RDRSTAT_NAME" resolve-to-field="RDRSTAT_ID"/>
</field>
<field index="6" db-field="RDR_ZONE" default-value="0"/>
<field index="7" db-field="RDR_CONTROLLER" />
<field index="8" db-field="RDR_PASSWORD" />
<field index="9" db-field="RDR_LASTPOLLDATE" date-format="yyyyMMddHHmmss"/>
<field index="10" db-field="RDR_MESSAGE"/>
<field index="11" db-field="TZ_ID">
<reference table-name="TIMEZONE" supplied-value="TZ_JAVA_NAME" resolve-to-field="TZ_ID"/>
</field>
<field index="12" db-field="RDR_CMI_SUBADDR" />
<field index="13" db-field="RDR_CMI_DLFILE" />
<field index="14" db-field="RDR_CMI_AUTOCONN" />
<field index="15" db-field="RDR_CMI_DISPSIZE" />
<field index="16" db-field="RDR_CMI_TYPE" />
<field index="17" db-field="RDR_DISABLE_PIN" default-value="N"/>
<field index="18" db-field="RDR_ENABLE_BIO" default-value="N"/>
<field index="19" db-field="RDR_SKD_VALIDATION" default-value="N"/>
<field index="20" db-field="RDR_GRACE_START_MINUTES" default-value="0"/>
<field index="21" db-field="RDR_GRACE_END_MINUTES" default-value="0"/>
<field index="22" db-field="RDR_SWIPE_METHOD" default-value="C"/>
<field index="23" db-field="RDRTYPE_ID">
<reference table-name="READER_TYPE" supplied-value="RDRTYPE_NAME" resolve-to-field="RDRTYPE_ID"/>
</field>
<field index="24" db-field="RDR_SHARE_SWIPES" default-value="N"/>
<field index="25" db-field="RDR_MEAL_CONFIRM_REQUIRED" default-value="N"/>
<field index="26" db-field="RDR_FLAG1" />
<field index="27" db-field="RDR_FLAG2"/>
<field index="28" db-field="RDR_FLAG3"/>
<field index="29" db-field="RDR_FLAG4"/>
<field index="30" db-field="RDR_FLAG5"/>
<field index="31" db-field="RDR_UDF1"/>
<field index="32" db-field="RDR_UDF2"/>
<field index="33" db-field="RDR_UDF3"/>
<field index="34" db-field="RDR_UDF4"/>
<field index="35" db-field="RDR_UDF5"/>
</fields>
</table>
</table-config>Sample CSV file
CLOCK A,Test for Insert,WB8000_GROUP1,192.168.0.5,ON-LINE,0,,,20220720092345,,America/Toronto,,,,,,,,,0,0,,WB8000,Y,Y,,,,,,UDF1,,UDF3,,,
CLOCK B,Test for Insert,wbcs_group1,192.168.0.1,off-line,1,,,20220720092345,,America/Vancouver,,,,,,,,,0,0,,VCLOCK,,,,,,,,UDF1,,UDF3,,,
CLOCK #C,Test for Insert Spl Char,WB8000_GROUP2,10.35.100.100,ON-LINE,0,,,20220720092345,,America/Toronto,,,,,,,,,0,0,,WB8000,Y,Y,,,,,,UDF1,,UDF3,,,
CLOCK D EMBEDDED,Meal and Swipe flag RGRP disabled,PB_GROUP5,10.35.100.46,Off-LINE,0,,,,,America/Toronto,,,,,,,,,0,0,,WB8000,Y,Y,,,,,,UDF1,,UDF3,,,
CLOCK E NON-EMBEDDED,Meal and Swipe flag RGRP disabled,PB_GROUP5,192.168.0.67,off-line,1,,,20220720092345,,America/Vancouver,,,,,,,,,0,0,,Http,Y,Y,,,,,,UDF1,,UDF3,,,
CLOCK F,Test for dld field,wbcs_group1,192.168.0.32,off-line,1,,,20220720092345,,America/Vancouver,,C:/cert/cmi.dld,,,,,,,0,0,,cmi,,,,,,,,UDF1,,UDF3,,,
CLOCK G,Test for non-existing group,clock_group,192.168.0.22,on-line,1,,,20220720092345,,America/Vancouver,,C:/cert/ats_qa.dld,,,,,,,0,0,,ATS,,,,,,,,UDF1,,UDF3,,,
CLOCK H,Test other clock,wbcs_group1,192.168.0.45,off-line,1,,,20220720092345,,America/Vancouver,,C:/cert/synel.dld,,,,,,,0,0,,synel,,,,,,,,UDF1,,UDF3,,,
CLOCK I,Test for RDR TYPE desc,wbcs_group2,192.168.0.30,on-line,1,,,20220720092345,,America/Vancouver,,C:/cert/ats_qa.dld,,,,,,,0,0,,WB6000,,,,,,,,UDF1,,UDF3,,,
CLOCK J,Test for Invalid TZ,wbcs_group2,192.168.0.22,on-line,1,,,20220720092345,,Denver,,,,,,,,,0,0,,wb9000,n,n,,,,,,UDF1,,UDF3,,,
CLOCK K,Test for existing IP,WB8000_GROUP2,10.35.10.1,on-line,1,,,20220720092345,,America/Denver,,,,,,,,,0,0,,wb8000,n,n,,,,,,UDF1,,UDF3,,,
CLOCK L,Test for no poll date,WB8000_GROUP2,10.35.10.141,on-line,1,,,,,America/Denver,,,,,,,,,0,0,,wb8000,n,n,,,,,,UDF1,,UDF3,,,
CLOCK M,Test for invalid poll date,WB8000_GROUP2,10.35.10.124,on-line,1,,,20220720 092345,,America/Denver,,,,,,,,,0,0,,wb8000,n,n,,,,,,UDF1,,UDF3,,,
CLOCK N EMBEDDED,Meal and Swipe flag RGRP enabled,PB_GROUP1,10.35.100.14,Off-LINE,0,,,,,America/Toronto,,,,,,,N,,0,0,C,WB8000,n,n,,,,,,UDF1,,UDF3,,,
CLOCK O NON-EMBEDDED,Meal and Swipe flag RGRP enabled,PB_GROUP1,192.168.0.15,off-line,1,,,20220720092345,,America/Vancouver,,,,,,,,,0,0,,Http,n,n,,,,,,UDF1,,UDF3,,,
CLOCK P EMBEDDED,Meal and Swipe flag RGRP enabled,PB_GROUP1,10.35.100.121,Off-LINE,0,,,,,America/Toronto,,,,,,,Y,,0,0,,WB8000,Y,Y,,,,,,UDF1,,UDF3,,,
CLOCK Q NON-EMBEDDED,Meal and Swipe flag RGRP enabled,PB_GROUP1,192.168.0.2,off-line,1,,,20220720092345,,America/Vancouver,,,,,,,,,0,0,,Http,Y,Y,,,,,,UDF1,,UDF3,,,
CLOCK R EMBEDDED,Meal and Swipe flag RGRP disabled,PB_GROUP5,10.35.100.128,Off-LINE,0,,,,,America/Toronto,,,,,,,,,0,0,D,WB8000,N,N,,,,,,UDF1,,UDF3,,,
CLOCK S NON-EMBEDDED,Meal and Swipe flag RGRP disabled,PB_GROUP5,192.168.0.3,off-line,1,,,20220720092345,,America/Vancouver,,,,,,,,,0,0,,Http,N,N,,,,,,UDF1,,UDF3,,,
CLOCK T EMBEDDED,Meal and Swipe flag RGRP enabled,PB_GROUP1,10.35.100.80,Off-LINE,0,,,,,America/Toronto,,,,,,,,,0,0,,WB8000,,,,,,,,UDF1,,UDF3,,,
CLOCK U NON-EMBEDDED,Meal and Swipe flag RGRP enabled,PB_GROUP1,192.168.0.80,off-line,1,,,20220720092345,,America/Vancouver,,,,,,,,,0,0,,Http,,,,,,,,UDF1,,UDF3,,,
CLOCK V,Test all field mapping,WB8000_GROUP3,192.168.0.50,WAS CONTACTING,0,,123,20220720092345,MESSAGE,America/Toronto,123.12.0,C:/cert/synel.dld,,,,Y,I,Y,25,35,S,WB8000,Y,Y,,Y,Y,N,Y,UDF1,,UDF3,,,
CLOCK W,Test for long description greater than 40 chars,WB8000_GROUP1,192.168.0.99,ON-LINE,0,,,20220720092345,,America/Toronto,,,,,,,,,0,0,,WB8000,Y,Y,,,,,,UDF1,,UDF3,,,
clock y,Test for lower case reader name,WB8000_GROUP1,192.168.0.100,ON-LINE,0,,,20220720092345,,America/Toronto,,,,,,,,,0,0,,WB8000,Y,Y,,,,,,UDF1,,UDF3,,,