How to open/impprt a XML file using Visio 2007

hi Visio experts!

i have a XML file generated by the"Export to Visio" option from a HP Storage Essentials (HPSE) sever. it is a diagram showing the SAN topology discovered and calculated by the HPSE server.

i am using MS Visio 2007. i found no way to open or import the XML file.

could someone here give me a hand on this? many thanks in advance.

kind regards,
bbao
LVL 37
bbaoIT ConsultantAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
bbaoConnect With a Mentor IT ConsultantAuthor Commented:
i think i have found the answer: this version of Storage Planner is not compatible with Visio 2007.

HP Storage Essentials Build 6.0 Release Notes
http://www.dectrader.com/docs/set3/c01330503.pdf

"Do Not Install Storage Planner (Export to Visio) with Visio 2007 (IEV-24499)
Storage Planner (Export to Visio) is not compatible with Visio 2007. Do not install Storage Planner on the same machine with Visio 2007. If you do so, Visio 2007 will come up in Safe Mode only. Uninstall Storage Planner, and Visio 2007 will work properly in Normal Mode."
0
 
oldvikingCommented:
If you could post the file (or a subset of it) maybe I would recongize if this is a format that Visio can handle or not.

I don't know HPSE at all, so don't know what to expect of the output.
0
 
bbaoIT ConsultantAuthor Commented:
OK, the content of a sample XML file has been posted in the code area. thanks, bbao
<?xml version="1.0" encoding="UTF-8"?>
<TOPOLOGYLAYOUT>
  <DOMAIN>
    <NAME>DOMAIN</NAME>
    <FABRIC>
      <NAME>Unknown</NAME>
      <OBJECTID>com.appiq.toolkit.topology.impl.FabricImpl:-1</OBJECTID>
      <OID>null</OID>
      <DESCRIPTION>null</DESCRIPTION>
      <GENERICFROMSWITCHNAMESERVICE>false</GENERICFROMSWITCHNAMESERVICE>
      <USENULLDEVICEID>false</USENULLDEVICEID>
      <USENOMISSINGDEVICE>false</USENOMISSINGDEVICE>
      <PROVIDERNAME>Unknown</PROVIDERNAME>
      <APPIQCONTACTEDTIME>null</APPIQCONTACTEDTIME>
      <APPIQCREATIONTIME>null</APPIQCREATIONTIME>
      <WWN>null</WWN>
      <TOPOLOGYPROCESSED>false</TOPOLOGYPROCESSED>
      <ELEMENTTYPESTRING>com.appiq.dataModel.FabricData</ELEMENTTYPESTRING>
      <VENDOR>null</VENDOR>
      <REPLICATIONSANID>null</REPLICATIONSANID>
      <OPTIONALVALUES>{}</OPTIONALVALUES>
      <APPIQSTATUS>null</APPIQSTATUS>
      <VIRTUALFABRICID>null</VIRTUALFABRICID>
      <SANID>-3</SANID>
      <APPLICATION>
        <NAME>Management DB</NAME>
        <OBJECTID>com.appiq.toolkit.database.impl.DatabaseInstanceImpl:1034</OBJECTID>
        <OID>null</OID>
        <GENERICFROMSWITCHNAMESERVICE>false</GENERICFROMSWITCHNAMESERVICE>
        <USENOMISSINGDEVICE>false</USENOMISSINGDEVICE>
        <PROVIDERNAME>LOCAL</PROVIDERNAME>
        <MANAGEMENTHOST>null</MANAGEMENTHOST>
        <APPIQCONTACTEDTIME>2010-09-03</APPIQCONTACTEDTIME>
        <APPIQCREATIONTIME>2010-09-03</APPIQCREATIONTIME>
        <ASM>No</ASM>
        <CLUSTER>false</CLUSTER>
        <TARGETOPERATINGSYSTEM>Windows(R) Server 2003</TARGETOPERATINGSYSTEM>
        <SERIALNUMBER>null</SERIALNUMBER>
        <BUILDNUMBER>null</BUILDNUMBER>
        <PAGEDETAILSDATA>null</PAGEDETAILSDATA>
        <OPTIONALVALUES>{ASM=No}</OPTIONALVALUES>
        <PRODUCTNAME>ORACLE</PRODUCTNAME>
        <VERSION>10.2.0.4.0</VERSION>
        <DATABASETYPE>ORACLE</DATABASETYPE>
        <APPIQSTATUS>Contacted</APPIQSTATUS>
        <IDENTIFICATIONCODE>LOCAL</IDENTIFICATIONCODE>
        <DESCRIPTION>Oracle Database Instance</DESCRIPTION>
        <USENULLDEVICEID>false</USENULLDEVICEID>
        <HOSTID>1031</HOSTID>
        <TOPOLOGYPROCESSED>false</TOPOLOGYPROCESSED>
        <PORT>0</PORT>
        <ELEMENTTYPESTRING>com.appiq.applicationIQ.databaseIQ.dbDataModel.DBInstance</ELEMENTTYPESTRING>
        <VENDOR>Oracle Corporation</VENDOR>
      </APPLICATION>
      <HOST>
        <NAME>E2K3</NAME>
        <OBJECTID>com.appiq.toolkit.topology.impl.HostImpl:1033</OBJECTID>
        <OID>E2K3</OID>
        <MODEL>VMware Virtual Platform</MODEL>
        <GENERICFROMSWITCHNAMESERVICE>false</GENERICFROMSWITCHNAMESERVICE>
        <USENOMISSINGDEVICE>false</USENOMISSINGDEVICE>
        <TOTALPHYSICALMEMORY>511 MB</TOTALPHYSICALMEMORY>
        <PROVIDERNAME>E2K3</PROVIDERNAME>
        <APPIQCONTACTEDTIME>2010-09-03</APPIQCONTACTEDTIME>
        <SMALLVERSION>0</SMALLVERSION>
        <APPIQCREATIONTIME>2010-09-03</APPIQCREATIONTIME>
        <BUILDNUMBER>185</BUILDNUMBER>
        <CLUSTER>false</CLUSTER>
        <VIRTUALMACHINE>false</VIRTUALMACHINE>
        <WWN>null</WWN>
        <NUMBEROFPROCESSORS>1</NUMBEROFPROCESSORS>
        <SUPPORTOSDEVICENAMEMAPPING>true</SUPPORTOSDEVICENAMEMAPPING>
        <SERIALNUMBER>None</SERIALNUMBER>
        <OS_CAPTION>Microsoft(R) Windows(R) Server 2003, Standard Edition</OS_CAPTION>
        <OPTIONALVALUES>{MINORVERSION=3, OTHERIDENTIFYINGINFO=[10.16.26.152], IDENTIFYINGDESCRIPTIONS=[Intel(R) PRO/1000 MT Network Connection], FSRMSUPPORTFLAGS=0, SYNCHRONIZERMODE=parent, SMALLVERSION=0, DOMAIN=home.local, MAJORVERSION=6, BUILDNUMBER=185, SUPPORTSMULTITHREADEDFSRM=true}</OPTIONALVALUES>
        <SYNCHRONIZERMODE>parent</SYNCHRONIZERMODE>
        <DNSNAME>e2k3.home.local</DNSNAME>
        <DOMAIN>home.local</DOMAIN>
        <VERSION>5.2.3790</VERSION>
        <APPIQSTATUS>Contacted</APPIQSTATUS>
        <MINORVERSION>3</MINORVERSION>
        <DESCRIPTION>AT/AT COMPATIBLE</DESCRIPTION>
        <OTHERIDENTIFYINGINFO>[10.16.26.152]</OTHERIDENTIFYINGINFO>
        <IDENTIFYINGDESCRIPTIONS>[Intel(R) PRO/1000 MT Network Connection]</IDENTIFYINGDESCRIPTIONS>
        <USENULLDEVICEID>false</USENULLDEVICEID>
        <PRIMARYOWNERNAME>BBAO</PRIMARYOWNERNAME>
        <PRIMARYOWNERCONTACT>null</PRIMARYOWNERCONTACT>
        <OS>Windows(R) Server 2003</OS>
        <MAJORVERSION>6</MAJORVERSION>
        <SUPPORTSMULTITHREADEDFSRM>true</SUPPORTSMULTITHREADEDFSRM>
        <TOPOLOGYPROCESSED>false</TOPOLOGYPROCESSED>
        <FSRMSUPPORTFLAGS>0</FSRMSUPPORTFLAGS>
        <ELEMENTTYPESTRING>com.appiq.dataModel.HostData</ELEMENTTYPESTRING>
        <VENDOR>VMware, Inc.</VENDOR>
        <IPADDRESS>10.16.26.152</IPADDRESS>
        <VIRTUALSERVER>false</VIRTUALSERVER>
        <HOSTINFERENCERULEID>null</HOSTINFERENCERULEID>
      </HOST>
      <HOST>
        <NAME>GURU</NAME>
        <OBJECTID>com.appiq.toolkit.topology.impl.HostImpl:1037</OBJECTID>
        <OID>GURU</OID>
        <MODEL>VMware Virtual Platform</MODEL>
        <GENERICFROMSWITCHNAMESERVICE>false</GENERICFROMSWITCHNAMESERVICE>
        <USENOMISSINGDEVICE>false</USENOMISSINGDEVICE>
        <TOTALPHYSICALMEMORY>511 MB</TOTALPHYSICALMEMORY>
        <PROVIDERNAME>GURU</PROVIDERNAME>
        <APPIQCONTACTEDTIME>2010-09-03</APPIQCONTACTEDTIME>
        <SMALLVERSION>0</SMALLVERSION>
        <APPIQCREATIONTIME>2010-09-03</APPIQCREATIONTIME>
        <BUILDNUMBER>185</BUILDNUMBER>
        <CLUSTER>false</CLUSTER>
        <VIRTUALMACHINE>false</VIRTUALMACHINE>
        <WWN>null</WWN>
        <NUMBEROFPROCESSORS>1</NUMBEROFPROCESSORS>
        <SUPPORTOSDEVICENAMEMAPPING>true</SUPPORTOSDEVICENAMEMAPPING>
        <SERIALNUMBER>None</SERIALNUMBER>
        <OS_CAPTION>Microsoft(R) Windows(R) Server 2003, Standard Edition</OS_CAPTION>
        <OPTIONALVALUES>{MINORVERSION=3, OTHERIDENTIFYINGINFO=[10.16.26.133], IDENTIFYINGDESCRIPTIONS=[Intel(R) PRO/1000 MT Network Connection], FSRMSUPPORTFLAGS=0, SYNCHRONIZERMODE=parent, SMALLVERSION=0, DOMAIN=WORKGROUP, MAJORVERSION=6, SUPPORTSMULTITHREADEDFSRM=true, BUILDNUMBER=185}</OPTIONALVALUES>
        <SYNCHRONIZERMODE>parent</SYNCHRONIZERMODE>
        <DNSNAME>GURU</DNSNAME>
        <DOMAIN>WORKGROUP</DOMAIN>
        <VERSION>5.2.3790</VERSION>
        <APPIQSTATUS>Contacted</APPIQSTATUS>
        <MINORVERSION>3</MINORVERSION>
        <DESCRIPTION>AT/AT COMPATIBLE</DESCRIPTION>
        <OTHERIDENTIFYINGINFO>[10.16.26.133]</OTHERIDENTIFYINGINFO>
        <IDENTIFYINGDESCRIPTIONS>[Intel(R) PRO/1000 MT Network Connection]</IDENTIFYINGDESCRIPTIONS>
        <USENULLDEVICEID>false</USENULLDEVICEID>
        <PRIMARYOWNERNAME>BBAO</PRIMARYOWNERNAME>
        <PRIMARYOWNERCONTACT>null</PRIMARYOWNERCONTACT>
        <OS>Windows(R) Server 2003</OS>
        <MAJORVERSION>6</MAJORVERSION>
        <SUPPORTSMULTITHREADEDFSRM>true</SUPPORTSMULTITHREADEDFSRM>
        <TOPOLOGYPROCESSED>false</TOPOLOGYPROCESSED>
        <FSRMSUPPORTFLAGS>0</FSRMSUPPORTFLAGS>
        <ELEMENTTYPESTRING>com.appiq.dataModel.HostData</ELEMENTTYPESTRING>
        <VENDOR>VMware, Inc.</VENDOR>
        <IPADDRESS>10.16.26.133</IPADDRESS>
        <VIRTUALSERVER>false</VIRTUALSERVER>
        <HOSTINFERENCERULEID>null</HOSTINFERENCERULEID>
      </HOST>
      <HOST>
        <NAME>HPSE</NAME>
        <OBJECTID>com.appiq.toolkit.topology.impl.HostImpl:1031</OBJECTID>
        <OID>HPSE</OID>
        <MODEL>VMware Virtual Platform</MODEL>
        <GENERICFROMSWITCHNAMESERVICE>false</GENERICFROMSWITCHNAMESERVICE>
        <USENOMISSINGDEVICE>false</USENOMISSINGDEVICE>
        <TOTALPHYSICALMEMORY>3,071 MB</TOTALPHYSICALMEMORY>
        <PROVIDERNAME>HPSE</PROVIDERNAME>
        <APPIQCONTACTEDTIME>2010-09-03</APPIQCONTACTEDTIME>
        <SMALLVERSION>0</SMALLVERSION>
        <APPIQCREATIONTIME>2010-09-03</APPIQCREATIONTIME>
        <BUILDNUMBER>185</BUILDNUMBER>
        <CLUSTER>false</CLUSTER>
        <VIRTUALMACHINE>false</VIRTUALMACHINE>
        <WWN>null</WWN>
        <NUMBEROFPROCESSORS>1</NUMBEROFPROCESSORS>
        <SUPPORTOSDEVICENAMEMAPPING>true</SUPPORTOSDEVICENAMEMAPPING>
        <SERIALNUMBER>None</SERIALNUMBER>
        <OS_CAPTION>Microsoft(R) Windows(R) Server 2003, Standard Edition</OS_CAPTION>
        <OPTIONALVALUES>{MINORVERSION=3, OTHERIDENTIFYINGINFO=[10.16.26.136], IDENTIFYINGDESCRIPTIONS=[Intel(R) PRO/1000 MT Network Connection #2], FSRMSUPPORTFLAGS=0, SYNCHRONIZERMODE=parent, SMALLVERSION=0, DOMAIN=WORKGROUP, MAJORVERSION=6, BUILDNUMBER=185, SUPPORTSMULTITHREADEDFSRM=true}</OPTIONALVALUES>
        <SYNCHRONIZERMODE>parent</SYNCHRONIZERMODE>
        <DNSNAME>HPSE</DNSNAME>
        <DOMAIN>WORKGROUP</DOMAIN>
        <VERSION>5.2.3790</VERSION>
        <APPIQSTATUS>Contacted</APPIQSTATUS>
        <MINORVERSION>3</MINORVERSION>
        <DESCRIPTION>AT/AT COMPATIBLE</DESCRIPTION>
        <OTHERIDENTIFYINGINFO>[10.16.26.136]</OTHERIDENTIFYINGINFO>
        <IDENTIFYINGDESCRIPTIONS>[Intel(R) PRO/1000 MT Network Connection #2]</IDENTIFYINGDESCRIPTIONS>
        <USENULLDEVICEID>false</USENULLDEVICEID>
        <PRIMARYOWNERNAME>BBAO</PRIMARYOWNERNAME>
        <PRIMARYOWNERCONTACT>null</PRIMARYOWNERCONTACT>
        <OS>Windows(R) Server 2003</OS>
        <MAJORVERSION>6</MAJORVERSION>
        <SUPPORTSMULTITHREADEDFSRM>true</SUPPORTSMULTITHREADEDFSRM>
        <TOPOLOGYPROCESSED>false</TOPOLOGYPROCESSED>
        <FSRMSUPPORTFLAGS>0</FSRMSUPPORTFLAGS>
        <ELEMENTTYPESTRING>com.appiq.dataModel.HostData</ELEMENTTYPESTRING>
        <VENDOR>VMware, Inc.</VENDOR>
        <IPADDRESS>10.16.26.136</IPADDRESS>
        <VIRTUALSERVER>false</VIRTUALSERVER>
        <HOSTINFERENCERULEID>null</HOSTINFERENCERULEID>
      </HOST>
    </FABRIC>
    <FABRIC>
      <NAME>IP</NAME>
      <OBJECTID>com.appiq.toolkit.topology.impl.FabricImpl:-2</OBJECTID>
      <OID>null</OID>
      <DESCRIPTION>null</DESCRIPTION>
      <GENERICFROMSWITCHNAMESERVICE>false</GENERICFROMSWITCHNAMESERVICE>
      <USENULLDEVICEID>false</USENULLDEVICEID>
      <USENOMISSINGDEVICE>false</USENOMISSINGDEVICE>
      <PROVIDERNAME>IP</PROVIDERNAME>
      <APPIQCONTACTEDTIME>null</APPIQCONTACTEDTIME>
      <APPIQCREATIONTIME>null</APPIQCREATIONTIME>
      <WWN>null</WWN>
      <TOPOLOGYPROCESSED>false</TOPOLOGYPROCESSED>
      <ELEMENTTYPESTRING>com.appiq.dataModel.FabricData</ELEMENTTYPESTRING>
      <VENDOR>null</VENDOR>
      <REPLICATIONSANID>null</REPLICATIONSANID>
      <OPTIONALVALUES>{}</OPTIONALVALUES>
      <APPIQSTATUS>null</APPIQSTATUS>
      <VIRTUALFABRICID>null</VIRTUALFABRICID>
      <SANID>-3</SANID>
    </FABRIC>
  </DOMAIN>
</TOPOLOGYLAYOUT>

Open in new window

0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
bbaoIT ConsultantAuthor Commented:
YES, i do have Storage Planner 1.0 installed. please see the screenshot below.

FYI, i am using HPSE 6.3, and the Storage Planner is installed from its Utilities CD (\Windows\StoragePlanner.exe).

thanks,
bbao
Storage-Planner-installed.JPG
0
 
oldvikingConnect With a Mentor Commented:
This is definetly NOT a Visio specific format, so I can very well understand that Visio cannot handle this file. There may be add-ons to Visio that can generate shapes from this. If your application claims to produce output for Visio, I would look for documentation of how to achieve this. But this is probably application specific, and not included in Microsoft Visio.

Sorry that I couldn't be of more help, but if somebody out there know HPSE and knows what is needed to get the information into MS-Visio?
0
 
bbaoIT ConsultantAuthor Commented:
> There may be add-ons to Visio that can generate shapes from this.

how can i check if the add-on is existing on my Visio 2007?

after installing the Report Planner, I see nothing different from the Visio 2007 interface. however, i do notice that there is a Shape file in Storage Planner's folder, as shown below. i can open this VSS file from Visio.

the folder also has some DLL files, not sure how these executables work with Visio 2007. probably they can understand the XML file??
Storage-Planner-Files.JPG
0
 
oldvikingCommented:
Yes, this could be a Visio plug-in or related SW. At least the presence of the SPStencils.vss may point in this direction. But I'm missing a .manifest file which is used by Visio plugins.

To check for plugins in Visio 2007, open Visio,  On the "tools" menu select "Trust Center",
and in the left pane then select "add-ins". There you will see what Add-ins are enabled and possibly also disabled.
0
 
oldvikingConnect With a Mentor Commented:
After looking a bit more, I found the reference to Visio in this document: http://h18000.www1.hp.com/products/quickspecs/13343_div/13343_div.PDF

It says "Visio must be installed before Storage Planner
Microsoft XML Parser required (included with
Storage Planner)"

Not much, but at least an indication that this should work. There are different kind of Plug-ins / Add-ins for Visio, so far I only know COM Add-ins. Maybe the other kinds of plugins do not require a .manifest file. So please check your add-ins list in Visio first.
0
 
bbaoIT ConsultantAuthor Commented:
thanks for your info oldviking.

i checked the Trust Center and found nothing related to the Report Planner, whatever it is enabled or disabled. please see the screenshot below.

and YES, Visio was installed before Report Planner. I didn't see any file having ".manifest" extension in the add-on's folder.
Visio-2007-Trust-Center.JPG
0
 
andyalderCommented:
I presume you've installed msxml6.msi seperately just to be sure?
0
 
oldvikingCommented:
Somehow I suspect that the installation of Storage Planner did not complete properly. I would have tried to de-install Storage Planner, and then install it again, and check for error messages or installer logs. (even though I don't know where these would be...)

The procedure for registering a plug-in in Visio is quite complicated, and cannot be done manually as far as I know.
0
 
bbaoIT ConsultantAuthor Commented:
> I presume you've installed msxml6.msi separately just to be sure?

YES, MSXML 6.0 Parser is installed, as well as MSXML 4.0 SP2, as shown below.

> I would have tried to de-install Storage Planner, and then install it again

i will do it tomorrow and keep you updated.

thanks,
bbao
MSXML-6.0-Parser-installed.JPG
0
 
bbaoIT ConsultantAuthor Commented:
just an update: uninstalling and reinstalling the Storage Planner doesn't make any difference on my computer, I still can't see it from Visio 2007 add-on manager.

thanks,
bbao
0
 
oldvikingCommented:
Mysterious. I guess this Software is not publically available, and I don't have it - so I can't try it myself. If we just could reach somebody who knows Storage Planner. Could you expand the question to more groups in the Storage Area or maybe andyadler has furhter tips, I|m afraid I am at my end.
0
 
oldvikingCommented:
This explains why it looked so strange to me; It simply written for older versions of Visio. Sorry I couldn't solve this problem fully. No objections to closing this question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.