Find Jobs
Hire Freelancers

dbf to csv conversion

$30-150 USD

Completed
Posted over 18 years ago

$30-150 USD

Paid on delivery
A program to take a dbf file that is produced by our timeclock system and convert it over to a modified csv file to import into our payroll system. ## Deliverables I need a program that will take a dbf file that my timeclock program creates each payroll and pull the following information out of it Column 1 - Employee Number (leading zeros removed) Column 2 - Date Worked (MM/DD/YYYY) Column 3 - Worked Department (leading zeros removed) Column 4 - TOT-WRK Column 5 - HOL Column 6 - VAC Column 7 - FMLA Column 8 - TRAVEL Column 9 - CALLOUT Column 10 - ADDAMT Column 11 - CALLOT and then save it as a csv files like below 1,06/27/2005,10,8.72,,,,,,, 6,07/03/2005,10,,,,,,4.15,,2 It would create two seperate files one for Worked Department 0-99 and another for 100-199. I would need to be able to run this from a command prompt and also need the ability to change the names and location of the 3 files. Input File Output 0-99 and Output 100-199 I had a program that used to do this but because of some changes I need to have a new one designed. I have enclosed a copy of the dbf input file and the ascii output file. I would also like the raw souce program file for future use if changes are ever needed. I also need to add that the time that comes out of the database is in minutes and needs to be converted to hour.hundredths. Another note the database does not lineup the data column to column but if there are hours for that category it send it out in the first open category. The csv file would have to always put them in the right column. So in the database TOT-HRS","523" and then there might be "CALLOUT","45" next or "FLMA","45" next just depends on what has data in it. ## Platform Program would need to be able to run on windows xp or 2003 server.
Project ID: 3817177

About the project

30 proposals
Remote project
Active 19 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$96.05 USD in 5 days
5.0 (15 reviews)
4.2
4.2
30 freelancers are bidding on average $82 USD for this job
User Avatar
See private message.
$127.50 USD in 5 days
5.0 (98 reviews)
7.9
7.9
User Avatar
See private message.
$95.20 USD in 5 days
5.0 (129 reviews)
7.8
7.8
User Avatar
See private message.
$127.50 USD in 5 days
4.9 (131 reviews)
7.6
7.6
User Avatar
See private message.
$68 USD in 5 days
5.0 (43 reviews)
7.0
7.0
User Avatar
See private message.
$106.25 USD in 5 days
5.0 (17 reviews)
6.1
6.1
User Avatar
See private message.
$49.30 USD in 5 days
5.0 (82 reviews)
6.1
6.1
User Avatar
See private message.
$102 USD in 5 days
5.0 (42 reviews)
5.7
5.7
User Avatar
See private message.
$85 USD in 5 days
5.0 (84 reviews)
5.4
5.4
User Avatar
See private message.
$85 USD in 5 days
5.0 (50 reviews)
5.2
5.2
User Avatar
See private message.
$62.90 USD in 5 days
5.0 (46 reviews)
5.1
5.1
User Avatar
See private message.
$63.75 USD in 5 days
5.0 (11 reviews)
5.3
5.3
User Avatar
See private message.
$34 USD in 5 days
4.7 (145 reviews)
5.5
5.5
User Avatar
See private message.
$46.75 USD in 5 days
4.9 (22 reviews)
4.3
4.3
User Avatar
See private message.
$85 USD in 5 days
5.0 (15 reviews)
4.0
4.0
User Avatar
See private message.
$25.50 USD in 5 days
5.0 (13 reviews)
3.8
3.8
User Avatar
See private message.
$85 USD in 5 days
4.9 (22 reviews)
3.5
3.5
User Avatar
See private message.
$119 USD in 5 days
5.0 (14 reviews)
3.4
3.4
User Avatar
See private message.
$85 USD in 5 days
4.1 (10 reviews)
3.4
3.4
User Avatar
See private message.
$85 USD in 5 days
5.0 (12 reviews)
2.7
2.7
User Avatar
See private message.
$85 USD in 5 days
5.0 (1 review)
2.5
2.5

About the client

Flag of UNITED STATES
United States
5.0
6
Payment method verified
Member since Jul 22, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.