Challenge Overview
Welcome to Project Atlas! In this series of challenges we will be building out a Sharepoint 365 Add-in which will track various contacts and how they respond to surveys completed in SurveyMonkey. Here at Topcoder we get a lot of requests for Sharepoint challenges, so with some good submissions you can expect to see more challenges like these coming in the future.
Requirements
In this challenge we are looking for you to build an Import Tool for fetching the data from a spreadsheet (attached in forums) and importing it in Sharepoint 365.
These surveys will be done using SurveyMonkey. The import tool needs to load the results from the excel into the following tables - Contacts & Surveys. Please refer to the provided spreadsheet for the field definitions.
Data Model
Create the following Lists and data columns on those lists:
Contact
First Name (Text)
Last Name (Text)
Email Id
Organization (Lookup to Organization List)
Readiness Index (Choice list - 1,2,3,4,5)
Willingness Index (Choice list - 1,2,3,4,5)
Survey
Experience in Years (Number)
Tenure (Number)
Aptitude (Choice list - 1,2,3,4,5)
Proficiency (Choice list - 1,2,3,4,5)
Technology Proficiency (Text)
Email_Notification (Bool)
Website_Notification (Bool)
Poster_Notification (Bool)
Wordofmouth_Notification (Bool)
Other (Bool)
Not_Received_Notification (Bool)
Informed (Choice list - 0,1,2,3)
Trained (Choice list - 0,1,3,5,10, 15)
Prepared_Hw_Sw (Bool)
Prepared_Some_Steps (Bool)
Prepared_All_Steps (Bool)
Prepared_Profile (Bool)
Prepared_No_Action (Bool)
Sentiment (Choice list - 1,2,3,4,5)
Leadership_Engager (Choice list - 1,2,3,4,5)
Perceived_Value (Choice list - 1,2,3,4,5)
Perceived_Urgency (Choice list - 1,2,3,4,5)
Perceived_Organisation (Choice list - 1,2,3,4,5)
Perceived_Benefits (Text)
Perceived_Challenges (Text)
Comments (Text)
Import Rules
The business rules for import are as follows
Ignore any blank rows
Use Email id as the unique identifier - if the contact with an email already exists, associate the survey with that contact. Else, create a new contact and associate the survey information with it
Ignore any surveys with invalid data, log all such information in a log file
At the end of the import process, show the result of the import process (success/failure)
API Reference
Please refer to the Sharepoint Online API reference
Developing for Sharepoint 365
In order to develop add-ins for the cloud version of Sharepoint 365 you will need a developer environment. You have a few (free) options listed at this URL: https://msdn.microsoft.com/en-us/library/office/fp179924.aspx
If you do the 30-day trial, you can ask for an extension by emailing Microsoft at the address they provide.
Please let us know if you are having environment issues as it can help us plan for future Sharepoint add-in challenges.
Final Submission Guidelines
Final Submission Guidelines
- The Add-in, meeting the requirements above (Visual Studio project files)
- Document consisting of full configuration, deployment and verification information.
- A video demonstrating the installation and use of your add-in
- Winner will be required to raise a merge request to our repo