{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Portal FAQ"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Portal FAQ","index":0,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[[27,0,37,0]]}
["Computer Settings "]
[null,"Is the Operating System is Windows 7/10?","Your operating system information can be found by selecting: \"Control Panel\\System and Security\\System\". The portal works better on windows machines with version 10."]
[null,"Display Settings to be 1440 *768 and above  ( for example 1920 * 1080 is also works well as the resolution is better than the recommended resolution for portal","This can be verified in Display Settings --> Resolution"]
["Connectivity"]
[null,"Is the computer connected to internet ( WiFi / Wired) ?","This can be easily verified by browsing any of the sites like Google/Yahoo. The portal will work only when there is a good internet connectivity. Verify the wired connectivity or wifi connectivity using the troubleshooter"]
[null,"Internet is available yet portal is not accesssble. Check on the firewall settings if the portal is allowed in the network?","Check with the network administrator that the portal url is not blocked by network team for security reasons."]
[null,"Portal is giving the error message \"If you continue to experience this issue please contact us via email or phone: DevelopmentOperations@scottishwater.co.uk \n0800 389 0379 \"","A possible reason could be that Scottish Water domain services are temporarily unavialable. Check with the internal IT team for further information"]
["Browser Settings "]
[null,"Ensure the browser used is Chrome 78 and above /Internet 11 and above/Firefox 70 and above","Testing on lower/older versions of the browsers or other browsers  not listed may result in incompatible behavour. Please install the latest version of the browsers mentioned for better user experience "]
[null,"Ensure that the browser zoom level is 100% and browser window is maximized"," Press Ctrl + 0 to make the zoom level to 100%. (Ctrl + '+' and '-' can be used to zoom in and out on a page)"]
[]
["Registration/Login","Are you registered with portal? ","If you have not registered yet: please click on \"Sign in or register for an account\"/\"Sign in\"  link  which redirects to Registration / Sign In page and then click on \"Sign up now\" and provide your details for registration."]
[null,null,"If you have registered: please click on \"Sign in or register for an account\"/\"Sign in\"  link  which redirects to Registration / Sign In page. If  you registered as \"Developer/Individual/Licensed Provider/Agent\"  use this sign in option to log in to the Portal. Use the 'Planning Authority' sign in option if you are a \"Planning Authority/ Local Authority\" user. "]
[null,"Invited user/ got any mail from Scottish Water Developer Service?","If yes, please click on \"Sign in or register for an account\"/\"Sign in\"  link  which redirects to Registration / Sign In page and then click on \"Sign up now\" and provide your details for registration."]
[null,"Your account is inactive?","Your account does not have access to the portal. Please contact Scottish Water on 0800 389 0379 for further information."]
["Decoding Portal Error Messages","Portal is fetching data from cache and your new data are not populating on screen?","Delete cache & history of your browser, reload the page by pressing Crtl+F5 and login again.\nYou can press CTRL+Shift+Delete of any browser to navigate to browser cache & history. \nInternet Explorer (IE): Click on Delete                                                                                  Chrome: Click on Clear data                                                                                                Mozilla Firefox: Click on Clear Now "]
[null,"I am not able to upload the file from Portal and am provided with a warning message “Apologies, the folder that you are attempting to upload is currently being created, please wait and try again shortly. If you continue to experience issues please contact us.”","Wait for some time before uploading any documents, this is a rare event. The Azure Logic App takes time to create a folder when a new case is created in Dynamics CRM which may cause this issue.  Click on \"Try again\" to upload the files.  If you continue to experience issues, please contact Scottish Water on 0800 389 0379 for further information.”"]
[null,"I logged in successfully and was idle for some time in the Portal and am now getting the warning message \"You will shortly be logged out due to inactivity. Do you wish to extend your session?\"","Click \"Yes\" to resume your session and continue to access the Portal. Click \"No\" to logout from the Portal. You will be automatically logged out from the Portal if you have not responded to this message within 5 minutes."]
[null,"I am getting the warning message \"Apologies – we have been unable to process the data you have provided. Please check the values of any data provided and try again.\"","You are trying to submit some invalid data or are missing required data in the specified format. Try to resubmit the data by clicking on \"Try again!\" button. Click on \"Home\" button if you continuously getting the same message and try to access the same case again."]
[null,"I am getting the warning message \"Apologies – you are not authorised to access this page or your session has expired, you will now be redirected to the log in screen.\"","You are trying to access Portal pages without being logged in or your logged in session is expired. Click on \"Okay\" button to login to Portal."]
[null,"I am getting the warning message \"Sorry, an error has occured, requested page access denied!\"","You are trying to access a Portal page which your account doesn't have access permission for. Clicking on \"Okay\" will be redirect you to the access denied page. Clicking on \"Developer Service Portal\" will redirect to Portal Home page and clicking on \"Contact us\" will take you to contact us page and there you can submit your queries if you think this is an error. Remind customers of the 'role' types for each case as this may be a factor which prevents access."]
[null,"I am getting the warning message \"Sorry, we couldn’t find the page you’re looking for.\"","You are trying to access a page which is not part of the Portal pages and has not been found. You will be redirected to \"Page not Found\" page by clicking on \"Okay\" button. "]
[null,"I am getting the warning message \"Sorry – you are trying to access a previously submitted page. If you need to make amendments please contact your assigned advisor. You will now be redirected to the dashboard.\"","You are experiencing this warning message whenever you try to access a previously submitted page by using browser Back/Next button or using a bookmarked url. You don’t have permission to modify the application which has already been submitted.  If you need to make amendments please contact your assigned advisor. You will now be redirected to the dashboard.\" "]
[null,"I am getting the warning message \"Apologies – we are experiencing technical difficulties and have been unable to process your request, please try again.\"","You will get this warning message whenever we experience some technical difficulties trying to submit or respond to your request. Try to resubmit the data by clicking on \"Try again!\" button. Click on \"Home\" button if you are continuously getting the same message and try to access the same case if it is an existing one or submit a new case."]
[null,"I am getting the warning message \"Apologies – you are not authorised to access this page, you will now be redirected to the log in screen and sign in with the appropriate accounts.\"","You will get this warning message whenever you try to Sign in using the wrong route on the Portal login screen. Use the \"Signin\" option under \"Planning Authority\" if you registered as \"Planning Authority/Local Authority\"  or use the \"Signin\" option under \"Developer/Individual/Licensed Provider/Agent\" if you registered as \"Developer/Individual/Licensed Provider/Agent\"."]
[null,"I am getting the warning message \"Apologies – we are experiencing technical difficulties and this page is currently unavailable, please try again later.\"","You will get this warning message whenever Scottish Water Developer Service Portal website is temporarily unavailable. Clicking on \"Okay\" will redirect to \"Service temporarily unavailable\" page and click on \"Refresh\" button to reload the page. If you continue to experience this issue, please contact us via email: DevelopmentOperations@scottishwater.co.uk or or phone: 0800 389 0379."]
["CRM Request Limitation Error Message","I am getting the warning message \"Apologies – we have been unable to process the data you have provided. Please check the values of any data provided and try again.\"","You will get this warning message when we experience some technical difficulties with exceeding the CRM request limit. The system can only deal with a limited number of requests at any given time. Try to resubmit the your data by clicking on \"Try again!\" button or \"Home\" button after 5 minutes. "]
["Useful Tips for using the Portal","When should customer use ‘request a meeting’ and when to use ‘construction schedule’ in terms of visits to site ?"]
[null,"What are the 2 tabs on the home dashboard?","there are 2 tabs on the home dashboard – one for sites and activities and one for enquiries"]
[null,"How do I view the list of the related applications?","the home dashboard will display a list of sites for which they have submitted applications. They then click on the site record to view the list of related applications, with the most recently updated appearing at the top"]
[null,"How do I refine my search results?","you can use the search bar at the top and apply filters on the dashboard to refine results – e.g. by application type, team (whether submitted by you personally or others in your organisation), and case status. "]
[null,"What does individual contact names mean? E.g case manager, end customer ","Use this link (Appendix 1 - Roles) to see screenshot and find out more information about different roles in Customer Portal"]
[null,"How do I book an advance tie-in","Call development operations and tie-in team will book this in for you (or send in proforma)"]
[null,"How do I request inspection/connection ","Click on construction schedule, for tie-in click on book inspection, for track inspections scroll to the bottom and tick the tracks you want to request"]
[null,"There is nowhere for me to put down my details if SW Connection","Put your details in the comment box and we will update the case"]
[null,"I can’t select a weekend date for inspections/sampling ","Inspections shouldn’t be taking place over the weekend, if there is a specific reason speak with connection team to discuss"]
[null,"How do I send in my pressure test/sample results ","Log into portal and click on construction schedule, here you will find a button to submit results"]
[null,"How do I find the case I want to submit inspections for ","There is a search bar at the top of the page you can search for case ref"]