Archive for the 'SharePoint General' Category

16
Mar
12

Add a Link to a Document to get around file size Limitation

Many times SharePoint users run into the maximum file size allowed on their SharePoint farm and the SharePoint administrator won’t change the rules and allow larger files.

One way to get around this is to enable the "Link to a Document" content type on and store the file on an available file share.  Here’s how you do it in 2007.  It’s similar in 2010.

Go to Document Library Settings.

image

Click on Advanced.

image

Enable management of content types.

image

Click on Add from existing site content types.

image

Add "Link to a Document" and click OK.

image

"Link to a Document" should now show up in the list of content types for your library.

image

Navigate back to your document library and click on the New drop-down and select "Link to a Document." 

image

If you attempt to enter a file:// URL to the file on your server, you’ll probably get an error, so put in a dummy URL that begins with http://.  Here’s an example URL.  http://wplnet/public/Aims/TRAX/BigFile.csv.

image

Edit the properties of the link.

image

Change the http:// prefix to file://

image

Click on the link and you should be directed to the file on the server.

image

A similar process can be used for SharePoint 2010.

20
Sep
11

Date and Time Formats in a Workflow

This is just so I can remember what the date and time formats look like when you reference the current date in a workflow variable.

Here’s a short workflow

image

and here are the results.

image

07
Jun
11

How to use nested quotes on the Runas command

This isn’t exactly SharePoint related, but it does deal with SQL Server (that is used by SharePoint) so I’m going to post it here anyways.  So shoot me.

To run SQL Server Enterprise Manager (Ouch!  What is he doing with SQL 2000?) as another user from the command line you can either use short file names or nested quotes.

C:\Windows\System32\runas.exe /user:domain\username "C:\Windows\System32\mmc.exe /s C:\Progra~2\Mi3EDC~1\80\Tools\BINN\SQLSer~1.msc"

If you want to use short filenames, you can cd to each directory and perform a dir /x to display the short directory or filename.

image

Or, if you want to use long filenames:

C:\Windows\System32\runas.exe /user:domain\username "C:\Windows\System32\mmc.exe /s \"C:\Program Files (x86)\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC"\"

The trick to using long filenames is to use \" for the first nested quote and "\ for the matching nested quote.

In either case, when you run the shortcut you’ll be prompted to enter your password.

image

26
Jan
11

What the heck is going on with SharePoint 2010 slide Libraries?

For all the great features added to SharePoint 2010, it is still mind boggling to see what issues remain with the user experience.  Take this recent experience with SharePoint 2010 slide libraries.  Terry turned me on to this in his instance so I began a validation in my instance.  My instance is currently patched with the October 2010 CUs.

I published a PowerPoint presentation to a slide library in SP2010 that had “require check in/out” enabled.  All slides were published in a checked out status.  I needed to check them in.  No problem, select multiple slides with the new “multiple selection” feature and check in. 

Nope, can’t do it.  Security issue?  I’m a logged in as a site collection administrator and I’m in the Owners group that has access to the slide library.  Shouldn’t have a problem there.

image

Okay, let’s see what happens if I don’t select multiple slides. 

Nope, tool ribbon is still disabled.  Even tried enabling “protected mode” in IE for trusted sites (in which this site resides).

image

Do I have access to check-in from the drop-down?  Yes.

Does it work?  Yes.

image

Now the special triple click trick.  Click the disappearing drop-down button.  The context sensitive drop-down list appears.  Click it again and the button disappears…but the drop-down list remains.  Click again and the drop-down list disappears.  Ahhh…the wonders of Ajax.  But I digress.

image

Let’s take a look at this problem from an SPD perspective.  We can see the files that are checked out.

image

Let’s select three files and check them in.

image

After performing a check-in, we still see the “checked-out” checkmarks.  Even the context-sensitive menu is confused about whether these slides are checked in or checked out.

image

Perhaps it’s that nagging problem with SPD where it doesn’t refresh correctly.  Press F5.  No change.

After closing and reopening the site in SPD.  No change.

From the browser UI I validated that they are still checked out.  Another non-functional feature?

image

It looks like SPD continues to be confused as to the status of the slide, even after closing SPD and starting a new instance.

image

SPD shows the same slide as checked out.  No amount of F5-ing changes this.

image

Hey, let’s try to use this feature to allow us to “manage files which have no checked in version.”

image

But wait!  There are no checkboxes with which to select the items? 

image

Perhaps I can use the “select all” checkbox.

Nope.  The "select all” checkbox is non-functional.  What’s up with this?

image

Oh, and this appears to work just fine on a document library in the same site.

image

I’m certainly open to others’ experiences with Slide Libraries in 2010.  Perhaps the Dec 2010 CUs will help?

As another test I went into SPD 2007 and tried the same thing.  No check-in will occur from SPD 2007.  So, I guess they didn’t break anything.

image

References

SharePoint Slide Library Adding Functionality




Asif Rehmani’s SharePoint Videos

SharePoint-Videos

Click to access a wealth of SharePoint videos

SharePoint Rx

SharePoint Rx Home

Categories

Posts by Date

May 2012
M T W T F S S
« Mar    
 123456
78910111213
14151617181920
21222324252627
28293031  
Support Wikipedia

Follow

Get every new post delivered to your Inbox.