Export tool systemhound 2007
From systemhoundwiki
Contents |
Export Wizard
Introduction
The systemhound website export tool provides the facility to export the audit data held within the systemhound reporting website. The application should be run on the systemhound central server. The export tool can export data to either a CSV (comma separated file) suitable for loading into Microsoft Excel 
, Microsoft Access Database (MDB) and generic databases via OleDB.
By using the 'save settings..' option to create a settings file it is possible to automate the export of data by using a 3rd party scheduling tool.
Performing an export
Start the systemhound export tool and if you wish to save the export configuration for automating the export, check the box "save settings to the desktop". If you wish to re-use a previously created configuration, run the wizard again from a command prompt adding the full path to the config file (in quotes) on the command line. Click next.
Figure 1
Example command line for running the export tool using a previously save configuration file:
shexport.exe c:\temp\systemhound_export_settings.ini
On the next page, confirm the location of the systemhound website and chose whether to export the data to CSV or MDB. The path to the systemhound website is defaulted to the location of the current website. If you wish to only export a subset of data then de-select the categories you wish to omit. Each category will result in single file or database table being created depending on the export type. Click next.
Figure 2
Exporting to CSV
When choosing to export to a CSV flat file you have the ability to select the export directory and which categories you wish to be merged into the main hardware csv file. Only the categories that can be merged are displayed and merged categories will become repeating columns within the hardware file (e.g. Processor1, Processor2, Processor3, …). Click next.
Figure 3
Export to Access MDB
When choosing to export to an Access database, select the location to create the database. The export tool will automatically create the Access database. Click next once the location has been selected.
Figure 4
Export Execution
On the final page, click next to begin the export.
Figure 5
Once the export is completed, the page below will be displayed.
Figure 6
The exported data is now ready for analysis within Excel or Access depending on your export choice.
