Installation Guide HRView (IDC_PMD_M_03)

Installation Guide HRView Document Name: Publication Date: Version: Prepared By: Reviewed By: Approved By:

S. No 1

Revision Details

Version 1.0

Installation Guide HRView 24/03/2013 1.0 Ankur Md. Asim Divyakant Gupta (Director)

Approved By

Previous Revision No.

Revision No.

Date

Page 1

Installation Guide HRView (IDC_PMD_M_03)

CONTENTS 1. PREREQUISITES ......................................................................................3 1.1. 1.2. 1.3. 1.4.

CONTROLLER LAN CONFIGURATION .....................................................3 IIS INSTALLATION...................................................................................5 STEPS TO CHECK IIS ................................................................................5 STEPS TO INSTALL IIS .............................................................................6

2. HRVIEW INSTALLATION .....................................................................7 3. HRVIEW CONFIGURATION ...............................................................19 APPENDICES: ...............................................................................................46 I DOCUMENT TO INSTALL IIS SERVER IN WINDOWS 7 ...............................46 II DOCUMENT TO INSTALL IIS SERVER IN WINDOWS 2008 .........................48 III STEPS TO INSTALL SQL IN 64BIT MACHINE .............................................51 IV SQL INSTALLATION IF CD NOT AUTO PLAYED .........................................58 V IMPORT DATA ..........................................................................................67 VI IMPORT CARD ..........................................................................................70 VII HOW TO CHANGE THE PORT ADDRESS OF CONTROLLER .........................72

Version 1.0

Page 2

Installation Guide HRView (IDC_PMD_M_03)

1. PREREQUISITES: Before starting the HRView installation, following tasks needs to be fulfilled: I.

Controllers should be configured on the LAN as explained in section 1.1

II.

IIS must be installed on the system. The procedure for IIS installation is explained in section 1.2.

III.

Note down the serial nos. pasted on VertX or Edge Devices.

1.1.

Controller LAN Configuration:

All the controllers are by default set on factory configurations with a default IP. For first time installation of the controllers, each controller needs to be configured on the LAN. To configure the IP address, Port and Host IP address configuration of the controller, follow the steps mentioned below: 1. Disconnect the computer from the network and directly connect the controller to the computer with an Ethernet cable. 2. Open the Local Area Connection properties of the computer. Note down the existing LAN configuration settings. Then change the computer IP address to 169.254.242.120 and subnet mask to 255.255.0.0 3. Now access a web browser (IE/Fire fox) and type controller default IP 169.254.242.121 into address field and press Enter key. 4. The web browser will prompt for login information. Enter the username as admin and leave the password field empty. 5. VertX basic setup configuration page opens. Enter the LAN settings of the controller as per the company‟s LAN settings (Fig. 1.1).         

Set connection selection to Network. Choose Basic Network Setup as Static. In IP Address, enter the IP to be assigned to the controller, provided by client. Enter the Subnet Mask, Default Gateway as per the LAN configuration settings of the company. Primary DNS Server and Secondary DNS server are optional fields required if the controllers are to be accessed though internet. In CS/Host addressing set the IP address of the server where HRView application manager is installed. Set “Here I Am Interval (sec)” to 20. Set the password. (Please remember this password, it is required when you open this configuration page in future) Now click on Submit button.

Version 1.0

Page 3

Installation Guide HRView (IDC_PMD_M_03)

Fig 1.1 A new window opens showing the set configurations. Click on Save button. If the changes are saved successfully, a VertX Reconnect page will appear. Now disconnect the controller from the computer and place it on the LAN. Similarly configure the LAN settings for all controllers, and then reconfigure the local area configuration of the computer to the company‟s LAN noted in Step 2.

Version 1.0

Page 4

Installation Guide HRView (IDC_PMD_M_03)

1.2.

IIS Installation:

HRView Web page application installation requires IIS to be installed on PC. If IIS is already installed it can be checked as shown below:

1.3.

Steps to check IIS:

For Windows7 & Windows 2008: Type localhost in web browser like Internet Explorer etc. and press Enter, if the window shown in Fig 1.2 appears, it means IIS is installed.

Fig 1.2

For Windows 2008, Windows7

For windows XP: Type localhost in web browser like Internet Explorer etc. and press Enter, if the window shown in Fig 1.3. appears, it means IIS is installed.

Fig 1.3

Version 1.0

Page 5

Installation Guide HRView (IDC_PMD_M_03)

1.4.

Steps to install IIS

If IIS is not installed on system, then follow the steps below to install it. For windows XP machine(32/64 bit) 

Click Start → Control Panel → Add/remove programs → Add/Remove Windows Components → select IIS from the list then click OK(Fig.1.4)

Fig. 1.4 

It will ask about the path then insert the respective windows CD and proceed.

For Windows7/Vista (32/64 bit machine) go to appendix I For Windows Server2008 go to appendix II

Version 1.0

Page 6

Installation Guide HRView (IDC_PMD_M_03)

2. HRVIEW INSTALLATION STEP 1: Insert HRView CD and allow it to autoplay. Note: If the CD is not autoplayed then explore the CD and click on autorun.bat file as shown in Fig.2.1

Fig. 2.1

Version 1.0

Page 7

Installation Guide HRView (IDC_PMD_M_03)

STEP 2: A web browser pops up (Fig.2.2). It is recommended to use internet explorer as default browser. Click on HRView Server Components.

Click Here

Fig. 2.2 STEP 3: Click on HRView Web Application(Fig2.3). Next page shows steps to check IIS server installation. If it is already checked as explained in section 1.2, click on Next.

Click Here

Fig. 2.3 Version 1.0

Page 8

Installation Guide HRView (IDC_PMD_M_03)

STEP 4: Install Web Application by clicking Install HRView Web Application & follow the onscreen instructions.

Click Here

Fig. 2.4 STEP 5: Now click on Install Ajax Control Toolkit to install Ajax and follow the onscreen instructions.

Click Here

Fig. 2.5 Version 1.0

Page 9

Installation Guide HRView (IDC_PMD_M_03) STEP 6: Once HRView Web Application is installed, click on HRView Server components to go back to the server components installation page.

Click Here

Fig. 2.6 STEP 7: Click on HRView Database Utility.

Click Here

Fig. 2.7 Version 1.0

Page 10

Installation Guide HRView (IDC_PMD_M_03) STEP 8: To install database utility, click on Install HRView Database Utility and follow the onscreen instructions.

Click Here

Fig. 2.8 STEP 9: If you don‟t have licensed SQL Server edition, then the SQL Server Express Edition can be installed from CD for 32 bit machines. Depending on the operating system of the server there are two versions from Microsoft for SQL Express. Click on the corresponding SQL Server Express Edition link to install it and follow the onscreen instructions as shown in Fig.2.9 to Fig.2.17 For SQL installation on 64bit system, go to Appendix III

Click Here

Fig. 2.9 Version 1.0

Page 11

Installation Guide HRView (IDC_PMD_M_03)

Click Here

Fig. 2.10

Click Here

Fig. 2.11

Version 1.0

Page 12

Installation Guide HRView (IDC_PMD_M_03)

Fig. 2.12 Note: If the cd is not autoplayed, the files required for SQL installation may not be saved due to which an error may occur here. Then SQL needs to be installed from cd as explained in Appendix IV. Follow the onscreen instructions to install SQL

Fig. 2.13

Version 1.0

Page 13

Installation Guide HRView (IDC_PMD_M_03)

Fig. 2.14 During SQL Database services installation, error shown in Fig.2.15 may occur two times, click on ignore button and continue the installation

.

Fig.2.15 Version 1.0

Page 14

Installation Guide HRView (IDC_PMD_M_03)

Fig. 2.16 STEP 10: Once SQL installation is finished, click on HRView Server components to go back to the server components installation page.

Fig. 2.17 Version 1.0

Page 15

Installation Guide HRView (IDC_PMD_M_03) STEP 11: Click on HRView Application Manager

Fig. 2.18 STEP 12: To install Application Manager, click on Install HRView Application Manager and follow the onscreen instructions.

Fig. 2.19

Version 1.0

Page 16

Installation Guide HRView (IDC_PMD_M_03) STEP 13: Now click on HRView Server components to go back to the server components installation page. As all HRView Server Components have been installed, click on Index button to install client component. STEP 14: Click on HRView Client Components

Fig. 2.20 STEP 15: To install Security View, click Install Security View & follow the onscreen instructions.

Fig. 2.21 Version 1.0

Page 17

Installation Guide HRView (IDC_PMD_M_03) All the four components of HRView have been successfully installed and can be accessed as shown in Fig. 2.22

Fig. 2.22

Version 1.0

Page 18

Installation Guide HRView (IDC_PMD_M_03)

3. HRVIEW CONFIGURATION: Step 1: Start Database utility as shown in Fig.3.1.

Fig. 3.1 The screen shown in Fig.3.2 appears with default server name, user Login and password. You need to connect with SQL by entering correct values of these parameters. If the CD was autoplayed and MS SQL Server Express Edition is installed as explained in Step 9 of chapter 2 then no change in the default parameters is required. If already installed SQL is being used for HRView database then the default parameters would be required to be changed as per the installed SQL server.

Fig. 3.2 Version 1.0

Page 19

Installation Guide HRView (IDC_PMD_M_03) Step2: Click on Connect. If the correct parameters were entered, user gets logged in SQL application.

Fig. 3.3 Step3: Click on Create Database.

Fig. 3.4

Version 1.0

Page 20

Installation Guide HRView (IDC_PMD_M_03) Step4: Click on Create Components.

Fig. 3.5 Step5: Start Application Manager either by desktop shortcut or follow the path as shown in Fig. 3.6.

Fig. 3.6 When HRView application manager is started for the first time, the database configuration screen pops up with default Server name, DB user id and DB password values. As explained earlier, if the default parameters were used while connecting with SQL then these values are not required to be changed else enter the appropriate values and click on save button.

Version 1.0

Page 21

Installation Guide HRView (IDC_PMD_M_03)

Fig. 3.7 Step6: A login window appears. Enter username as Administrator and password as password.

Fig. 3.8 To run the software, a license file is required. To get the license file, click on register tab (Fig.3.9)

Fig. 3.9 Version 1.0

Page 22

Installation Guide HRView (IDC_PMD_M_03) Step7: Fill in the form. The serial no. is pasted on top of HRView CD as well as in serial.txt file in the CD files. Click on Next button.

Fig. 3.10(a)

Version 1.0

Page 23

Installation Guide HRView (IDC_PMD_M_03) Step8: On eachVertx1000, VertX2000, VertX100, ER40, E400, a serial no. sticker is pasted. Enter the serial no. of the device in the text box. Click on Add button. Similarly add the serial nos. of all Edge or VertX devices.

Fig. 3.10(b) Step9: Click on save button. The file is saved as Registration.info. Send Registration. info file to [email protected] with subject as “Request for license” to receive the license file. Step10: After receiving the license file, paste it inside the Application Manager folder at the following path(Fig.3.11). C:\Program Files\IDCUBE\HRView\Application Manager

Version 1.0

Page 24

Installation Guide HRView (IDC_PMD_M_03)

Fig. 3.11 Step11: Restart the Application Manager. Now, click on tab Add Company. Step12: Fill up the client company and branch details. Employee id is the first user of the company which can later be changed. Click on button Add Company to add company. Note: Remember the employee id entered here, as the same shall be used to login into security view and web application for the first time.

Fig. 3.12 Version 1.0

Page 25

Installation Guide HRView (IDC_PMD_M_03) Step13: Click on Application Service tab and start the service. The Service Status should always be shown as Running.

Fig. 3.13 Step14: Now click on controllers tab. After configuring IP settings of the controllers as explained in section1.1, all the controllers are shown in controllers tab with their MAC address (Fig.3.14)

Fig. 3.14 Version 1.0

Page 26

Installation Guide HRView (IDC_PMD_M_03) Step15: Click on the MAC address of the controller to select it. Select the company and branch of the company to which it is supposed to be associated. Click on Change Branch. Step16: If HID 26 bit formatted cards are to be used, then the corresponding facility code file needs to be uploaded (Fig.3.15) To upload the file, follow the below steps: i. Click on Card formats. ii. Enter company name. iii. Select card id which is any integer between 1 and 253. It is recommended to use card id same as facility code. iv. Enter a format name. This name shall be visible while issuing cards to employees. v. Select the corresponding facility code file name and click on upload file. vi. Now click on update controllers. vii. Select the company and Click on „Card Format Task Status‟ to find the task status as shown in Fig.3.16.

Fig. 3.15

Version 1.0

Page 27

Installation Guide HRView (IDC_PMD_M_03)

Fig. 3.16 Note: If cards other than 26 bits are being used then please contact IDCUBE to get the .vff file. Paste the file at the following location: C:\Program Files\IDCUBE\HRView\Application Manager\Fmts and then follow steps (i) to (vii). Step17: Start Security view either by desktop shortcut or by following path as shown in Fig.3.16.

Fig. 3.17(a) Version 1.0

Page 28

Installation Guide HRView (IDC_PMD_M_03) When Security View is started for the first time, the database configuration screen pops up with default Server name, DB user id and DB password values. As explained earlier, if the default parameters were used while connecting with SQL then these values are not required to be changed else enter the appropriate values and click on save button.

Fig. 3.17(b) A login window appears. Enter username and password. Username: Employee ID while adding company in Application Manager. Password: Employee ID while adding company in Application Manager.

Fig. 3.18 Step18: Choose the branch with which the controller is assigned to configure it. The window shown in Fig.3.19 appears, here all the controllers connected in the branch are displayed. The green tick shows controller is connected with server machine.

Version 1.0

Page 29

Installation Guide HRView (IDC_PMD_M_03)

Now click here for controller configuration

This green tick means controller is connected

Fig. 3.19 Step19: Click on configuration icon to configure all controllers connected in this branch. Step20: Click on „Config‟ link as shown in Fig.3.20

Fig. 3.20 Version 1.0

Page 30

Installation Guide HRView (IDC_PMD_M_03) Step21: Enter the Controller Name and click on save button Step22: Click on search interface. All the interfaces connected with the controller are displayed as shown in Fig.3.21.

Click here

Fig. 3.21 Step23: To define the readers, click on the config link of each interface, reader configuration window opens as shown in Fig.3.22.

Version 1.0

Page 31

Installation Guide HRView (IDC_PMD_M_03)

Fig. 3.22      



Card In-Card Out option is meant for access doors where readers are placed both at the entry and exit side of the same access door. For this scenario, check the Card-In Card-out checkbox else leave it unchecked. Select reader1 checkbox to define its parameters. Select Pin reader checkbox if the reader is a pin reader. Enter the name of the reader. Select Reader protocol as Clock & Data if the reader is a Clock & Data reader else keep it Wiegand only. Select Reader Type from the following options: o In: For the reader is to be used only as Access reader and installed at entry of access door. o Out: For the reader is to be used only as Access reader and installed at exit of access door. o Login: For the reader is to be used as Attendance plus Access reader or Attendance reader only. o Logout: For the reader is to be used as Attendance plus Access reader or Attendance reader only and installed at exit of access door. o Login/out: For the same reader to be used as Login and Logout both. There are two options: o Alternative Login-Logout: First swipe of the day is recorded as Login, second swipe logout then third again Login and in this manner the card swipes are recorded. o Except First all Logout: Here only the first card swipe of the day is taken as Login while all the other card swipes are taken as logout. Choose the Access control type as per the installed location of the reader eg. if the reader is placed on a door then choose Access Control type as Door.

If the readers are to be used only for access purpose (not for attendance) then only define the reader name and save the default settings. Version 1.0

Page 32

Installation Guide HRView (IDC_PMD_M_03) Step24: Click on Web Configuration Utility icon on the desktop, OR Follow the following path Start  All Programs IDCUBE Web Configuration Utility

Fig. 3.23 Server Name, DB User ID & DB Password are the same parameters entered while creating database via Database utility as explained earlier. Click on save button. Step25: Open web browser like internet explorer and type “ip address of server machine/hrview”. The HRView web page opens (Fig.3.24)

Fig. 3.24 Step26: Enter the login details. Employee ID: Employee ID while adding company in Application Manager Password: Employee ID while adding company in Application Manager Company: Select the name of the employee‟s company Version 1.0

Page 33

Installation Guide HRView (IDC_PMD_M_03) Step27: Before adding a user, access group and attendance shift needs to be defined.Click on access control to define access group (Fig.3.25)

Fig. 3.25 Step 28: Click on Define time code. Step 29: Enter the time code name and choose the access timings eg. For 24 hours access, choose Term1 as 00:00 to 23:59 (Fig.3.26). Click on save button.

Fig. 3.26 Version 1.0

Page 34

Installation Guide HRView (IDC_PMD_M_03) Step 30: Click on Define Time zone.

Fig. 3.27 Step 31: Enter the Time zone name. Choose predefined time codes for each day. Click on save button.

Fig. 3.28 Version 1.0

Page 35

Installation Guide HRView (IDC_PMD_M_03) Step 32: Click on Define Reader group.

Fig. 3.29 Step 33: All readers defined in security view are shown in the left hand side. Shift the readers on which access is required to right side eg. for access on all readers, choose all the readers on right hand side. Click on save button.

Fig. 3.30 Version 1.0

Page 36

Installation Guide HRView (IDC_PMD_M_03) Step 34: Click on Define Access group.

Fig. 3.31 Step 35: Enter the access group name (Fig.3.32). Choose the predefined reader group name and time zone. Step 36: Click on Add button. Click on save button.

Fig. 3.32

Version 1.0

Page 37

Installation Guide HRView (IDC_PMD_M_03) Step 37: If attendance rule also needs to be defined then click on Time Attendance to define attendance shifts. Step 38: Click on Define Attendance rules.

Fig. 3.33 Step 39: Enter the Attendance rule Name (Fig. 3.34).Enter the shift timings as explained below:

Fig. 3.34

Version 1.0

Page 38

Installation Guide HRView (IDC_PMD_M_03) Note: Time should be given in 24 hours format for example to set Check-Out Time to 6 pm, set appropriate field to18:00, otherwise it will be considered as 6:00 AM.  Attendance Rule Name: Specify the name of the Attendance Rule to be created. Maximum 10 characters are allowed.  Day Start Time: By default the new day starts at 12:00 AM (00:00), for the shift. Specify the time from which the day should start for the shift. For example: if a user sets the day start time as 6:00 hrs, it means that before 6:00 AM the day will be considered as the previous day or the Date of Duty for the employee changes after 6:00AM instead of 12 night. This parameter is useful for the companies having multiple shifts (morning, noon night etc.) or the employees work till early morning.Eg. If the Day Start Time is set to 6:00 AM for the shifts assigned to an employee for the month of June and an employee logs-out at 2:00 AM of 2nd June, then this logout will be counted in the shift of 1st June  Check-In Time: Specify the time at which the shift starts.  Check-Out Time: Specify the time at which the shift ends. It is not necessary to define checkout time in the same calendar day but has to be defined after check-in time and within 24 hr period from the day start time of the shift. Eg. if 6:00AM is set as day start time and 9:00AM is defined as the check-in time, then the check out time for the shift can be defined between 9:00 hrs and 05:59 hrs.  Min. Half Day Hours: Specify the minimum number of hours for the shift to be considered as half day eg. If an employee has to work minimum 4 hours to be considered as half day then choose it as 4. If the field is left unchanged (00:00) then this parameter will not be considered in the attendance calculations.  Min. Full Day Hours: Specify the minimum number of hours for the shift to be considered as full day. If the field is left unchanged (00:00) then this parameter will not be considered in the attendance calculations.  Late Coming Half Day Hours: Specify the number of hours from the check-in time after which half day will be considered for the shift. If the field is left unchanged (00:00) then this parameter will not be considered in the attendance calculations. Eg. if Late Coming Half Day Hours is set as 1:00 hr and check-in time is 9:00AM, if an employee comes at 10AM or after 10AM then the day status will be shown as Half day for the employee in the attendance reports.  Early Going Half Day Hours: Specify the number of hours before the check-out time before which half day will be considered for the shift. If the field is left unchanged (00:00) then this parameter will not be considered in the attendance calculations. Eg. if Early Going Half Day Hours is set as 1:00 hr and check-out time is 18:00 hrs, if an employee leaves at 17:00PM then the day status will be shown as Half day for the employee in the attendance reports.  Over Time Period: Specify the time between which the Over Time Period will be considered for the shift. The overtime period can be specified either before or after the shift, but after the day start time and within 24 hrs period from day start time. If the field is left unchanged (00:00) then apart from the time between shift check-in and shift check-out time, the rest is considered as over time period for the employee. Eg. If the day start time, check-in time and check-out time is set to 6:00 hrs, 9:00 hrs and 18:00 hrs respectively, then the overtime period can be defined between 6:00 hrs and 9:00 hrs or 18:00 hrs and 5:59 hrs.  Min. Over Time Period: Specify the minimum working hours for the employee during the overtime period defined, below which the overtime for the employee will not be considered. For example: if 1hr is set as minimum over time working hour, it means that any employee working less than 1hr during the overtime period defined then it will not be considered as overtime for the employee.

Version 1.0

Page 39

Installation Guide HRView (IDC_PMD_M_03) Step 40: Click on Save Button. Step 41: Click on Define ACTA rule group.

Fig. 3.35 Step 42: Enter the T&A Rules group name. Step 43: Select appropriate shift for each day. For Weekly Off days, select the checkbox as shown for Sunday & Saturday in Fig.3.36. Click on Save button.

Fig. 3.36 Version 1.0

Page 40

Installation Guide HRView (IDC_PMD_M_03) Step 44: Click on Users tab to add users. Employees can be added into the software by importing data through excel sheet or individually. Import Data method is explained in Appendix V, method for adding employees individually is explained below. Step 45: Click on Add New user to add users, assign access groups, attendance shift and issue cards individually.

Fig. 3.37 Step 46: Enter the Emp ID and First Name. These are the compulsory fields. To add Department and Title, it needs to be added first through Initial Setup or by import data as explained later. Click on Next button. Step 47: Here, both formatted and No Formatted cards can be issued: To issue a card with No Format, follow the steps below:  Select No Format Check box  Show the card to be issued, to the reader  Click on Add Card.  Select that reader from the drop down list and click on Find .A new window opens showing the card id and date/time of the card shown.  To add card click on insert or cancel to close the window.

Version 1.0

Page 41

Installation Guide HRView (IDC_PMD_M_03)

Fig. 3.38 To issue a Formatted card, follow the steps below:  Check the Format Option checkbox.  Select the Format Name( added through Application Manager) from the dropdown list  Write the card no. printed on the card in the Card ID field. Step 48: Select the branch and access group to be assigned to the employee (Fig. 3.39). Click On Next Button.

Fig. 3.39 Version 1.0

Page 42

Installation Guide HRView (IDC_PMD_M_03) Step49: Choose the shift from New T&A Group and date from which the shift will be effective. Step50: Click on Next button.

Fig. 3.40(a)

Fig. 3.40(b)

Version 1.0

Page 43

Installation Guide HRView (IDC_PMD_M_03) Step51: Choose the HRView and Security view privilege to be assigned to the user. Click on Finish button.

Fig. 3.41 Step52: Click on Actions pane. If No pending task message is shown, it means card has been successfully uploaded to controller. If the error shown is “ Lookup of unique id found a duplicate number” then go to configuration menu in Security View and Click on Sync.Card DB for each controller. Step53: To generate Reports, click on Reports tab.

Version 1.0

Page 44

Installation Guide HRView (IDC_PMD_M_03)

Fig. 3.42 Step54: Click on Search button. Step55: Select the Users. Step56: Select the appropriate period. Step57: Select the report type. Step58: Choose the report format (PDF, Excel or CSV) from dropdown list and click on report button to generate report.

Version 1.0

Page 45

Installation Guide HRView (IDC_PMD_M_03)

Appendices: I Document to Install IIS server in windows 7 Step1: Go to Control Panel then select Program and Features.

Fig. 1 Step 2: Select Turn Windows Feature on or off.

Fig.2 Version 1.0

Page 46

Installation Guide HRView (IDC_PMD_M_03) Step 3: Check the boxes shown in Fig.3

Fig. 3 Click on OK button. This installs IIS server in Windows7/Vista.

Version 1.0

Page 47

Installation Guide HRView (IDC_PMD_M_03)

II Document to Install IIS server in windows 2008 

Steps to check IIS Server availability: o Click Start -> Control Panel -> Administrative Tools o Here if you see IIS Server Icon then it means IIS Server is already installed in this PC

Fig. 1 o



You have to check its connectivity with the computer where it is installed. Click on this IIS Server Icon and if it is showing your computer name then it means it is connected.

Steps to install IIS Server o Click on Start -> Control Panel -> Administrative Tools -> Server Manager o Click on Roles and then Add roles as shown below in the image:

Fig. 2

Version 1.0

Page 48

Installation Guide HRView (IDC_PMD_M_03)

o

Click on Server Roles and then check Web Server option as shown below

o o

Click on Next -> Role Services Now select the option Application Development and IIS Management Compatibility as shown below

Version 1.0

Page 49

Fig. 3

Installation Guide HRView (IDC_PMD_M_03) Fig. 4

Fig.5 Click on Next -> Install. After installation restart your computer

Version 1.0

Page 50

Installation Guide HRView (IDC_PMD_M_03)

III Steps to install SQL in 64bit machine Step-1: Locate the SQL setup on your disk and click on Run.

Fig. 1

Fig.2 Version 1.0

Page 51

Installation Guide HRView (IDC_PMD_M_03)

Fig.3

Fig. 4

Version 1.0

Page 52

Installation Guide HRView (IDC_PMD_M_03)

Fig. 5

Fig. 6 Version 1.0

Page 53

Installation Guide HRView (IDC_PMD_M_03)

Fig.7

Fig. 8

Version 1.0

Page 54

Installation Guide HRView (IDC_PMD_M_03)

Fig. 9

Fig.10 Version 1.0

Page 55

Installation Guide HRView (IDC_PMD_M_03) Step-2 Check named instance and put it as hrviewserver as it is default name in HRView applications

Fig. 11

Fig. 12

Version 1.0

Page 56

Installation Guide HRView (IDC_PMD_M_03) Step-3 Select mixed mode and enter the password “idcube_hrviewserver2005” as given

Fig. 13

Fig. 14 Version 1.0

Page 57

Installation Guide HRView (IDC_PMD_M_03)

IV SQL installation if cd not auto played Step-1: Go to the path CD\Installer_SQL2005\extract Click on Setup application file and follow the onscreen instructions.

Fig. 1

Fig. 2 Version 1.0

Page 58

Installation Guide HRView (IDC_PMD_M_03)

Fig. 3

Fig. 4 Version 1.0

Page 59

Installation Guide HRView (IDC_PMD_M_03)

Fig. 5

Fig. 6

Version 1.0

Page 60

Installation Guide HRView (IDC_PMD_M_03)

Fig. 7

Fig. 8 Version 1.0

Page 61

Installation Guide HRView (IDC_PMD_M_03)

Fig. 9

Fig. 10 Version 1.0

Page 62

Installation Guide HRView (IDC_PMD_M_03) Step-2: Check named instance and put it as HRViewserver as it has been given by default in applications

Fig. 11 Step-3: Check sql server & sql browser both

Fig. 12 Version 1.0

Page 63

Installation Guide HRView (IDC_PMD_M_03) Step-4: Select mixed mode and enter the password “idcube_HRViewserver2005” as given

Fig. 13

Fig. 14 Version 1.0

Page 64

Installation Guide HRView (IDC_PMD_M_03)

Fig. 15

Fig. 16 Version 1.0

Page 65

Installation Guide HRView (IDC_PMD_M_03)

Fig. 17

Step-5: During SQL Database services installation, error shown in Fig.18 may occur two times, click on ignore button and continue the installation

.

Fig. 18

Version 1.0

Page 66

Installation Guide HRView (IDC_PMD_M_03)

V Import Data Select File to Import Click on Import Data to import employees data from excel file.

Fig. 1 Steps:  Browse the path of XLS file which the user wants to import.  Write the name of the Excel Sheet to be imported e.g. Sheet1 etc.  Click on Bind Data.

Fig.2

Version 1.0

Page 67

Installation Guide HRView (IDC_PMD_M_03)

Fig. 3  Click on Next.  Map the imported excel fields with the SQL fields.

Fig. 4

Version 1.0

Page 68

Installation Guide HRView (IDC_PMD_M_03)

Fig. 5  Click on Finish button to finish importing the data. The departments, titles in the excel fields are automatically created in the HRVIEW software without defining in the initial setup

Version 1.0

Page 69

Installation Guide HRView (IDC_PMD_M_03)

VI Import Card To Import CardId follow the steps below: Steps:     

Click on Import Card Browse the path of XLS file which the user wants to import. Write the name of the Excel Sheet which is to be imported. Click on Bind Data. Click on Next button

Fig. 1   

Enter no. of Bits Map the imported excel fields with the SQL fields as shown below Click on Finish

Version 1.0

Page 70

Installation Guide HRView (IDC_PMD_M_03)

Fig. 2

Version 1.0

Page 71

Installation Guide HRView (IDC_PMD_M_03)

VII How to Change the port address of controller 1. Access a web browser (IE/Fire fox) and enter IP address of the controller into Address field 2. The web browser will prompt for login information. From the Login screen enter admin as username and password as already set. By default Vertx/Edge controller use 4070 as Connection port and 4050 as Listen port. This is also the default configuration for the demonstration server. In case, if it is required to change the port uses the following instruction. 1. Click on Advanced Setup on the top of the basic setup page

2. Set Domain Name to HIDVertx.com

3. Set the TCP/IP Connection port and TCP/IP Listen port

4. Now click on Submit button. Then click on save button on summary page. If the changes saved successfully a Vertx Reconnect page will appear.

Version 1.0

Page 72