Develop a portal using drupal and third party CRM Package (1514742)

Description: To connect a web portal in drupal to a CRM package. The CRM package uses MSSQL and the schema for this database will be provided. The portal is where clients log in and can view details regarding their information with ourselves. They can edit the information. The PORTAL currently uses drupal as its framework and the form fields have already been built by myself, these are in standard html at present. The website is on a linux server, the CRM package is on an AMAZON cloud windows server. ## Deliverables **STAGE 1: ****Security and login:** The site must be 100% secure. We wish the login system to be: 100% secure, SSL is to be installed, the username will be the customers email address which will need to come from the CRM database. There is also a field for the password to come from the CRM database also. The passwords may be changed by the user and this should use the drupal account pages. **Page 1 ??" Personal details** The personal details page is in the attached screenshot. The data from the MSSQL database needs to show in the form fields. The database must be updated if this information is changed and submitted. One of the pages is attached as a screen shot. The portal forms must update the CRM . Layout and structure of the portal is to be reviewed by myself and the winning developer. **End of stage 1** Once this page is completed then we will sign off and start on stage 2/3/4 of the portal. This work will be on-going as we build our portal. I wish to develop a relationship so the next stages can be completed over the next 3 months. Stage 2/3/4: If stage 1 is successful then the portal will be extended on over the next months. The portal is to be cutting edge and a mobile app will also be needed in the future. This must be taken into account when developing stage 1. Stage 2/3/4 will include: Another 5 pages of data, Developing a mobile app An admin page for the users to select to receive email alerts, sms etc. An advanced contact email page with all previous correspondents showing Etc, etc. 1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement). 2) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 3) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Employer's environment--Deliverables must be installed by the Worker in ready-to-run condition in the Employer's environment. b) For all others including desktop software or software the employer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this project. ## Platform Amazon Server hosts the CRM package - Windows server Drupal website - linux server