
Repair problems & speed up response times for existing Contact Management System
- or -
Post a project like this2713
$$$
- Posted:
- Proposals: 11
- Remote
- #1865589
- Completed
PHP, MYSQL,ORACLE, WORDPRESS, AJAX, CSS, HTML, ANGULAR,NODE, CODEIGNITER, JAVASCRIPT, JQUERY, PAYPAL, API INTEGRATION

PHP | WordPress | Laravel | Magento | Python | CI | HTML/CSS | SEO | JQUERY | CSS3 | JAVASCRIPT
370948287359190040920674311938351372914194199518315411047858





Description
Experience Level: Expert
General information for the website: Online Contact Management System
Database management system (DBMS): MySQL
Kind of development: Customization of existing website
Description of requirements/features: We had a custom contact management system built 2 years ago. It worked alright, but over time became a bit slow. Now, it has suddenly just stopped working altogether, and shows erroneous data. We need a DB and programming expert to fix the problems on the site, and speed up the way it works.
The original system spec was as follows:
Allow user creation, delete, edit and user level (admin / standard) assignment.
The entire system will only be accessible to logged in users.
In terms of main functionality, system database consists of the following tables:
- Company
- Contact
- Contact History
- Industry
- Sector
- Country
- Languages
Country - Admins can add / delete / edit country names
Languages - Admins can add / delete / edit language names
Industry - Admins can add / delete / edit industry names
Sectors - Sectors are sub-sets of industry and each industry will have a number of sectors. Sectors shouldn't be duplicated across industries. All users can add sector names, but when users add sectors, they should be checked against duplication. Only admins can delete / edit sector names or place them under a different industry.
Company - Has a number of fields. Each company is linked to 1 country, multiple languages, 1 industry, multiple sectors. All users can add / edit companies. Only admins can delete a company. Each company can have 0 to multiple contacts. A company can have a direct contact history (in the case of 0 contacts) or contact history associated with each contact.
Contact - Each contact has a number of fields. Each contact may be linked to multiple companies, multiple sectors. All users can add / edit contacts. Only admins can delete a contact. Each contact can multiple contact histories associated with each company or as an individual.
Contact History - All users can add a contact history entry. Only admins and the user who added the entry can edit it. Only admins can delete a contact history entry. Each contact history entry is tied to a contact and/or company.
Reporting functionality:
1. Search for companies and contacts based on keywords. Filtering results by industry, sector, country and/or language. Users should be able to quickly export list of results to CSV
2. Admins should be able to run the following reports for each user:
(a) Contacts and companies added each month
(b) Number of contact history entries made each month. Filtering results by specific fields within the contact history
----------------------------------------------
Extra notes: All work must be fully hosted and installed on our servers.
We may not be able to provide full database access due to privacy and security concerns.
Database management system (DBMS): MySQL
Kind of development: Customization of existing website
Description of requirements/features: We had a custom contact management system built 2 years ago. It worked alright, but over time became a bit slow. Now, it has suddenly just stopped working altogether, and shows erroneous data. We need a DB and programming expert to fix the problems on the site, and speed up the way it works.
The original system spec was as follows:
Allow user creation, delete, edit and user level (admin / standard) assignment.
The entire system will only be accessible to logged in users.
In terms of main functionality, system database consists of the following tables:
- Company
- Contact
- Contact History
- Industry
- Sector
- Country
- Languages
Country - Admins can add / delete / edit country names
Languages - Admins can add / delete / edit language names
Industry - Admins can add / delete / edit industry names
Sectors - Sectors are sub-sets of industry and each industry will have a number of sectors. Sectors shouldn't be duplicated across industries. All users can add sector names, but when users add sectors, they should be checked against duplication. Only admins can delete / edit sector names or place them under a different industry.
Company - Has a number of fields. Each company is linked to 1 country, multiple languages, 1 industry, multiple sectors. All users can add / edit companies. Only admins can delete a company. Each company can have 0 to multiple contacts. A company can have a direct contact history (in the case of 0 contacts) or contact history associated with each contact.
Contact - Each contact has a number of fields. Each contact may be linked to multiple companies, multiple sectors. All users can add / edit contacts. Only admins can delete a contact. Each contact can multiple contact histories associated with each company or as an individual.
Contact History - All users can add a contact history entry. Only admins and the user who added the entry can edit it. Only admins can delete a contact history entry. Each contact history entry is tied to a contact and/or company.
Reporting functionality:
1. Search for companies and contacts based on keywords. Filtering results by industry, sector, country and/or language. Users should be able to quickly export list of results to CSV
2. Admins should be able to run the following reports for each user:
(a) Contacts and companies added each month
(b) Number of contact history entries made each month. Filtering results by specific fields within the contact history
----------------------------------------------
Extra notes: All work must be fully hosted and installed on our servers.
We may not be able to provide full database access due to privacy and security concerns.

Farhad D.
98% (51)Projects Completed
29
Freelancers worked with
24
Projects awarded
69%
Last project
17 Nov 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies