Are you using HP OVO (Openview Operation)/ITO/OMU (Operation Manager for Unix) ? So you must be understand how hard to write a templates document, especially if you have hundreds or thousands templates in your environment . This is a quick-and-dirty script I use, that similar to my previous released script, tpl2csv, but instead dumping the templates to csv file, this script will generate xls (Microsoft Excel) spreadsheet.
You need to have the node templates first before executing the tpl2xls.pl script, and also the templates has to be in a correct directory hierarchy. But don’t worry, I will also give you the script (gettemplates.pl) to download the templates in correct hierarchy.
The script needs John McNamara’s Spreadsheet-WriteExcel module, but it has been included inside the tpl2xls archive.
Please read terms of use before downloading the script(s)
Download
tpl2xls
tpl2xls-1.0.3
gettemplates
This script will download templates into tpl2xls-readable hierarchy. It reads a node list file like the one included in the package
gettemplates-1.0.2.pl.tar.gz
Are you using HP OVO (Openview Operation)/ITO/OMU (Operation Manager for Unix) ? So you must be understand how hard to write a templates document, especially if you have hundreds or thousands templates in your environment . I started a project to dump OVO templates into a csv file.
The script is in perl, so actually I can generate an Excel spreadsheet file directly but the script will need the spreadsheet perl module. To make it widely usable, i am going to make the script to only generates csv file. csv files can later be imported to nearly any spreadsheet editor.
Update: If you want to dump/export the OVO templates into a well-formatted MS-Excel file, read this post instead.
You can freely use, modify, and share this script, just keep the attribution intact.
Please read terms of use before downloading the script(s)
Version 1.1.0
- Unlike the initial build, this script includes downloading templates that has been assigned to nodes. Put node names inside the node list file separated by newlines. Now the script’s first argument is node list file instead of directory name.
- Backward compatibility (perl 5.0) increased.
- No longer using Getopt to grab options (to avoid dependency to getopt module)
- Some minor changes.
tpl2csv-1.1.0.pl
Version 1.0.0
The initial release. The script will dump all templates files inside the specified directory into csv file.
tpl2csv-1.0.0.pl