110 likes | 234 Views
Passerelle. Sebastian.Lopienski@cern.ch. What is Passerelle. a ccess to equipment from Excel no coding necessary user friendliness (well-known Windows environment) allows users to use it directly from Excel or write own macros. Structure (layers). Excel.
E N D
Passerelle Sebastian.Lopienski@cern.ch
What is Passerelle • access to equipment from Excel • no coding necessary • user friendliness (well-known Windows environment) • allows users to use it directly from Excel or write own macros
Structure (layers) • Excel • Visual Basic for Applications (VBA) scripts • Passerelle Java code • SL CMW API (Java) • Controls Middleware – CMW (Java)
Technological issues • how to access Java code from VBA scripts? • JIntegra vs. JavaBeans to ActiveX Bridge • evaluations (available on the web) • chosen technology: JIntegra on DCOM • SL CMW API – special API to access SL equipment done for Passerelle
What can Passerelle do? Functions: • read and set on all SL equipment • read on all PS equipment Features: • read/write operations are complete (whole worksheet) or selected (only selected cells) • passing user options • no limit on data size • old macros can be used
What’s next? • bi-directional operations (XBI mode) • advanced error reporting • subscription mechanism
People The team: • Eugenia Hatziangeli (SL/CO) – project leader • Vasileios Fasoulas (SL/CO) – preliminary work till Aug’01 • Sebastian Lopienski (SL/CO) – work since Sept ’01 Collaborators (as users): • Gianluigi Arduini (SL/OP) • Delphine Jacquet (SL/OP) Support: • Kris Kostro (SL/CO) - CMW • Vito Baggiolini (SL/CO) – SL CMW API
Web page Passerelle project web page: http://www.cern.ch/proj-passerelle (documentation, mandate, people involved, milestones, presentations etc.)