5 Replies Latest reply on Nov 26, 2009 11:11 AM by FLASHPLL

    Importing parts from a external Data Base.

    afs

      Greetings,

       

      Hello everyone, I'm an IT developer for my company and I was assign to do a integration job.

       

      Here at my company, we have our own software to manage components and part number creation. But it only manages the components features (eg: For a capacitor, we define: capacitance, tolerance, voltage, manufacturer, etc.. and assign a specific PN for it). Our software isn't interested in creating symbols or pin mapping.

       

      All the components we create are stored in a MySQL data base.

       

       

      All we gotta do now is to get this components and its features into our DX Design Library. After we do that, we will manually create/assign symbols and pin mapping.

       

      My question here is: Is there a way to import this parts we create in the 3rd party software into DX Design?

       

      I've been trying to do so for the past weeks, using DX DataBook aproches.. But got nothing so far. So I start guessing im doing something wrong. Or it can't be done this way.  =/

       

      Any thoughts?

       

      Tkz all.

        • 1. Re: Importing parts from a external Data Base.
          afs

          Just to clarify what I've been trying to do.. (noticed that i havent explain what i did over here.. ops)

           

           

           

          I have created a table on our MySQL data base called "Capacitor"

          This table contains a series of colunms (Tolerance, Capacitance, Voltage, Manufacturer, and so on)


          And this table is populated with a lot of capacitors that we have created in our PartManagementSoftware.

           

          After that, I tried do use DX DataBook to "link" this table to a Partition on Library Manager. But none parts were "imported".

           

           

           

          If my explanations lacks information, please, feel free to ask for more..

           

          Tkz again.

          • 2. Re: Importing parts from a external Data Base.
            artsiom.shchatsko

            Could you elaborate on "After that, I tried do use DX DataBook to "link" this table to a  Partition on Library Manager. But none parts were "imported"."? What exactly did you do?

            In general DxDataBook is able to connect to any ODBC database

            • 3. Re: Importing parts from a external Data Base.
              afs

              Hello Artsiom,

               

              sorry bout the delay on answering your question.

               

              Here it goes.

               

              First, let me show the capacitor table im trying to import.

               

              Table:

              tableCapacitor.JPG

               

               

              I've created a ODBC connection for this table called cLybrary.

               

              And then, configured this data source on Library Manager/DXDatabook

               

              Configuring DataSource:

              configuringDataSource.JPG

               

               

              I can see that all the columns have been recognized and are shown in the databook

               

              Table Imported:

              capacitorTableInDXDatabook.JPG

               

               

              But I get no parts in "capacitor" partition as you can see.

               

               

              No parts imported:

              partitionCapacitorEmpty.JPG

               

               

              Im obviously doing something wrong.. lol

               

              Tkz for the help.

              • 4. Re: Importing parts from a external Data Base.
                artsiom.shchatsko

                afs wrote:

                Im obviously doing something wrong.. lol

                It's staggeringly obvious

                I'm sooooo tempted to shout "RTFM!"

                 

                The thing is that you must have parts in Central Library as their main function is to map symbols to cell. DxDataBook just provides a more convenient way to manage data prorerties. As you have no parts, DxDB doesn't show you anything - DxDB entry references a name that doesn't exist.

                • 5. Re: Importing parts from a external Data Base.
                  FLASHPLL

                  Hi,

                  I am very new to Mentor but experienced database developer.

                  First thing I will check is that databse table structure of both

                  database tables(MySQL and Mentor Database). Any vriation

                  may produce undesired results, some cases it may currupt

                  database.

                   

                  I am not sure this will help(due to my lack of Mentor database)

                  but worth spending little time to investigate will certainly help

                  for good.

                   

                  Vijay Sheth