Export To Spreadsheet not showing response columns from Survey:MOSS 2007

Survey list has so many limitations and this list is very unique from all lists which are present in sharepoint.

I have handled so many issues regarding survey from last few weeks. From all of them, i have noticed one which is very unqiue and need some tweaks to get your issue resolved.

When we used "export to spreadsheet" option for survey then we dont get all the columns data  and shows only time stamp and items field.

End user opened a ticket for this and it took some time to resolve this issue as it was new for me also.

Please refer the following steps regarding the same:

1. Open the survey list

2. Edit Page

3. Modify shared webpart

4. Edit the current view

5. Select the appropriate view in which you wants to make the changes

6. Copy the View GUID ID from the URL and paste in a note pad https://sharepoint2007/sites/AHRC/Comp%20Survey%20Report/_layouts/viewedit.aspx?List=%7B415A8DFB%2D0FFF%2D4412%2D925D%2DC4191DDF4127%7D&View=%7B02550769%2DEBF3%2D45F8%2D987C%2DE19F51CC06DB%7D&Source=https%3A%2F%2Ftestl%2Ewsstools%2Econsumer%2Esharepointgroup%2Enet%2Fsites%2FAHRC%2FComp%2520Survey%2520Report%2Fdefault%2Easpx%3FPageView%3DShared

7. Edit the GUID to eliminate few characters , notice the change carefully: %7B02550769%2DEBF3%2D45F8%2D987C%2DE19F51CC06DB%7D&  becomes “02550769- EBF3- 45F8-987C-E19F51CC06DB”

8. Select the number of columns as per your requirements and click OK

9. Click on Actions-Export to spreadsheet. Now as you mentioned in the screenshot below there is a view ID in connection properties-Replace the View GUID with the one copied above and click OK.

10. It will give you the correct spreadsheet.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you

Exploring The New Internet Explorer 9

The improvements to Internet Explorer are as much about what you don't see as what you do see. Internet Explorer 9 has a streamlined design, fewer dialog boxes to click through, more intuitive navigation, and many new features that speed up your web browsing experience. Features like Pinned Sites let you pin your favorite website directly to the taskbar for one-click access. Other features, like hardware acceleration, deliver an all-around faster browsing experience. With Internet Explorer 9, websites perform and feel more like the programs you use every day on your PC.

I have just installed Internet Explorer 9, which is now available for download. First think that i noticed is that it’s a faster browser than Internet Explorer 8. Pages seem to load faster, and IE itself is lighter on its feet and more agile. The second thing is that Microsoft made major changes to the look of IE and moved major components around. The Favorites Center is now on the right side and pop-up blocker notifications display from the bottom of the application window. The IE icon on the taskbar has a large E symbol, and the letter is a lighter shade of blue.

Here's what's new:

-Streamlined design

-Pinned Sites:
Pinning a site is simple: click the icon to the left of the web address in the address bar (or the website icon on the New Tab page) and drag it to the taskbar—the website's icon will stay there until you remove it. When you click the icon later, the website will open in Internet Explorer.

-Download Manager:
Download Manager is a powerful new feature that keeps a running list of the files you download from the Internet and notifies you when a file could be malicious. It also lets you pause and restart a download—if you have a slow internet connection—and shows you where to find downloaded files on your computer. You can clear the list at any time.

-Enhanced tabs:
Tabbed browsing allows you to move easily between multiple open webpages in a single window, but there might be times when you want to look at two tabbed pages at the same time. Tear-off tabs allow you to drag a tab out of Internet Explorer to open the tab's webpage in a new window, and Snap it for side-by-side viewing.

-New Tab pageThe redesigned New Tab page displays the sites you visit most often and color codes them for quick navigation. A site indicator bar also shows how often you visit each site, and you can remove or hide the displayed sites anytime you like.

-Hardware accelerationTo speed up performance, Internet Explorer uses the power of your computer's graphics processor, also known as a GPU, to handle graphics-heavy tasks like video streaming or online gaming. By tapping into the GPU, Internet Explorer delivers a faster and more immersive web experience.

-Tracking ProtectionSome content on websites can be used to track your activity as you browse the web. Tracking Protection allows you to limit the browser's communication with certain websites—determined by a Tracking Protection List—to help keep your information private. Anyone can create Tracking Protection Lists, and there should be many to choose from in the near future.

Download the IE 9 Release candidate and try it out for yourself at:

http://windows.microsoft.com/en-US/internet-explorer/products/ie-9/home?WT.mc_id=MSCOM_DLC_US_PT_113LMUS004274

Internet Explorer 9 final to be released in two weeks:
Microsoft released the Internet Explorer 9 Release Candidate on February 10, and according to some sources, the company is going to release the final version of the browser during a conference that is going to take place on March 14 in Texas.
The information confirms what we already knew: Microsoft said that there will only be one Release Candidate version, and the date of March 14 fits the six weeks release cycle that Internet Explorer used until now.

Microsoft said that the Release Candidate version is going to automatically be updated to the final version, so a direct download should be available starting with March 14.

Report contains no data

SharePoint Server provides the ability to audit the usage of your SharePoint environment. The SharePoint Server auditing capabilities allow you to track all activities that occur within the environment. The site collection administrator has the ability to set auditing requirements within the environment that determine the types of actions that should be tracked. Reports are then available that can be used to review the logged events.

Yesterday, one of my users reported me the following error message for the site collection on which he was working:

Report contains no data

As we know, only site collection administrator works/can view the audit log reports so my user clicked on the report and got the above mentioned error message.

What you have to do in this situation:

1)   Open the site on which you are working

2)   Site actions

3)   Site settings

4)   Site collection administration

5)   Site collection audit log settings

6)   Select the columns as per your requirements 

The following list of events can be audited:

1)   Opening, Downloading and viewing of content.

2)   Editing Content

3)   Checking in and out.

4)   Moving and copying content.

5)   Deleting and restoring.

6)   Editing Content Types and Columns

7)   Searches performed by users.

8)   Changes to security settings.

Note: Make sure you do some activity in order to get the reports because you have implemented the audit logs by checking all the appropriate audit events. 

Once auditing has been enabled and the site has been in use for a while. Different reports can be pulled from the log. If no data has been recorded in the log, then the reports will simply not open.

After doing the above mentioned steps, your issue will be resolved..

In case of any queries/questions regarding the above mentioned information then please let me know, Thanks…

A usage report is not available for this site. Usage processing may be disabled on this server or the usage data for this site has not been processed yet.

When you try to view the Site Usage Report page, you may see the following message:
A usage report is not available for this site. Usage processing may be disabled on this server or the usage data for this site has not been processed yet.


Logging and usage processing must be turned on, and users must have visited a page on your site before any data can appear on the Site Usage Report page. Contact your site administrator to verify that logging and usage processing are turned on in Windows SharePoint Services 3.0. Also, if the site is new (created today) or has not been used before today, no data will appear until the usage log processing is completed (usually within 24 hours). Furthermore, if there has been no activity on the site for the past 31 days, you will see the "no data" message.
How to Enable Windows SharePoint Services usage logging:

Enable Windows SharePoint Services usage logging for the farm hosting the Web application containing the SSP. Please refer the following steps to enable usage logging for the farm:

-On the Central Administration home page, click Operations. 

-On the Operations page, in the Logging and Reporting section, click Usage analysis processing. 

-On the Usage Analysis Processing page, in the Logging Settings section, select Enable logging. 

-Type a log file location and number of log files to create. 

-In the Processing Settings section, select Enable usage analysis processing, and then select a time to run usage processing. 

-Click OK.

Enable portal usage reporting:

After Windows SharePoint Services usage logging is enabled in the server farm, SSP administrators must enable the portal usage reporting service. SSP administrators can control the complexity of usage analysis processing, and select whether or not reporting is enabled for search queries. 

Please refer the following steps to enable portal usage reporting:

-On Central Administration home page, click the Shared Service Provider listed under Shared Services Administration in the Quick Launch bar. 
-On the SSP home page, in the Portal Usage Reporting section, click Usage reporting. 
-On the Configure Advanced Usage Analysis Processing page, in the Processing Settings section, click Enable advanced usage analysis processing. 
-In the Search Query Logging section, select Enable search query logging. 
-Click OK.

Note: If advanced usage analysis processing is not selected, usage reporting statistics will be minimal.

Reset Internet Information Server:


-Go to the Start Button and click Run 
-Type IISReset and click OK.

Activate portal usage reporting

After portal usage reporting is enabled for the SSP, site collection administrators must activate the reporting feature. Until the reporting feature is activated on a site collection, usage reports are not available. 

Please refer the following steps to activate the reporting feature:

-On the Site Actions menu, click Site Settings. 
-On the Site Settings page, in the Site Collection Administration section, click Site collection features. 
-On the Site Collection Features page, click the Activate button for the Reporting feature.

If you have any queries/questions regarding the above mentioned information then please let me know, Thanks...

Your changes could not be saved because this SharePoint Web site has exceeded the storage quota limit. You must save your work to another location. Contact your administrator to change the quota limits for the Web site.

User trying to save file in shared documents on personal site. It’s telling user “ Your changes could not be saved because this SharePoint Web site has exceeded the storage quota limit.

A quota specifies storage limit values for the maximum amount of data that can be stored in a site collection. Quotas also specify the storage size that, when reached, triggers an e-mail alert to the site collection administrator. Quota templates apply these settings to any site collection in a SharePoint farm.

To Track Quotas:
-Site administrators can go to Site Actions -Site Settings and click "Storage space allocation" to review space usage.
-Here they can display lists of libraries, documents, lists and Recycle Bin contents.
-These lists are by default sorted on size, descending. They can be resorted on Date Modified or Size

Resolution:
Server administrators are able to set limits on the amount of storage space that sites can use on the server. Contact your server administrator to request that the storage quota for the Web site be increased.

Exact Steps:
1. Go to your Central Administration a Application
2. On the Application Management page, in the SharePoint Site Management section, click Quota Templates.

I have also seen that user faced this kind of error message usually for their mysites because Personal site’s Limit site storage is set to 100M by default.

If you have any queries/questions regarding the above mentioned information then please let me know...I would be more than happy to help you as well as resolves your issues, Thanks..