Exporting CICS Explorer connections using Open Office spreadsheets
Giovanni Creato 270004PNT1 Visits (3035)
Abstract: CICS CMCI connections can only be defined manually in CICS Explorer. This is suitable if you have to create a small number of connections but does not fit if you have to define a large number of connections. This document will show you how to generate Connections.pref from an Open Office spread sheet. This article is based on CICS Explorer 5.1.1
Objective: Generate Connections.pref from Open Office spread sheet (See picture below)
How you will reach your objective: By following this guide you will define an XML Filter on OpenOffice. You will then use the newly created XML Filter to Export the spread sheet. You will then use Open Office in this way: On OpenOffice Calc, click on File -> Export, on Save as type Select the newly created export type. (See picture below)
What needs to be done:
1 - Store the attached sample files:
2 - On Open Office Calc. Click on Tools -> XML Filter Settings...
Explanation: The XML file that you have referenced in Open Office Calc is a XSLT file. XSLT is language used in many contexts (for example Mobile development) by which you can specify XML transformations.