The Application Importprogram will import applications from a text file into HR. The import file can contain data delimited (separated) by either commas or tabs. The file expects the first field to be the employee number. The subsequent fields can be any number of posting numbers that the employee has applied for.
12345,c0102-6789,c0102-5432,c0738-7965,c0203-6671,c0203-8112,C0203-5443
67012,c0102-1234,,,,,
In the sample text file above, there are applications for two employees: 12345 and 67012. Employee 13245 has applied for postings C0102-6789,C0102-5432,C0738-7965,C0203-6671,C0203-8112 and C0203-5443. Employee 67012 has applied for posting C0102-1234.
This program will create application records by filling in the employee number and posting number in HR. All other fields will be left blank.
As the program reads through the data contained in the import file, it will ensure data integrity. This is to say that it will not create applications with invalid data. If the application already exists, or the employee or posting numbers are invalid, the application(s) will not be created. The report will indicate if any problems were detected.
File Location (DISK:[DIR]FILE.SCV)
Enter the location of the text file you want to import. You must enter a valid VMS directory path followed by the filename of the text file. Your file location may look something like:
DKA100:[USERS.SHAWN]CUPE_APPS.CSV
The file must exist on your server (as opposed to your own PC Client). You will have to transfer the file from your PC to the server using a FTP program such as FTP Pro. Your technology department should be able to help you accomplish this.
Field Delimiter
Enter 'C' if your import file contains comma-delimited fields.
Enter 'T' if your file contains tab-delimited fields.
Preliminary/Final
Enter 'P' to run this process in preliminary or 'F' to run it in final mode. A preliminary run displays the contents of import file without updating the HR application data file. A final run will create the applications contained in the import file.