Main Restorations Software Audio/Jukebox/MP3 Everything Else Buy/Sell/Trade
Project Announcements Monitor/Video GroovyMAME Merit/JVL Touchscreen Meet Up Retail Vendors
Driving & Racing Woodworking Software Support Forums Consoles Project Arcade Reviews
Automated Projects Artwork Frontend Support Forums Pinball Forum Discussion Old Boards
Raspberry Pi & Dev Board controls.dat Linux Miscellaneous Arcade Wiki Discussion Old Archives
Lightguns Arcade1Up Try the site in https mode Site News

Unread posts | New Replies | Recent posts | Rules | Chatroom | Wiki | File Repository | RSS | Submit news

  

Author Topic: Anyone know how to use Visio with an external data source?  (Read 973 times)

0 Members and 1 Guest are viewing this topic.

shmokes

  • Just think of all the suffering in this world that could have been avoided had I just been a little better informed. :)
  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 10397
  • Last login:September 24, 2016, 06:50:42 pm
  • Don't tread on me.
    • Jake Moses
Anyone know how to use Visio with an external data source?
« on: February 21, 2008, 04:42:19 pm »
I have to make extensive flow charts for one of my classes.  I've found that Visio will work in conjunction with Excel if I've input my data in a spreadsheet, but it doesn't seem to work like what seems like the obvious way it should work, so I wonder if I'm doing something wrong.

Basically I've got a long list of numbered items (Excel spreadsheet) that I drag onto my flowchart, where they are assigned a shape with a label indicating the item number.  The problem I'm having is that if I realize that my list needs a piece of data inserted into it, I have to fix all the numbers in the ID # column of the spread sheet, and every item below the item I've just inserted gets a new number, i.e., 56 becomes 57, 57 becomes 58, etc.

I can then go into Visio, where my data is showing at the bottom of the screen and tell it to "Refresh Data".  The changes will be reflected in the list, but not on the chart.  So if I've already put 57 on the chart, it will not change to 58.  It will still say 57, meaning that the shape is now referring to the wrong data entry. 

What's the purpose of being able to refresh the data if you still have to basically start your chart over from scratch?  It makes no sense.  That's why I figure that I'm missing something.  Anybody here know Visio well?
Check out my website for in-depth reviews of children's books, games, and educational apps for the iPad:

Best Kid iPad Apps

Felsir

  • Wiki Master
  • Trade Count: (0)
  • Full Member
  • *****
  • Offline Offline
  • Posts: 875
  • Last login:September 28, 2022, 01:21:47 pm
  • Creating cab artwork
    • Felsir's World
Re: Anyone know how to use Visio with an external data source?
« Reply #1 on: February 22, 2008, 06:30:14 am »
What you want to do is change the "refresh settings". Rightclick on the datasheet in Visio: a context menu should popup. Now, I have the dutch 2007 version so I'm not sure what the english language labels are like but my guess is: "refresh properties..." it's the item right under "refresh" in this context menu. A properties dialog should pop-up; on the righthand side select the bottom radiobutton. It should say something like "use excel row order to identify records".
The radiobuttons let you switch between using a custom identifier such as employee-number or the excel row numbers. In your case you seem to need the latter option.

shmokes

  • Just think of all the suffering in this world that could have been avoided had I just been a little better informed. :)
  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 10397
  • Last login:September 24, 2016, 06:50:42 pm
  • Don't tread on me.
    • Jake Moses
Re: Anyone know how to use Visio with an external data source?
« Reply #2 on: February 22, 2008, 08:51:10 am »
Thanks.  I'll give that a shot.
Check out my website for in-depth reviews of children's books, games, and educational apps for the iPad:

Best Kid iPad Apps

Felsir

  • Wiki Master
  • Trade Count: (0)
  • Full Member
  • *****
  • Offline Offline
  • Posts: 875
  • Last login:September 28, 2022, 01:21:47 pm
  • Creating cab artwork
    • Felsir's World
Re: Anyone know how to use Visio with an external data source?
« Reply #3 on: February 27, 2008, 06:25:32 am »
Just curious: did it work?