www.skelta.com
Home      Members   Calendar   Who's On

Welcome Guest ( Login | Register )
      

Home » BPM.NET 2007/Sharepoint Accelerator 2007 » BPM.NET 2007/Sharepoint Accelerator 2007 » Database » Stored procedures


Stored proceduresExpand / Collapse
Author
Message
Posted Monday, March 17, 2008
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 2 days ago @ 4:42 AM
Posts: 59, Visits: 154
Hello

Do you have Stored procedures in BD?

For example, i need extract data from blob-type cell with local variables or with sharepoint data.

Did you have mechanism for it?

Can you help me?

Thanks!

Post #663
Posted Monday, March 17, 2008
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: Thursday, April 10, 2008
Posts: 23, Visits: 38
Hello,

There are no stored procedures available for retrieving Workflow data, you can use Skelta APIs or directly query the related Skelta tables for retrieving the workflow data.

Another option will be to use the WorkItemFormBase implementation which can also be used for updating user databases with workflow information

Regards,

Roni

Post #666
Posted Tuesday, March 18, 2008
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 2 days ago @ 4:42 AM
Posts: 59, Visits: 154
But I have a problem: variable stores in blob-type cell (255 symbols) and its value stores from 24-th symbol (for example string variable with value '12345')

Work with it is inconveniently

Post #669
Posted Tuesday, March 18, 2008
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: Thursday, April 10, 2008
Posts: 23, Visits: 38
Hello,

You will need to implement the WorkItemFormBase, this could be used for storing the workflow related data in custom database tables.

Regards,

Roni

Post #674
Posted Wednesday, March 19, 2008
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 2 days ago @ 4:42 AM
Posts: 59, Visits: 154
Hello

Where I can see IWorkItemFormBase?

I don't find it...

Thanks

Post #691
Posted Wednesday, March 19, 2008
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: Thursday, April 10, 2008
Posts: 23, Visits: 38
Hi,

Attached is a sample implementation, which can be used for saving Workflow specific information to custom database or logs.

Step1: After creating the customized class you must compile it and copy the dll in the \Bin folder of the Skelta installation folder (C:\Program Files\Skelta\BPM.NET 2007\Bin)  

Step2:Add a row in the SKAddInProviders table, with the name "FormProvider", specifying the Type as "Form" and providing the class name and path of the Dll

Regards,

RSimon


  Post Attachments 
Sample implementation.zip (27 views, 733.50 KB)

Post #692
Posted Friday, March 21, 2008
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 2 days ago @ 4:42 AM
Posts: 59, Visits: 154
I compiled this project without changes

Add row in table but have error:

System.Exception: Could not load property: ChannelSelection.(Error while loading the channel collection for application -Reglament, workflow -Cafedra, [AddinProvider] Could not create instance for BPMActivityMapClass from assembly C:\Program Files\Skelta\BPM.NET 2007\bin\SkeltaBPMActMap.dll)

Post #708
Posted Friday, March 21, 2008
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: Thursday, April 10, 2008
Posts: 23, Visits: 38
Hi,

Please re reference the Skelta Assemblies and try. Hope you have the correct entries in the add in provider table.

Regards,

RS

Post #709
Posted Monday, March 24, 2008
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 2 days ago @ 4:42 AM
Posts: 59, Visits: 154
I did this, but it not works

1) I compiled project without changes (SkeltaBPMActMap.dll)

2) I copied this dll to C:\Program Files\Skelta\BPM.NET 2007\bin

3) I added row to "SKAddInProviders" table:

Form     FormProvider     NULL     BPMActivityMapClass     bin\SkeltaBPMActMap.dll     NULL     False     False     False     24.03.2008 9:23:05

4) after that I restarted server and saw same error

What I did incorrect?

Thanks

Post #710
Posted Tuesday, March 25, 2008
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: Thursday, April 10, 2008
Posts: 23, Visits: 38
Hi,

As I mentioned earlier, please add reference for the skelta assemblies (Skelta.HWS, Skelta.HWS.WorkListChannel.Web and Workflow.NET.NET2). Also add the complete class name (Skelta.HWS.WorkListChannel.Web.BPMActivityMapClass) in the SKAddinProvider Table.

Regards,

RS

Post #714
« Prev Topic | Next Topic »