Import data from TXT file - vertical
Under Payroll preparation, by pressing on the wizard, there is an option Import data from TXT, XLS file. To import data for payroll preparation from a text file (ANSI formatting) choose Text File Type - Vertical
Formatting of a text file must be ANSI.
Data in TXT. is recorded arbitrarily. We only need to look at the employee in one of the following ways:
When closing the wizard always the last layouts are kept.
|
File
|
We select the file, which we will import, which can only be in TXT (ANSI encoding) format.
|
|
Employee
|
It represents the format of the data in which we have written employee.
In TXT file we can choose between:
- Reg. No: data that is identical to the data from Employee files from the field Reg. No./ID
- Number: data that is identical to the data from Employee files from the field Number
- ID Card: data that is identical to the data from Employee files from the field Card No.
We select an option which determines an employee in the text file. We then need to specify the length and position of Employee data in the file.
|
|
Position
|
It represents the format of the data in which we have written Position.
In TXT file we can choose between:
- Automatic: data that is identical to the data from Employee files from the field Position in Salary Parameters.
- ID: data that is identical to the data from Employee files from Position from the register Positions of Employment
- Name: data that is identical to the data from Employee files from Position from the register Positions of Employment.
Again, we need to specify the length and position of this information in the text file.
|
|
Department
|
In TXT file we can choose between:
- None: data will not be transferred from the file. We can leave the field empty.
- Name: data that is identical to the data from Employee files from the field Dept. in Salary Parameters.
Again, we need to specify the length and position of this information in the text file.
|
|
Cost Center
|
In TXT file we can choose between:
- None: data will not be transferred from the file. We can leave the field empty.
- Name: data that is identical to the data from Employee files from the field Cost Center.in Salary Parameters.
Again, we need to specify the length and position of this information in the text file.
|
|
Report
|
We select the Report where we want to transfer the imported data. Here we can see only those Pay slips that are not finished yet (in Payroll preparation do not have checked box “Finished”).
|
|
Group ET
|
The checker is active only in case there is already some kind of ET in the selected pay slip for data transfer at the time of preparing the pay slip for a particular employee, or that data has already been transferred.
In case the checker is confirmed, all ET’s will be transcribed for each worker by the new values in the pay slip preparation.
|
|
If there is some ET in the transfer data to the preparation, which is no longer in TXT file will be deleted form the preparation next to the confirmed checker when resuming the transfer.
|
|
|
Group workspace, dept., cost ctr.
|
When the checkbox is confirmed than the program will group ET’s by workplace, department and/or cost center.
|
|
Eg: when we have an employee with eg the same position but different department or cost center and we would like that every ET is calculated for the correct position, than we confirm this checkbox.
|
|
|
Fix the ET values
|
Checkbox is active only in a case that in the selected calculation for the transfer of data the already exist an earning type in the payroll calculation for a specific employee or that the data have already been transferred.
In case the checkbox is confirmed all ET for individual employee will be transferred to the payroll preparation with the new ET values. With the transfer to the payroll preparation it will not overwrite existing ET in the fields Days, Hour, Amount and Index but it only correct the values.
Eg. for ETs that are set in AP/Settings/Personnel/Payroll/Commute from Work, it does not overwrite Amount which is transferred form EF/Salary Parameters/ Commute to Work, but for eg. it enters only hours.
|
|
Overwrite Existing ET
|
Checkbox is active only in a case where in the selected calculation for transfer of data already exist a sort of earning type in the payroll preparation for a specific employee or that the data have already been transferred.
In case the checkbox is confirmed all ET for individual employee will be transferred with the new values.
|
|
Eg.: with repeated transfer of data to payroll preparation already exist an ET which is no longer in XLS that with the confirmed checkbox with repeated transfer this ET will be deleted from the payroll preparation.
|
|
|
Run
|
By pressing on the button, we import data from TXT file selected in a field File.
|
|
Line
|
We enter the name of the item, which represents the earning type for example Vacation. We can enter up to 3 characters.
|
|
ET
|
We select the Earning Type (eg. DOP) from the code table of Earning Types to which we can enter by double click.
|
|
Data Type1
|
We select the type of data, which we import. We can select from Hours, Days, Amount and Index. Based on selected type the information will be imported to the correspondent column.
|
|
Data Type2
|
We select the type of data, which we import. We can select from Hours, Days, Amount and Index. Based on selected type the information will be imported to the correspondent column. We use this Data Type if we already entered information in Data Type1.
|
|
Data Type3
|
We select the type of data, which we import. We can select from Hours, Days, Amount and Index. Based on selected type the information will be imported to the correspondent column.
|
|
Data Type3
|
We select the type of data, which we import. We can select from Hours, Days, Amount and Index. Based on selected type the information will be imported to the correspondent column.
|
