K2 Blackpoint Blackpearl – How to update a Sharepoint list items using common meta data

Published on

In a K2 Sharepoint process you will quite often have to update the same piece of meta data in multiple locations ie. you have a status column which is part of the list your process is attached to but you may need to reflect this status update on another list item in another list for … Continue reading K2 Blackpoint Blackpearl – How to update a Sharepoint list items using common meta data

Merging documents into a single document using Open XML SDK 2.0 and Word Automation Services

Published on

The code below will create a webpart that can be added to any document library, when the button ‘Merge Reports’ is clicked it will merge all the documents together in the library in to a single document using Open XML SDK & Word Automation Services. You will need to add the following references: DocumentFormat.OpenXml Microsoft.Office.Word.Server … Continue reading Merging documents into a single document using Open XML SDK 2.0 and Word Automation Services

How to create an Excel Workbook from an SQL database using Open XML SDK 2.0

Published on

Below is the C# code to create a new Excel workbook based on a template file & populated by an SQL database. You need to add references to: DocumentFormat.OpenXml System.Data.Linq Windows.Base using System; using System.IO; using System.Data; using System.Collections.Generic; using System.Linq; using System.Text; using DocumentFormat.OpenXml.Packaging; using DocumentFormat.OpenXml.Spreadsheet; using DocumentFormat.OpenXml; namespace ElitetoExcel { class Program { … Continue reading How to create an Excel Workbook from an SQL database using Open XML SDK 2.0

Asana

Published on

So what exactly are we up to at Asana? Here’s a peek at what we’re building and why: We’re starting by building collaborative task and project management software. It will be free of charge, delivered over the Web, and initially suitable for both individuals and

Modifying an Open XML Document in a SharePoint Document Library

Published on

C# Console Application code to query a Sharepoint Library, Open a document, Make a change & then save the document. You need references to WindowsBase.dll, Microsoft.Sharepoint & DocumentFormat.OpenXml You also need to ensure your project is .Net 3.5 & set to target ‘Any CPU’ in the project properties. Code written by Eric White

Sharepoint Object Model C# Error The Web Application at could not be found. Verify that you have typed the URL correctly

Published on

When running some C# code containing a reference to SPSite ie I was getting the following error: The Web Application at could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the … Continue reading Sharepoint Object Model C# Error The Web Application at could not be found. Verify that you have typed the URL correctly

How to auto populate Word template using Open XML SDK 2.0

Published on

Here is some simple code that updates a word document template that contains 2 content controls in the template document called: MatterNumber DocType The template document is – C:UsersstilgoepWordTesttest-contentcontrol.docx The output document is – C:UsersstilgoepWordTesttest-contentcontrol-updated.docx You need to add the following 2 references: DocumentFormat.OpenXml WindowsBase.dll You will also need to download the Word Content Control … Continue reading How to auto populate Word template using Open XML SDK 2.0

Page cannot be found when trying to view a K2 Sharepoint Workflow Integration Task

Published on

If you are creating a K2 Blackpearl / K2 Blackpoint process using the ‘Sharepoint Workflow Integration Client’ and when trying to open a particular task item to complete it & you get a ‘page cannot be found’ error in you web browser, its probably because the task title in your workflow contains a ‘&’ char. … Continue reading Page cannot be found when trying to view a K2 Sharepoint Workflow Integration Task

When trying to view K2 Blackpoint Blackpearl report error: ‘Microsoft.ReportViewer.WebForms The system cannot find the file specified

Published on

When trying to view a K2 Blacpoint or Blackpearl report in a process portal you get the following error: An error has occurred trying to load the settings for the report. N/A:Could not load file or assembly ‘Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ or one of its dependencies. The system cannot find the file specified. In my … Continue reading When trying to view K2 Blackpoint Blackpearl report error: ‘Microsoft.ReportViewer.WebForms The system cannot find the file specified