CreateDxDatabook Utility overview

Discussion created by peter_festesen on Jul 24, 2018
Latest reply on May 5, 2020 by peter_festesen

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.


----------------------- Start March 2020 Newsflash ------------------------------------

I have gone through the motions with GitHub, and finally succeeded in uploading both a zip file that has everything (may be used as a reference in the future, so I left it there), as well as the full file structure.  


It is located here : 

Link to Github (MGC-CrDB/CrDB)


----------------------- End March 2020 Newsflash ------------------------------------


----------------------- Start February 2020 Newsflash ------------------------------------

Scroll down and find "" (posted February 7th 2020 - important bug fixes - also see the explanation from the same date regarding the CPDB tables in the Databook configuration. 



----------------------- End February 2020 Newsflash ------------------------------------


----------------------- Start December 2019 Newsflash ------------------------------------

New version for VX.2.6 available !!!
This new version just landed on my desk, and I wanted to make sure to get this out before the Christmas holidays. 

Keep in mind that VX.2.6 is 64bit only - that means that the new version will only create a SQLite (db3) database (NO mdb - corrected (was 'dbc', is now 'mdb') February 7th 2020)   

Initial tests have shown that in some cases we see symbols missing in the Databook grid. The database itself looks fine. We are working on this, but wanted to make the utility available nonetheless. 
If you find the time to download and test the utility with VX.2.6 and have some insight to what may cause this, we are keen to hear from you here in the thread.


Have fun with it -  look a bit further down for the download ( 


----------------------- Start November 2018 Newsflash ------------------------------------

Important Newsflash - November 2018 :

New Version WITH support for SQLite available !!!!

The latest release of the CreateDxDatabook utility allows you to create an SQLite (db3) database (and of course the matching dbc file).

Scroll down to download the latest version - look for "CreateDxDatabook_EXE_32#64bit_v8.6.2.4_EEVX.2.4_2018.11.08.current.7z". It supports EEVX.2.4, EEVX.2.3 and EEVX.2.2.


Of course this excellent addition has caused some minor changes in the GUI.



It is now possible to define where the dbc file is saved - In the same folder as the database file, (.mdb or .db3) or in the Central Library folder.

In order to create an SQLite format database, simply pick the Database Type : SQLite (DB3) as shown above.


Additional note, November 13, 2018 :
While SQLite is fully supported for a 64bit EEVX installation, the utility does not support Microsoft Access (mdb) for 64bit EEVX. So the utility will default to db3 if it detects a EEVX.n.n 64 bit install







----------------------- End November 2018 Newsflash -------------------------------------------


----------------------- General Info below ----------------------------------------------------------

'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)


Configuration options:
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.




Basic operation:
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
  1. Run the executable CreateDxDatabook.exe
  2. Select your Central Library
  3. Define your configuration options
  4. Turn on/off switches ‘Use Centlib Symbols’ and/or ‘Create/Update DBC file’
  5. 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'
  6. 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.
  7. 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’