Scott's blog

Receiving "There was an error in the callback" error message when expanding tree in Content and Structure page.

ScottM — Wed, 14 May 2008 22:25:00 GMT

Background:

We recently ran into this issue when attempting to access our site through the Content and Structure page on the main site. This error presented itself when attempting to expand the tree for a particular site. After clicking the plus sign and waiting for a while, the error message would appear just below the site name. After receiving the error, attempting to expand any other site resulted in the immediate display of the message. Also, when trying to access the Content and Structure page from any site under the problem site, SharePoint would display the Error page with the very useful “An unknown error has occurred” message. This was a big problem for us because we needed to move items, lists, and sites.

Solution:

Ultimately the problem was caused by the server timing out on the request. Our system administrator changed the IIS timeout settings from 120 to 600 for an unrelated issue. After the setting was changed we no longer encountered the error. We made the change on a development server that was having the same issue, and this solved the problem there as well.

Posted on SharePoint Blogs

Our Initial Use of Email Enabled Libraries

ScottM — Fri, 21 Mar 2008 15:18:00 GMT

We have recently enabled the email functionality for libraries. I am sure that there are much more advanced applications of this functionality in use by others, but I wanted to document our first attempt for others that may benefit.Our Situation: We use SQL Server Reporting Services (SSRS)to auto-produce a series of reports on a regular schedule. We wanted to have those reports be automatically uploaded into a SharePoint Document Library, then build a Web Part Page to automatically display the latest set of reports.Below are the steps we used to do this:

Ensure that SharePoint’s journaling feature has been enabled.
In SharePoint, create a Picture Library to store the report images.
In SSRS, create and deploy the reports.
Create email subscriptions in SSRS for each of the reports to be emailed to the new picture library with an attachment in PNG format.
Set up the picture library with a category field. Specify category values for each of the unique report types coming into the library. In our case we have four unique report types and four corresponding categories.
In order to preserve a history of the reports, we created a workflow to append the date to each report’s file name to make each file unique. We outlined this process in an earlier blog post: Change a Filename using a Workflow. Do not finish the workflow yet.
In the workflow, add another step.
Create a branch in the workflow for each category.
Add a condition to “Compare <picture library> field” in each branch.
Set the field to Title or Name, change Equal to Contains, and specify a keyword in the filename that identifies the category.
Add an action to “Set Field in Current Item” to each of the branches.
Set the field to your category field, and set the value accordingly for each branch.
Click “Finish.”

We then created a Web Part page to display the images. We added the picture library web part to the page four times and made the following modifications to each one:

In the drop-down for the web part, select Modify Web Part and make the following changes:

Change the name to reflect the report being displayed.
Click on “Edit the current view” and make the following changes:

Uncheck the checked fields and check the Preview field.
Order by the create date in descending order.
Set a filter on the category field equal to the appropriate category.
Change the Item Limit to 1.
Click Ok.

The result will be a web part page that displays the last report uploaded in each of the categories.

Posted on SharePoint Blogs

"Word did not save the document" Error When Saving and Checking In Office 2007 Documents from Vista to a SharePoint 2007 Document Library

ScottM — Thu, 06 Dec 2007 21:53:00 GMT

We had users running Vista and Office 2007 working with documents stored in a document library on SharePoint 2007. When they attempted to check the documents in, they received the error “Word did not save the document.” Excel files appeared to go through fine, however the file never closed and the document was still checked out. I discovered a workaround that solved the issue for us. Below are the steps to follow from the machine running Vista:

1. With the file open, click the Save button.

2. Close the file without checking it in.

3. In the document library click Upload.

4. Navigate to Documents > SharePoint Drafts and select the saved file. Click Open.

5. Make sure the check box for “Add a new version to existing file” is selected.

6. Modify the Title if necessary and click Check In.

This procedure updated the file, and we were then able to open any other file in the document library, save it, and check it in without any problems.

Posted on SharePoint Blogs

Data Source Library Grayed Out

ScottM — Mon, 01 Oct 2007 17:25:00 GMT

After cleaning up permissions on our sites, I encountered a problem trying to access a site using the Data Source Library. I received an error: “The web <site url> cannot be opened.” When I opened the site in SPD the Data Source Library was grayed out. With the help of the Dean we found the problem. Somehow in my permissions cleaning the fpdatasources permissions were altered. I corrected the problem using the following steps:

1. Open the problem site in SPD

2. In the Folder List navigate to _catalogs/fpdatasources

3. Right-click fpdatasources and click the Security tab

4. Click “Manage permissions using the browser.”

5. Add the appropriate permissions.

You may have to refresh or restart SPD to see the change, but the Data Source Library should no longer be grayed out.

Posted on SharePoint Blogs

“Failed to load the workflow” Error Message in SharePoint Designer

ScottM — Sat, 21 Jul 2007 02:38:00 GMT

I recently ran into this problem when trying to either create a new workflow or open an existing workflow. With help from The Dean I was finally able to find a solution that worked. I navigated to C:\Documents and Settings\<my user name>\Application Data\Microsoft\SharePoint Designer\ProxyAssemblyCache and deleted the existing folder (12.x.x.xxxx). I then opened SharePoint Designer, created a new workflow, and it opened just fine. I posted this solution on the forums with the question, but it doesn’t hurt to get the information out to as many places as possible. J

Posted on SharePoint Blogs

Change a Filename using a Workflow

ScottM — Thu, 12 Jul 2007 16:25:00 GMT

One of the questions that has arisen in our use of SharePoint is this: “How can we automatically change the filename of a document added to a document library?” We have PDF files that are automatically created in SQL Server Reporting Services, and we want to take advantage of the ability of SSRS to create the files and email them and SP 07 lists to receive emails and add attached documents to the list. Unfortunately we have not been able to figure out in SSRS how to append a date to the filename, so we turned to SP Workflows to find a solution.

Through knowledge gained in training along with a lot of head scratching, we came up with a solution. It may not be the best solution, but it works for us.

1. Create a column in the target library, name it “Text Date” (or whatever you prefer), set it as single line of text, and calculate the value using the following expression:

=Text([Today], “yyyymmdd”)

2. Create a workflow.

3. Give it a name and select the checkbox for “Automatically start this workflow when a new item is created.”

4. Click Next.

5. Add the Action to “Set Field in Current Item.”

6. Click Field and select “Title.”

7. Click Value, click the function button, and in the Field drop-down select “Name (for use in forms)”. This will set the title as the current filename without the file extension.

8. Add the Action to “Build Dynamic String.”

9. Click “Dynamic String” and create it as follows using “Add Lookup” (Documents is the name of my target library):

[%Documents:Title%]_[%Documents:Text Date%].[%Documents:Type%]

10. Click “Variable: variable1”, “Create a new variable…” and give it a name. I called mine “FileName”.

11. Add the Action to “Set Field in Current Item” again.

12. Click Field and select “Name (for use in forms).”

13. Click Value, click the Function button, change the source to “Workflow Data”, and change the field to “Variable: FileName”.

14. Click Finish.

Once the Title field has been used to build the FileName variable, it can be rebuilt using any method you see fit. The “Text Date” field can also be calculated using any date format you wish, however special characters such as / and : cannot be used in a file name.

Posted on SharePoint Blogs

Some Information

ScottM — Thu, 12 Jul 2007 16:24:00 GMT

A little information about me: I work for a software company in the support department. We are implementing SharePoint as our department intranet, and this blog will be a way for me to post solutions to problems that I have been unable to find online. The solutions may not be the best, but at least they’ll hopefully work. What was the phrase I recently heard in our SharePoint Bootcamp? Ah yes, “if it works, it’s ‘elegant’.” – Dustin Miller

Posted on SharePoint Blogs