Data entry and reporting UI

I need to be able to cut and paste data from a website table into a simple UI to save it to a database table (master list), and then be able to get access to this data via a simple reporting interface.

You can see from the screen shot what the copy/paste data will look like. I can cut and paste the text from the page, but from there I need to be able to put it into a web application that allows me to save the following data.

1. Email Address

2. IP address

3. Date

4*. Viewed ID (can be disregarded)

5. Http Device (user agent string)

6. City

7. State

8. Zip Code

9. Country

As for #5 above, I would like to record the user agent string verbatim but have its value parsed and interpreted when displayed in any of the reports (as desktop or mobile).

Other UI Needs:

1. I need to be able to create specific list segments. (Financial, Health, Credit). These will be selectable in a multi-select dropdown list when importing each new batch of copy/paste data.

2. Scrub duplicate email addresses from each list when importing.

3. I need to be able to export data, by segment, in a TXT format

4. I must be able to filter and export data based on filtering by different variables. For example, Michigan only; Health segment and Michigan; Finance segment only, etc.. Giving me many different options on how I want to export the data.

5. The ability to search for an email in the mater list (across all segments) to permanently remove it. The email search and removal feature should have a default option of adding the email to a 'suppression list' which prevents that email from being imported (for any segment) again in the future.

Should be built in OO PHP using MVC format. Needs to work with PHP5.3 and MySQL 5.5. Feel free to use jQuery for UI components.

See attachment for copy/paste data format.

Habilidades: MySQL, PHP

Veja mais: ui reporting, simple reporting, segment table example, php 7 mvc, mysql data access, jquery mobile ui, how to get into data entry, how to get data entry work, free data entry website, email list scrub, duplicate data entry, data entry table, Data entry in mobile , data entry device, data access interface, country state and city database mysql, batch data entry, ui-date, mysql ui, jquery ui mobile, desktop ui, how to get an agent, search removal, mysql dropdown, multi agent

Acerca do Empregador:
( 30 comentários ) Sunnyvale, United States

ID do Projeto: #4594440

Concedido a:


Hi, I can help you to import the data into a database and create a UI for you to show/filter data. If the data have a constant representation form like a table(as in the attached image), we can write an a script to ext Mais

$277 USD em 10 dias
(55 Comentários)

4 freelancers estão ofertando em média $319 para esse trabalho


Interested! Please check PM for details of my bid. Thanks...

$250 USD in 7 dias
(25 Comentários)

I am ready to start this project....

$473 USD in 7 dias
(15 Comentários)

Dear Sandaami.. I'm happy to help you on this project. Kindly send me some more information in PM. Thanks - Faiz Rasool

$277 USD in 3 dias
(0 Comentários)