The LOCATION FTE IMPORT function allows you to import Location FTE Allocations from a tab delimited text file. This file would typically be created from a spreadsheet application such as Excel. The function expects that the text file will contain at least three columns: location number, FTE allocation code and the allocation amount. These 3 pieces of information are needed to be able to update the FTE Allocation file. There can be additional columns, but at least above three are required. The function will prompt for the location of the text file and for the FTE type for which the data is being imported (Teaching, Non-Teaching or Both). You may also purge the existing records so that your data can be completely refreshed. Finally, this function has a preliminary/final prompt, which allows you to perform the import function with or without actually updating HR's databases.
Year
Enter a valid four digit year for which you want to import the FTE allocation amounts.
File Location (DISK:[DIR]FILE.TXT)
Enter a valid VMS file location of the text file to import. Your file location may look something like:
DKA100:[USERS.SHAWN]FTE_BUDGETS.TXT
The file must exist on your VMS server (as opposed to your own PC Client). You will have to transfer your file from your PC to the server using a FTP program such as FTP Pro. You technology department should be able to help you accomplish this.
FTE Types To Import
Enter 'T' to import only teaching allocation amounts for the specified year.
Enter 'N' to import only non-teaching amounts for the specified year.
Enter 'B' to import both teaching and non-teaching allocation amounts for the specified year.
Purge Existing Data
Enter 'Y' to purge FTE Allocations that currently exist on your system for the specified year. This allows you to refresh your HR data with only the information that exists in your import file.
Enter 'N' if you do not want to purge out existing HR allocation amounts for the specified year.
FTE Types To Purge
Enter 'T' to purge out just teaching allocation amounts.
Enter 'N' to purge out non-teaching allocations.
Enter 'B' to purge out both teaching and non-teaching allocations for the year specified.
Location Column Number
Enter the column number that contains the location code in your import file.
FTE Code Column Number
Enter the column number that contains the FTE code in your import file.
Amount Column Number
Enter the column number that contains the FTE amount in your import file.
Preliminary/Final
Enter 'P' to run this process in preliminary mode. A preliminary run will display the contents of import file without updating the HR allocation data file. It will also show you the results of the purge without actually purging any information.
Enter 'F' to run this function in Final mode. A final run will purge the old data (if requested) and import the new data.
No client customizations for this report