peter_festesen

CreateDxDatabook Utility overview

Discussion created by peter_festesen on Jul 24, 2018
Latest reply on Aug 5, 2019 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 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.

 

CrDxDB_Config_w_DB3.jpg

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

 

64bit_warning_w_DB3.jpg

 

 

 

 

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

 

----------------------- General Info below ----------------------------------------------------------
Disclaimer:

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

MainGUI.jpg

Capabilities:
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.

 

Config.jpg

 

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’

Outcomes