News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

auto generate multiple diagrams from a single template linked to excel data

Started by splicer72, April 12, 2012, 02:35:20 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

splicer72

Hi
I have a Visio template that has around 20 variables in text boxes. The variable data is held in excel rows each with an unique identifier. I need to create 20 diagrams using the excel data that would create and save 20 seperate visio files. This is basically a mail merge between excel and visio but i cannot seem to find out if it is actually possible. I tried using the data link process but this seems to only allow me to add data to the shapes themselves whereas i want to fill in the text boxes and have the file saved individually based on the unique identifier.

I have attached the template here and the text in red corresponds to the variable cells in excel that i want to be pulled in

Have looked long and hard to find a solution so any help will be greatly appreciated

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 134 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1047KB.
Tokens: post-login.
Cache hits: 13: 0.00174s for 26,767 bytes (show)
Cache misses: 2: (show)
Queries used: 16.

[Show Queries]