Sharepoint 2010 & Google Analytics

Discovered that you can set a custom variable in Google Analytics to the ID of the Sharepoint user (that’s ID, not Name) :

This is the tracking code I used. The important part here is the _gaq.push([‘_setCustomVar’ line. We can use the Sharepoint JS variable _spUserId:

<script type="text/javascript">
 
  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-xxxxxxxx-x']);
  _gaq.push(['_setCustomVar',
		1,         // This custom var is set to slot #1.  Required parameter.
		'User',    // The name of the custom variable.  Required parameter.
		_spUserId, // This is the Sharepoint JS variable _spUserId. Required!
		2          // Sets the scope to session-level.  Optional parameter.
	   ]);
_gaq.push(['_trackPageview']);
  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();
 
</script>

Don’t forget to change the UA string from

UA-xxxxxxxx-x

to the value for your site!

 Lovely!

Sharepoint Error, Part 2

Sharepoint Error

“The list cannot be imported because a Microsoft SharePoint Foundation-compatible spreadsheet application is not installed or is not compatible with your browser.”

 I resolved the above error by running the Office Setup routine from the installation disk. Incidentally, you’ll need to use 32 bit Internet Explorer when importing your spreadsheet as a list.

However, I still had an issue, where once i’d clicked ‘Import’, the following error occurred:

“An unexpected error has occurred.”
 
Handy. Not.

However, the following Microsoft Support Article helped resolved the issue:

http://support.microsoft.com/kb/2492798

It would appear that you have to append ‘&ListBaseType=0&DisplayName=Spreadsheet+Import‘ to the URL of the import page.

Thanks to the following websites for help with this:

http://kbalertz.com/833714/requires-Windows-SharePoint-error-message-Office-document-document-library.aspx

http://msdn.microsoft.com/en-us/library/ms427792.aspx

http://lichao.net/eblog/how-to-resolve-edit-document-requires-a-windows-sharepoint-services-compatible-application-and-microsoft-internet-explorer-60-or-greater-error-200901215.html

Sharepoint Error

SharePoint Error

Ok, so I gotta vent. This is frustrating:

“The list cannot be imported because a Microsoft SharePoint Foundation-compatible spreadsheet application is not installed or is not compatible with your browser.”
 

I’m using:

Microsoft Sharepoint Foundation 2010

Microsoft Internet Explorer 8

Microsoft Excel 2010

 

I’ll get back to you once i’ve found out how to sort this nonsense.

1 17 18 19 20 21 25