asked on

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

oldviking

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.

bbao

ASKER

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

Member_2_231077

Have you installed the storage planner add-on -

http://forums13.itrc.hp.com/service/forums/questionanswer.do?admit=109447627+1283875773259+28353475&threadId=1334455

bbao

ASKER

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

SOLUTION

oldviking

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bbao

ASKER

> 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

oldviking

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.

SOLUTION

oldviking

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bbao

ASKER

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

Member_2_231077

I presume you've installed msxml6.msi seperately just to be sure?

oldviking

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.

bbao

ASKER

> 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

bbao

ASKER

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

oldviking

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.

ASKER CERTIFIED SOLUTION

bbao

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

oldviking

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.