?
Solved

How to open/impprt a XML file using Visio 2007

Posted on 2010-09-07
16
Medium Priority
?
1,853 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:bbao
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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:bbao
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 56

Expert Comment

by:andyalder
ID: 33619185
0
Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

 
LVL 37

Author Comment

by:bbao
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 2000 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:bbao
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 2000 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
 
LVL 37

Author Comment

by:bbao
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 56

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:bbao
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:bbao
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:
bbao 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

Independent Software Vendors: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Many businesses neglect disaster recovery and treat it as an after-thought. I can tell you first hand that data will be lost, hard drives die, servers will be hacked, and careless (or malicious) employees can ruin your data.
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…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

771 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