Microsoft KB Archive/254739

= Visio5: How to Export Information from the AutoDiscovery Database to a Text File =

Article ID: 254739

Article Last Modified on 11/10/2000

-

APPLIES TO


 * Visio 5.0 Enterprise

-



This article was previously published under Q254739



SUMMARY
When you use the AutoDiscovery feature to discover a network, Visio Enterprise creates an internal database to store information. In order to export the database information for use in other applications or to generate a report, you can use the DBEXPORT utility that is included with Visio Enterprise. This article shows you how to do so.

NOTE: The AutoDiscovery feature is available only when the AutoDiscovery and Layout template is open in Visio Enterprise.



MORE INFORMATION
The DBEXPORT utility is an MS-DOS-based program that creates a tab-delimited text file. This file contains the field data in the AutoDiscovery database. You can find the DBEXPORT utility in the Visio\Solutions\Network diagram\_bin folder. Microsoft recommends you leave the utility in this location.

NOTE: The following procedure assumes that:
 * You have generated a network database by using the Basic Discovery or Advanced Discovery Wizard and have it open in Visio Enterprise.
 * You are familiar with AutoDiscovery and Layout terminology. For more information, click AutoDiscovery and Layout Help on the AutoDiscovery menu, and then type getting started on the Index tab.
 * You are familiar with navigating through MS-DOS.

To run the DBEXPORT utility:
 * 1) At an MS-DOS command prompt, navigate to the \Solutions\Network diagram\_bin folder.
 * 2) Type dbexport filename.txt, where filename.txt is a file name of your choice.
 * 3) Press ENTER to generate the text file.

The output is sent to the file that you specify.

For additional syntax information, open the Dbexport.txt file, located in the Solutions\Network Diagram\_bin\ folder.

DBEXPORT Text File Syntax
When you run the DBEXPORT utility, it creates a text file, delimited with tab characters. Any nonprinting characters embedded in the descriptive files of the database are converted to a space.

There are two types of database records, Device and Interface, and they are both formatted the same. There is one Device record per device. The AutoDiscovery database creates a record based on the device's name and object ID (sysObjectID). If there are multiple IP addresses or DLCIs assigned to an interface, multiple interface records may exist in the database. If this is the case, the database creates an Interface index. All records contain Device Class, Device Name, and Device SysObjectID fields. All fields in a record will be filled if data is available (except devDesc).

Field Description
This table contains the field data in the AutoDiscovery database.

NOTE: All Field names ending in "Title" are fields that you can modify in the Visio AutoDiscovery and Layout template.

Keywords: kbhowto KB254739

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.