TOPSpro Export Wizard Howto

1
TOPSpro Export Wizard How-to

• Prepared by Ken Zutter for
• Nevadas AEFLA funded programs

2
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.

3
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.

4
Be Prepared

• Always BACKUP your data BEFORE exporting.
• It is always better to be safe than sorry!

5
Step One

• Open TOPS and click Wizards Import/Export

6
Step Two
Clickgt Next

• Click gt Export this systems data for use on
  another system

7
Step Three
Clickgt Next

• For submission of quarterly data,
• Click gt Export tables for Data Submission (on
  disk)

8
Step Four
Clickgt Next

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

9
Step Five
Clickgt Next

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

10
Step Six
Check gt Activity Dates
Clickgt Next

• For quarterly data submission, the dates should
  correspond to the current fiscal year.
• Set Site, Program, Class and Student to
  All

11
Step Six, cont.
Clickgt OK

• 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.

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

• Click gt Save data on disk...
• Even if you going to be sending the file by
  email.

This step continues on next slide ?
13
Step Seven, cont.

• Click gt the Hard Drive icon

14
Step Seven, cont.
In this example, I am saving the export file onto
my Desktop.
Clickgt Save

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

15
Step Seven, cont.
Now you can Clickgt Next
16
Step Eight
Clickgt Finish

• Uncheck both of these boxes unless told otherwise.

17
Step Nine
Clickgt OK

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

18
Step Ten

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

19
Step Eleven

• If this export is for data submission, use your
  email program to attach the encrypted file and
  sent it to kzutter_at_doe.nv.gov

20
Were 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