2 Replies Latest reply on Aug 3, 2018 6:21 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.


      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