PANTHEON™ Help

 Kazalo
 Glavna stran - Dobrodošli v PANTHEON navodila
[Collapse]PANTHEON
 [Collapse]Vodiči za PANTHEON
  [Collapse]Vodič po PANTHEON-u
   [Expand]Pomoč
   [Expand]Nastavitve
   [Expand]Naročila
   [Expand]Proizvodnja
   [Expand]Blago
   [Expand]Servis
   [Expand]Denar
   [Collapse]Kadri
    [Expand]Personalna mapa
    [Expand]Koledarji
    [Expand]Potni nalogi
    [Collapse]Plače
      Subvencija minimalne plače po PKP8
      Obračun nadomestila razlog zadržanosti 15- po 46.
      Bolniška 3 dni - brez obiska zdravnika
      Iskanje osnove povprečja
      Formule - splošno
     [Expand]Spremenljivke za izračun plač
     [Expand]Pregled pozicij obračuna
     [Collapse]Priprava obračuna
      [Expand]Glava obračuna
      [Collapse]Ukazna vrstica priprave obračuna plač
        Prenos v obračunu
       [Collapse]Čarovniki v pripravi plač
         Kopiraj na vse
         Vnesite posamično
         Jasni tipi zaslužkov za vse
         Obvestilo o kopiranju
         Vnesite jubilejni bonus
         Kopiraj iz prejšnjega plačilnega lista
         Avtomatizacija izračuna plače
        [Expand]Uvozi podatke iz TXT, XLS datoteke
         Prenos v pripravo plač
         Kopiraj vrste zaslužka na druge plačilne liste
       [Expand]Čarovnik
       [Expand]Uvoz in izvoz podatkov
        Avtomatika obračuna plače
        Vnos vsem
        Vnos posamezno
        Brisanje vsem
        Razmnoževanje obvestila
        Vnos jubilejnih nagrad
        Prenos iz prejšnjega obračuna
       Podatki o delavcih
      [Expand]Priprava
      [Expand]Napake obračuna plač
      [Expand]Napake
      [Expand]Knjižbe
      [Expand]Plačilni nalogi
       Krediti
       Rekapitulacija
      [Expand]Sporočila plač
     [Expand]Izpis
     [Expand]Iskanje osnove za nadomestila nad 30 dni
     [Expand]Iskanje osnove za bolniško do 30 dni
     [Expand]Poročilo o dohodku
     [Expand]Obrazec M-4 do 2008
     [Expand]Obrazec M-4 od 2008 dalje
     [Expand]Kako knjižimo obračun plač
    [Expand]Varnost in zdravje pri delu
    [Expand]Obrazci
    [Expand]Zaposlovanje
    [Expand]Računovodska nadzorna plošča
    [Expand]Kontrolni izpisi
    [Expand]ZEUS Kadri
     Pop-up okno
    [Expand]Arhiv
   [Expand]Namizje
   [Expand]Analitika
   [Expand]Sporočila programa
   [Expand]Uradna pojasnila
   [Expand]Sistemsko okolje
   [Expand]Dodatni programi
    Slovar izrazov
   [Expand]Zastareli produkti
  [Expand]Vodič po PANTHEON Farming
  [Expand]Vodič po PANTHEON Retail
  [Expand]Vodič po PANTHEON Vet
 [Collapse]Uporabniški priročniki za PANTHEON
  [Expand]Uporabniški priročnik za PANTHEON
  [Expand]Uporabniški priročnik za PANTHEON Retail
  [Expand]Uporabniški priročnik za PANTHEON Vet
[Collapse]PANTHEON Web
 [Collapse]Vodiči za PANTHEON Web
  [Expand]Vodič po PANTHEON Web Light
  [Expand]Vodič za PANTHEON Web Terminal
  [Expand]Vodič za PANTHEON Web Legal
  [Expand]Arhiv starih izdelkov
 [Collapse]Uporabniški priročniki za PANTHEON Web
  [Expand]Kako začeti
  [Expand]Uporabniški priročnik za PANTHEON Web Light
   Uporabniški priročnik za PANTHEON Web Terminal
  [Expand]Arhiv starih izdelkov
  [Expand]Uporabniški priročnik za PANTHEON Web Legal
[Collapse]PANTHEON Granule
 [Collapse]Vodiči za PANTHEON Granule
  [Expand]Granula Kadri
  [Expand]Granula Potni nalogi
  [Expand]Granula Dokumenti in Opravila
  [Expand]Granula Nadzorna plošča
  [Expand]Granula B2B Naročanje
  [Expand]Granula Servis na terenu
  [Expand]Inventar fiksnih sredstev
  [Expand]Granula Inventura skladišča
 [Collapse]Uporabniški priročniki za PANTHEON Granule
   Začetek
   Primer uporabe PANTHEON Granul v namišljenem podjetju
  [Expand]PANTHEON Granule in aktivacija
  [Expand]Granula Kadri
  [Expand]Granula Potni nalogi
  [Expand]Granula Dokumenti in opravila
  [Expand]Granula B2B naročanje
  [Expand]Granula Nadzorna plošča
  [Expand]Granula Servis na terenu
  [Expand]Granula Inventura osnovnih sredstev
  [Expand]Granula Inventura skladišča
   PANTHEON Granule - pogosta vprašanja in odgovori
   Arhiv
[Expand]Uporabniške strani

Load Time: 406.2555 ms
"
  1007130 | 219433 | 356086 | Published
Label

Data Import from TXT

Import Data from Text File

010381.gif010411.gif010382.gif010383.gif

In Taskbar in Payroll preparation, by pressing on the wizard  we open a window Import Data from Text File through witch we can import data about presence in hours and days in the form txt. files and data derived from Spica.

In TXT type we can import different txt. Files layouts as followed:

  • Horizontal, where the setting in txt. is following:

         

  • Vertical, where the setting in txt. is following:

         

  • From Spica

Depending on the selection of the type of layout also a window opens, which is adapted for each layout.  

000001.gif

Data in txt. is recorded arbitrarily. We only need to look at the employee in one of the following ways:

  • Reg. No.

  • Number

  • ID Card

  When closing the wizard always the last layouts are kept.

 

Horizontal type txt. files:

From

We enter from which characters in txt file we are importing values written (Hours, Days). For example above, this is from 19 characters on.

To

We enter to which characters in txt file we are importing values written (Hours, Days). For example above, this is to 21 character.

Line

We enter the name of the item, which represents the earning types for example Vacation. We can enter up to 10 characters.

ET

We select the Earning Type (eg. DOP) form 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.

 

Vertical type txt. files:

File

We select the file, which we will import, which can only be in txt format.

Employee

Form/To

It represents the format of the data in which we have written employee.

In txt file where 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.

If we have in txt file of an employee written in a form of a number from the personal folder form the Number field, then we select the Number.

We write from/to of which characters we have in txt file of written employee. In our example, for a horizontal layout, this is from 1st to 15th character.

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 we do not have checked box “Finished”).

Run

By pressing on the button, we import data from txt file selected in a field File. Data are written on the second half of the forma.

 

File

We select the file, which we will import, which can only be in txt format.

Employee

Form/To

It represents the format of the data in which we have written employee.

In txt file where 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.

If we have in txt file of an employee written in a form of a number from the personal folder form the Number field, then we select the Number.

We write from/to of which characters we have in txt file of written employee. In our example, for a horizontal layout, this is from 1st to 15th character.

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 we do not have checked box “Finished”).

Run

By pressing on the button, we import data from txt file selected in a field File. Data are written on the second half of the forma.

 

In the second half of the forma we will see the imported data, which we can also correct here. The data’s are in the columns Pos., Days and Hours.

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 meant only for reading.

Pos.

Employee’s last active position from the panel Position/Salary is written. With double click to this field, we open employee’s file of this employee. We can change here the data.

Position Name

It is written the last active name of the position from the panel Position/Salary. With double click to this field, we open employee’s file of this employee. We cannot change here the data, it 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 click we access the code table of earning types. We cannot change here the data, it meant only for reading

Days

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

Hours

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

Amount

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

Index

From txt we import the index for an individual earning in case we have in the first half of the form in Data Type if we 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 txt 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 that 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.

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 will be deleted form the preparation next to the confirmed checker when resuming the transfer.

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.  

 

79176.gif Watch example:

Import data from TXT

 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!