Solved

Visio diagram to document database download, upload, excel file ftp

Posted on 2013-11-07
2
1,846 Views
Last Modified: 2013-11-12
Not that experienced using Visio

Looking to create a Visio document  that depicts a process that does the following

1.  Retrieve data from tables in several data bases  (via a sql view)

2.  Insert the retrieved data into a different database

3. create an Excel file extract

4. Ftp the Excel file to an ftp server


I know there is a database shape and an Excel spreadsheet shape but struggling with the best combination of other shapes to document this.  Doesn't seem like an uncommon process

I have spent some time trying to google search for examples but so far haven't found anything

Anybody have a sample I could look at for ideas?
0
Comment
Question by:johnnyg123
2 Comments
 
LVL 30

Accepted Solution

by:
Scott Helmers earned 500 total points
ID: 39635180
The simplest solution is probably just to draw a flowchart. Start with the Basic Flowchart template, which is located in the Flowchart template category. Then use the Process shape for the steps and the External Data shape to represent the data stores. Not fancy but it gets the message across. Something like this:sample
0
 

Author Closing Comment

by:johnnyg123
ID: 39642368
Great idea ...I think I was trying to make it harder than it was
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My experience with Windows 10 over a one year period and suggestions for smooth operation
Outlook Free & Paid Tools
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question