July 14, 2010
A customer recently asked for a code example demonstrating how to use our Dovetail SDK to do data access custom objects using Generics (the Dovetail kind not the C# kind) Imports FChoice.Foundation.Clarify Imports System.Collections.Specialized Imports FChoice.Foundation Imports NUnit.Framework Module SDKExample <TestFixture()> Public Class SDK_test <Test()> Public Sub update_case_title() InitializeDovetailSDK() UseGenericToUpdateExistingCaseTitle("1", "new title") End Sub End Class Sub InitializeDovetailSDK() Dim config As New NameValueCollection 'These are hard coded database credentials. More typically you'd use application configuration config.Add("fchoice.dbtype", "mssql") config.Add("fchoice.connectionstring", "Data Source=.; Initial Catalog=SDKcl125_2k5; User Id=sa; Password=sa;") ClarifyApplication.Initialize(config) End Sub Sub UseGenericToUpdateExistingCaseTitle(ByVal caseId As String, ByVal title As String) Dim session As ClarifySession session = ClarifyApplication.Instance.CreateSession("sa", "sa", ClarifyLoginType.User) Dim dataset As New ClarifyDataSet(session) Dim caseGeneric As ClarifyGeneric caseGeneric = dataset.CreateGeneric("case") caseGeneric.AppendFilter("id_number", StringOps.Equals, caseId) caseGeneric.Query() If caseGeneric.Rows.Count < 1 Then Throw New ApplicationException(String.Format("Case {0} was not found.", caseId)) End If caseGeneric.Rows(0)("title") = title…
July 29, 2010
Big thanks to those that attended today’s webinar on Rulemanager and Advanced Business Rules We had a good turnout, and some really good participation from attendees. Slides The slides from today’s presentation are available on Slideshare. Links Rulemanager Wiki: http://rulemanager.wikispaces.com/ Send SMS message from Rulemanager using Twilio: http://github.com/gsherman/Javascripts Ideas for Future Webinars? Have an idea for a future webinar? Something you’d like to see or learn more about? Leave a comment here or drop me an email: gary [at] dovetailsoftware [dot] com
July 16, 2010
Welcome to part 3 of the series on converting an application from the Clarify Desktop environment to work in Dovetail Agent/Admin. The Employee Manager Utility (EMU) is being migrated into Dovetail Admin, and will provide the tools needed to manage workgroups and the employees that are assigned to them. In the installment of the series, the functionality for the Add... button of the form is going to be implemented. This is going to be a different method that what is normally used in Dovetail Admin due to the fact that workgroups are actually just elements in the WORKGROUP user defined list. EMU adds a lot of information and configuration capability for a workgroup, but there needs to be a record in table_workgroup to hold the details. The Add... button has a small hint that it will have different behavior…