Import Hours from Text or CSV File

IMPORT HOURS FROM TEXT FILE

To access this utility go to Utilities > Import Hours>  from text file

The import file name must be wimport.txt

Within the payroll under the utility menu there is a browse type screen where the user selects the drive, folder, to find where the file is.

There is a grid which will show the employees name and number and if P45 issued. This can be copied to Excel or similar via the clipboard and sorted as desired

The import file detail is shown to the user on a similar grid.

There is no checking that the names/numbers are correct. It is up to the user to determine that the numbers on the import data file match the numbers of the corresponding employees in the payroll. The employee works numbers are shown on the grid.

The file spec

ascii text file - zero filled

bytes name

02 period - week or month number

04 employee number

06 Standard hours (123.56)

06 hours x 1.5 (123.56)

06 double time (123.56)

02 weekly or monthly marker (1 is weekly, 2 is monthly)

06 hours x 1.3333

30 filler

02 carriage return/line feed

total record size is 64 bytes

IMPORT HOURS FROM CSV FILE

To access this utility go to Utilities > Import Hours > from CSV file

The file spec ;

Works No, Hours at standard rate, at time & half, at double time, at time & third

e.g.

0001,40,,,

0002,40,4,2,

0003,40,,,3

or

0001,40

0002,35

To record fractional hours then these should be shown in decimal format

e.g.

0001,40.50,,,

The above would record 40 1/2 standard hours for employee with the works number 1

Click 'Locate File' and the grid will populate with the contents of the chosen CSV file

Click 'Validate' and the program will see if it can match works numbers with employees

Click 'Import' when you are happy that it is OK to import

The hours imported will be used when you next update the payroll.