Topspro export wizard how to
Download
1 / 20

TOPSpro - PowerPoint PPT Presentation


  • 311 Views
  • Updated On :

TOPSpro Export Wizard How-to. Prepared by Ken Zutter for Nevada’s AEFLA funded programs. Introduction . Exporting is the process of sending data from your local database to a database in another location.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'TOPSpro' - Renfred


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Topspro export wizard how to l.jpg

TOPSpro Export Wizard How-to

Prepared by Ken Zutter for

Nevada’s AEFLA funded programs

State of Nevada


Introduction l.jpg
Introduction

  • Exporting is the process of sending data from your local database to a database in another location.

  • This presentation will illustrate ‘How-to’ export data from your TOPSpro database by breaking the process into a series of easy to follow steps.

State of Nevada


Vocabulary l.jpg
Vocabulary

  • export

    1. To send or transport (a commodity, for example) abroad, especially for trade or sale.

    2. To send (data) from one program to another.

State of Nevada


Be prepared l.jpg
Be Prepared

  • Always BACKUP your data BEFORE exporting.

    • It is always better to be safe than sorry!

State of Nevada


Step one l.jpg
Step One

Open TOPS and click Wizards | Import/Export

State of Nevada


Step two l.jpg
Step Two

Click > Export this system’s data for use on another system

Click> Next

State of Nevada


Step three l.jpg
Step Three

For submission of quarterly data,

Click > Export tables for Data Submission (on disk)

Click> Next

State of Nevada


Step four l.jpg
Step Four

The default setting is to export student data only.Accept this setting unless told otherwise.

Click> Next

State of Nevada


Step five l.jpg
Step Five

The default is to export all tables and include incomplete records, accept this setting unless told otherwise.

Click> Next

State of Nevada


Step six l.jpg
Step Six

Check > ‘Activity Dates’

For quarterly data submission, the dates should correspond to the current fiscal year.

Set ‘Site’, ‘Program’, ‘Class’ and ‘Student’ to ‘All’

Click> Next

State of Nevada


Step six cont l.jpg
Step Six, cont.

You may get this message if any of the tables have no records. While it is common for ‘Personnel’ and “Class Status” records, it should not happen for other record types.

Click> OK

State of Nevada


Step seven l.jpg
Step Seven

Click > Save data on disk...

Even if you going to be sending the file by email.

The Send data as email option looks tempting, but it does not work for us. Do not use it.

This step continues on next slide ►

State of Nevada


Step seven cont l.jpg
Step Seven, cont.

Click > the Hard Drive icon

State of Nevada


Step seven cont14 l.jpg
Step Seven, cont.

In this example, I am saving the export file onto my Desktop.

Navigate to an appropriate folder, such as ‘My Documents’ or the ‘Desktop’ before clicking the Save button.

Click> Save

State of Nevada


Step seven cont15 l.jpg
Step Seven, cont.

Now you can Click> Next

State of Nevada


Step eight l.jpg
Step Eight

Uncheck both of these boxes unless told otherwise.

Click> Finish

State of Nevada


Step nine l.jpg
Step Nine

Good! We have successfully created and saved an export file.

Click> OK

State of Nevada


Step ten l.jpg
Step Ten

Be sure to encrypt the file before sending it in an email.

State of Nevada


Step eleven l.jpg
Step Eleven

If this export is for data submission, use your email program to attach the encrypted file and sent it to: [email protected]

State of Nevada


We re done l.jpg
We’re Done!

Now you know how to use the

TOPSpro Export Wizard.

If you have any questions or comments, please call the

Nevada State ABE MIS Administrator

at 775-687-7291

State of Nevada


ad