Find Jobs
Hire Freelancers

database extract and append to flat file.

$30-100 USD

Completed
Posted almost 19 years ago

$30-100 USD

Paid on delivery
We require a PHP application to extract email addresses from a mySQL database and combine them into an ascii flat file that is maintained by another application. Extraction is UNIX date based (Date of registration). The routine must have the following: - On loading, the browser to display the date of last extraction, the number of records since last extraction, and an option to do the extraction. - Output to browser so that a quick visual check can be made before combining with flat file - Output to have the following data items: Email Address, Date of registration (converted to standard date format). - Append to log (Create if doesn't exist) - Confirmation Screen shows: number of records extracted, option to view log file, option to delete log file (file renamed, not actually deleted). Due to the confidentialityof emails this needs to be a "black box" application. All “parameters?? like database name, dbusername, password, tablename, field name needs to be read from a config file as variables. Data only needs to be appended to flat file, no error or duplicate checking is needed (other application takes care of that.) This application will be read only on the database so anything that it needs to remember must be written to files in it's install directory. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). * * *This broadcast message was sent to all bidders on Wednesday Jul 13, 2005 2:46:51 PM: Someone asked what I meant by "black box" application. The code required has to be written without any information about the system it's going on. Anything that the code needs to know will be provided by me through a config file after I install it. I will provide a dummy flat file and mySQL field types, etc. Hope that makes sense :-) Thanks, Rob ## Platform -PHP -mySQL -Linux -Apache
Project ID: 3802718

About the project

18 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.
$63.75 USD in 10 days
4.8 (119 reviews)
6.8
6.8
18 freelancers are bidding on average $56 USD for this job
User Avatar
See private message.
$85 USD in 10 days
4.9 (147 reviews)
6.5
6.5
User Avatar
See private message.
$21.25 USD in 10 days
4.9 (107 reviews)
6.4
6.4
User Avatar
See private message.
$63.75 USD in 10 days
4.7 (93 reviews)
6.3
6.3
User Avatar
See private message.
$51 USD in 10 days
4.9 (131 reviews)
6.2
6.2
User Avatar
See private message.
$74.80 USD in 10 days
5.0 (82 reviews)
6.1
6.1
User Avatar
See private message.
$85 USD in 10 days
5.0 (63 reviews)
5.4
5.4
User Avatar
See private message.
$29.75 USD in 10 days
5.0 (22 reviews)
5.1
5.1
User Avatar
See private message.
$38.25 USD in 10 days
5.0 (41 reviews)
4.5
4.5
User Avatar
See private message.
$59.50 USD in 10 days
5.0 (6 reviews)
3.2
3.2
User Avatar
See private message.
$38.25 USD in 10 days
4.7 (16 reviews)
3.5
3.5
User Avatar
See private message.
$42.50 USD in 10 days
5.0 (12 reviews)
2.8
2.8
User Avatar
See private message.
$85 USD in 10 days
4.0 (9 reviews)
3.6
3.6
User Avatar
See private message.
$85 USD in 10 days
5.0 (2 reviews)
0.8
0.8
User Avatar
See private message.
$42.50 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$25.50 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$42.50 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$76.50 USD in 10 days
5.0 (1 review)
0.0
0.0

About the client

Flag of CANADA
Canada
5.0
2
Member since Apr 12, 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.