UBS Payroll Software » Others

ID #1417

Export CSV/TXT File

Description

Below solution shows  the  way of export  employee file information which contains Employee Number, Name, Job Title & Basic Pay to Excel format.

 

Solution

1.    Go to Miscellaneous — Export CSV/TXT File, select Report  To Set in row No. 2

2.    Create  a Report  Title, e.g.  Employee Basic Pay —  November  2006

Header File

From File:               PMAST (PMAST = Personnel File Maintenance dbf)

 

Tag:                         PMASTI

 

Body File

 

Body File               PTR (PTR = 2nd  Half Payroll transaction dbf)

 

Tag                            PAYTRANI

 

To File                     EMP.CSV (any filename with .CSV)

 

Index Key             EMPNO     X fix length

 

Separator             ,                       R with separator

 

Start Line               Employee No,  Name, Job Title, Basic Pay

 

Note: Start  Line = Excel header, the  length is limited to 70 characters (alpha-numeric)

 

3.    Click on “Save”, “Next”.

 

4.    Right click on row No.1, select variable from table field:

 

row 1 as pmast.empno row 2 as pmast.name row 3 as pmast.jtitle

row 4 as ptr.basicpay, and insert additional field to STR(ptr.basicpay,l2,2)

 

- user  need  to insert length of field and  change the  figures/amount to string in order  to be appeared as figures

 

for row 5, type in CSVEND

 

- Excel column must  enter  CSVEND at the  end of the  report, in order  to limit the  file size that  has been  sent  to Excel

 

5.    Click on “Save” and “Export” button to export  to a specific folder. User may open  the  Excel file in that  folder.

 

(Note: if there  is any fault encounter message when  exporting, it must  be the  incomplete variable in a particular field)

 

Tags: Export CSV/TXT File

Related entries:

Last update: 2010-11-17 06:07
Author: Noor Diyana
Revision: 1.0

Digg it! Share on Facebook Print this record Send FAQ to a friend Show this as PDF file
Propose a translation for Propose a translation for
Please rate this FAQ:

Average rating: 4 (1 Vote)

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry