UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Mapping Out Server/file Dependencies, Windows 7    
 
   
JonSmith
post Feb 10 2017, 11:48 AM
Post#1



Posts: 3,075
Joined: 19-October 10



Hey guys,

At the organisation I work at we have lots of different systems that all do stuff and generate outputs, these outputs can then be used as inputs for other systems and the spiderweb between stuff goes on.
Sometimes the inputs are received from an external vendor and will be manually saved to a server location.

Its all rather complex and I would like to start mapping out the tools that I am responsible for, what inputs they use, what outputs they make (which then get used as inputs for other files).

I would love to be able to display this graphically so I can see the links between systems and files but maybe thats a pipe dream as I also need it to be data driven. I want to use the data I record as the basis for creating and refreshing test environments. If I change a tool I can check to see what inputs it needs and grab them from the production environment aswell as see what other systems may be affected downstream.

So I can design the data structure in Access. Does anyone have any ideas of something that can display the information visually Viso style? (Is Visio an option)
Go to the top of the page
 
jleach
post Feb 10 2017, 12:22 PM
Post#2


UtterAccess Editor
Posts: 9,690
Joined: 7-December 09
From: Staten Island, NY, USA


Hi Jon - higher editions of Visio can be data-driven like this. I don't have much experience in implementing that type of stuff, but I know it can do it.

Here's a few links based on a quick search:

https://support.office.com/en-us/article/Ad...US&fromAR=1

https://www.microsoftpressstore.com/article....aspx?p=2469147

This one seems to be a bit more practical in terms of how to actually work with data:
http://boxesandarrows.com/automating-diagrams-with-visio/

Maybe it'll give you a start.

Cheers,

--------------------
Go to the top of the page
 
JonSmith
post Feb 10 2017, 01:15 PM
Post#3



Posts: 3,075
Joined: 19-October 10



Thanks Jack. I did do some google around about Visio but it didn't seem to be as flexible as I wanted. It basically was just if I change a value here it changes there, I still need to draw everything which kind of loses the benefit.

I'll check out your link though.
Go to the top of the page
 
jleach
post Feb 10 2017, 02:31 PM
Post#4


UtterAccess Editor
Posts: 9,690
Joined: 7-December 09
From: Staten Island, NY, USA


Have you looked into UML?

There's some tools that can convert text formats to UML automatically... if you can render your data in an appropriate text format...

http://modeling-languages.com/uml-tools/#textual

http://plantuml.com/

--------------------
Go to the top of the page
 
Scott_Hall
post Mar 3 2017, 09:20 AM
Post#5



Posts: 326
Joined: 24-July 13
From: Vancouver, WA


I did something like this once. Quick and dirty, I added icons and lines to a large form and then selectively toggled visibility. This worked okay, but you do need to have a fully defined list of inputs and outputs. I just didn't want to spend more time learning UML when I'm still working in VBA/XML/VB.Net.

--------------------
Running Access 2010 on Windows 10
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    25th May 2017 - 01:48 AM