进行中

Database on Steriods -- 2

I have approximately 75 large spreadsheets ("master lists") from anywhere to 30k rows to [url removed, login to view] 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, 软件构架, SQL

查看更多: my sql create database, database development cost, cost for database development, server client download app, freelancer server cfg download, requirements sql database windows sharepoint server installation, office communication server sdk download, freelancer server operator download, create database primavera sql server 2005, configure database primavera dtabase server

About the Employer:
( 18 reviews ) United States

项目ID: #8161939

已悬赏给:

salain

Hi, I am interested in your project. Do you need protection for this script (user login)? Do you need design /template ? Is your daily file in a standard format ? Do you need the result file to be cleaned up le 更多

$222 USD 在5天内
(31条评论)
4.9

13名威客为此工作的平均竞标价是$195

diastark

Hello sir/madam , We have good experience of PHP,JOOMLA,HTML,HTML5,CSS, Ajax,jquesry,JavaScript,Mysql, Graphic Design,Website Design, Android, mobile application,Photoshop, Banner Design ,Flayer mail,Logo Design, 更多

$368 USD 在7天内
(59条评论)
5.3
zExcel

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

$190USD 在1天里
(15条评论)
5.2
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 更多

$200 USD 在5天内
(24条评论)
4.9
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 dis 更多

$233 USD 在7天内
(20条评论)
4.1
neatsoft

You have chosen the right way to solve the problem. Creating of micro-site will save you from having to configure anything on your desktop, all the necessary features will be implemented on the server. If you already 更多

$99 USD 在3天内
(5条评论)
4.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 dev 更多

$277 USD 在3天内
(1条评论)
2.9
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 更多

$155 USD 在3天内
(11条评论)
3.1
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 s 更多

$105USD 在1天里
(6条评论)
2.8
m7slabs

A proposal has not yet been provided

$147 USD 在3天内
(9条评论)
2.8
decester

A proposal has not yet been provided

$155 USD 在3天内
(2条评论)
2.7
UPitcs

The excellency to understand your requirements and expertise in the requirement you need for your project is all we have as a complete package. We as a team , completely understood your requirement and are completely 更多

$222 USD 在7天内
(0条评论)
0.0
yuriytigiev

A proposal has not yet been provided

$167 USD 在30天内
(0条评论)
0.0