I need software that will send txt files into mysql database.
Explain:
Picture [login to view URL] :
- 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 [login to view URL] this goes to table -> live_b,
if file is [login to view URL] it goes to table ->type_b ,
if file is [login to view URL] it goes to table ->ranking_b ,
if file is [login to view URL] it goes to table ->startlist_b ,
if file is [login to view URL] it goes to table ->obavijest_b ,
if file is [login to view URL] 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 [login to view URL] 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.
10+ years experience. 500+ projects completed successfully. I have done similar projects many times. Please check my reviews for a recent project where I did exactly as per your needs. I am ready to start work on your requirements ASAP.
Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)
I have 4 years of working in Java, My Sql and oracle database. I have been working with Oracle for last 4 years, which is a database company. I can provide a very efficient solution for this. Let me know, if we can work together.