FS95 Survey Materials - Importing Examples

Federal Support Survey

FSS Data Entry Program Instructions

Example of How to Import Data

You may have several offices provide you with individual submissions; the import function will enable you to combine or aggregate all of these individual submissions into your agency's single submission.

To load Instructions & Specifications-formatted data into the database, you must first exit FSS. At the C:\FSS95> prompt; type FSSIO, and then press the key. (If you select the Imports option from the main screen in FSS, the same directions will be provided). The import/export program's main screen will appear:

Screen 15

Press to select the Import Data option. The "File to Import?" screen will appear, as shown on the next page. On this screen, you can specify the drive, path, and name of the file to be imported. When the screen first appears, it will show all files in your current path (C:\FSS95>) which have a file name extension of ".txt." The file can be named anything you want (as long as it has a legitimate DOS name and extension). To change the drive, path, and file name, simply <Tab> to each of these fields on the screen and enter the correct entry. In our example, the file which is to be imported is called "part1.f95" and resides on the current path (C:\FSS95):

[Screen 16] Screen 16

After the file to be imported has been specified, begin the import function by selecting the OK option. If you decide not to import at this time, you can cancel this function by selecting Cancel. When OK is selected, the "FSS Import" screen will appear:

[Screen 17] Screen 17

This screen will provide you with two options:

Log every card as entered (Audit trail) — a file with a summary of each record loaded into the database will be created; you can print/review this file later.

Only log errors — a file with a summary of only those records which did not pass all of the edit checks will be created; you can print/review this file later. This must be reviewed, since some of these records (depending on the type of error) will NOT be loaded into the database.

NOTE: If multiple imports are done (i.e., to combine data from several offices) all data will be ADDED to what is already in the database!! If you import the same file more than once, you will be double-counting your obligations - BE CAREFUL!

The files created by the Import option will have names that are the same as the file which was imported but are given extensions of ".err" and ".skp" — these files provide the errors encountered and any institutions which were not imported (skipped) because of severe errors. To print these files, exit the FSS PC survey disk program and return to DOS. Type "copy filename LPT1" where filename is either the errors file (filename.err) or the skipped file (filename.skp) and LPT1 is the printer port you use (LPT1 is the most common printer port).

Review the error summary and list of skipped institutions created during the import function. You can manually correct any errors or enter skipped institutions on an institution-by-institution basis. See the instructions for manually entering data.