The Create DxDatabook utility helps users to build an mdb and dbc file, based on parts data in the Central Library.
Important note: I did NOT write this brilliant piece of software. Over the last many years, it is known to have helped a lot of people, and we have decided to support it via the Automation and Scripting Community, as we see the usage is growing.
'Acceptable Usage Policy
' This software is NOT officially supported by Mentor Graphics.
' The following software is "freeware" which Mentor Graphics
' Corporation provides as a courtesy to our users. "freeware"
' is provided "as is" and Mentor Graphics makes no warranties
' with respect to "freeware", either expressed or implied,
' including any implied warranties of merchantability or fitness
' for a particular purpose.
Note that this means that you will not be able to get support from the Mentor Support Channel.
If you run into trouble or have questions, please post them here and the community will do its best to help.
The GUI :
This utility allows you to
- build an mdb (MS Access) file based on the data in the Parts database (PDB) of your Central Library
- if desired, also a DxDatabook Control file (.dbc) can be generated
- merge PDB Data with parametric data from your PLM/ERP system (Comma separated file, .psf)
Expecting that you are familiar with the LMC/PDB/MDB/DxDatabook features in Library Manager, here is a picture of the configuration dialog (File -> Edit Configuration). The selected options will be written to an .ini file at the same location as the executable.
The zip file contains the following files (for VX.2.2 and VX.2.3)
- CreateDxDatabook.exe – the main executable
- CreateDxDatabook.ini – configuration settings
- SddVxEnv.dll, DxDbClass60.dll – necessary dll files
- Run the executable CreateDxDatabook.exe
- Select your Central Library
- Define your configuration options
- Turn on/off switches ‘Use Centlib Symbols’ and/or ‘Create/Update DBC file’
- Sometimes it is necessary to verify that a certain Microsoft dll (DAO360.dll) is properly registered. This may be needed at the very first run AND after a Windows Update. Run 'File -> Check DAO360.dll'
- By default, the resulting mdb file is placed in the root folder of you library. Due to the locking mechanism used by MS Access, the folder, where the mdb file resides, must be writeable for all users. Not all Librarians allow this – in that case, switch on the ‘Use Different MDB Dir’ shown above and specify a directory. The dbc file always ends up in the Library root folder.
- A log file (CreateDxDatabook.log ) is written to the LogFiles folder in your Central Library
CommandLine options are available – you will have to run this utility in order to have the mdb in sync with your LMC data. The best approach is to run a scheduled task on your server – for example once a day. The scheduled task will run a batch file (.bat) that has all the proper commandline switches. For commandline options, see ‘Help -> CommandLine Args’