Can Absence details be exported from IRIS Payroll
Professional?
IRIS Payroll Professional stores absence details in an 'Absence
Diary' which is not exposed to the standard import or export
routines, however you can generate an absence report in the
software and export the report data to file. This would have to be
separate from the other exports.
How do I export a report to
Excel/Lotus etc.?
Preview the report as normal to the screen. At the top of the
screen you will see an 'envelope' icon. Click on this icon and you
will be able to choose an Export Format and Destination. You will
then be able to specify a File Name and a Location to save the
report. If you do not get the option to export to a specific
program, you may have some export dlls missing. Call your Support
Centre and they can supply you with the necessary export dlls.
What format does the data need to be
in for importing?
There are several predefined import structures that come with IRIS
Payroll Professional but you can also define your own. You can
import in either:
- Fixed length
- CSV (Comma Separated Value) or
- Microsoft Excel formats
When you choose fixed length you need to
specify the start position and length for each field. We usually
recommend using CSV as these are the easiest files to read and
diagnose if there are problems. All import files must be in a
simple column based format with a row for each employee. The first
column is always the employee code and the remaining columns are
defined by the structure.
My clock-in details are not coming
through to the payroll run, why?
Check the Clockin file is in the IRIS Payroll Professional program
folder and it is named correctly. It will be either Clockin or
Clockin.XXX, where X represents the company ID number. The
Clockin file will also not come through to the payroll if it is a
re-run.
