Understanding Expedition Enterprise - Mentor Graphics
Integrating EE flow with Enterprise Systems Nick Hong Sr. Corporate Application Engineer Customer Support Division May 2011
Agenda Understanding EE flow Automation Things around integrating with Enterprise Systems Summery
2
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Understanding EE flow Library Manager . Part Editor . Symbol/Cell/Padstack Editor
DxDesigner / DxDataBook ExpeditionPCB FablinkXE visECAD & PCB Browser
Understanding Expedition Enterprise Library Manager — Part Editor — Symbol/Cell/Padstack Editor
DxDesigner / DxDataBook ExpeditionPCB FablinkXE visECAD / PCB Browser
4
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Understanding Expedition Enterprise Library Manager — Part Editor — Symbol/Cell/Padstack Editor
DxDesigner / DxDataBook ExpeditionPCB FablinkXE visECAD / PCB Browser
5
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Understanding Expedition Enterprise Library Manager — Part Editor — Symbol/Cell/Padstack Editor
DxDesigner / DxDataBook ExpeditionPCB FablinkXE visECAD / PCB Browser
6
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Understanding Expedition Enterprise Library Manager — Part Editor — Symbol/Cell/Padstack Editor
DxDesigner / DxDataBook ExpeditionPCB FablinkXE visECAD / PCB Browser
7
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Understanding Expedition Enterprise Library Manager — Part Editor — Symbol/Cell/Padstack Editor
DxDesigner / DxDataBook ExpeditionPCB FablinkXE visECAD / PCB Browser
8
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Understanding Expedition Enterprise Library Manager — Part Editor — Symbol/Cell/Padstack Editor
DxDesigner / DxDataBook ExpeditionPCB FablinkXE visECAD / PCB Browser
9
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Understanding Expedition Enterprise Library Manager
CIS
Library
PDM/PLM
Viewer
FablinkXE
ExpeditionPCB
DxDesigner
Manufacturing Other Enterprise Systems
10
DRC/ Status Check
Documentation
Analysis
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Understanding Expedition Enterprise Library Manager
CIS
Library
PDM/PLM
Viewer
FablinkXE
ExpeditionPCB
DxDesigner
Manufacturing Other Enterprise Systems
11
DRC/ Status Check
Documentation
Analysis
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Automation
Automation Microsoft® technology which allows server applications to expose data and functionality to be used by automation clients. Access sets of items using filters to only get the items of interest. Customize and streamline your environment Add new commands, which have the ability to listen and react to any event Integrate with other applications with the design tools Language independent (Vbscript, jscript, perl script, Visual Basic, C/C++, …) Unlike Ample, Automation is not a transcript language. 13
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Automation Automation Form Editor (IDE) — WYSIWYG design environment that allows to create forms and add controls — Includes a code window, to write the codes associated with each object — Easily setup buttons, check boxes, text boxes, list boxes, …
14
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Automation Examples — RenumberRefDes.vbs
15
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Automation Examples — ReportRoutedNet.efm
16
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Things around integrating with Enterprise Systems Part Registration Part Browser/Instantiation/Package Bill of Materials (part list) Schematic/PCB viewer Transfer Design Data Archive Design Data
Part Registration Part Registration — PDB (Central Library) — DxDataBook (Text Attributes including PART_GRADE)
Documents, text attributes reside in Enterprise Systems — CIS, PDM, …
Lots of manual operation : tedious & error-prone Synchronization with CIS 18
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Part Registration Has been able to be achieved by hkp import/export Hkp will fade out in next major release, and should be replaced to use PCB Automation — \ docs\ pdfdocs\ library_editors_auto.pdf — Access Library Manager CreateObject(“LibraryManager.Appilcation”)
— Or, access each editor directly CreateObject("MGCPCBLibraries.PartsEditorDlg") CreateObject(“CellEditorAddin.CellEditorDlg”) CreateObject("MGCPCBLibraries.PadstackEditorDlg")
* GetObject(, “…”) can be used as an alternative 19
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Part Registration To access Oracle database using vbscript Const sSQL = "SELECT TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS') AS DateTime FROM DUAL" connectionString = "Provider=MSDAORA.1;User Id=;Data Source=<sid>;Password=<passwd>;" Set connection = CreateObject("ADODB.Connection") connection.Open connectionString Set rows = connection.Execute(sSQL) While Not rows.EOF sDate = Left(rows.Fields("DateTime").Value, 10) sTime = Right(rows.Fields("DateTime").Value, 8) MsgBox("Retrieved database server date: " & sDate & " and time: " & sTime) rows.MoveNext Wend connection.Close
20
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Part Browser/Instantiation/Package Part Browser — Symbol Viewer — DxDataBook — Company Browser (by project, plant, …)
Part Instantiation — DxDB Customization (Restrict by part grade) — Custom Browser
Annotation — Customization (Apply additional info., e.g. IBIS metadata)
21
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Bill of Materials (part list) From DxDesigner — EDIF — CCZ — Parts Lister
From ExpeditionPCB — CCZ — Report Writer
Not able to combine information from other systems (e.g. cost, grade) Use Automation to export BOM in custom format & to increase flexibility 22
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Bill of Materials (part list) DxDesigner PartsLister — Line command support – TechNote MG245620
Automation capability — Access any object in design data — Access Central Library to bring together additional information — Create ASCII file in any format — Retrieve associated objects to get additional connection information — Create log file at desired point by event handling
Example — Export part list in company standard format — Create part price report — Create temporary code part list — Calculate total area of solder paste
23
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Schematic/PCB Viewer For schematic viewer — visECAD (CCZ) – Cross-probe support – Line command support
— HPGL export — PDF export – Line command support – Searchable text, Hyperlinks
— EDIF Schematic
For PCB viewer — visECAD (CCZ) – Cross-probe support
— ODB++ export — DXF, GDSII — PDF export by layer — Free PCB Browser 24
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Schematic/PCB Viewer Schematic PDF — Line command support - TechNote MG242597 — %SDD_HOME%\ wv\ win32\ bin\ sch2pdf -project "c:\ WDIR\ sample\ sample.prj" –schematic schematic1 -a "c:\ temp\ sample.pdf" -c 1
PCB PDF — Requires FablinkXE & Automation Pro license — \ docs\ pdfdocs\ exp_engines_auto.pdf — Use setup file - ExtendedPrint.pcf Set oExtendedPrintEngine = CreateObject("MGCPCBEngines.ExtendedPrint") %SDD_HOME%\ standard\ examples\ pcb\ Automation\ AutoProEngines\ RunExtendedP rint.vbs
— Or, compose each page by Automation Set oPDFEngine = CreateObject("MGCPCBEngines.PDFOutput") %SDD_HOME%\ standard\ examples\ pcb\ Automation\ AutoProEngines\ RunPDF.vbs
25
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Transfer Design Data Schematic Data — CCZ FablinkXE
— CCZ
DxDesigner
PCB Data
ExpeditionPCB
— EDIF Schematic
— ODB++ — XE Neutral File — HKP (Fade out)
Automation capability to retrieve design information and write in custom format
26
3rd Party/In-house Tools
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Archive Design Data DxArchiver — Collects and stores schematic, symbols and other associated data — DxDesigner > Tools > Archiver — Command line support – TechNote MG51826 – DxArchiver -noGUI -p C:\ WDIR\ sample\ sample.prj -c Z:\ cfg\ DxArchiver.xml – %SDD_HOME%\ wv\ win32\ bin\ DxArchiver.exe –h
27
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Summary
28
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Summary Existing command line programs can be used to generate required files in prescribed formats Outputs, including design files, can be integrated with PLM or other non-EDA systems For special demands, Automation scripts can be adapted to most requirements Automation training will be held in Q3
29
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
www.mentor.com
30
MN, DMS Product Update, May 2010
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Agenda Understanding EE flow Automation Things around integrating with Enterprise Systems Summery
2
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Understanding EE flow Library Manager . Part Editor . Symbol/Cell/Padstack Editor
DxDesigner / DxDataBook ExpeditionPCB FablinkXE visECAD & PCB Browser
Understanding Expedition Enterprise Library Manager — Part Editor — Symbol/Cell/Padstack Editor
DxDesigner / DxDataBook ExpeditionPCB FablinkXE visECAD / PCB Browser
4
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Understanding Expedition Enterprise Library Manager — Part Editor — Symbol/Cell/Padstack Editor
DxDesigner / DxDataBook ExpeditionPCB FablinkXE visECAD / PCB Browser
5
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Understanding Expedition Enterprise Library Manager — Part Editor — Symbol/Cell/Padstack Editor
DxDesigner / DxDataBook ExpeditionPCB FablinkXE visECAD / PCB Browser
6
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Understanding Expedition Enterprise Library Manager — Part Editor — Symbol/Cell/Padstack Editor
DxDesigner / DxDataBook ExpeditionPCB FablinkXE visECAD / PCB Browser
7
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Understanding Expedition Enterprise Library Manager — Part Editor — Symbol/Cell/Padstack Editor
DxDesigner / DxDataBook ExpeditionPCB FablinkXE visECAD / PCB Browser
8
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Understanding Expedition Enterprise Library Manager — Part Editor — Symbol/Cell/Padstack Editor
DxDesigner / DxDataBook ExpeditionPCB FablinkXE visECAD / PCB Browser
9
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Understanding Expedition Enterprise Library Manager
CIS
Library
PDM/PLM
Viewer
FablinkXE
ExpeditionPCB
DxDesigner
Manufacturing Other Enterprise Systems
10
DRC/ Status Check
Documentation
Analysis
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Understanding Expedition Enterprise Library Manager
CIS
Library
PDM/PLM
Viewer
FablinkXE
ExpeditionPCB
DxDesigner
Manufacturing Other Enterprise Systems
11
DRC/ Status Check
Documentation
Analysis
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Automation
Automation Microsoft® technology which allows server applications to expose data and functionality to be used by automation clients. Access sets of items using filters to only get the items of interest. Customize and streamline your environment Add new commands, which have the ability to listen and react to any event Integrate with other applications with the design tools Language independent (Vbscript, jscript, perl script, Visual Basic, C/C++, …) Unlike Ample, Automation is not a transcript language. 13
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Automation Automation Form Editor (IDE) — WYSIWYG design environment that allows to create forms and add controls — Includes a code window, to write the codes associated with each object — Easily setup buttons, check boxes, text boxes, list boxes, …
14
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Automation Examples — RenumberRefDes.vbs
15
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Automation Examples — ReportRoutedNet.efm
16
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Things around integrating with Enterprise Systems Part Registration Part Browser/Instantiation/Package Bill of Materials (part list) Schematic/PCB viewer Transfer Design Data Archive Design Data
Part Registration Part Registration — PDB (Central Library) — DxDataBook (Text Attributes including PART_GRADE)
Documents, text attributes reside in Enterprise Systems — CIS, PDM, …
Lots of manual operation : tedious & error-prone Synchronization with CIS 18
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Part Registration Has been able to be achieved by hkp import/export Hkp will fade out in next major release, and should be replaced to use PCB Automation — \ docs\ pdfdocs\ library_editors_auto.pdf — Access Library Manager CreateObject(“LibraryManager.Appilcation”)
— Or, access each editor directly CreateObject("MGCPCBLibraries.PartsEditorDlg") CreateObject(“CellEditorAddin.CellEditorDlg”) CreateObject("MGCPCBLibraries.PadstackEditorDlg")
* GetObject(, “…”) can be used as an alternative 19
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Part Registration To access Oracle database using vbscript Const sSQL = "SELECT TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS') AS DateTime FROM DUAL" connectionString = "Provider=MSDAORA.1;User Id=;Data Source=<sid>;Password=<passwd>;" Set connection = CreateObject("ADODB.Connection") connection.Open connectionString Set rows = connection.Execute(sSQL) While Not rows.EOF sDate = Left(rows.Fields("DateTime").Value, 10) sTime = Right(rows.Fields("DateTime").Value, 8) MsgBox("Retrieved database server date: " & sDate & " and time: " & sTime) rows.MoveNext Wend connection.Close
20
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Part Browser/Instantiation/Package Part Browser — Symbol Viewer — DxDataBook — Company Browser (by project, plant, …)
Part Instantiation — DxDB Customization (Restrict by part grade) — Custom Browser
Annotation — Customization (Apply additional info., e.g. IBIS metadata)
21
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Bill of Materials (part list) From DxDesigner — EDIF — CCZ — Parts Lister
From ExpeditionPCB — CCZ — Report Writer
Not able to combine information from other systems (e.g. cost, grade) Use Automation to export BOM in custom format & to increase flexibility 22
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Bill of Materials (part list) DxDesigner PartsLister — Line command support – TechNote MG245620
Automation capability — Access any object in design data — Access Central Library to bring together additional information — Create ASCII file in any format — Retrieve associated objects to get additional connection information — Create log file at desired point by event handling
Example — Export part list in company standard format — Create part price report — Create temporary code part list — Calculate total area of solder paste
23
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Schematic/PCB Viewer For schematic viewer — visECAD (CCZ) – Cross-probe support – Line command support
— HPGL export — PDF export – Line command support – Searchable text, Hyperlinks
— EDIF Schematic
For PCB viewer — visECAD (CCZ) – Cross-probe support
— ODB++ export — DXF, GDSII — PDF export by layer — Free PCB Browser 24
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Schematic/PCB Viewer Schematic PDF — Line command support - TechNote MG242597 — %SDD_HOME%\ wv\ win32\ bin\ sch2pdf -project "c:\ WDIR\ sample\ sample.prj" –schematic schematic1 -a "c:\ temp\ sample.pdf" -c 1
PCB PDF — Requires FablinkXE & Automation Pro license — \ docs\ pdfdocs\ exp_engines_auto.pdf — Use setup file - ExtendedPrint.pcf Set oExtendedPrintEngine = CreateObject("MGCPCBEngines.ExtendedPrint") %SDD_HOME%\ standard\ examples\ pcb\ Automation\ AutoProEngines\ RunExtendedP rint.vbs
— Or, compose each page by Automation Set oPDFEngine = CreateObject("MGCPCBEngines.PDFOutput") %SDD_HOME%\ standard\ examples\ pcb\ Automation\ AutoProEngines\ RunPDF.vbs
25
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Transfer Design Data Schematic Data — CCZ FablinkXE
— CCZ
DxDesigner
PCB Data
ExpeditionPCB
— EDIF Schematic
— ODB++ — XE Neutral File — HKP (Fade out)
Automation capability to retrieve design information and write in custom format
26
3rd Party/In-house Tools
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Archive Design Data DxArchiver — Collects and stores schematic, symbols and other associated data — DxDesigner > Tools > Archiver — Command line support – TechNote MG51826 – DxArchiver -noGUI -p C:\ WDIR\ sample\ sample.prj -c Z:\ cfg\ DxArchiver.xml – %SDD_HOME%\ wv\ win32\ bin\ DxArchiver.exe –h
27
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Summary
28
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
Summary Existing command line programs can be used to generate required files in prescribed formats Outputs, including design files, can be integrated with PLM or other non-EDA systems For special demands, Automation scripts can be adapted to most requirements Automation training will be held in Q3
29
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
www.mentor.com
30
MN, DMS Product Update, May 2010
© 2010 Mentor Graphics Corp. Company Confidential
www.mentor.com
