Westin's Technical Log - All Comments

What Lies Behind SharePoint's Price Tag?; Making the Cloud a Reality; Google Wave Worth the Fuss?

SharePoint Daily — Thu, 15 Oct 2009 12:58:24 GMT

Top News Stories SharePoint Statistics: The Real Reason Behind SharePoint's Price Tag (ZDNet) What

re: How To Create a Hyperlink to SharePoint's List Export to Spreadsheet

misbips — Wed, 14 Oct 2009 18:58:25 GMT

Thanks so much for the information! I wanted to add a bit with regards to surveys....

For surveys it is a bit different since you can't select views. I ended up going to the view of the survey results that I wanted and then did the view source from the browser. Using "export to" I found the information regarding the link just above that.

\u002f[Site]\u002f[Subsite]\u002f_vti_bin\u002fowssvr.dll?CS=65001\u0026Using=_layouts\u002fquery.iqy\u0026List=\u00257B880B2537\u00252DEE3C\u00252D4312\u00252D95BC\u00252D4F56FC22106A\u00257D\u0026View=\u00257B633D9301\u00252DEB6C\u00252D4666\u00252D892E\u00252DF42DF94F46AA\u00257D\u0026RootFolder=\u00252F[Site]\u00252F[SubSite]\u00252FLists\u00252F[SurveyName]\u0026CacheControl=1

I replaced the following:

\u00257 = %7

\u00252 = %2

\u0026 = &

\u002f = /

So eventually it looked like this:

http://[server]/[site]/[subsite]/_vti_bin/owssvr.dll?CS=65001&Using=_layouts/query.iqy&List=%7B880B2537%2DEE3C%2D4312%2D95BC%2D4F56FC22106A%7D&View=%7B633D9301%2DEB6C%2D4666%2D892E%2DF42DF94F46AA%7D&RootFolder=%2F[site]%2F[subsite]%2FLists%2F[SurveyName]&CacheControl=1

Replace placeholders

http://[server]/[site]/[subsite]/_vti_bin/owssvr.dll?CS=65001&Using=_layouts/query.iqy&List=[List GUID]&View=[View GUID]&RootFolder=%2F[site]%2F[subsite]%2FLists%2F[SurveyName]&CacheControl=1

re: Project Summary Task Summing Incorrectly

david — Mon, 12 Oct 2009 21:04:42 GMT

I still have the problem without any reource assignments given. I am using elapsed days for all task times.

re: Project Summary Task Summing Incorrectly

David — Thu, 01 Oct 2009 12:56:35 GMT

hello,

Is there any way to "fix" summary tasks length, not being forced to recalculate the duration based on the length of the indented tasks?

Regards,

David

re: How To Create a Hyperlink to SharePoint's List Export to Spreadsheet

Mordechai — Fri, 25 Sep 2009 09:18:27 GMT

Thanks, that saved my life!

re: Multi-Value Filtering on SharePoint Lists

Andrea — Tue, 22 Sep 2009 17:29:31 GMT

I'm trying to follow your instructions, but I don't really understand code and I'm not sure what URL protocol is (link is broken).

I'd really appreciate detailed instructions for dummies!

Thanks.

re: Multi-Value Filtering on SharePoint Lists

Pallavi — Wed, 09 Sep 2009 16:56:55 GMT

Hi,

I liked your post – I have a problem of filtering based on the custom metadata lookup field.. The lookup field is saved as ; separated.

List A has the meta data of lookup column field with multiple values.

I need to display the items in a dataview where the filter is only a.Fetch only articles with metadata of a i.e. A4 should not be returned

A1 > a;b;c;d;ab;bc;cd

A2 > a

A3 > a;b;ab

A4 > ab;bc

i will greatly appreciate if someone has a solution for this…

re: How To Create a Hyperlink to SharePoint's List Export to Spreadsheet

Maria — Mon, 10 Aug 2009 04:06:18 GMT

I get an error

an unexpected error has occurred, changes to your data cannot be saved.

office 2003 sp2

Spreadsheet Export Link Custom Column Type

Joe Sharepoint — Sun, 02 Aug 2009 02:43:46 GMT

Spreadsheet Export Link Custom Column Type

re: Multi-Value Filtering on SharePoint Lists

Steve — Thu, 02 Jul 2009 18:06:09 GMT

Is there a way to create a url that filters a 'person or group' field based on that field containing the user that is logged in?