Showing posts with label SharePoint. Show all posts
Showing posts with label SharePoint. Show all posts

Friday, 22 March 2013

Scanning Direct to a SharePoint List

There are plenty of products available to assist with scanning documents directly to sharepoint; from installable modules for your multi-function devices (MFD)/scanners to software solutions. But here's a quick workaround I discovered using Symbolic links and shared folders:

The Problem:
SharePoint doesn't store documents in a standard file system. The documents are actually stored within the SharePoint database. When you navigate to a document list and click 'Open with Windows Explorer' a number of technologies included WEBDAV are used to give you access to the files as if they were stored in a standard file system.

So the bottom line is although your computer is able to interpret this file storage location your scanner/MFD in most cases can't.

The Solution:
If your scanner/MFD is able to scan to a networked location there is a workaround:

1. For this solution to work, scans are going to go via a share on one of your Servers. This can be your SharePoint server or another of your choice. On this server navigate to the SharePoint list you want to scan to and choose the 'Open with Windows Explorer' option. You may need to install the 'Windows Desktop Experience' if prompted.
 
2. From the explorer window that appears make a note of the address (probably in the format of http://yourserver/yourlist or \\yourserver\yourlist depending upon your site structure)

3. Open a command prompt and type the following 

mklink /d [link name] [target]


For example if you wanted to create your link to http://myserver/mylist in a test folder on your c:\ called 'mytestlink' the syntax would be as follows

mklink /d c:\test\mytestlink \\myserver\mylist

   
4. Once the symbolic link has been created - test that it works and then set it up as a shared folder on the network

5. Modify your scanner to scan to the new shared folder and test the scans appear as expected.

6. On the server where you created the link ensure that the WebClient service is enabled and set to start automatically - otherwise you may find that after a server restart your links don't work until you browse to the SharePoint list again.

Tuesday, 14 August 2012

SharePoint - Out of the Box KPI Functionality

I've been playing about recently with the KPI functionality within SharePoint 2010:
  • I set myself up with a Status List
  • Created a few performance indicators
  • Loaded the KPI Status List webpart
Then I encountered a problem - I needed to filter the list of KPIs by the current user. Simple right? No. Every other list you can filter by the current user but not the Status List. Even if you apply the filter to the view, the filter doesn't apply and there doesn't seem to a way to connect the webpart to a current user filter either.

I could use a standard content query webpart but then I don't get the nice indicators (I don't even see a way to display the actual key value)

So unless anyone has any other ideas I have two options
  1. Create my own custom webpart
  2. (The easier option) Use SQL Reporting Services (SSRS) to build the users KPI list and show that on the page instead.
Very disappointing!

Tuesday, 7 August 2012

SharePoint Data and SSRS Reports

Problem

I had a number of reports configured in SSRS to output data from our SharePoint server. They worked fine but with the following issues.
  1. When browsing the report if the user navigated away from the page and then clicked the back button all the SharePoint data within the report would display an error
  2. If the user exported the report to Excel all the SharePoint data would be replaced by an error.

Solution

The reports in question all had something in common; none of them had a table or matrix within the report to display the SharePoint Dataset (via SOAP query). In each case I was using the data for calculations within tables linked to other datasets (SQL connections).

As soon as I added a hidden table to directly display the SharePoint data the problem went away.

It would seem therefore that unlike SQL connections which 'just work', SOAP datasets are only loaded when the report is first displayed, unless you have a table or matrix that directly references it. Hence why it wasn't loaded the data on the page back or the Excel Export.

Lesson learned.


My Setup: Visual Studio 2010 publishing reports to SQL Server Reporting Services 2008 R2.

Friday, 3 August 2012

SharePoint and Business Data Columns

Problem

I've been struggling for a while copying data from one SharePoint List to another where one of the fields links to Business Data Connectivity (BCS) data. The copy always works with no errors, but the recipient BCS field remained blank.

Solution

If you tell SharePoint Designer (SPD) to populate the BCS data column in List B from the BCS data column in List B it simply won't work. (It does actually copy a name in the field but the link to the BCS data is not actually created). This is because it also needs to have an ID entered in the [yourBCSdataname]_id field.

Annoyingly SPD will let you read from this id field but it won't let you write to it.


My workaround therefore was to write the id field from List A into a temporary field in List B. To make things a bit easier for me I also copied the display name of the BCS item to a temporary field in List B. Upon item creation in List B I then fired a visual studio designed workflow to copy the data from the temporary field into the id field in List B. The code was relatively simple:


SPListItem item = workflowProperties.Item;
item["MyBCSData_ID"] = item["tempid"].ToString();
item["MyBCSDataField"] = item["tempname"].ToString();
item.Update();

Note: If you have any additional BCS fields displayed these won't automatically be populated. You will need to refresh the BCS data for this to happen. There is code out there to do that, but it wasn't an issue for me I was purely concerned with getting the link created on that one field.


See my post back on the original Microsoft Forum HERE