TOPSpro Export Wizard How-to - PowerPoint PPT Presentation

Topspro export wizard how to l.jpg
Download
1 / 20

  • 302 Views
  • Updated On :
  • Presentation posted in: Pets / Animals

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.

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

Download Presentation

TOPSpro Export Wizard How-to

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: kzutter@doe.nv.gov

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


  • Login