Each employee's data is on a separate line. Each line is structured as
ID, PR1, PR2, PR3, PR4, PR5, PR6, Ref, Units, Ref, Units, Ref, Units, etc
Every field must be delimited with a comma.
The first field is the employee ID as used in Ace Payroll.
The next six fields (PR1 to PR6) are the number of units of each of the first six user definable pay rates to be paid for the employee. If less than six rates are used, the unused fields must still be delimited with commas.
After reading the pay rates fields, the import utility reads in allowances to be paid until the end of the line is reached.
There can be any number of allowances paid. They are structured in pairs. The first element of the pair (Ref) is the allowance reference as used by Ace Payroll. The second element of the pair (Units) is the number of units of the allowance to be paid. The import utility reads these paired fields until the line ends.
The information is read into the current pay period (This Pay) for the relevant employee.
All fields after the identifier (ID) accept a maximum of eight characters of numeric data. The maximum number that can be used in each field is 9999.999. If a whole number is used you do not have to include a decimal point.
The import utility will ignore any line that contains an invalid employee identifier, and will also ignore any allowances that have not been assigned to the relevant employee.
The utility overwrites the 'This Pay' fields for the relevant imported employees but leaves all other employees alone.
Employee EH has two different rates for fruit picking. Apricots have been loaded as allowance reference number 6. Peaches are reference 8 and the unit value of each of these allowances is per kilogram.
EH has picked 300 kilograms of apricots and 500 kilograms of peaches in the current pay period. The data in IMPORT.TXT for this employee will appear as
Employee FJ has worked 40 hours at payrate 1, 3 hours at payrate 2, and 1.25 hours at payrate 3. Their union fee is loaded as allowance number 73 and 1 unit of this will be deducted. Their meal allowance is loaded as reference number 89 and 2 of these will be paid. The data in IMPORT.TXT for this employee will be
Style #50 provides a method of importing hours worked, allocated to individual departments.
Each line takes five parameters. Example lines are
This style is used in conjunction with style #50, and enables the import of allowances and deductions. By combining styles #50 and #51 within the same import file, pay rates and allowances can be imported.
Style #51 takes four parameters. An example is
The last example given for the generic import utility was
This can be replaced completely using styles #50 and #51. Using these styles, the same functionality is provided by
#50,FJ,50001,40, - 40 hours at first pay rate
#50,FJ,50002,3, - 3 hours at second pay rate
#50,FJ,50003,1.25, - 1.25 hours at third pay rate
#51,FJ,73,1 - 1 unit of allowance 73
#51,FJ,89,2 - 2 units of allowance 89
This style imports into Ace Payroll the hours worked by an employee, together with the hourly rate to be paid.
Each line represent the hours and rate to be paid for each of an employee pay rates.
A style #52 line has five fields. An example is
#52,FJ,50001,40,15.75 - First pay rate 40 hours @ $15.75
#52,FJ,50002,3,12.70 - Second pay rate 3 hours @ $12.70
#52,FJ,50020,1.25,18.00 - Twentieth pay rate 1.25 hours @ $18.00
deletes the file after importation. To provide more detail within the import file, you could precede the #89 line with a comment. For example
! delete file after importing
Style #99 introduces the facility for the supplier of an import file to communicate with the Ace Payroll user, via the import file, without the user having to open the file in Notepad or similar.
The text circled in yellow is created by placing the following line anywhere in the import file
#99,"[center]Hi John. This file contains attendance records for the[br][b]week ending 22/06/2003[/b][/center]"
Note the following
Comments can be inserted into any part of the file by either
Comments work on a line by line basis. To comment out a block of lines, every line in the block must be commented as shown.