In Progress

Build an SQL database that auto-updates

I would prefer to be contacted before revealing too much. But in a nut shell, I have a lot of flat files (text files) in various folders. These folder names need to be primary keys or ids that will link multiple tables together. These tables will be composed of data from the text files. So the data from a text file from each folder will form one row of a table. Each text file will have its own table and all these tables are to be linked together based on the primary id, i.e, the folder name. There needs to be a script that auto-updates the tables or populates every hour or whatever in order to make sure that data from new folders also make it into the database.

Skills: MySQL, PHP

See more: nut, mysql to sql, build database sql, mysql flat file, link sql, shell script mysql, script auto mysql, mysql shell script, script auto database, script sql table, link sql database, order database table form, sql multiple tables, build rule engine database sql server, shell php mysql, auto file name, mysql row order, php form sql database, script php auto text, script php auto, sql database tables, form sql database, build form mysql, link tables mysql, auto order script

About the Employer:
( 1 review ) charlotte, United States

Project ID: #5038432

Awarded to:

suraj99p

I am expert in databases. I have created ER model for my company. I can do this task. Which database we are planning to use, for eg MySql/Oracle/MS Sql or any other? I would like to go through all the data, so that I c More

$250 USD in 7 days
(7 Reviews)
4.3

23 freelancers are bidding on average $427 for this job

buraqtech

1. Saleaday Site We recently compeleted an amazon aws apis based online ecommerce site in which we are fetching the products live from amazon by using its apis and displaying on site with custom shopping cart function More

$747 USD in 22 days
(85 Reviews)
7.9
zainy01

Hi! I'm interested in it, the requirements are pretty descriptive, we can detect the change in textfile by the file (Updated Date) so we don't need to put each file in every run and we have to run a cron for scheduling More

$515 USD in 5 days
(62 Reviews)
7.1
zeke

Dear Customer! I am an expert PHP developer with over 6 years of experience and very interested to work on this project. Available to start immediately and finish as soon as possible. My bid is for fast professional s More

$515 USD in 10 days
(165 Reviews)
7.0
netxpertindia

Hi, I am interested to create this system to manage your files in sql. I need more details with some sample files so that i will review and able to give better time, cost and other details to perform this project. More

$388 USD in 5 days
(88 Reviews)
6.8
sainathkohta

Hello Sir, I am from Confianza Technologies. I have gone through your requirements. We have developers who have vast experience in required technologies. We are interested in your project, but before finalizing budget More

$750 USD in 15 days
(40 Reviews)
6.6
SICS

Hello, Could you please provide a detailed description regarding project? Do you have any time frame for the project? Can we have a discussion? We are an ISO 9001-2008 certified [url removed, login to view] are very good in mob More

$2061 USD in 30 days
(31 Reviews)
6.5
AlGordo

Hello, I am experienced with PHP and MySQL. Budget is lowest, $250, long-term support is included. Some more details about the files quantity and content (samples?) would be helpful. I can help you setup a cron job t More

$250 USD in 7 days
(40 Reviews)
6.0
dinastalb

Hello, I am John Profit. I work with my partners Marlen and Van at Netronian Inc., in Orlando, Florida. We have great experience with Magento. 80% of our developed websites are Magento websites. We are the masters More

$6183 USD in 30 days
(15 Reviews)
5.9
virtual7

It can be done. But I am not sure it will be good to scan all folders and files in order to find changes. Especially if there are many files. There must be some way to let a script know what files have been changed More

$421 USD in 5 days
(49 Reviews)
5.6
techvolcano

Hi, We do have solid experience in file parsing and database development. Looking forward to hear from you. Thanks.

$260 USD in 5 days
(81 Reviews)
5.6
webdevt

Hello. I understand exactly what you need and i can write the script fast. It will be started with a cronjob on a time basis you want and will auto-updates the mysql tables according to the folders and text files. I More

$250 USD in 3 days
(42 Reviews)
5.2
elboukharimu

Hi, I'm very interested helping you creating your database, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some sample More

$368 USD in 10 days
(20 Reviews)
4.8
expertcoder1vw

Hi, I'm an expert database designer and developer and have recently completed a similar job as a Windows desktop database application for another client. Based on your requirements, I can customize it to handle your i More

$336 USD in 5 days
(11 Reviews)
4.5
linuxstudios

Hi, I have written similar scripts (but not precisely as you describe) that recursively navigates a folder tree and collects up data in txt/csv/etc files and dumps it into MySQL. I also have recent, extensive experi More

$736 USD in 7 days
(9 Reviews)
4.4
santosoftvw

Dear Customer, I have experience in CRON Job, Windows Task Scheduler, writing Shell Scripts i.e. .sh files, writing batch files. I am also experienced in Mysql and PHP. I can do your job successfully. Thank you.

$250 USD in 5 days
(9 Reviews)
4.2
VRWebSolutions

VRZ Solutions prides itself for being instrumental in developing global Internet based presence for many small and large businesses. The teams of professionals at the helm of affairs in our company have already c More

$371 USD in 16 days
(2 Reviews)
4.0
DrMDodd

I have over 8 years experience programming in .NET and if you look one of my previous projects: [url removed, login to view] I have almost done e More

$555 USD in 3 days
(2 Reviews)
4.0
FernandoCanizo

Hello, can you please attach some sample text files? You said: "...Each text file will have its own table...", I think you mean each *kind* of text file, did you? Anyway, I'd like to see exactly what you need do More

$555 USD in 30 days
(6 Reviews)
3.8
RoseOffice

Dear sirlotoflance, I am very pleased to provide you an innovative solution for your project. I will provide you a PHP script to brows the tables, and another script to run as a cron job to update the database perio More

$250 USD in 14 days
(11 Reviews)
3.8
sunshinelabs

Hello! I am American, live in NYC, have a day job, and need extra projects (which is why I'm on this site). I'm free to talk on the phone at any time as well! I have been building .NET and MSSQL projects and systems More

$283 USD in 3 days
(5 Reviews)
3.6