Importing Data from a CNE Data Vault

When fully installed, Spector 360 will automatically populate its Database with the Client recordings received by the Data Vault Service. An Import Utility (FileToSQL.exe) allows you to populate a Spector 360 Database with data from pre-existing Spector CNE Data Vault files, as long as you were using Spector CNE version 4.3, 4.4, or 6.0. The Import Utility is automatically installed with the Spector 360 Database.

• Only the Spector 360 System Administrator login can import data into a Spector 360 Database.

• You can run the Import Utility on more than one Data Vault to consolidate all data in one Spector 360 Database.

• You can re-use the Import Utility on the same Data Vault after a period of time to retrieve new data, if necessary.

To import CNE data into the 360 Database:

1. Start the Import Utility:
   Open the Windows Start menu, select All Programs, Spector 360, and Spector 360 SQL Import Utility.  At the Welcome screen, click Next.

2. Specify the SQL Server location:
   At the Database Configuration screen, click Browse to display all instances of SQL Server currently available on the network. Select the computer\Spector360 instance you installed as part of the Spector 360 setup, where computer is the Windows computer name where SQL Server and the Data Vault are installed.
   

3. Log in to the database:
   Select Use SQL Server Authentication, enter sa as the user name and the password you defined for the System Administrator (SA) while installing the database. See System Administrator Password for more information.
   
   
   
   Click Next on the Database Configuration panel.

4. Specify the Data Vault source location:

Source Folder: Enter the location of the Source Folder for the Data Vault, or click Browse to navigate to the location of the Spector CNE Data Vault you wish to import. Select the directory and click OK.


Include Subfolders: Leave this option checked if you want to import data from all subfolders in the specified location. If you do not check this item, only data files in the named location are imported.

Data Extension: Leave the sdf data file name extension as is, unless you have changed the file extension for your Spector CNE data files.

Press Next.

5. Specify options for the import:

Import Snapshot Events: Check this option if you want to import existing Screen Snapshots into the Spector 360 Data Vault. Leave it blank if you do not want to import Snapshots. Make sure you have enough disk space to hold past, present, and future Snapshot files. See Estimating the Database Size.

• Use Existing Folder Structure: Check this option to have the Spector 360 point to Snapshots in their original location in the Spector CNE Data Vault rather than importing them into the new Spector 360 Data Vault; you save disk space, but the files cannot be encrypted. If you plan to archive and remove CNE Data Vault files after the import is finished, do not check this option.

• Copy Snapshot Files: Check to import and optionally encrypt  Snapshot files.
  
  

Encryption Type: Select a file encryption from the drop-down list. The encryption will be applied to each file as it is imported:

• None - no encryption applied, files can be opened as is

• Internal - applies SpectorSoft encryption format

• 3DES - applies "Triple Data Encryption Standard" (a NIST standard) format with 3 stages of encryption

Import Email Attachments: Check this option to import all email attachment files.  Leave it blank if you do not wish to view Spector CNE attachments from the Dashboard.  

• Encryption Type: Select a file encryption from the drop-down list (None or 3DES). The encryption will be applied to each file as it is imported.

Reimport Previously Imported Files: The Import Utility is able to mark data files that have and have not been imported. If you are using the Import Utility to add recently captured data from your Data Vault to the database, leave this option blank. Check this option to import all data from the Spector CNE Data Vault, including data that has already been imported.

Import Today's Data Files: The Import Utility imports data recordings in full days. If you want to import all data for viewing in Dashboard, leave this option blank. You can get a full day's recordings for today on a subsequent import. Check this option only if you want today's recorded events, even though additional data recording could take place after the import.

Combine Local Users into One Account: Check this option to import user names that may be recorded as a local user on different computers (for example: Computer1\sallyj, Computer2\sallyj) as one user (<Combined>\sallyj). This is particularly useful for Novell networks. All data for the combined user is consolidated. Leave this option blank if this is not a problem.

Output Folder: Select a folder to store the imported Snapshot and Email Attachment files. You can create a new folder with any name you wish. Click Next. If you will not be importing Screen Snapshot or email attachments, you do not have to choose an output folder.

6. Click Finish. The Import Utility connects to the Spector 360 Database, and the import begins.

7. Importing the data:
   A status screen displays data being imported and the import progress. Click OK when the import is complete.  You are now ready to begin using the Spector 360 Dashboard.
   
   

8. Review the import log.
   If errors occur, you can review the log file (filetosql.log), a text file with date and time stamps showing errors that occurred during the import. The file is saved at C:\Program Files\SpectorSoft\Spector360\filetosql.

Related Topics. . .