Closed

Send txt files to Mysql database

This project received 34 bids from talented freelancers with an average bid price of $126 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$10 - $30 USD
Total Bids
34
Project Description

I need software that will send txt files into mysql database.

Explain:

Picture [url removed, login to view] :

- IP ADDRESS: here i must write mysql server ip Address
- PORT : here i must write mysql server port
- DB : here i must write database name
- USERNAME : mysql username
- PASSWORD : mysql password
- FOLDER : i must select from which directory will program catch all this .txt files.

----------------------------------------------------------------------------------------------------------------------------------------------

IMPORTANT!! Software must send txt files to mysql base when file change. File must be bigger than 0kb.


if file name is [url removed, login to view] this goes to table -> live_b,
if file is [url removed, login to view] it goes to table ->type_b ,
if file is [url removed, login to view] it goes to table ->ranking_b ,
if file is [url removed, login to view] it goes to table ->startlist_b ,
if file is [url removed, login to view] it goes to table ->obavijest_b ,
if file is [url removed, login to view] it goes to table ->naslov_b

Why to _b? - > because, this page will be refreshed every ~ 1 sec, and user can get blank page.

Sending data to mysql database - Example table LIVE

1) if file is [url removed, login to view] TRUNCATE live_b table
2) INSERT INTO live_b
3) RENAME TABLE live TO tmp_live, live_b TO live, tmp_live TO live_b

Pictures of databases, txt files, and program window are attached to project.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online