Help

Start a discussion
UNSOLVED

LucD1

updated

17 years ago

L

LucD1

5 Posts

0

7209

March 8th, 2010 04:00

converting arrayconfig.xml to Excel

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

  • J

    Jen_LeClair

    111 Posts

    1264

    0

    Posted March 8th, 2010 06:00

    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.

  • L

    LucD1

    5 Posts

    1266

    0

    Posted March 8th, 2010 08:00

    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

  • L

    LucD1

    5 Posts

    1266

    0

    Posted March 8th, 2010 08:00

    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

  • K

    kelleg

    6 Operator

    •

    4537 Posts

    1266

    0

    Posted March 8th, 2010 14:00

    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

  • L

    LucD1

    5 Posts

    1266

    0

    Posted March 9th, 2010 00:00

    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

  • K

    kelleg

    6 Operator

    •

    4537 Posts

    1266

    0

    Posted March 9th, 2010 08:00

    Just an FYI - CAP will be discontinued in the future

    glen

  • T

    TonyAlmeida1

    2 Posts

    1266

    0

    Posted March 16th, 2010 03:00

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

  • L

    LucD1

    5 Posts

    1266

    0

    Posted March 16th, 2010 05:00

    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

  • R

    RRR

    6 Operator

    •

    5739 Posts

    1266

    0

    Posted March 16th, 2010 05:00

    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 !

  • T

    TonyAlmeida1

    2 Posts

    287

    0

    Posted March 16th, 2010 08:00

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

Dell Support Resources

Latest Solutions

View More