Question sequence gets disordered when export a survey with Rating Scale questions to Excel sheet

Issue:
Question sequence is disordered when we export a survey list to excel
Resolution – Only to get questions in proper sequence in Excel sheet!!

• Checked Survey settings
• Found there were total 50 questions and found almost 30 questions were created using “Rating Scale“ category
• Changed question ordering from Survey settings > Change order of questions
• Previously it was from Q-1 > Q-1-a….Q-5 > Q-5-e
• Changed it to reverse order and arranged Q-5-e > Q-5…..Q-1-a > Q-1
• Exported to spreadsheet, and got all the questions in right order.
• Now another issue occurred, Q-6 (Multiple Line of Text) came first in datasheet, so from view removed it to be displayed or to be exported to spreadsheet.
• The other issue noticed was when user clicks on “Respond to this survey”, user will get the same reverse orders of questions (i.e. Q-5, 4, 3, 2, 1, 6)
• Though this helps us to get questions in proper sequence only in Spreadsheet but this cannot be implemented as this occurs disordering of questions in survey.

Found 2 alternate workarounds
Workaround 1

• Changed all “Rating Scale” questions to “Choice” category with “Radio button” & fill in “mandatory” option
  
• Order remained same (i.e. Q- 1, 2, 3, 4, 5, 6)
• Now it worked proper for both scenarios, user got the right order when open “Respond to this survey” and also got the right order when exported to excel.

Workaround 2

• Created a page and added a Data View Web part using SPD on the page
• Used SharePoint survey as a Data source and added all questions / columns in to the web part
• Then from Data view web part exported data to excel

Feel free to reach me in case of any queries on above steps. Thanks

Your client does not support opening this list with Windows Explorer

 

When you log on to the SharePoint online site , navigate to a document library and click “Open with Explorer” button on the ribbon, you receive the following error message:

Your client does not support opening this list with Windows Explorer
[Resolution]
To successfully make “Open with Explorer” work, we need ensure the following:
1.  WebClient service is started 

WebClient service which the WebDav protocol enables Windows-based programs such as Windows Explorer to create, access and modify Internet-based files.

ð  For this Go To RUN , type ‘services.msc’

ð   Click on ok

ð  Go To  ‘Web Client ‘  as shown in screen shot

ð  Right click on that and make the status started if not.

           

ð  When on windows 7 the webclient service seems to be running, restart it.

  NOTE : If you do not have access to change the status, Kindly raise a request to your local service desk/Network desk for starting Web client service.

Important Note:  If you are running a server type Windows OS, for example, you use Window Server 2008, install Desktop Experience feature first to get  WebClient service installed.

1. From the Start menu, point to Administrative Tools, and click Services.
2. Scroll down, right-click WebClient, and click Properties.
3. In the Startup type list box, click Automatic.
4. Click Apply.
5. In the Service status section, click Start.
6. Click OK.

  2.    You have supported Web browser
it’s recommended to use 32-bit or 128 bit Internet Explorer 7,8,9.

 3. User Account Control Settings

ð  Open User Account Control Settings by clicking the Start button , and then clicking Control Panel. In the search box, type uac, and then click Change User Account Control settings.

ð  Go to User Account Control Settings.

ð   Type in UAC, or go to the System and Security applet.

ð  Click on the "Change User Account Control Settings" link.

ð  It should not be disabled. If disabled then make it as low level.

4.  Add https://sp.myatos.net  to Local intranet site
To configure Web browser, open “Internet Options” menu, navigate to the “Security Tab”, and add https://sp.myatos.net  to Local intranet site.


Then restart the browser and try it again.

Steps to Clear Cache

Please delete the browser cookies using below steps:

a.       Go to “Tools” menu and then “Internet Options” of Internet Explorer browser,

b.       Click “General” Tab and Click “Delete” as in screen shot below:

            

c.       Check the “Check Boxes” as in screen shot below:

d.       Click “Delete”.

After this please copy and paste the URL ( https://sp.myatos.net ) into

address bar of Internet Explorer. Add it in Trusted Sites.

1.       Go to “Internet Explorer>>Tools>>Internet Options”.

2.       Go to “Security” tab and then click “Trusted Sites” and click “Sites” as in screen shot below:

3.       Put the URL “ https://sp.myatos.net ” in Text box and click “Add” and Click “Ok”

Ø  Uncheck the “Enable Protected Mode” of your browser.

Case Study : Internet Explorer

Case Study : Internet Explorer

For IE 7,8 and 9 :

1.    To use  "Open with Explorer" ,  We need to have compatible Internet Explorer configuration as Microsoft suggested. This issue is compatible with IE 7 version onwards [IE 7,8,9] with 32 and 128 bit browsers not for 64 bit, 256bit  browsers.

    Sometimes, IE 7 version onwards [IE 7,8,9]  with 64 bit, 256bit browsers will work with limited support as these are not fully compatible browsers.

2.    If browsers IE 7 version onwards [IE 7,8,9] with 32 and 128 bit browsers are not working . The fallowing setting will help to make it workable.

 Settings to be done :

A.  WebClient service  should be is started 

WebClient service which the WebDav protocol enables Windows-based programs such as Windows Explorer to create, access and modify Internet-based files.

ð  For this Go To RUN , type ‘services.msc’

ð   Click on ok

ð  Go To  ‘Web Client ‘  as shown in screen shot

ð  Right click on that and make the status started if not and set to :  “Automatic”.

           

ð  When on windows 7 the webclient service seems to be running, restart it.

  NOTE : If you do not have access to change the status, Kindly raise a request to your local service desk/Network desk for starting Web client service.

B.  User Account Control Settings

Open User Account Control Settings by clicking the Start button , and then clicking Control Panel. In the search box, type uac, and then click Change User Account Control settings.

Ø  Go to User Account Control Settings.

Ø   Type in UAC, or go to the System and Security applet.

Ø  Click on the "Change User Account Control Settings" link.

ð  It should not be disabled. If disabled then make it as low level.

C.   Add https://sp.myatos.net   to Local intranet site
To configure Web browser, open “Internet Options” menu, navigate to the “Security Tab”, and add https://sp.myatos.net  to Local intranet site.


Then restart the browser and try it again.

Regarding IE 10 :
Actually, there is compatibility issue from Microsoft with Internet Explorer 10 while using option ‘Open with Explorer’.

a.       There is work around for this issue is to remove Internet Explorer 10.When you remove Internet Explorer 10, you can restore the previously installed version of Internet Explorer.

For Adding User in the sharepoint group

For Adding User in the group  :

Please fallow the steps as shown in the screenshot.

1.       Go to Link :  https://sp.myatos.net/ms/fr/SitePages/Home.aspx

     

2.       Go To Site Actions>> Site Permissions

3.        For example, Click on the group in which group , you want to add the user.

4.       Go to NEW >>Add User

5.       Add DAS ID, then check that id as shown below.

6.       In this way you can add the new users in the group

File name, length and character restrictions for SharePoint

File name, length and character restrictions for SharePoint

What are the file name restrictions of the document libraries, link lists, etc

Here’s a list of general restrictions.

• File and folder name lengths can’t exceed 128 characters
• Link list items can’t exceed 256 characters
• The entire path of files can’t exceed 260 characters

File and folder name restrictions:

• Can’t be longer than 128 characters
• Can’t use: ~ # % & * { } \ : < > ? / + | ”
• Can’t use the period character consecutively in the middle of a file name (blah…blah.docx)
• Can’t use the period character at the end of a file name
• Can’t use the period character at the start of a file name
• Can’t end with:
• .files
• _files
• -Dateien
• _fichiers
• _bestanden
• _file
• _archivos
• -filer
• _tiedostot
• _pliki
• _soubory
• _elemei
• _ficheiros
• _arquivos
• _dosyalar
• _datoteke
• _fitxers
• _failid
• _fails
• _bylos
• _fajlovi
• _fitxategiak

The same goes for site, subsite and site group names.