AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Import & Export

From Layton Support
Jump to: navigation, search

Btn back up.png Back to Contents



The import feature allows you to import data from a flat CSV file into the AuditWizard database. This interface was originally designed to import text files that were exported from AuditWizard v7, but most of the options may also be used to quickly create the location structure, user-defined data, and asset data. It can be useful when migrating from another application, or when a spreadsheet of data must be quickly added to AuditWizard. There are four different data import options:

Aw admin gen db03.png


Assets and Locations

Use this option to import Assets and the Location structure. An example CSV has been loaded below.

Database maintenance import assets locations.png

Creating an Import File

If you are constructing a CSV file for import, the file should have no headers (first row is first asset). The location should be listed first, followed by starting and ending IP addresses (null if not applicable, like with a device), and finishing with an asset name.

Examples: Computers:


Non-Computer Devices:


Picklists and Items

This import option allows for the import of Picklists and Picklist Items. If the Picklist already exists, then the Items will be imported into it. If the Picklist does not yet exist, then it will be automatically created.

Database maintenance import picklists items.png

User Defined Data Fields

Use this import feature to import user-defined data values. If the fields have already been configured in User Defined Data, then the values will be imported into them as defined. If the fields do not yet exist, then they will be automatically created. An example CSV file has been loaded below.

Database maintenance import userdefined data.png

Asset History Data

This is used to import asset history data that was exported from AuditWizard v7.

Btn back up.png Back to Contents

Personal tools

Main Page
Online User Guides
General Support
Release Notes