MySQL / PHP / WP-Admin Expert needed

Closed

Simple Database Model and WP-Admin pages to manage the data.

(Project completed in 7 days max)

What we need: *Additional information in attached document.

Custom Database and WP-Admin pages to manage data

1. Database/tables schema created to manage our Data Lists "we will provide example data file, also please see below for our list of rows for the primary table". Would be no more then ~ 3-5 tables but I leave it up to you experts to decide the best model.

2. Ability to manage our data from custom pages in wp admin. I see this as a tab in the WP Admin with a few pages or sub-items of the tab to perform the operations mentioned below (Import, Export, Reporting...)

3. Ability upload data lists and perform data associations "see the image at the bottom" - we will be able to explain in more detail and are open to recommendations. Our data list files for import will be large files between 5-100megs.

4. Ability perform Queries on the data list tables to pull targeted lists based on custom search criteria and have ability to export and save the data to comma delimited .csv files with max rows of 100,000 "so if 1,000,0000 rows returned then there would be 10 .csv files created". Would be optimal to export the files "if more then 1) to .zip file. The search functionality will need to have ability to perform Custom Select Statments or use a Search Box and Select Boxes to determine what to search the data by "I can provide specific information for this".

5. Ability to add IP/Domain and Email Addresses to a Blacklist Table in the Database and all queries will reference this to not include the record if the record has either a IP/Domain or an Email Address associated with the Blacklist.

6. WP Admin Page to display information/report about the Data in the Database (Total Rows of Data), (Last Import Performed), (Last Export Performed)

NOTE: Import/Export operations need to display information about the successful or errored rows during an import and or export.

i.e.:

• 1,000,000 rows imported

• 840,000 rows successful

• 160,000 rows failed to insert (Link to view error report)

Additional Notes:

1. Database needs to have certain fields verified before allowing an insert

• IP address and Domain “regex to validate domain and or IP” make domain standardized with “http://” i.e. "[url removed, login to view]" would become "[url removed, login to view]" and IP standardized.

• datetime would need to be a standard format for all data

2. Database needs to verify "upon data upload" the IP/Domain and Email Addresses against a blacklist table. Need a page to insert records into the blacklist manually. Do not want to pull any records that ip/domain is in the blacklist table.

3. Database model needs to be able to handle 100’s of millions of records and all queries need to be optimized for efficiency.

*Additional information in attached document.

Skills: Database Administration, MySQL, PHP, WordPress

See more: yahoo blacklist, wp experts, regex example, wp all import, wordpress mysql php, php regex, export mysql, email blacklist, blacklist ip, admin expert, wordpress upload error, import export project php, tab display php, report mysql php database, import wordpress large, wordpress mysql insert data, php upload file csv, php save data file, php add record mysql table, mysql add record, php tab php mysql, php table csv, php insert select, import csv data mysql, php list files

Project ID: #4591069

18 freelancers are bidding on average $545 for this job

lightcresent

Wordpress, HTML5 & CSS3 guru here, have expertise in doing stuff related to DB & WP-admin management along with custom plugin development... All payments through Milestone Payment (Escrow)... Online 16 Hours a day, Can More

$618 USD in 7 days
(481 Reviews)
8.9
denisCh

Hello, please check PM

$736 USD in 7 days
(65 Reviews)
7.5
madhavdutta

Hi I have 8 years of experience in WordPress Design and development. Please check my latest work.

$618 USD in 7 days
(77 Reviews)
7.5
rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$1000 USD in 3 days
(406 Reviews)
7.0
alinawaz88

Ready to start

$526 USD in 7 days
(111 Reviews)
6.9
OutsourceMan

Hello We would like to get opportunity to work with you and offer you the best. Thank you

$360 USD in 25 days
(80 Reviews)
6.8
DeamonBizz

We are expert in designing and development.Please check private message for sample work...

$342 USD in 15 days
(86 Reviews)
6.8
adityalivelife

hi, please find the attached private message of the work done ...Thanks!!!

$231 USD in 15 days
(141 Reviews)
6.4
TomsCustoms

Ready to start immediately. WP/PHP/MySQL expert

$1237 USD in 7 days
(24 Reviews)
5.9
MaTeMaTiKci

Let's do it!

$500 USD in 3 days
(60 Reviews)
5.6
hrarcon

Ready to work

$631 USD in 7 days
(7 Reviews)
5.2
mxicoders

Dear Potential Customers, We accept only few projects at a time so we can give our 110% input for complete satisfaction with our services. Now, we can start your esteemed project and finally , it is feasible for More

$463 USD in 7 days
(10 Reviews)
5.3
Voyageinfo

Dear Sir, We are in TOP 1000 among 7000000 freelancer in the world please check PMB. Thanks Voyage Team

$515 USD in 20 days
(16 Reviews)
4.8
evidcomm

Ready to start now..Many thanks..

$420 USD in 14 days
(14 Reviews)
4.1
CrimsonWeb

We are a quality web design and web development firm offering affordable services to our clients. We can complete the project in 20 days as we have an expert team of professionals with more than 8 yrs experience in the More

$578 USD in 20 days
(2 Reviews)
3.1
Harvardapps

We are two computer science majors at Harvard and we have a company called Crimson Coders. We develop websites and mobile applications. We have a team of 50 developers and designers who have 5+ years of experience. You More

$360 USD in 3 days
(2 Reviews)
2.8
popovicerik

I know we have no rating, we are new on Freelancer but have been in business for 8 years. I assure you we can do this.

$526 USD in 7 days
(1 Review)
2.0
jstechnosales

Hi, Greetings for the day! I am Mishil Patel, Business Development Executive & Consultant from Jstechno, a growing IT firm based out in India with offshore centers in Canada,UK and Australia. We came to receive yo More

$526 USD in 21 days
(2 Reviews)
1.0
micropixel1

This proposal is to express my interest in discussing your requirement . The requirement posted by you is a strong match for my well-rounded background.

$400 USD in 7 days
(0 Reviews)
0.0
rajanlama1

Ready to work....

$500 USD in 7 days
(0 Reviews)
0.0