Custom module for SugarCRM 5.0 /info@hand 5.3
This project consists of 3 phases and we are looking for a group or individual that has worked with custom SugarCRM/Joomla/PHP/MySQL development in the past and someone that knows the SugarCRM system.
The project is to create a zip code table import module and a School Locator table import module. We need to have the ability to import updated zip code and schools data into the system from time to time. Access to this will be restricted to the administrator. Then utilizing these tables create a new module/tab that will allow our sales reps to perform different queries based on the table data. One such script would allow users to enter a zip code then select a mileage radius and see all of the schools within this radius. Other scripts will include showing schools within a city, county, state, as well as parameters such as state,city, or zip and average household income as the selection criteria. I have a list of the different search criteria. I will provide the table data in a CSV or Excel format and the import function must import the same file layouts. We will also need to have the ability to export query results to a CSV file (admin only, same tab as the import functions). The zip code data is from [url removed, login to view], Business Database Version. Here is a link to sample code for the scripts that might help. [url removed, login to view]
** In this phase the schools will be in their own table, in the next phase if the school becomes a lead it will be moved to another table. **
I can provide table layouts for the zip code and schools data and will want feedback as to how this data will relate to the SugarCRM leads & contacts for future plans.
Please include your available start date/time with your bid as we are looking for someone to start right away. After this project is completed we have some additional customization that you can also work on as well. If you are a company that has more than one individual that can work on this project to get it completed faster please note that in your bid.
**** Please only bid if you have worked with the SugarCRM system in the past and understand it's database structure. ****