Copying and pasting resource data to a spreadsheet
You can use the copy and paste function to copy resource data and paste it into a spreadsheet, or save the data as a comma-separated variable (csv) file.
About this task
CICS Explorer® must be connected to a CICS® Version 4 or later system before you can use the copy and paste function.
CICS Explorer downloads only the amount of resource information that is needed to populate a view. For example, if your CICS system has 2000 running tasks and you open the Task view, CICS Explorer downloads only the first 30 tasks, or as many as it takes to populate the Task view. Every time you scroll the view, more task information is downloaded.
When you copy resource information to the clipboard, you can copy only information that is already downloaded. For example, if you attempt to select all the tasks by using Ctrl+A (cmd+A for macOS) and then copy them by using Ctrl+C (cmd+C for macOS), the copy action fails because all the tasks are not available. You must ensure that the resource information you want to copy is downloaded, by displaying it in the view, before you perform the action. If you want to copy data in columns that are not displayed in the default view, or you want to exclude columns from the data, you must add or remove the columns before displaying and downloading the data. See the related task for more information.
Procedure
- Select the data to be copied. If the data is not all visible in the view, select the start row of the data then, holding the Shift key, select the end row of the data.
- Press Ctrl+C (cmd+C for macOS) to copy the data to the clipboard.
Results
The data is copied to the clipboard. You can now paste the data into a spreadsheet application or a document. You can also save the data as a csv file by pasting the data into a folder on your local machine.