Importing third party XML data into MS Visio
Posted on 2012-04-01
I type text into shapes in Visio drawings derived from Templates. Now I want to add automation, by importing text automatically from various third party XMLs. Can I and ought I import the data fields of the 3rd party into MSOffice XML derived from my drawing template? I use Visio 2010 Premium.
This would involve a learning curve on my part. I am aware that third party XML should be established as well formed, and they will not comply with the MS schema.
Can you recommend procedures/applications whereby I can:
- Select, for each relevant data field in Visio MSOffice XML, which data field should be imported from the third party XML?
- Make a sensible shell in vba to automate the import process, so that a series of third party XML specifications of the same structure but different content can be imported into different instances of a Visio template.
If available, on the grounds of cost, freeware / vba code would be an attractive first step, to gain a working model in the first instance. However, a commercial application would be of interest if it can be used 'out of the box'.