converting arrayconfig.xml to Excel

Question

Hi

been trying to get this ArrayConfigToXLS.js from NST to convert an arrayconfig.xml file to a single XLS file, the way the good old CAP2CCPF used to do. However I only seem to obtain something like 27 HTML files, each one containing only a single part of the XLS i'm expecting to get.

While executing the JS script, I see Excel being started in Windows Task Manager. After the script ends, Excel stays loaded but remains invisble.

There is NO XLS file being created at all.

Is this script supposed to create a single XLS file? if so, what am I doing wrong?

my syntax:

create the arrayconfig.xml file: (using navisecCLI v 6.29...)

naviseccli -user -password -scope 0 -h arrayconfig -capture -output arrayconfig.xml

export to excel:

C:\capData\CKM00090800xxx>cscript c:\emc\repository\ArrayConfigToXLS.js arrayconfig.xml

this generates the following files:

Analysis.html
Disk Enclosure Layout.html
Drive Modules.html
Host HA Report.html
Hosts.html
Initiators.html
Introduction.html
Issues.html
I_O Module Information.html
LUN Mappings.html
LUNs.html
metaLUN Information.html
MirrorView_Asynchronous.html
MirrorView_Synchronous.html
RAID Groups.html
Registration Details.html
Replaceable Units.html
SAN Copy.html
SnapView clones.html
SnapView sessions and snapshots.html
SnapView.html
Software Packages.html
SPs and Ports.html
Storage Groups.html
Switches Information.html
Virtual Machine LUN Mappings.html
Virtual Machines.html
Virtual Provisioning.html
XML File Information.html

Is there an easy way to get all these HTML files into one XLS, each file on a separate worksheet of the same workbook?

Any help would be much appreciated!

regards

Luc

Jen_LeClair · Answer

The html file are temporary files that are being generated and deleted.

The xls file is created at the end of the processing with information presented in tabbed view.

Please provide.

a. version of the ArrayConfigToXLS.js.

b. the arrayconfig.xml you are having the issue with.

LucD1 · Answer

Hi Jen

Thanks for your reply.

The ArrayConfigToXLS.js file I used came with NST v 6.29.0.6.28-6. I can't find a version number in it.

See attached arrayconfig.zip.

Hope you can help.

Regards

Luc Degelin

LucD1 · Answer

Hi Jen,

The ArrayConfigToXLS.js file I used came with NST v 6.29.0.6.28-6. I can't find a version number in it.

I received an error after I mailed the arrayconfig file to your reply. is there any other way I can send you the file?

Thanks!

Luc

kelleg · Answer

Luc, Have you tried using the arrayconfig command with the -format switch? naviseccli -h xxx.xxx.xxx.xxx arrayconfig -capture -output test.csv -format csv glen

LucD1 · Answer

Glen,

I tried with the CSV format as well. The CSV is created successfully, but importing that one in Excel still doens't give the same result as CAP does.

CSV is not usable with ArrayConfigToXLS.js

Thx

Luc

kelleg · Answer

Just an FYI - CAP will be discontinued in the future glen

TonyAlmeida1 · Answer

Why discontinu CAP ? that's the best tool ever I use to create reports for customers !

LucD1 · Answer

Issue is solved!

The problem consists of Excel 2007 using Excel 97-2003 file format as standard in stead of XLSX.

If you encounter this error, use the following steps:

Open Exel 2007, click the Office button, open Excel Options. with the Save applet you will find the option "Save files in this format", there make sure you select "Excel workbook *.XLSX".

Thanks very much to the EMC staff who assisted with fixing this!!

Luc

RRR · Answer

In Navisphere you can do the same with the 'generate report' button on the left (under 'reporting'). I must admit, that I liked CAP2 better, but hey: the functionality isn't gone !

TonyAlmeida1 · Answer

I just tried but, didn't work for me. Besides the save format was already on *XLSX* ...

ceizner · Answer

Converting a CLARiiON configuration XML file to Excel VERSION 6  http://one.emc.com/clearspace/docs/DOC-17974/diff?secondVersionNumber=6 Updated for FLARE 30 as of Sept 2nd, 2010 This is a command -line utility which uses a script to convert an XML file to Excel format.  It uses the Windows script host executable 'c:\WINNT\system32\cscript.exe'. This utility is included in the download of the Navisphere Service Taskbar (NST) starting with R29 and the Unisphere Service Manager starting with FLARE 30. Capture 'CLARiiON Configuration XML' from storage system. This utility does NOT work on the SP Collect zip file. Option 1: Starting R28, every SPCollect includes 'SP_arrayconfig.xml'. The file can be found in the *_sus.zip file within SPCollect. Option 2: Starting R28, use NaviSecCLI 'arrayconfig –capture' command Naviseccli –h xx.xx.xx.xx arrayconfig –capture –output ArrayConfig.xml Usage: Open a command prompt (DOS      window) Change the current drive /      directory to the location of the CLARiiON configuration xml file you wish      to convert Enter the following command      cscript \ArrayConfigToXLS.js          where is the name of the CLARiiON configuration xml file to be converted to an Excel file. Output: The script creates an Excel output file in the current directory, with the same name as the input file.

CLARiiON

converting arrayconfig.xml to Excel

Was this post helpful?