Page Comparison

Problem (Issue) Statement:

How to Import Staff Record With Card No. and Card Serial No. in Hex Format in xPortalNet HS Software

Description:

xPortalNet HS software is provided with higher security features. One of them is to display the Card No. / Card Serial No. in Hexadecimal number format. This can tighten up the security to prevent from being tampered by others. Eg. Stolen Id No, Change Id No, etc. This article will show you how to import staff record in Hex format number.

Related Software:

xPortalNetHS v1.8.0.3

Related Hardware:

NIL

System Application:

Door Access System

Symptom and Finding:

NIL

Cause:

NIL

Solution:

Warning

title	Warning!

Users are not recommended to run any xPortal software in Windows XP operating system as the system is unstable
Users are also advised to stop the xPortal Services before shutting down the Server PC to prevent any missing transaction issues.

.

Summary

.

Step-by-step Guide:

Anchor
createimportfile
createimportfile
To Create the Import File.

In these steps, user will be guided to create the import file.

.

Step 1: Run any spreadsheet application. Eg: Excel, OpenOffice Calc.

.

Step 2: Create a new blank sheet.

.

Step 3: Follow the following template.
Staff Record Template Image Modified
^{Figure 1: Staff Record Template.}

Download Template Here

.

Step 4: Save the changes made.

.

Step 5: Proceed to import the file in xPortalNet HS Client Software.

.

Anchor
importstaffrecord
importstaffrecord
To Import the Staff Record.

In these steps, user will be guided to import the staff record which the Card No. and Card Serial No. is in Hexadecimal format.

.

Step 1: Login to xPortalNet HS Client.

.

Step 2: Go to Data Setup > Access Data Setting > Staff Records.

.

Step 3: Staff Detail Setup window will be shown. Click Import.
Image Modified
^{Figure 2: Select Import Menu.}

.

Step 4: The Import Staff window will be shown.

To import new staff record select Add only Import Rules.
Specify all field according to the field description below:

Select Data Source Window Image Modified
^{Figure 3: Select Data Source Window.}

Select Data Source Field Description Image Modified
^{Table 1: Select Data Source Field Description}

.

Step 5: Click Next.

.

Step 6: Fill in the mappings section accordingly.
Column Mapping Window Image Modified
^{Figure 4: Column Mapping Window.}

Column Mapping Field Description Image Modified
^{Table 2: Column Mapping Field Description.}

.

Step 7: Click Next.

.

Step 8: Ready to Import Window will be shown. Make sure the "Total Unresolved Exceptions: 0". Otherwise, please resolve selected exception first.

.

Step 9: Click Confirm to start importing the staff record.

Ready to Import Window Image Modified
^{Figure 5: Ready to Import Window.}

.

Step 10: The Processing Data loading bar will be shown.
Processing Data Loading Bar Image Modified
^{Figure 6: Processing Data Loading Bar.}

.

Step 11: The Import Staff Result window will be shown when the import to the software database is success.
Import Staff Result Window Image Modified
^{Figure 7: Import Staff Result Window.}

.

Step 12: The Delivery Report window will be shown when the import to the controller is success.
Delivery Report Window Image Modified
^{Figure 8: Delivery Report Window.}

.

Step 13: Check the staff record that is successfully imported to the software database from the Staff Records.
Staff Record Window Image Modified
^{Figure 9: Staff Record Window.}

.

Step 14: Flash card to verify the record is successfully installed to the controller.
Latest Event List Window Image Modified
^{Figure 10: Latest Event List Window.}

Common Issues:

Failed to convert numeric value
Blank field error

Document Date

09/08/2018 (Rev 1.0)

Status

subtle	true
colour	Yellow
title	Proof-read

...

Section

border	true

Column

width	100%

Versions Compared

Old Version 5

New Version Current

Key

Users are not recommended to run any xPortal software in Windows XP operating system as the system is unstable

Users are also advised to stop the xPortal Services before shutting down the Server PC to prevent any missing transaction issues.

Summary

To Create the Import File.

To Import the Staff Record.

Step-by-step Guide:

Anchor
createimportfile
createimportfile
To Create the Import File.

Anchor
importstaffrecord
importstaffrecord
To Import the Staff Record.

Related Articles.

Page Comparison

Versions Compared

Old Version 5

New Version Current

Key

Users are not recommended to run any xPortal software in Windows XP operating system as the system is unstable

Users are also advised to stop the xPortal Services before shutting down the Server PC to prevent any missing transaction issues.

Summary

To Create the Import File.

To Import the Staff Record.

Step-by-step Guide:

AnchorcreateimportfilecreateimportfileTo Create the Import File.

AnchorimportstaffrecordimportstaffrecordTo Import the Staff Record.

Related Articles.

Anchor
createimportfile
createimportfile
To Create the Import File.

Anchor
importstaffrecord
importstaffrecord
To Import the Staff Record.