Congratulations to Asher at our partners Tech-Pro, who has made his first sale of Toucan Navigate 2007 to a customer in India!
Also congratulations to Jean-Michel Davault at Hommes et Process and Clive Davies at D2i - both have passed the new Microsoft Office Groove 2007 certification exam. If you're looking for a partner to help with implementing Groove, then you should consider J-M and Clive to be your "go to" guys, if you're in the UK or France.
I've just uploaded a new release of Toucan Reporter 2007. This release, 2.0.11 features new icons for the application and the report files well as fixes for a couple of bugs.
Working with files in Groove seems to be a theme, this month. We're just finishing off a project for a customer who has lots of forms records with lots of attachments. This is affecting forms performance, as well as being unwieldy, so we're moving the attachments out of the forms tool and info a files tool. This makes them amenable to searching with our recent free Tocuan FileFinder application.
Here's the script that extracts the files from the forms tool, written in the Boo programming language:
/*
Class: ExportAttachments
Exports the attachments from a forms tool
*/
class ExportAttachments (GrooveScript):
def Main():
try:
space = Groove.GetSpace("DMS2")
formsTool = space.GetFormsTool("Billing")
data = formsTool.GetData("All Records", "", true)
table = data.Tables[0]
for row in table.Rows:
cust = row["CustomerName"]
purchaseOrder = row["PONum"]
rec = GetFormsRecord(row)
print "${cust}/${purchaseOrder}"
for attachment in rec.Attachments:
attachment.SaveToFolder("C:\\temp\\${space.Name}\\${cust}\\${purchaseOrder}");
except e:
ReportError(e)
I'm pretty happy with this - it expresses my needs clearly with (almost) a minimum of overheads. I particularly like the the SaveToFolder call which constructs the folder path using the variables declared earlier on. The only ugliness is getting the data with GetData, and then getting the zeroth table from Groove in two lines rather than one.
What about error checking you may ask? Well, it is included - at two levels. First, if there was any of the usual problems (space or tool not existing for example), you would see a warning message. GetSpace, for example, will post a warning message if the space does not exist. If something unusual happens, the ReportError script function will give you a detailed report.
Of course, I'm only going to take a part of the credit - the code responsible for integrating with Groove. The clarity of programming in Boo is down to Rodrigo B. de Oliveira and numerous supporting developers.
If you want to have a play with Bambuco - go right ahead and download it here.
Our main objective with Toucan Navigate is to help people create meaningful maps very quickly. If you're looking for readily-available datasets, try these two web sites. Both provide useful and free data that can be downloaded and displayed in Toucan Navigate. Once downloaded, with just a few mouse clicks you can start viewing them over the roads maps and satellite imagery from Virtual Earth. You can also edit these datasets to fit your specific needs.
Download Toucan Navigate and start mapping your data now.
Not only free, but useful too! We've created a small utility program to help you find files in Groove files tools.
