How do I generate a report from Library Manager of Cells, Symbols & parts as a text or Excel file?
Use Report Writer. You should be able to find it under the Windows Start Menu go to All Programs | Mentor Graphics SDD | layout | Report Writer. When Report Writer opens under File select Extract. The next dialog box select Central Library, check Create Database Now and click the OK button. This will open a browser window. Navigate to the library .lmc file, select it and click the Open button. Report Wrtiter is also a button in the Expedition menus.
The resulting Excel database file will be the old Jet database engine format for Access. You should be able to open the database in any recent version of Excel.
Thanks a lot for your suggestion, it is working fine.
There may be an easier way to perform this same task, if so I'm not aware of it, so I'll provide you my only known solution.
Are you familiar with Report Writer (RW)? If not and you have it loaded, you can launch this tool from the Window's Start menu, All Programs > Mentor Graphics SDD > Layout > Report Writer.
When Report Writer is launched, the first task is to extract an .MDL database from your Central Library (CL), so select the File > Extract Data command to start this process.
This will open an Extractor Selection dialog, select the radial button located next to the Central Library item and verify that the Create Database Now option is checked, click the OK button.
This will open a Select Central Library browse window, browse, located and select the Central Library .LMC file, then click the Open button, this will load all the data from the CL into Report Writer at the same time creating the needed .MDL file.
(If you look in your Central Library container at this point, you will find a new folder named VBReport. Within this folder exists an Output folder where the newly *.MDL file was created).
Now that the *.MDL file has been created and all the CL data has just been loaded into RW, you now can extract your needed reports. Select the File > Open Reports command, this will open the Open Report dialog with a list of pre-exiting report types (*.rpl) that is delivered with the software. Below I've provided a description of each report type:
cellpartition.rpl - Cells w/descriptions, including Mechanical & Drawing cells, with partition name
commprop.rpl - User defined common properties added using the Property Definition Editor
padstack.rpl - Padstacks w/defined technology
partpartition.rpl - Part Number, w/Part Name & Part Label, categorized by partition name
searchpath.rpl - Search paths defined in the Partition Search Paths
stackup.rpl - Padstack stackup report, reports pads defined for Top, Bottom, Internal, etc.
sympartition.rpl - Symbols categorized by partition
templates.rpl - Available templates w/descriptions
If you do know RW well, you can get creative and create your own reports, if required.
When you have selected one of the delivered reports listed above, click the the Open button to display a Preview Report in the RW window. Use the toolbar commands on the Preview window to Page Up/Down, Print and/or Export the displayed report. The Export option has many output formats, use this to create a text, Excel, etc. report type that your requesting.
I hope this helps!
Mentor Graphics SDD
Thanks a lot for your detailed instruction, it is working fine.
perhaps there is a better way.
(I think it is a Mentor-secret).
Go to C:\MentorGraphics\2007.8EE\SDD_HOME\lm\win32\bin\libPDFMenu.exe
When you start it, you can choose the library, a name for pdf output file and others.
Use the search function in pdf.
Hope it helps.
I am using 2005 version and I am not able to locate the exe file which you mentioned.
Thanks for your support.
In the 2005 version it is located at C:\MentorGraphics\2005EXP\SDD_HOME\wg\win32\bin\libPDFMenu.exe. However, you can also run this from within Library manager by doing File->Output PDF
Yes, I got the required report.
Jeff is right.
In the same directory there is a little tool named "libtool.exe".
After extraction of the library in Report Writer as described above, you can open a file in [centrallib]\VBreport\output\[centrallib].mdl.
Thank you, I got it.
If you want to extract the library database from the command line, create a batch file and the following line:
This will create a file in \VBReport\Output\ called hba_lib.mdl
You can open this file Microsoft Access and create custom queries, but you really can't save anything in the database. So I can save my queries and reports, I create my own Access Database and then link to the tables in hba_lib.mdl
Is there a way to export all the part numbers using one cell. For example, we have 400 0603 resistors in EE2007 library and they may not be in the same part partition, in this case how to export all of the different part numbers so that I can easily know the 0603 cell has been used in which part.
You could also use automation to write it to a text file .....
Dim libObjSet libObj = Application.ActiveLibrary
' number of cells in CELL partition 15
MsgBox libobj.Partitions(kCELL).item(15).Name & " - " & libobj.Partitions(kCELL).item(15).Count
' Gives the name and number of associated parts of the 4th Cell in Cell partition 15MsgBox libobj.Partitions(kCELL).item(15).Item(4).Name & " has followings parts mapped: " & libobj.Partitions(kCELL).item(15).Item(4).AssociatedParts.Count
Dim PartObjSet PartObj = libobj.Partitions(kCELL).Item(15).Item(4).AssociatedParts
'Delivers the Name of the first mapped Part
Retrieving data ...