passerelle
DESCRIPTION
Passerelle. [email protected]. 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. - PowerPoint PPT PresentationTRANSCRIPT
Passerelle
Passerelle – Sebastian Lopienski (SL/CO/AP) – 14/12/2001
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
Passerelle – Sebastian Lopienski (SL/CO/AP) – 14/12/2001
Structure (layers)
• Excel
• Visual Basic for Applications (VBA) scripts
• SL CMW API (Java)
• Passerelle Java code
• Controls Middleware – CMW (Java)
Passerelle – Sebastian Lopienski (SL/CO/AP) – 14/12/2001
Structure (layers)
Passerelle – Sebastian Lopienski (SL/CO/AP) – 14/12/2001
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
Passerelle – Sebastian Lopienski (SL/CO/AP) – 14/12/2001
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
Passerelle – Sebastian Lopienski (SL/CO/AP) – 14/12/2001
What’s next?
• bi-directional operations (XBI mode)
• advanced error reporting
• subscription mechanism
Passerelle – Sebastian Lopienski (SL/CO/AP) – 14/12/2001
PeopleThe 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
Passerelle – Sebastian Lopienski (SL/CO/AP) – 14/12/2001
Demonstration
Passerelle – Sebastian Lopienski (SL/CO/AP) – 14/12/2001
Web page
Passerelle project web page:
http://www.cern.ch/proj-passerelle
(documentation, mandate, people involved,
milestones, presentations etc.)
Passerelle – Sebastian Lopienski (SL/CO/AP) – 14/12/2001
Thank you
Any questions?