Monday, June 21, 2010

Deploying a .NET workflow onto a SharePoint List

1. Copy the DLL your workflow creates from the build directory ( inDebug) to the Global Assembly Cache (GAC)
2. Create a directory in the features directory [C:Program FilesCommon Filesmicrosoft sharedWeb Server Extensions12TEMPLATEFEATURES] and drop both the feature.xml and workflow.xml files into the directory.

3. Install the feature on your farm, using the following command line statements
stsadm -o installfeature -name DocumentMoveAndShortcut

4. Activate the feature to a site collection

stsadm -o activatefeature -name DocumentMoveAndShortcut -url http://moss2007win2008

(or by going thru the site collection settings:
Activate the newly installed feature by navigating to the "Site Collection Features" page, under "Site Action" -> "Site Settings". Scroll down until you see "New Task Workflow", and click "Activate":)

From:

http://vspug.com/andynoon/2008/02/06/sharepoint-2007-workflow-with-visual-studio-2008/
http://philwicklund.com/archive/2008/02/12/deploying-a-net-visual-studio-workflow-into-a-sharepoint-list-in-10-easy-steps-part-2-of-2-deploying-the-workflow.aspx

Monday, June 14, 2010

Business Data Catalog & Custom List

A new notes:

1. With Microsoft ® Business Data Catalog Definition Editor, there is need to manually change MethodInstance to Type "Finder";
2. Unless Single Signin is implemented, the ADF need to have 'RevertToSelf' as authentication mode rather than 'PassThrough';

3. make sure MOSS user have access to database used here;


Here is a link about using SSIS to importing data into sharepoint custom list:

http://www.onlinetechblog.com/blog/index.php/2009/07/how-import-data-to-sharepoint-list-using-ssis/

Thursday, April 15, 2010

"Transaction context in use by another session" and linked server

if you use linked server and loopback server then call SPs using the linked server, this scenario is not supported.

you will need to modify the code to call the SP directly.

Tuesday, March 23, 2010

Get Tomcat installation directory in Java

System.getProperty("catalina.base")

Excel VBA - "operation is not allowed when the object is closed"

This is normally caused by the stored procedure called, you will need to place 'set nocount on' on top of the SP to eliminate the extra information returned.

Disable Microsoft Defender for Cloud for Visual Studio Subscription (MSDN)

I use a visual studio pro subscription which comes with $150 azure cloud credit, for some reason Microsoft Defender for Cloud was turned on ...