## Using PcdmisXMLStatsToDatabase.exe

This tool was enhanced in version 2011 to function identically to the Data Importer tool. It remains for backwards compatibility purposes. For information on this tool, consult the documentation on the DataImporter.exe file. See "Using DataImporter.exe".

OLD DOCUMENTATION: The PcdmisXMLStatsToDatabase.exe tool allows you to monitor a specified directory on a local computer or a network for XML files that were created using the DataPageStats.exe file. It will use a defined interval to read the data from any XML files and send it into the defined Destination Database.

You can re-access the database at any time inside DataPage+ to get at the new data by using the Refresh icon.

This tool resides in the directory where you installed DataPage+. To use it, simply run PcdmisXMLStatsToDatabase.exe, fill out the resulting dialog box, and then either click the Check button to check the monitored directory now, or click the Close button to automatically check the monitored directory using the time interval in the Auto Check area. Once you run this program, an orange icon appears in your system tray.

The dialog box contains these items:

File Monitor: This area defines the directory to monitor for any XML file additions. The tool will look in this directory at the specified interval and if it detects any new XML files, it will send the data in the XML files to the database defined in the Destination Database area.

File Disposition: When an XML statistics file is detected in the monitored directory, and after the data has been imported into the specified database, you can use this area to tell the tool what to do with the file. You must use one of these items so that the file is no longer monitored once it has been processed. The available options are:

- Move to directory - This moves the XML statistics file out of the monitored directory into the to the new directory.

- Delete - This deletes the XML statistics file.

- Rename - This renames the XML statistics file to a different extension.

Auto Check: This area lets you define whether or not to automatically check the monitored directory using the defined time interval. Set the time interval as a value in the edit box and select the time component (seconds, minutes, hours) from the drop down list.

Part Category: This assigns the part to the specified category. See "Categories".

Destination Database: This lets you choose the database to which the tool will send the data in the statistics file. It contains these options:

- Always use the same database with DataPage+ - This will use the same database that DataPage+ is currently configured to use.

- Specify a Different Database - The tool will use a different database specified by using the ... browse button. Clicking this button opens the Database Connection Properties dialog box. For a description of this dialog box, see "Connecting to a Database".

Show this dialog when startup: This determines whether or not to display this tool's user interface whenever you run the .exe file. If the check box is cleared, the user interface is hidden while the tool continues to run in the background. You can tell it is running because an icon appears in the system tray. It continues to use the settings already defined. To access the tool's settings at any time, right-click on the icon in the system tray and choose Settings.

Check: This runs an immediate check on the monitored directory. You can also run a check from the system tray icon, by right-clicking on it and choosing Check.

Close: This closes the tool, placing it in a hidden mode while it continues to monitor the defined directory in the background. To permanently close the tool, even from the system tray, right-click on the icon and choose Exit.