PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Expand]Settings
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]POS
   [Expand]Service
   [Collapse]Financials
    [Expand]Accounting Basics
    [Expand]Posting
    [Expand]Automatic Posting
    [Collapse]Accounting Dashboard
     [Collapse]Personnel
      [Expand]Employment
      [Expand]Travel Management
      [Collapse]Payroll
       [Collapse]Payroll
        [Collapse]Wizards
          Copy Earnings Type to All
          Clear Earning Type For All
          Import Data from TXT, XLS file
        Payment Orders
        Posting
        Reports
        Forms
     [Expand]Goods
     [Expand]Financials
      Calculation
      Event Log
    [Expand]Overview
    [Expand]Close
    [Expand]Accruals and Deferrals
    [Expand]Credits and Leases
    [Expand]Reports
    [Expand]Special Reports
     Consolidated Financials Statements
    [Expand]Fixed Assets
    [Expand]Transactions
    [Expand]Debt Collection
    [Expand]Reminders
    [Expand]Year-end
    [Expand]Interest
    [Expand]Cash
    [Expand]Archive
     ZEUS Planning
   [Expand]Personnel
   [Expand]Analytics
   [Expand]Desktop
   [Expand]Help
   [Expand]Messages and Warnings
   [Expand]Additional programs
   [Expand]Old products
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Expand]User Manual for PANTHEON
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 391.248 ms
"
  1000006539 | 225936 | 414602 | Updated
Label

Import Data from TXT, XLS file

 

By clicking on Wizard in Taskbar of Payroll preparation we can open a window Import Data from TXT, XLS file.  Through this window we can import data about presence in hours and days in the form txt or xls for all in the Accounting dashboard selected databases.

Table of contents

  1. Horizontal TXT file
  2. Vertical TXT file and Špica
  3. Vertical XLS file
  4. XLS file horizontally

 

Warning

Files that we want to import must be named and saved as the Company's Tax number.   In the File section we select the location folder and once we hit Run, the program will look for files for each of the previously selected databases.

1. Horizontal TXT file

We can import data from a txt file by specifying the starting character of each set of txt file content.

From We enter from which character in the txt file we are importing values written (Hours, Days). In the example above, this is from the 19th character on.
To We enter to which character in the txt file we are importing values written (Hours, Days). For example above, this is to 21st character.
Line We enter the name of the item that represents the earning types for example Vacation. We can enter up to 10 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 Type 1 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. 

 

Warning

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

2. Vertical TXT file and Špica

We can import data from a txt file by specifying the start line of each set of txt file content.

Lines From - To The start line of the earning type.
Values From - To The start line of the values for above specified earning type.  We specify for each of the Data Type 1-4 columns in the middle window of this form.
Line Name of the earning type.
ET We select the Earning Type (eg. DOP) from the code table of Earning Types to which we can enter by double click.
Data Type 1 - 4 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. 

 

3. Vertical XLS file

When importing from a vertical XLS, we need to specify the content of XLS columns.

Lines Column We enter the number of the column in which in XLS file the ET is located.

Values

Columns 1 - 4 

We enter the number of the column in which in XLS file the Data Type is located.

 

Line We enter the name of the item, which represents the earning type for example Vacation. We can enter up to 3 characters.
ET In a drop down menu we select the Earning Type (eg. DOP) from the Earning Types register
Data Type 1 - 4 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 corresponding column.

4. XLS file horizontally

 

Column XLS column representing the earning type.  Up to 100 columns can be selected to import.
Line We enter the name of the item, which represents the earning type for example Reg.work. We can enter up to 10 characters.
ET In a drop down menu we select the Earning Type (eg. DOP) from the Earning Types register.
Data Type 1 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 corresponding column.

 

 

 

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