SOYAL TECHNOLOGY CO., LTD

Membership Center
0
Browsing Records
How to synchronize the card format on the LCD screen of controller and the record on 701ClientSQL?
2022-12-09
No. S00305055-EN

Serial NO. : S00305055-EN

Date of Editing : 2022-12-06

Questions : How to synchronize the card format on the LCD screen of controller and the record on 701ClientSQL? How to convert the card format via Excel?

Content:

1. Introduction

2. Card encoded with Weigand format (WG26/WG34)

3. Card encoded with ABA format

(1) ABA8 / ABA10

(2) ABA64

4. Card encoded with HEX format  (HEX32/HEX64)

5. How to convert the card format from ABA to WG (HEX ⇄ DEC) via Excel?

 

1. Introduction 

SOYAL controller provides 5 types of card encoding format indication, including WG34/WG26/ABA10/ABA8/HEX formats. The card number showing on LCD screen and showing on 701ClientSQL are two different parameters, therefore, it is required to synchronize the parameters to display the same card number on both sides.

In addition, using ABA format is required to modify the parameter option in 701ClientSQL; using HEX format is required to download portable version of 701ClientSQL.

The “Card UID Length Range” is the card number that will have been shown on 701ClientSQL, “Show UID” is the card number that will have been shown on LCD screen, please refer to the comparison table as below:

Card UID Length RangeCard UID Length RangeShow UID
WG3441=WG
ABA1042=ABA
HEXAccording to the portable software version.3=HEX
WG2634=WG26
ABA835=ABA8

卡號轉換範例說明

Card format  
WG24/26*(DEC)      4617412
UID24(HEX)     2E4404
WG32/34*(DEC)    0055817412
UID32(HEX)    22E4404
UID64(HEX)A3567E3222E4404
UID32(HEX)    22E4404
ABA10(DEC)    36586500
UID24(HEX)     2E4404
ABA8(DEC)     3032068

※UID is Hexadecimal format and WG / ABA are Decimal format.

※The number followed the format is the length of card data acquisition, it could be corresponded to the field of the table above.

Testing card number is 00558,17412 (WG), it is equal to the default value of SOYAL controllers and the number printed on the Mifare card, please refer to the function below to convert the card number foramt.

Windows Calculator-

 

(1) WG34 (DEC) to UID32 (HEX)

Select DEC and input 558, getting HEX is 2 2E; input 17412, getting HEX is 44 04.

 

(2) UID32 (HEX) to ABA10 (DEC)

Select HEX and input 2 2E 44 04, getting DEC is 36586500.

 

2. Card encoded with Weigand format (WG26/WG34) 

STEP1. Modify the parameter setting via the command

 

STEP2. Enter program mode > 3. Parameters (1) > 9. PIN&UID format > Card UID Length > Show UID

 

(1) WG34 is Card UID Length = 4, Show UID = 1 (WG34)

(2) WG26 is Card UID Length = 3, Show UID = 4(WG26)

 

3. Card encoded with ABA format 

(1) ABA8 / ABA10

STEP1. Modify the parameter setting via the command

 

STEP2. Enter program mode > 3. Parameters (1) > 9. PIN&UID format > Card UID Length > Show UID

 

(1) ABA10 is Card UID Length = 4, Show UID = 2 (ABA10)

(2) ABA8 is Card UID Length = 3, Show UID = 5 (ABA8)

 

STEP3. Modify the card format, Setting > System Parameter > Tick up “ABA Card ID Format”

  

STEP4. Restart the 701ClientSQL software

 

*Please remind the card number should be written on right field.

(2) ABA64

 

STEP1. Modify the parameter setting via the command

 

STEP2. Enter program mode > 3. Parameters (1) > 9. PIN&UID format > Card UID Length > Show UID

 

(1) ABA64 is Card UID Length = 7, Show UID = 2 (ABA)

 

STEP3. Download 701ClientSQL portable version >> Download on official website

 

The relevant manual please refer to >>701 ClinetSQL Standard version & Portable version differences

*Please remind the card number should be written on right field.

4. Card encoded with HEX format  (HEX32/HEX64)

STEP1. Modify the parameter setting via the command

 

 

STEP2. Enter program mode > 3. Parameters (1) > 9. PIN&UID format > Card UID Length > Show UID

-The length of HEX number is followed by portable software version, “Show UID” = 3 (HEX).

 

STEP3. Download 701ClientSQL portable version >> Download on official website

 

The relevant manual please refer to >>701 ClinetSQL Standard version & Portable version differences

 

5. How to convert the card format from ABA to WG (HEX ⇄ DEC) via Excel? 

 

Example: Convert ABA 10 to WG 32 via Excel formula

 

Introduction:

It is not available to convert between ABA and WG format directly, please refer to the process below to comprehend the conversion procedure and steps:

 

1. ABA (DEC) > 2.HEX > 3. Isolate the card code > 4. WG (DEC)

 

STEP1. Run Excel, input the original card number

 

STEP2. Press an empty field, input the formula =DEC2HEX(), then press the field B2 to convert from Decimal Format to Hexadecimal Format.

 

(*It is available to use =HEX2DEC() to convert from Hexadecimal Format to Decimal Format.)

STEP3. Copy the field that have been converted

STEP4. Select the paste option without the formula

STEP5. Select “Data Parsing” function and tick up “Fixed-length”

STEP6. Press the middle of the card code

STEP7. Insert a field, using formula =HEX2DEC() to convert the card code again.

STEP8. Copy the formula and convert all of the card number.

Browsing Records
Go Top