Database on Steriods -- 2

$30-250 USD

In Progress

Posted

almost 9 years ago

$30-250 USD

Paid on delivery

I have approximately 75 large spreadsheets ("master lists") from anywhere to 30k rows to 1.5M rows of data (up to 250 MB) (all of which could be combined), which I need to cross reference on a daily basis with a new list of data ("daily list"). If I were to do this on excel, I would manually combine all of the master lists, then VLOOKUP three cells on the daily list and master list. Unfortunately, excel does not work due to the size of the files. I need a program created to match two fields from the daily list to the corresponding value in the large lists, and add if the matching fields in the daily list correspond with the 5-10 cells of data to each row of the daily list. I would like for you to create an SQL database ideally via PHPMyAdmin on my server, which would allow me with the capability of uploading the daily list as an input file, match 2-3 cells and download an output file consisting of the input file + 5-10 new cells. Please provide a cost estimate for development, and specifically address if there would be any on-going costs associated with the project. If you think that you have a different way at solving this problem, I am willing to listen.

MySQL

PHP

Software Architecture

SQL

Project ID: 8161939

About the project

11 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

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

11 freelancers are bidding on average $202 USD for this job

@m7slabs

A proposal has not yet been provided

$147 USD in 3 days

4.9

(122 reviews)

6.3

@ProProgrammerz

Hi, I am at home in PHP CSS, Database Systems, MySQL, AJAX and JS, you may see my recent work for details. The Design you proposed is really good and will be optimal. The CSV files can be written into a database in an automated way. Also you can add daily list as txt, csv or enter values manually. I can complete this task in 5 day, please contact me so that we may start.

$200 USD in 5 days

5.0

(32 reviews)

5.5

@zExcel

I can do that with a macro in Excel which will search all 2 or 3 million records in one go ...........................................................................................................................................................

$190 USD in 1 day

4.8

(23 reviews)

5.8

@nikmah344

Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. If you can afford SQL server Then I can provide you solution in SQL server with c#.net desktop application to meet your requirement And I 'll make sure you will get rid of excel. and daily activity you do on excel . I will create functionality in application with just click away. But its possible only with SQL server not with mysql. I am having 6+ years of experience in Web Development. I have worked on below technologies/languages/database server. - Asp.net,C#.net,Asp.net MVC - Linq to SQL,Entity Framework - Javascript,Jquery,KnockoutJS,AngularJS - Crystal Reports,DevExpress Reports - SQL server,SSIS Package,SSRS Reports - Facebook Graph API - Application Security Remediation - SVN,TFS I love working on SQL and query/sp optimization . I can achieve the results that you are asking for. We can discuss further on chat(Skype:mahajan344). Looking forward from your end. Thanks Nikhil Mahajan

$155 USD in 3 days

4.7

(28 reviews)

5.7

@basrimy

hi, the real challenge would be to export your master list to mysql. it will need custom script for it. then next job is the inferace of daily input and also records comparison. but this is doable. please reply to discuss more. basri

$233 USD in 7 days

4.9

(27 reviews)

4.7

@decester

A proposal has not yet been provided

$155 USD in 3 days

5.0

(4 reviews)

3.9

@ddpana

Hello. I am expert in scripting and automation. I have over 10 years of experience ! I can make you a program, multi-threaded, on Linux Server, that will work as follows : - you upload the file, no matter the size is - script will process the data - it will prompt you to download the final file. Without any database, this can be achieved. Flat 105 FEE , 1 day to complete. Thanks.

$105 USD in 1 day

4.8

(8 reviews)

3.2

@mudassarcs66

Hope, you are doing good. I found your job post and i am interested in your project. I as a focal person of Techinn Global want to introduce with my company. Our company provides services of Full Time dedicated developers. We have a pool of dedicated developers who works directly with clients. We have very talented and senior developers who have more than 5 years experience in Web Applications. So having such skill set, we are the right choice for you for this particular job. I think, if i create cron file which get input and if matches, update excel sheet. It will be a small web form which can do this trick. You only need to upload daily file there and program will automatically add matching data to large file. There is hardly any future development cost for this until requirement are changed

$277 USD in 3 days