The Database Listing form is displayed when you select Utilities>DB Listing or Query>DB Changes from the main bar menu. This form lets you output all or part of the database, including element attributes, as a text file.
A simple procedure to create a DB listing:
<!--[if !supportLists]-->1) <!--[endif]-->Select Utilities > DB Listing
<!--[if !supportLists]-->2) <!--[endif]-->Navigate to the element that you want to list.
<!--[if !supportLists]-->3) <!--[endif]-->Select Add > CE from the DB Listing form.
<!--[if !supportLists]-->4) <!--[endif]-->Destination should be File. Accept the default filename, or give a path and filename of your choice, i.e. C:\temp\P1501A.txt.
<!--[if !supportLists]-->5) <!--[endif]-->Press the Apply button at the lower left corner of the DB Listing form.
<!--[if !supportLists]-->6) <!--[endif]-->Open the file in the text editor of your choice, i.e. NotePad, WordPad, etc., and edit any attributes such as names, positions, etc. Search and Replace can be used to change names throughout the file. Remember, names must be unique. Don’t forget to save the file.
<!--[if !supportLists]-->7) <!--[endif]-->In PDMS, navigate to the level of a legal owner (or below) of the element type that you have listed.
<!--[if !supportLists]-->8) <!--[endif]--> Display > Command Line
<!--[if !supportLists]-->9) <!--[endif]-->Key in: $M C:\TEMP\P1501A.TXT
It can be used in three different modes:
DB Listing: This outputs a listing of the specified parts of the database in its current state.
DB Changes: This outputs a listing of the changes to the specified parts of the database as a macro which can be run in to return the database to the state it was in at the given time or session. You can edit the macro file so that only the required elements are changed.
DB Differences: This outputs a listing of the specified parts of the database, with the old and new elements and attributes changed or added since the given time or session.
The mode affects which gadgets are active on the form. The mode is changed using the options under Control on the menu at the top of the form.
You can send the output to the Screen or a File. If you select File, fill in a valid filename to output to the $PDMSUSER directory, or input a valid pathname to output to a different directory. Select New for a new file, or Overwrite or Append if the file exists: if you do not, you will be prompted to specify which one you want. If you select Screen, the Command Input & Output window will be displayed, ready to display the information when you press Apply.
This shows the list of elements that will be reported on when the Apply button is pressed. Clicking on any element in this list will navigate to that element.
The active gadgets in this frame depend on the form mode, which is shown by the frame title. None of the gadgets are active in DB Listing mode. In DB Changes and DB Differences modes, you can select:
Savework, which will report on changes since the last Savework.
TimeDate, which will report on changes since the time and date given.
Time format is HH:MM on a 24 hour clock, e.g. 16:15.
Date format is DD Mon Year, e.g. 9 Feb 1998 or 30 Aug 97
Session, which will report on changes since the given session number. Set the other gadgets in this frame to the time, date, session number and session user of the last saved session of the current DB.
Extract, which is only active when the current element is in an extract database. will report on changes since the given session number. When you choose this option, the options in the Since Extract frame will become active, see below.
You can type in the session number, or change it using the + and - buttons.
Note that TimeDate and Session are related: changing one will affect the other settings, and also display the correct Session User.
The More button shows a form with the Session comment for the given session.
the 3D graphics views in the colour specified by Colour>Changes. This option is useful after a Getwork to see the changes that other users have made.
The first drop-down list in the Since Extract frame will become activewhen you choose the Since Extract option in the DB Changes/Differences frame. It shows all the databases in the extract hierarchy above the current extract, with the Master at the top of the list.
The options on the next drop-down list are:
Only which compares the current database with the selected extract ancestor database
Latest which compares the database with the latest version of the selected extract ancestor database.
Session which compares the database with the selected ancestor extract since session nn of that extract.
Date which compares the database with the selected ancestor extract since the given date in a session of the ancestor extract.
The Apply button is only active when there are elements in the Elements list.
The Dismiss button dismisses the form and clears the Elements list.