Re: Importing Data Into Visio 2003 Pages

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Are you starting with a 'clear page', or have the data properties and page/shape layouts already been created?

When you say '2007' isn't an option, do you mean Visio or Excel? Visio 2007 Professional is strongly recommended for the drawing creation and datalinking. They can be saved as v2003 for those that do not have access to v2007.

When you say "specific fields(text boxes)" are you referring to 'text boxes' or custom/data properties within shapes? The easiest implementation is when the custom/data property names are the same as the column/field names. Then it becomes read a row of data and apply it to the shape (examples in sdk on how to change a custom property).

Data (imho) does not do well when split between two locations, is your data repository the spreadsheets or the drawings? If the datasource is the drawing then consider using the the database wizard for export and import. It's relatively easy to implement.

"Have a visio document with hundreds of pages" is probably unrealistic. IME separate documents for each site based on template drawings worked better. On average we were changing site configs 2% to 3% per month. There are examples in the sdk on how to open/save drawings. By naming the drawings based on some form of site id and adding that as a field to your device(?) record you can then link to the correct drawing, or page if you insist on multipage documents.

This example uses MS Access for some of it's data needs, but it is pretty close to what you're about to get into and demonstrates reading from a source and exporting data.
http://msdn.microsoft.com/en-us/library/aa140253(office.10).aspx

al

"km7516" <km7516@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:031C03CA-51EB-4B0D-80B0-A035F96912DA@xxxxxxxxxxxxxxxx
Have a visio document with hundreds of pages that define a standard
configuration. Each page represents a site specific configuration diagram
with text boxes that should contain site specific configuration data. The
data is in Excel all version 2003 and this won't change going to 2007 isn't a
option.

What I'm trying to figure out is how to pull or push the data contained in
an excel work*** into the specific fields (text boxes). I've enable the
linkages to Excel and have had some initial success, however I don't
understand enough of Visio pull the data from excel using VBA.

I could do this by hand though the client has demonstrated a tendancy to
randomly change the data for sites which means having an automated approach
will same time in the long run.

What I want to do is open the visio document, open the excel
workbook/work*** (this is real easy since I code this all the time), parse
through the workbook looking for a change indicator, when a change is
indicated find the correct visio page, activate that page and then pull the
data from the excel spread*** and populate the correct locations in on the
page (actually replace place holder data).

I've searched the web for examples of code, downloaded the SDK for visio and
I'm just not having any luck. A generic answer though appreciated isn't
going to help.

Thank you in advance,

.

Quantcast