The import file must be a comma delimited (.csv) file. An excel file can easily be saved as a comma delimited (.csv) file by selecting the File >> Save As option and changing the Save As Type field to “CSV (Comma Delimited) (*.csv)”. Each column heading needed for the import file is listed below. The import file must follow the exact order as presented below; if this order is not exact the import will be unsuccessful. The import logic expects the column headings to be in the first row/line of the import file. The second row/line of the file is the first row that it tries to import. If an error occurs on any row, it will skip that row and process whatever rows it can. The import screen will display any errors that occur and will provide record counts.
Additional Details
This import is for creating Assignment Compensation Worksheet Templates. Certain conditions must be true for this to happen:
There must be a Payroll System defined
There must be a Primary Payroll System set for the assignment
The Primary Payroll System must have a Currency defined
The Primary Payroll System Pay Periods Per Year must be at least 1
The Secondary Payroll System must have a Currency defined
The assignment must not already have a compensation worksheet template
The Template ID provided must be from the Assignment's Company
All company-level templates must be active*
* If there are any inactive company level CW Templates in the system prior to importing CW Templates to assignment records, activate these templates for the purpose of the import and then make them inactive once the import is done.
The system does not check to make sure that Compensation is enabled for the Assignment before creating the Template. Once the import updates the data, there is no way to automatically reverse what you just did. But you can access the template and edit them to make corrections.
Import Requirements
File Format
The input data file should be a CSV-formatted text file. A comma (“,”) will be used to separate each column. A carriage-return+line-feed character combination will be used to terminate each row. If a carriage-return+line-feed character combination must be included as part of the data of a single column, the column’s data should be enclosed in double-quotes. The same is true if a comma must be included as part of the data of a column. If a double-quote character must be included as part of the data of a column, then it should be “escaped” by being immediately proceeded by another double-quote character. (e.g. "Hello world" would be encoded as ""Hello World"" if the double-quotes were required as part of the value for a field.)
High-Level File Structure
The file will consist of one header row, followed by one or more data rows. The header rows explicitly state which fields will be updated.
Immediately following the header rows there should be one or more data rows. Each data row shall contain the necessary command, key and data values needed to import one row of data into the database table.
Header Row Details
The first non-blank row in the import file shall be interpreted as the header row. The header rows shall be used to define which fields will be imported. There are 2 fields in the header: AssignmentID and CompWorksheetCompanyTemplateID
Data Row Details
Following the header row are one or more data rows. All subsequent columns, should contain data. The field order should exactly match the field order specified in the header row, as should the field count. Each data row will contain two mandatory columns:
AssignmentID - You will want to enter the AssignmentID for the assignment you are updating.
CompWorksheetCompanyTemplateID – Supply the value of the Compensation Worksheet Company Template you want to create the Assignment Template from for this assignment.
Sample Format
AssignmentID, CompWorksheetCompanyTemplateID
109952,51