Problem
Creation of Survey,
Requirement is we should replace 2 slides in ppt with existing survy and there are 13 questions in excel file we should replace them with existing 11 questions
Solution
For this case user has given ppt and excel file and based on these files we should do modification to existing survey
We should copy the existing project “Risk AssesmentsLC 2015” and name new copy as
“Risk AssesmentsLC 2016”
- Open the project “Risk AssesmentsLC 2016” in block 1 there is one slide we should replace this with given 2 slides
Take screen shot of first slide in ppt and save it in on desktop and do same for second slide as well
In survey click on block 1 click on slideà select option Rich content editor
Select option Insert graphic
Select option upload new graphic
Click on choose file option and locate your file saved in desktop and click on save
First slide will be inserted, do the same for 2nd slide screen shot as well
Delete Note content in red color “2lines”
replace 11 questions with 13 questions given in excel sheet
Click on question, edit/replace question with excel sheet question, do the same for all 13 questions
Note: we have to add 2 more rows here, as there are only 11 rows, for this click on question and press enter, one row will be added
Finally we should check for triggers, because after filling the survey once user submits it, email will be triggered on to user saying that survey is completed and will show all 13 questions
For this click on ToolsàTriggersàEmail Triggers
Click on the link displayed in above screen shot:
Change the sentence 11 risks to be assessed as “13 risks to be assessed”
Delete first question and click on {a}
Select Survey questionàsearch for survey questions and click on first question
We will get first question as ${q://QID8/ChoiceDescription/11}
Follow same for all 13 questions
- Here only 11 rows are available, so we should add 2 more rows for this right click on last row and select option row-->insert row after
For Impact and Level of control columns, no need to modify first 11 rows, we have to create last 2 rows
Copy previous row: ${q://QID8%231/ChoiceGroup/SelectedAnswers/20}
In a note pad, copy question 13 link in notepad: ${q://QID8/ChoiceDescription/38}
Modify this code as per the previous row
${q://QID8%231/ChoiceGroup/SelectedAnswers/38}
- Paste this modified code to 12th row in Impact column
Do the same for Level of control column as well
After completing, click on save triggers, then click on preview survey
Get feedback from user, if everything is fine then we should send actual survey link to user
Procedure to get actual survey link:
Select Distributions from menu option and click on Anonymous link, copy this link and send it to requested user
For getting extraction link, please follow below procedure
https://wiki.solvay.com/pages/viewpage.action?pageId=22620108
get extraction link from above wiki page:
https://survey.qualtrics.com/WRAPI/ControlPanel/api.php?API_SELECT=ControlPanel&Version=2.5&Request=getLegacyResponseData&Labels=1&User=[User]&Token=[API Token]&Format=HTML&SurveyID=[SurveyID]
replace [user] with cgi user id Cgi-support@solvay.com
replace [API Token] with API token
replace [SurveyID] with Survey ID
How to get API token:
On right corner click on dropdown menu and select Account settings:
Select Qualtrics IDs-->Right side is API token and Left side is Survey ID
In this case actual link is:
https://survey.qualtrics.com/WRAPI/ControlPanel/api.php?API_SELECT=ControlPanel&Version=2.5&Request=getLegacyResponseData&Labels=1&User=Cgi-support@solvay.com&Token=3UIUw7WuFS9uE3PRzdlkmVg13MMbRKiCNBTXa2kt&Format=HTML&SurveyID=SV_6qZklbFvzBgDaoB














