Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1896
  • Last Modified:

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
0
bbao
Asked:
bbao
  • 7
  • 7
  • 2
3 Solutions
 
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
 
Handy HolderSaggar makers bottom knockerCommented:
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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
 
oldvikingCommented:
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
 
oldvikingCommented:
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
 
Handy HolderSaggar makers bottom knockerCommented:
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
 
bbaoIT 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:
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 7
  • 7
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now