Issue
Conversion process for taking small numbers in I/NET Seven to Large numbers in I/NET Seven
Environment
I/NET Seven rev 1.12 and above
Cause
The card number of the Prox cards are larger than 24000
Resolution
-
Sort the Individuals list according to the Individual Number. Find out the lowest number in the list. In this example number 1 is the lowest card number.
-
Look at the tenant editor to determine the Tenant Code/Facility code of the cards.
-
Go into the Door Editor and verify the Bit Format of the Cards. In this case it is a standard 26-Bit Format.
-
Verify in the door editor that the cards in this system are 26-Bit Wiegand. Then use the attached Excel spreadsheet (This is a ZIP File) to determine the Decimal number of the first card in the system (Card #1 Facility code 199) is 13041665. This number will become the source number in the Key card table.
-
Create a Key card table like below, using the Source # that was determined in Step #3 above. Please note the Target # must be equal to the value of the Lowest Individual Number.
-
Next unzip the supplied Windows SQL Script (BigCardConvert.exe).
Please note that the SQL Script will ask for a Username and Password. These are the Username and Password used for the SQL in the DbCreate Editor. - Once unzipped, double click the “EXE” file and this will convert all the existing card numbers into “Hex” numbers.
- After this process has completed, verify that the cards did in fact convert OK. Look at the lowest individual number the (“Source” card used the “Hex” and “Decimal” numbers) will be the same values determined in the Excel spread sheet.
- After verifying that all is OK, then delete the “Card Key Translation” table created to do this process.