REQUEST A DEMO

Blog

ClearBasic cbbatch tip: Display the line number of the most recent error

September 27, 2011 After over a decade of doing ClearBasic coding, I’m still learning new things.   Today, Marek pointed out the Erl function, which returns the line number of the most recent error.   Within the Clarify Client, if you use the –debugCB option, you’ll get the line number of the last CB error, so it’s pretty easy there.   But in cbbatch, it doesn’t tell you the line number. Error message, no line number   For example, I have a simple cbbatch script that I’ve coded with an error.   Notice how it tells me the error, but it doesn’t tell me *where* the error is.   Let caveman debugging commence. Ugh. More error details   Now, lets add a simple error handler.   At the beginning of my routine, I add an On Error statement: On Error Goto ErrorHandler   And then at the end of…

Interesting Business Rule using MTM properties and aliases

September 9, 2011 I was recently presented with an interesting business rule requirement from a customer. the objective here is when someone closes a case, I can use Rulemanager to send an email to the related CR owner.   Lets give it a whirl. Data Model   First, lets recall the data model.   Cases are linked to solutions (probdesc/workaround), and solutions are linked to Bugs (CRs, Change Requests).   Case >---  Workaround  >--- Probdesc >---<  Bug   A case is related to one workaround, a workaround is related to one probdesc, and a probdesc can be related to many CRs.   So we have a MTM in play (between probdesc and bug) – which makes this a bit interesting, and uncommon. Applications In Use   I'm using Dovetail Admin for configuring rules and rule properties, and Dovetail Rulemanager for processing the rules. Rule Properties   We’re going to need some new…

Dovetail signs on as a sponsor of the Los Techies Fiesta

August 25, 2011 I mentioned Pablo’s Fiesta earlier, and Dovetail has now signed on as a sponsor of Los Techies Pablo’s Fiesta. This is always a great event, and we’re proud to be a part of it. Pablo’s Fiesta - September 30, October 1, & 2; Austin, TX Los Techies Open Space Conference on Software Quality & Craftsmanship The Los Techies blogging community is a truly exceptional group of developers, writers, teachers and mentors who love what we do for a living and take pride in producing quality software.  Because we want to foster this within our software development community, we are proud to sponsor Pablo's Fiesta, a two-day open space conference.  This conference will be dedicated to strengthening and expanding a passionate community, creating quality software & constantly striving to be better at our craft.  To be better craftsmen, we need to:…

Schema 201 Webinar Follow-up

August 24, 2011   Big Thanks! to all those that attended today’s Schema 201 webinar. We had a great turnout!     Slides   The slides from today’s presentation are available on Slideshare.   Recording The webinar recording is available for playback.   Links Schema 101:  http://dovetal.es/schema101webinar   SQL View example: http://dovetal.es/sqlView   SQL View that includes case data, plus a column that indicates “how many open subcases does this case have”   More Info on Dovetail SchemaEditor: http://dovetal.es/dtSchema   More Info (and free download) for Dovetail BOLT:  http://dovetal.es/dtBolt   Future Webinars Have an idea for a future webinar? Let’s hear it!   You can leave a comment here, or drop me an email at gary@dovetailsoftware.com

Linking a solution to a closed case

August 23, 2011 I’ve talked in the past about the functionality and benefits of linking solutions to cases, and I’ve shown how we’ve simplified the process in Dovetail Agent. One scenario that’s come up more often, especially around here, is the need to link a solution to a closed case. A common workflow we see here is: 1. A case is opened for a customer 2. We work with the customer to figure out a resolution to the issue 3. Customer uses SelfService to indicate that the resolution solved the issue, and the customer closes the case (and you know how much I love when a customer closes their own case) Now that we know that the resolution we provided did indeed solve the problem, we can create a solution, so this knowledge can be reused, should the same issue arise in the…

Reminder: Clarify / Dovetail Schema 201 webinar this week

August 22, 2011 Just a little reminder that I’ll be presenting a session on advanced schema topics this Wednesday. We already have a good number of registrants, so it seems like a topic that folks are interested in. Cool! Topics SQL Views Many-To-Many Tables Role Objects Pseudo Relations Exclusive Relations Change Fields Closer look at the ADP tables Those are the topics I have planned to cover. If there’s anything else you’d be interested in, please let me know, and I’ll see what I can do. When Wednesday, August 24, 2011 11:00 AM - 12:00 PM (Central Time) Register Register at: https://dovetailsoftwareevents.webex.com/dovetailsoftwareevents/onstage/g.php?t=a&d=669502491

Upcoming Austin Developer Conferences

August 11, 2011   I’ve been to both of these conferences in the past, and I definitely recommend them  - great stuff.     Austin Code Camp – September 10th   The Austin .Net User Group is proud to sponsor it's fifth Annual Code Camp.   This is one day FREE conference For The Community, By the community.     Pablo’s Fiesta - September 30, October 1, & 2   Los Techies Open Space Conference on Software Quality & Craftsmanship   The Los Techies blogging community is a truly exceptional group of developers, writers, teachers and mentors who love what we do for a living and take pride in producing quality software.  Because we want to foster this within our software development community, we are proud to sponsor Pablo's Fiesta, a two-day open space conference.  This conference will be dedicated to strengthening and expanding a passionate community, creating quality software & constantly striving…

Business Rule Usage Report

August 4, 2011 The other night I got curious and inspired and started working on a Business Rule Usage Report. This tells us what business rules are firing along with how often. Perhaps even more importantly, it allows you to see the rules that are not being fired. Perhaps those rules could be removed, or made inactive, therefore simplifying business rule administration. Or maybe they should be firing, and need further investigation. I ran it against our production system, and it was pretty enlightening. Here’s an example (run against my development database, so the rule firing numbers are pretty small): As part of normal operations, we collect huge amounts of data and usage statistics in our CRM systems. I’m looking forward to exploring more reports like the above that give us insights into system usage. This will be officially released as part of…

No one said CRM was easy.

August 2, 2011 Michael Moaz over at Gartner recently penned an interesting article: We failed at CRM. Now let’s try Social CRM – it’s even harder. A few quotes form his article stood out to me. One of the woman on the panel compared a CRM program to childbirth: “I thought once a child is born, the hard part is over! Boy was I mistaken!” Completely agree. I've been working in CRM since the mid 90's, and one thing is always clear: your systems need to keep evolving. Your business changes. Technology changes. Customer demands and expectations change. Your systems need to change as well. Much of the work we've been doing here at Dovetail over the last 5 years is helping organizations update their CRM systems. Companies poured millions into their CRM systems early on, then left them alone for years, and…

Webinar: Clarify / Dovetail Schema 201

August 1, 2011 In this complimentary webinar, we'll build on the previous Schema 101 session, and dive into more advanced schema topics. We had a great turnout in the first session, and a lot of requests for part 2. Topics SQL Views Many-To-Many Tables Role Objects Pseudo Relations Exclusive Relations Change Fields Closer look at the ADP tables Those are the topics I have planned to cover. If there’s anything else you’d be interested in, please let me know, and I’ll see what I can do. When Wednesday, August 24, 2011 11:00 AM - 12:00 PM (Central Time) Register Register at: https://dovetailsoftwareevents.webex.com/dovetailsoftwareevents/onstage/g.php?t=a&d=669502491