http://travisdunbar.blogspot.com/2009/12/taskcentre-dynamically-naming-file.html
Took me a bit of playing around to dynamically generate the name of a file I was saving. I blogged an though I would share.
My goal was to save a file using the current date; for example:
foo_MMDDYYYY.txt
In the Save As File object, set the Filename property as so:
Week16_{=Month(Date())}{=Day(Date())}{=Year(Date())}.txt
I'm trying to use the "Run Program" Tool in a Task. I'm pointing it to an EXE file that takes two parameters: the first is a path to an XML file and the second is a key/value pair. From the command line, I call the program like this:
MyProgram.exe config.xml id=123
What is the equivalent in TaskCentre? I have the following configuration but it does not appear to work:
I'm having issues getting a Taskcentre trigger to work in my iMIS database. The trigger is failing when it has to create an instance of an OLE object (sp_OACreate). I confirmed that the public DB role has execute permissions on sp_OACreate. This code is autogenerated by Taskcentre v4. It fails on creating this object and therefore doesn't get to my custom code. Any suggestions?
I am getting the following error when setting up an email task in iMIS TaskCentre:
Error while evaluating expression : Syntax error - {=<SPAN class=GramE>ThisStep.RecordSource(</SPAN>"Testing")}
This message is coming up during the HTML step of the task. What I am looking to do is add the Notes field from Meet_Master when there is a value in that field. Not all the events require any Notes, however, some do.
Anyone interested in sharing their TaskCentre experience?
I posted something to my blog at:
http://travisdunbar.blogspot.com/2009/04/imis-taskcentre-new-member.html
This task was developed for a bar association. Judicial circuits are made up of counties, usually several counties to a circuit, and bar associations want to know what judicial circuit an attorney practices in. Assigning circuits is typically a very manual process. This task makes use of a judicial circuit lookup table, where the description contains a comma-delimited string of the names of the counties included in the district. Every time an attorney's county is changed the task is fired and automatically updates the circuit.
This task and stored procedure generate concatenated salutations based on setups in Gen_Tables every time a name is changed. Essentially, the description line in the Gen_Tables stores the SQL statement for the salutation. When a name is changed or added, the task fires a stored procedure that uses the Gen_Tables setups to create all the "auto" salutations for the donor. The solution also accommodates manually created salutations, for instance for the occasional record that would have a special executive's salutation, leaving those alone when it rebuilds the auto salutations.
This example shows how to use user-defined checkboxes to automatically create or update dues billing lines for section. It was developed for a bar association demo, where they wanted members to be able to sign up for sections on the web. Just checking the section box creates the dues line. Click on the "Pay my dues" link, and the new section billing is there!
Zip contains a task and a stored
There is a new "book" of TaskCentre samples and examples drawn from some of the interesting stuff we've been doing for iMIS demos over the past months. We've gotten LOTS of wows as we show these. You'll find them under the Implementation tab, way at the bottom, under Third Party Products. Or search. From that location, you can download tasks ready for import into iMIS TaskCentre, along with scripts for stored procedures when they require them.
