{"type":"doc","content":[{"type":"paragraph","content":[{"text":"Background","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Microsoft SharePoint is a part of the Microsoft Suite cloud storage solution. You (as an administrator of both systems) may integrate SpeakUp data with your organization’s SharePoint. When done so, the system will automatically export SpeakUp data once a day to the specified folder in your SharePoint environment. The data is exported in a single xlsx file., with multiple tabs.","type":"text"}]},{"type":"paragraph","content":[{"text":"You can use this automatically updated export file to integrate the SpeakUp data with your own business intelligence tool (for example Power BI dashboard). ","type":"text"}]},{"type":"rule"},{"type":"paragraph","content":[{"text":"Who can do this?","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SpeakUp System administrator","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Microsoft Suite System administrator","type":"text"}]}]}]},{"type":"paragraph"},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Preparation on SharePoint","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open a notepad (or any other note taking software)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Go to ","type":"text"},{"text":"https://www.office.com/","type":"text","marks":[{"type":"link","attrs":{"href":"https://www.office.com/"}}]},{"text":" and click the 9 dots in the top left corner","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"SharePoint","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click the ","type":"text"},{"text":"site*","type":"text","marks":[{"type":"em"}]},{"text":" that you want the Export to be uploaded to","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Copy the complete URL of the site to the notepad","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Example: ","type":"text"},{"text":"https://[","type":"text","marks":[{"type":"link","attrs":{"href":"#"}}]},{"text":"mycompany","type":"text","marks":[{"type":"em"},{"type":"link","attrs":{"href":"#"}}]},{"text":"].sharepoint.com/sites/[","type":"text","marks":[{"type":"link","attrs":{"href":"#"}}]},{"text":"mygroupsite","type":"text","marks":[{"type":"em"},{"type":"link","attrs":{"href":"#"}}]},{"text":"]/","type":"text","marks":[{"type":"link","attrs":{"href":"#"}}]},{"text":" ","type":"text"},{"text":"(Note: nothing beyond this value","type":"text","marks":[{"type":"em"}]},{"text":")","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"This URL will be referred to as the ","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Go to /_layouts/15/appregnew.aspx","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Example: ","type":"text"},{"text":"https://[","type":"text","marks":[{"type":"link","attrs":{"href":"#"}}]},{"text":"mycompany","type":"text","marks":[{"type":"em"},{"type":"link","attrs":{"href":"#"}}]},{"text":"].sharepoint.com/sites/[","type":"text","marks":[{"type":"link","attrs":{"href":"#"}}]},{"text":"mygroupsite","type":"text","marks":[{"type":"em"},{"type":"link","attrs":{"href":"#"}}]},{"text":"]/","type":"text","marks":[{"type":"link","attrs":{"href":"#"}}]},{"text":"_layouts/15/appregnew.aspx","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Here you are going to register a new Sharepoint app; follow the steps as shown in the screenshot below: ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":45.0},"content":[{"type":"media","attrs":{"width":304,"id":"e3a96f9e-7a3a-4fe9-b378-a5a1822ead7b","collection":"contentId-3359899669","type":"file","height":112}}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click the ","type":"text"},{"text":"Client Id Generate","type":"text","marks":[{"type":"em"}]},{"text":" button, wait for the site to generate an Id and copy this to the notepad; this value is the ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click the ","type":"text"},{"text":"Client Secret Generate","type":"text","marks":[{"type":"em"}]},{"text":" button, wait for the site to generate an Id and copy this to the notepad; this value is the ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a title for the SharePoint App; this is only for your reference and SpeakUp will not use this.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The App domain is ","type":"text"},{"text":"www.speakup.com","type":"text","marks":[{"type":"link","attrs":{"href":"http://www.peopleintouch.com"}}]},{"text":" ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The redirect URL is ","type":"text"},{"text":"https://www.speakup.com/default.aspx","type":"text","marks":[{"type":"link","attrs":{"href":"https://www.speakup.com/default.aspx"}}]},{"text":" ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Create","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"When the app was successfully created the page will display a summary of the information; please see an example below: ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":50.0},"content":[{"type":"media","attrs":{"width":245,"id":"a6a9faec-de17-44c3-9fcc-4e4a06f73cc0","collection":"contentId-3359899669","type":"file","height":64}}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"To grant permission to your app, go to /_layouts/15/appinv.aspx","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Example: ","type":"text"},{"text":"https://[","type":"text","marks":[{"type":"link","attrs":{"href":"#"}}]},{"text":"mycompany","type":"text","marks":[{"type":"em"},{"type":"link","attrs":{"href":"#"}}]},{"text":"].sharepoint.com/sites/[","type":"text","marks":[{"type":"link","attrs":{"href":"#"}}]},{"text":"mygroupsite","type":"text","marks":[{"type":"em"},{"type":"link","attrs":{"href":"#"}}]},{"text":"]/_layouts/15/appinv.aspx","type":"text","marks":[{"type":"link","attrs":{"href":"#"}}]}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Get the ","type":"text"},{"text":"App Id","type":"text","marks":[{"type":"strong"}]},{"text":" from the previous steps and paste it in the ","type":"text"},{"text":"App Id","type":"text","marks":[{"type":"em"}]},{"text":" field","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on the ","type":"text"},{"text":"Lookup","type":"text","marks":[{"type":"em"}]},{"text":" button and wait for the site to fetch all your App details","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Copy & Paste the following XML in [Permission Request XML] textfield:","type":"text"}]}]}]},{"type":"codeBlock","content":[{"text":"\n\n","type":"text"}]},{"type":"orderedList","attrs":{"order":18},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Create ","type":"text","marks":[{"type":"em"}]},{"text":"and then ","type":"text"},{"text":"Trust It","type":"text","marks":[{"type":"em"}]},{"text":" when the site asks you if you trust the app","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":30.0},"content":[{"type":"media","attrs":{"width":185,"id":"3d6ea753-53b6-440a-b483-e356085a799e","collection":"contentId-3359899669","type":"file","height":88}}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Go to /_layouts/15/appprincipals.aspx","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Example: ","type":"text","marks":[{"type":"em"}]},{"text":"https://[","type":"text","marks":[{"type":"link","attrs":{"href":"#"}}]},{"text":"mycompany","type":"text","marks":[{"type":"em"},{"type":"link","attrs":{"href":"#"}}]},{"text":"].sharepoint.com/sites/[","type":"text","marks":[{"type":"link","attrs":{"href":"#"}}]},{"text":"mygroupsite","type":"text","marks":[{"type":"em"},{"type":"link","attrs":{"href":"#"}}]},{"text":"]/_layouts/15/appprincipals.aspx","type":"text","marks":[{"type":"link","attrs":{"href":"#"}}]}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"From the app with the name you’ve just created, copy the App Identifier and paste in the notepad; copy the part after the “@” to the notepad and mark as ","type":"text"},{"text":"","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Decide which folder within your SharePoint site the data exports should be uploaded to; if the folder does not yet exist, make sure to create it now","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Example: In the site, go to Documents and create a folder named “SpeakUp Exports”.","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Go to the ","type":"text"},{"text":"SpeakUp Export - SharePoint Integration","type":"text","marks":[{"type":"strong"}]},{"text":" page and fill the following information in the textboxes:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SharePoint Url","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"This is a part of the , but only the part between https:// - and - .sharepoint.com/","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Example","type":"text","marks":[{"type":"underline"}]},{"text":": ","type":"text"},{"type":"hardBreak"},{"text":"If your = ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://mycompany.sharepoint.com/sites/mygroupsite/"}},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":"then the SharePoint Url = mycompany","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SharePoint Group","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"This is a part of the , but only the part after “/sites/” and without any final “/”","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Example","type":"text","marks":[{"type":"underline"}]},{"text":":","type":"text"}]},{"type":"paragraph","content":[{"text":"If your = ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://mycompany.sharepoint.com/sites/mygroupsite/"}},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":"then the SharePoint Group = mygroupsite","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Application (Client) ID","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"This is the generated that you stored in the notepad","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Secret Value","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"This is the generated that you stored in the notepad","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Directory (tenant) ID","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"This is the generated that you stored in the notepad","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Export Folder","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The Export folder starts with “Shared Documents” and, depending on the folder you chose in step 23, the path may for example be: Shared Documents/SpeakUp Exports or, Shared Documents/SpeakUp/Automatic Exports","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":865,"id":"697aec18-095c-4f32-a74e-5f3768031b6a","collection":"contentId-3359899669","type":"file","height":723}}]}]}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click save and wait for a confirmation; upon successful integration, an export is created immediately and from then on once every day","type":"text"}]}]}]},{"type":"paragraph"}]},{"type":"paragraph"},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Good to know","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"What data is exported?","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"All data is exported except the communication with the reporter. ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"(Note: Timestamp in metadata is UTC+0)","type":"text","marks":[{"type":"em"}]}]}]},{"type":"paragraph"}],"version":1}

Browser not supported