In Progress

CSV data to website

Hello,

This would be all down using mysql/python/php/html5, on a linux machine.

I have a CSV file with around 400,000 entries of the following format: (We'll call this MAIN table)

name1, color, date created, notes

name2, color, date created, notes

name3, color, date created, notes

I would want a python script that can take the format above and import the data automatically into the given sql database. From there you'll use php/html5 to display back the data via web browser.

Some functionally includes, search & filter options (like filter by multiple names and color) & edit field (only for the note field).

There will also be another table with the format: (We'll call this external table)

name2 extra, text:text, text:text, text:text

name3, text:text

name2, text:text, text:text

name1, text:text, text:text

This external table will have different amounts of text:text per line, but it will all be seperate by a comma.

----------

With the MAIN table, if I click: “name2, color, date created, notes”

It will exapand and show contents of External table that has the same “name2” in it.

In this example, it will show like this:

name1, color, date created, notes

name2, color, date created, notes

name2 extra, text:text, text:text, text:text

name2, text:text, text:text

name3, color, date created, notes

and If I click name3 it should show like this:

name1, color, date created, notes

name2, color, date created, notes

name2 extra, text:text, text:text, text:text

name2, text:text, text:text

name3, color, date created, notes

name3, text:text

and If I click name2 again (while it's expanded):

name1, color, date created, notes

name2, color, date created, notes

name3, color, date created, notes

name3, text:text

-----------

Some notes:

-Displaying this much data in a web browser might crash it, if I can limit it to show only 50,000 per page.

-Have it look modern and have color (this is why I mention html5)

-I'll be adding data to the tables frequently, having a python script that can automatically add the new cvs data is needed.

Skills: HTML5, MySQL, PHP, Python

See more: website csv data feed reader, capture data website export csv, collect data user using flash file website, data miner download, how to display csv file on web page, extract data from webpage, extract data from website to excel, extract data from website online, csv to webpage, how to read data from csv file in html, data miner chrome extension, mysql, python, html5, crawl data website csv, csv data file dat file, csv data feed website, display csv data website, pull data website file csv, data website output csv

About the Employer:
( 0 reviews ) Canada

Project ID: #17501104

Awarded to:

rameshpizza

Hi, I am interested in this project. I'll be using python for backend, not PHP, all other stack remains as mentioned. Can we discuss further about this project. Thanks

$25 USD in 1 day
(5 Reviews)
3.1

11 freelancers are bidding on average $35 for this job

$25 USD in 1 day
(28 Reviews)
5.2
superbpartner

hi,dear. I understand your proposals and I am very interested in this job - 'CSV data to website'. I am senior software developer and I am able to perform this task in timely manner. HTML5, MySQL, PHP, Python, Plea More

$25 USD in 1 day
(5 Reviews)
4.0
jjmutumi

Hello, I have over 8 years experience writing software in Python. This can be done in Python. The CSV reader and filterable HTML view can all be done easily. You'll also need to split the import task to have faster More

$25 USD in 3 days
(3 Reviews)
3.5
ranahashim

Hi. I uderstand your project requirements. I have few questions about this project. Let's discuss more over chat.

$25 USD in 1 day
(10 Reviews)
3.3
origami07

Hello, I am a python web applications developer. Please notice my certifications and portfolio. I must have a milestone created and complete specifications sent to me before i can do anything at all. Kind Rega More

$100 USD in 3 days
(8 Reviews)
3.3
$25 USD in 1 day
(0 Reviews)
0.0
$17 USD in 1 day
(0 Reviews)
0.0
Sanju06r

Sir/Madam, I am professional web developer. I have been completely understood your task. Contact me for further discussion. Here is website link on which i have already been done this job. [login to view URL] More

$30 USD in 2 days
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
$66 USD in 6 days
(0 Reviews)
0.0