What is The Fastest Way to Delete Selected Staff Records from The Database

NIL

NIL

Step-by-step Guide: 

• To Delete Card Records using Import feature:

In these steps, user will be guided to delete the selected Staff Card Records by using the Import feature.

Step 1: Run the xPortalNet Client.

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

Step 3: At Staff Detail Setup, check which record to be deleted. For example, to delete 500 records from the following list.
^{Figure 1: Staff Detail Setup window.}

Step 4: Prepare the list to be imported by using spreadsheets or notepad file.

• It is optional to have a complete details as following.
• The compulsory field for deleting record is only Staff No and Staff Card No.

^{Figure 2: Staff Records list.}

Step 5: Click Import.

^{Figure 3: Click Import.}

Step 6: At Import Staff window, specify the following then click Next.

<sup>Table 1: Import Staff Field Description.


Figure 4: Select the Data Source.</sup>

Step 7: At Column Mapping, specify the following and then click Next.

• Source Column No. for Staff No and Card No 
• Start From Row
• End At Row

^{Figure 5: Edit the column mappings and import row range.}

Step 8: At Ready to Import window, verify the following and then click Confirm to start the deletion process.

• Make sure the status of the record is all OK.
• Make sure that the correct total records to be deleted is displayed.
• No Unresolved Exceptions is detected.

^{Figure 6: Confirm the import action.}

Step 9: Please wait while the system processes the data. The system will proceed to delete the selected records from the software database.

^{Figure 7: Processing data loading bar status.}

Step 10: At Import Staff Result window, once all selected records has been deleted, please make sure the Total Errors count is 0. Click Close.

^{Figure 8: Delete staff record result.}

Step 11: Please wait while the system send Delete Card command to all controllers connected to the software.

^{Figure 9: Sending Delete Card command to the all controllers.}

Step 12: Please make sure no error found from the Delivery Report after the sending Delete Card command is completed.

^{Figure 10: Sending Delete Card command to the controllers.}

Step 13: Open Staff Records and check that the records are successfully deleted.

^{Figure 11: Verify the staff records is successfully deleted.}

Step 14: Finished.

The status of Column 'Card No' exceed the max. length [6] shown when the system is ready to import.

^{Figure 12: Column 'Card No' exceed the max. length [6] status.}

This is due to user forgot to exclude the title row of the staff records table when making selection of Start From Row at 1.

^{Figure 13: Staff records table row.}

^{Figure 14: Mistake on Start From Row.}