AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Import & Export
m (Added "Back to Contents" link) |
m (Minor text changes) |
||
Line 50: | Line 50: | ||
==Locations== | ==Locations== | ||
− | It is not possible to import | + | It is not possible to import all location information using the '''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Import & Export#Assets and Locations|Assets and Locations]]''' method because that method imports assets with their locations. The asset is the focus of that method. A list of locations have to be imported directly into the database using Management Studio. The table structure is as follows: |
_LOCATIONID,_FULLNAME,_NAME,_PARENTID,_START_IPADDRESS,_END_IPADDRESS,_HIDDEN | _LOCATIONID,_FULLNAME,_NAME,_PARENTID,_START_IPADDRESS,_END_IPADDRESS,_HIDDEN |
Revision as of 04:51, 21 November 2016
Contents |
Overview
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:
Sections
Assets and Locations
Use this option to import Assets and the Location structure. An example CSV has been loaded below.
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:
Location1,192.168.1.1,192.168.1.255,ASSET1 Location2,192.168.2.1,192.168.2.255,ASSET2 Location3,192.168.3.1,192.168.3.255,ASSET3
Non-Computer Devices:
Location1,,,Phone1 Location1,,,Phone2 Location2,,,Phone3 Location2,,,Phone4
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.
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.
Asset History Data
This is used to import asset history data that was exported from AuditWizard v7.
SQL Import
When one of the above options is too limited, SQL queries can be used to import data directly into the database.
Locations
It is not possible to import all location information using the Assets and Locations method because that method imports assets with their locations. The asset is the focus of that method. A list of locations have to be imported directly into the database using Management Studio. The table structure is as follows:
_LOCATIONID,_FULLNAME,_NAME,_PARENTID,_START_IPADDRESS,_END_IPADDRESS,_HIDDEN
Column Name | Description |
---|---|
_LOCATIONID | Serial number for internal reference. |
_FULLNAME | The name, with any parent names, separated by a backslash \. |
_NAME | The name of this location without any parent names. |
_PARENTID | The _LOCATIONID of any parent one level up. |
_START_IPADDRESS | The starting IP address of a range that represents this location (optional). |
_END_IPADDRESS | The ending IP address of the range (optional). |
_HIDDEN | Unused at this time. Enter 0. |
Example CSV File
_LOCATIONID,_FULLNAME,_NAME,_PARENTID,_START_IPADDRESS,_END_IPADDRESS,_HIDDEN 1,Home,Home,NULL,,,0 14,Home\Site 01,Site 01,1,,,0 15,Home\Site 02,Site 02,1,,,0 16,Home\Site 03,Site 03,1,,,0 17,Home\Site 01\Location 01,Location 01,14,13.14.5.1,13.14.5.255,0 18,Home\Site 01\Location 02,Location 02,14,13.15.5.1,13.15.5.255,0 19,Home\Site 02\Location 01,Location 01,15,48.3.14.1,48.3.14.255,0 20,Home\Site 02\Location 02,Location 02,15,48.3.15.1,48.3.15.255,0 21,Home\Site 02\Location 03,Location 03,15,,,0 22,Home\Site 02\Location 04,Location 04,15,,,0 23,Home\Site 03\Location 01,Location 01,16,,,0 24,Home\Site 03\Location 02,Location 02,16,,,0 25,Home\Site 03\Location 03,Location 03,16,,,0