Uvoz iz TXT datoteke - vertikalno

Datoteka

Izbor putanje datoteke koju ćemo uvoziti i koja može biti samo u TXT formatu (ANSI kodiranje)

Radnik

Predstavlja tip podatka kojim počinje zapis o radniku.

Podatak može biti:

• Mat.br./ID: podatak upisan u polje Mat.br./ID radnika u PM
• Šifra: podatak upisan u polje Šifra radnika u PM
• Broj kartice: podatak upisan u polje Broj kartice radnika u PM

Potrebno je izabrati jednu od ponuđenih opcija za označavanje podataka o radniku u TXT datoteci. Po tom, potrebno je odrediti dužinu tog podatka i poziciju u TXT datoteci:

Radno mesto

Predstavlja tip podatka kojim počinje zapis o Radnom mestu.

Podatak može biti:

• Automatsko: podatak upisan u polje Radno mesto, u panelu Parametri... radnika u PM
• Šifra: podatak upisan u polje šifre RM iz šifarnika RM, a koje je dodeljeno radniku u PM|Parametri...
• Naziv: podatak upisan u polje naziv RM iz šifarnika RM, a koje je dodeljeno radniku u PM|Parametri...

Potrebno je odrediti dužinu tog podatka i poziciju u TXT datoteci:

Odeljenje

U TXT datoteci se može korsititi:

• Bez: podatak neće biti prenošen it TXT datoteke; može se ostaviti prazno.
• Naziv: podatak upisan u polje Odeljenje, u panelu Parametri... radnika u PM

Potrebno je odrediti dužinu tog podatka i poziciju u TXT datoteci:

Nosila troška

U TXT datoteci se može korsititi:

• Bez: podatak neće biti prenošen it TXT datoteke; može se ostaviti prazno.
• Naziv: podatak upisan u polje Nosilac troška, u panelu Parametri... radnika u PM

Potrebno je odrediti dužinu tog podatka i poziciju u TXT datoteci:

Obračun

Biramo obračun u koji želimo da uvezemo podatke. Ovde možemo videti samo one obračune koje još nisu zaključeni (u obračunu nije označeno polje „Zaključeno“).

Grupiši VZ

Opciono polje je aktivno samo u slučaju da već postoje neke VZ izabrane za prenos podataka ili su podaci već preneti u pripremu obračuna.

U sliučaju označenog polja, sve VZ će se za svakog radnika biti prepisane novim vrednostima u pripremi obračuna.

Grupiši RM, Odeljenje, Nos.tr.

Ako je opciono poje označeno, program će grupisati VZ po RM, Odeljenju i/ili Nosiocu troška.

Popravi vrednosti VZ

Opcija je označena samo u slučaju da u izabranom obračunu za prenos podataka već postoji VZ u pripremi obračuna za određenog radnika ili su podaci već bili preneseni.

U slučaju da je opcija označena sve VZ za određenog radnika će biti prenete u pripremu obračuna sa novim vrednostima VZ. Prenosom u pripremu obračuna neće prepisati postojeće VZ u poljima Dani, Sati, Iznos ili Indeksni odnos, već će samo ispraviti vrednost.

Na primer: za VZ koje su podešene u AK|Podešavanja|Kadrovi|Plate|Prevoz na posao, neće prepisati Iznos koji je prenesen iz PM|Parametri za obračun plata| Prevoz na posao, već samo unosi sate.

Prekrij postojeće VZ

Opcija je označena samo u slučaju kada u izabranom obračunu za prenos podataka već postoji neka VZ u pripremi obračuna za određenog radnika ili su podaci već preneseni.

U slučaju da je opcija označena, sve VZ za pojedinog radnika će biti prensene sa novim vrednostima

Prenesi

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 Type4

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.

Lines from-to

We enter the length and position of the ET in the text file.

Values

1. From-to
2. From - to
3. From - to
4. From - to

We enter the length and position of chosen data types described in the above table.

Employee

From TXT file we import the employee. With double click in this field, we open employee’s personal file. We cannot change here the data, it is  meant only for reading.

Pos.

Employee’s last active position from the panel Position in Salary Parameter is written. We can change here the data.

Position Name

It is shown the last active name of the position from the panel Position in Salary Parameter. With double clicking to this field, we open employee’s file of this employee. We cannot change the data, it is meant only for reading.

ET

It is written the earning type, which we set in the first half of the form in the entry from the column ET. With double clicking we access the code table of earning types. We cannot change the data, it is meant only for reading.

Days

From TXT file we import the days for an individual earning in case we have in the first half of the form in Data Type selected Days. We can change the data here.

Hours

From XLS file we import hours for an individual earning in case we have in the first half of the form in Data Type  selected Hours. We can change here the data.  We can change here the data.

Amount

From TXT file we import the amount for an individual earning in case we have in the first half of the form in Data Type selected Amount. We can change here the data.

Index

From TXT file we import the index for an individual earning in case we have in the first half of the form in Data Type selected Index. We can change here the data.

Status

When importing data, various warnings and errors are written in the Status. Errors are separated by two degrees, which lines are also colored accordingly. The color can be randomly determined in Administration Panel | …| Payroll | Message Statuses – Payroll in the Critical Error, Error and Warning fields. In this way two kinds of messages appears Error and Warnings, which are briefly described. Errors cannot be corrected and cannot be transferred to payroll preparation, while warnings can be corrected and are subsequently marked for transfer to pay slip.

Critical errors are:

• Employee is not active (employee is not active or has no parameters for this calculation).
• Pos. is not in the period (the position is not in the period of a case, so at this moment of the entry changes Pos.)

Warnings are: 

• ET is already in the preparation (this earning type employee already has in a preparation, the data in the column ET is colored)
• Difference in Days (this employee already has for this ET, but the difference is in the days, the data is colored in Days column).
• Difference in Hours (this employee already has for this ET, but the difference is in the hours, the data is colored in Hours column).
• Already transferred (this employee has already the data transferred to the preparation, trough importing XLS  file)
• More active Pos. (this employee has more active positions, which are possible in this pay slip for this period; the data in the column Pos. is colored).

All other records are marked for transcription and are not colored. Coloring can also be changed as far as the box in column Sel. is checked and the warning color changes so only the remainder of the data where the Warning occurred. Always remains colored field Employee with the color for warnings.

Sel.

We check the box in case we want the selected positons to be transferred in the payroll preparation.

Run

By pressing the button, the data will be transferred in the pay slip preparation and the program will display the information, which we confirm.