In observance of Memorial Day, RS2 Technologies will be closed Monday, May 27th, 2019

Importing Using The Import/Export Option


Overview

This article outlines the steps to perform a data import of cardholders and cards from a file such as, in this example, a Microsoft Excel spreadsheet.

Access It! Universal.NET Licensing

The following licensing option must be enabled within the Access It! Universal.NET dongle and is a system wide license.

  • Import/Export - Yes

Selecting the data source

  1. Within Access It! Universal.NET navigate to Cardholders
  2. Select Import Data from the toolbar
  3. Select the Microsoft Excel tab
  4. In the File name field, click Select and browse for the supported Microsoft Excel Spreadsheet to import from
  5. If applicable, in the Sheet name field, select the desired sheet
  6. If the first column of the Excel Spreadsheet contains column headers, check the box First row contains column headers
  7. Select Next

Field Mappings

Minimum field mappings required for a card- First Name, Last Name, Card Number, Facility Code.  

  1. Select Add
  2. Find the desired Destination field in the Access It! Universal.NET database the import data will be placed into
  3. Select the corresponding field in the Source section by clicking the right side of the box, which will display a drop down list.
  4. Select the corresponding field from the Microsoft Excel Spreadsheet that will be mapped to the desired destination field. If a static value is to be assigned to the Destination field, select Static Value and enter accordingly
  5. Select Next
  6. Select Finish

 Please see the attached sample file for sample layout.


  • 708
  • 14-Nov-2018
  • 539 Views