How to export I/NET individual data to a .csv file

Issue

Site may be migrating from I/NET to another access control system and would like to import the data.

Product Line

TAC I/NET, Andover Continuum

Environment

I/NET

SQL Management Studio

Cause

The site is migrating from I/Net to Continuum or another access control system.

Resolution

  1. Open SQL Management Studio and create a New Query by clicking on the "New Query" button
  2. Run the script below:

    SELECT * FROM InetDb.dbo.IdWorksView
     
  3. Select File>Save Results As...
  4. Save the file as a .csv to a location of your choosing