UBS Payroll: Difference between revisions

From eStream Software
(Created page with "''File | Import Data | UBS Payroll'' ==Introduction== This function is to import the Data From the UBS Payroll.<br> <br> ==Type Information/Data Import== #Maintain Branch #Mai...")
 
No edit summary
 
(11 intermediate revisions by 4 users not shown)
Line 2: Line 2:
==Introduction==
==Introduction==
This function is to import the Data From the UBS Payroll.<br>
This function is to import the Data From the UBS Payroll.<br>
<br>
 
==Type Information/Data Import==
==Type Information/Data Import==
#Maintain Branch
#Maintain Branch (branch.dbf)
#Maintain Category
#Maintain Category (category.dbf)
#Maintain Department
#Maintain Department (dept.dbf)
#Maintain Project
#Maintain Project (project.dbf)
#Maintain Race
#Maintain Race (race.dbf)
#Maintain Allowance
#Maintain Allowance (awtable.dbf)
#Maintain Deduction
#Maintain Deduction (dedtable.dbf)
#Maintain Employee
#Maintain Employee (pmast.dbf)
<br>
 
==Requirement==
==Requirement==
#UBS Payroll Version 9 and above
#UBS Payroll Version 9 and above
Line 18: Line 18:
#SQL Payroll Application
#SQL Payroll Application
#Empty Database of SQL Payroll
#Empty Database of SQL Payroll
==Steps==
If your pc <b>do not install UBS Payroll follow step 1</b> , if you <b>had install UBS Payroll in your pc <u>IGNORE</u> step 1</b>
<br>
#Extract your UBS Payroll file by using 7zip.
::[[File:5.png]]
<br>
<li>Download 7 Zip to extract UBS Payroll Backup file.</li>
<b><u>Download Path for 7 Zip :</u></b>
Window 32 Bits : http://www.sql.com.my/utility/7-zip.msi
Window 64 Bits: http://www.sql.com.my/utility/7-zip-x64.msi
<br>
:2.Create a Empty Database in SQL Payroll
::[[File:1.png]]
<br>
::[[File:2.png]]
<br>
<br>
==Steps==
::[[File:3.png]]
#Login the Empty Database of SQL Payroll
<br>
#Click File | Import Data | UBS Payroll<br>
:3.Login the Empty Database of SQL Payroll
::[[File:File.ImportData.UBS.jpg]]<br>
::[[File:4.png]]
:3. Select the UBS Payroll Directory Folder & Click Ok to Start Import <br>
<br>
::[[File:File.ImportData.Autocount.Fig3.jpg]]<br>
:4.Click File | Import Data | UBS Payroll
:4. Click Close to Finish import.
::[[File:6.png]]
<br>
:5. Select the the extracted backup folder <b>or</b> UBS Payroll Directory Folder & Click Ok to Start Import <br>
::[[File:7c.png]]
<li>If failed to connect and prompt message "Provider cannot be found. It may not be properly install".<br />
 
<b><u>You need to download and install the file "VFPOLEDBSetup.msi" from:</u></b>
https://www.microsoft.com/en-my/download/details.aspx?id=14839 </li>
<br>
:6. Click Close to finish import.
::[[File:8.png]]
<br>
:7. Go Human Resources | Maintain Employee to check all your Employee List imported successfully from UBS Payroll.
::[[File:9.png]]
<br>
::[[File:10.png]]
<br>
 
 
==FAQ==
:1. Get message "Provider cannot be found ....it may not be properly installed" when try to import the UBS backup folder.
:'''Answer:''' The computer need to add Microsoft Visual FocPro Driver in ODBC Data Source Adminstrator (control panel)

Latest revision as of 10:21, 18 February 2021

File | Import Data | UBS Payroll

Introduction

This function is to import the Data From the UBS Payroll.

Type Information/Data Import

  1. Maintain Branch (branch.dbf)
  2. Maintain Category (category.dbf)
  3. Maintain Department (dept.dbf)
  4. Maintain Project (project.dbf)
  5. Maintain Race (race.dbf)
  6. Maintain Allowance (awtable.dbf)
  7. Maintain Deduction (dedtable.dbf)
  8. Maintain Employee (pmast.dbf)

Requirement

  1. UBS Payroll Version 9 and above
  2. UBS Payroll Data (after restore)
  3. SQL Payroll Application
  4. Empty Database of SQL Payroll

Steps

If your pc do not install UBS Payroll follow step 1 , if you had install UBS Payroll in your pc IGNORE step 1

  1. Extract your UBS Payroll file by using 7zip.
5.png


  • Download 7 Zip to extract UBS Payroll Backup file.
  • Download Path for 7 Zip : Window 32 Bits : http://www.sql.com.my/utility/7-zip.msi Window 64 Bits: http://www.sql.com.my/utility/7-zip-x64.msi

    2.Create a Empty Database in SQL Payroll
    1.png


    2.png


    3.png


    3.Login the Empty Database of SQL Payroll
    4.png


    4.Click File | Import Data | UBS Payroll
    6.png


    5. Select the the extracted backup folder or UBS Payroll Directory Folder & Click Ok to Start Import
    7c.png
  • If failed to connect and prompt message "Provider cannot be found. It may not be properly install".
    You need to download and install the file "VFPOLEDBSetup.msi" from: https://www.microsoft.com/en-my/download/details.aspx?id=14839

  • 6. Click Close to finish import.
    8.png


    7. Go Human Resources | Maintain Employee to check all your Employee List imported successfully from UBS Payroll.
    9.png


    10.png


    FAQ

    1. Get message "Provider cannot be found ....it may not be properly installed" when try to import the UBS backup folder.
    Answer: The computer need to add Microsoft Visual FocPro Driver in ODBC Data Source Adminstrator (control panel)