October 22, 2008
Recently I had the need to consume JSON in ClearBasic. For example, I make a request to a web service, and the service returns a result set in JSON format. I want to display those results within Clarify. JSON JSON (JavaScript Object Notation) is a lightweight data-interchange format. JSON is a pretty popular data transfer format, especially for the web. Here's an example of a simple JSON object: { FirstName: Joe, LastName: SixPack, Programming Languages: [ClearBasic, Perl, Ruby] } A real-world JSON example I can make an HTTP request to a Google API to perform a web search. The result will be in a JSON format. For example, a search for "fcsdk powershell" can be made by using this URL: http://ajax.googleapis.com/ajax/services/search/web?v=1.0&q=fcsdk%20powershell The result will be this: {"responseData": {"results":[{"GsearchResultClass":"GwebSearch", "unescapedUrl":"http://blogs.dovetailsoftware.com/blogs/gsherman/archive/2007/04/25/using-the-fcsdk-in-powershell.aspx", "url":"http://blogs.dovetailsoftware.com/blogs/gsherman/archive/2007/04/25/using-the-fcsdk-in-powershell.aspx", "visibleUrl":"blogs.dovetailsoftware.com", "cacheUrl":"http://www.google.com/search?qu003dcache:u9RLwKjiIPYJ:blogs.dovetailsoftware.com", "title":"Gary Sherman : Using the u003cbu003efcSDKu003c/bu003e in u003cbu003ePowerShellu003c/bu003e",…
November 18, 2008
Long time ClarifyCRM users may have a number of traditional Clarify queries accumulated over time. After such a business acquires Dovetail Software CRM products for Clarify database, it becomes one of the migration issues: how to reuse Clarify queries in the new thin client. Dovetail Software Agent has no built-in support for Clarify queries, and for a good reason. fcQuery is far superior to traditional Clarify query model and all the users are highly encouraged to abandon Clarify queries in favor of fcQueries. If the business no longer uses Clarify Classic Client, migration is a must. Until the release of Dovetail Agent v.4.2. the only way to move a Clarify query to fcQuery was to recreate it manually. The new Dovetail Query Converter makes migration of Clarify queries into fcQueries very easy. Clarify Query vs. fcQuery These are the…
October 24, 2008
I am currently working on a project where I need to take a database from empty to usable with a script file. I am at the point where I need to import data files, and the data files I need to import don't exist. The customer has the data, and luckily they have a tool to create nice, tidy data files for me - Dovetail Software's Data Import Export Tool (DIET). The challenge for me is to make it easy for them to use DIET, so I can get the data files that I need. DIET is the perfect tool for the job, because it is designed to do exactly what I need. I need data from three related tables in the database for this file, so I created a directives file to specifically control what information to…
One of my favorite features in Dovetail Mobile Agent is the Recent Workgroup Case Activity view which displays a listing of all the cases recently modified by agents in my workgroup. At the end of the day I sometimes browse Recent Case Activity using my Dash from the comfort of a bar stool or easy chair. Here is a snapshot of the Call Administrator workgroup (my emphasis not some silly CSS style) This is also quite a handy view for Support Managers wishing to keep tabs on their minions agents. Why filter by workgroup? The short answer is to avoid drinking from the support information fire hose. We are using the employee workgroup as an way to logically divide up an organization. For most organizations trying to see all case activity for any reasonable time period, say a day or…