Solved

How to open/impprt a XML file using Visio 2007

Posted on 2010-09-07
16
1,805 Views
Last Modified: 2013-11-14
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
Comment
Question by:Bing CISM / CISSP
  • 7
  • 7
  • 2
16 Comments
 
LVL 4

Expert Comment

by:oldviking
ID: 33618203
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
 
LVL 37

Author Comment

by:Bing CISM / CISSP
ID: 33618745
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
 
LVL 55

Expert Comment

by:andyalder
ID: 33619185
0
 
LVL 37

Author Comment

by:Bing CISM / CISSP
ID: 33619260
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
 
LVL 4

Assisted Solution

by:oldviking
oldviking earned 500 total points
ID: 33621642
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
 
LVL 37

Author Comment

by:Bing CISM / CISSP
ID: 33623125
> 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
 
LVL 4

Expert Comment

by:oldviking
ID: 33624403
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
 
LVL 4

Assisted Solution

by:oldviking
oldviking earned 500 total points
ID: 33624453
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
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 37

Author Comment

by:Bing CISM / CISSP
ID: 33624765
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
 
LVL 55

Expert Comment

by:andyalder
ID: 33625254
I presume you've installed msxml6.msi seperately just to be sure?
0
 
LVL 4

Expert Comment

by:oldviking
ID: 33625531
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
 
LVL 37

Author Comment

by:Bing CISM / CISSP
ID: 33626521
> 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
 
LVL 37

Author Comment

by:Bing CISM / CISSP
ID: 33812304
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
 
LVL 4

Expert Comment

by:oldviking
ID: 33813286
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
 
LVL 37

Accepted Solution

by:
Bing CISM / CISSP earned 0 total points
ID: 33816261
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
 
LVL 4

Expert Comment

by:oldviking
ID: 33818261
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now