3 Replies Latest reply on Nov 13, 2018 4:39 AM by peter_festesen

    CreateDxDatabook Utility overview

    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’

        • 1. Re: CreateDxDatabook Utility overview
          peter_festesen

          Hello - after having discussed how DxDatabook connects to an Access database via the dbc file, and the details around this, I decided to dig up a presentation on the subject, update it with some details around the CrDxDB utility, and post it here for everyone. Enjoy !!

          • 2. Re: CreateDxDatabook Utility overview
            peter_festesen

            After a chat today, a few important remarks were made, so I thought I'd share them here.

             

            • On Windows 10, sometimes the File->Check DAO360.dll fails. This is due to some security restrictions, and can possibly be avoided by running the utility as Administrator
            • Creation of the dbc file - you may want to do this ONLY when needed. At the first run, the dbc file is saved with a lot of default settings - settings that you may change (LOAD/ANNOTATE and other settings)
              If you happen to add properties, you MUST update the dbc file in order to have the dbc file and mdb file in sync.
            • Be aware of the MS Access locking mechanism. As soon as one user opens Designer with Databook, the mdb file gets locked, which means that the utility cannot update the mdb data. In cases were it is difficult to have users exit their Designer sessions at the end of the working day, one workaround could be to let CrDxDB create the mdb in a different folder than the folder accessed by users via Databook - you would then have to manually replace the 'production' copy of the mdb file. 
            • Be aware that the utility opens Library Manager in the background, so a standalone Library Manager license is needed. 
            1 of 1 people found this helpful
            • 3. Re: CreateDxDatabook Utility overview
              peter_festesen

              Hello All

              Please note that the utility now is available in a version that is compatible with the recently released VX.2.4.

              I have verified it to work on Windows 10 with a EEVX.2.4-32bit install.

               

              Enjoy - be sure to let us know if you are facing any issues.

              /P