Arcana Development Forums http://www.arcanadev.com/forums/forums/ This is an XML content feed of; Arcana Development Forums : Last 10 Posts Fri, 05 Dec 2008 12:14:52 +0000 Tue, 04 Nov 2008 08:49:26 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.04 30 www.arcanadev.com/forums/forums/RSS_topic_feed.asp Arcana Development Forums http://www.arcanadev.com/forums/forums/../images/forumhead.gif http://www.arcanadev.com/forums/forums/ User Surveys : User Survey: Mail-based job triggering http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=99&PID=268#268 Author: Arcana
Subject: User Survey: Mail-based job triggering
Posted: 04 November 2008 at 8:49am

Back in 2004 we put out a standalone mail reading utility called admailpoll that could be used in conjunction with adTempus to do mail-based conditional processing. It downloads messages from a mailbox, filters for various criteria, and sets an exit code used by adTempus to control conditional job flow.

We're now working on integrating mail-based processing directly into adTempus, and are seeking feedback from users are using or would like to use this functionality.

If you're currently using admailpoll, please let us know how you're using it. If you're not, let us know what kind of mail-based processing you'd like in adTempus.

You can post here, send a private message, or use the feedback form.
]]> Tue, 04 Nov 2008 08:49:26 +0000 http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=99&PID=268#268 General : adTempus MSDE Database Schema http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=98&PID=267#267 Author: J.D.
Subject: adTempus MSDE Database Schema
Posted: 03 November 2008 at 9:21am

Database schema documentation is available for adTempus 2.1 and adTempus 3.0.

This is bare-bones documentation; you will need to look at the API docs as well for descriptions of tables (objects) and columns (properties).

The API is the preferred way for developers to interact with adTempus. Direct database updates are not supported.
]]> Mon, 03 Nov 2008 09:21:28 +0000 http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=98&PID=267#267 General : adTempus MSDE Database Schema http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=98&PID=266#266 Author: slick50
Subject: adTempus MSDE Database Schema
Posted: 31 October 2008 at 4:28pm

Is there any doc on the structure of the SQL database? I assume if I want to programmatically search for jobs based on certain values, that I'd need to know what the database structure is. But I can't seem to find detailed info on it.

Maybe that's unnecessary, or the assumption is we'd use some other tool (like adtDbUtil.exe) to look at the structure ourself instead of relying on doc?

]]> Fri, 31 Oct 2008 16:28:07 +0000 http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=98&PID=266#266 API : adTempus 2.0 API - ASP http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=97&PID=265#265 Author: J.D.
Subject: adTempus 2.0 API - ASP
Posted: 30 October 2008 at 6:07pm

The example I linked to earlier from the 3.0 documentation shows an example of using IObjectRequestFilter. But when I said earlier that it would be tough to do in VBScript I should have said "if you can do it in VBScript I don't know how." I don't think VBScript allows you to create classes that implement interfaces, though I haven't worked with newer versions of the language.

You are better off using the example from the 2.0 documentation. If it's not working as written, replace "ClassIDEnum.CID_Job" with the numeric value 1.
]]> Thu, 30 Oct 2008 18:07:29 +0000 http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=97&PID=265#265 API : adTempus 2.0 API - ASP http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=97&PID=264#264 Author: slick50
Subject: adTempus 2.0 API - ASP
Posted: 30 October 2008 at 5:54pm

Would you be willing to provide an example using IObjectRequestFilter? Maybe that's all I need to get me started...

]]> Thu, 30 Oct 2008 17:54:48 +0000 http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=97&PID=264#264 API : adTempus 2.0 API - ASP http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=97&PID=263#263 Author: J.D.
Subject: adTempus 2.0 API - ASP
Posted: 30 October 2008 at 3:55pm

The CID argument to that method is a ClassIDEnum value, which is essentially a constant. If you add a reference to the adTempus type library to your ASP page, this should cause the constants to be defined:
<!-- METADATA TYPE="typelib" FILE="c:\program files\arcana development\adtempus\adtempus.dll"-->

If you get an error back from the method saying that you're requesting an invalid class, that means the script isn't picking up the type library properly and the constant isn't defined. If you can't get the type library import to work you can use the integer value instead of the enumeration. The numeric values are given in the ClassIDEnum help topic. For example, use 1 for CID_Job.

The API did have some "breaking" changes between 2.x and 3.0 (documented here). But for the basic stuff you are (presumably) doing, the changes to move to 3.0 should be minimal.



]]> Thu, 30 Oct 2008 15:55:17 +0000 http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=97&PID=263#263 API : adTempus 2.0 API - ASP http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=97&PID=262#262 Author: slick50
Subject: adTempus 2.0 API - ASP
Posted: 30 October 2008 at 1:55pm

How portable is code written for 2.0 after an upgrade to 3.0?]]> Thu, 30 Oct 2008 13:55:35 +0000 http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=97&PID=262#262 API : adTempus 2.0 API - ASP http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=97&PID=261#261 Author: slick50
Subject: adTempus 2.0 API - ASP
Posted: 30 October 2008 at 1:30pm

Your question of why we are moving to 2.1 instead of 3.0 is a good and legitimate one. The answer is related to accounting - not for technical reasons.
 
I have been using the example in the 2.0 API doc you referenced. But when I try and translate that example into something else, I run into the stumbling block of not being able to decipher the API documentation. For example, I can see that GetObjectsForClass is a method, which takes ClassIDEnum.CID_Job as an argument. But I can't get my arms around, even after reading the doc, is what the structure of that argument is, or how I build or pass different arguments. This is obviously a limitation of my programming knowledge, which also limits my ability to understand what it really means to be "build with ASP.NET" versus "classic ASP". To me, ASP is just vbscript embedded in HTML. And I understand vbscript, so classic ASP wasn't that difficult. But I don't know how that compares with ASP.NET.
 
I'm just really looking for more examples at this point, and hopefully your references will help. Thanks for your response.
]]> Thu, 30 Oct 2008 13:30:55 +0000 http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=97&PID=261#261 API : adTempus 2.0 API - ASP http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=97&PID=260#260 Author: J.D.
Subject: adTempus 2.0 API - ASP
Posted: 30 October 2008 at 10:43am

If you are just now migrating from the Arcana Scheduler (if I understand correctly), you should strongly consider going to adTempus 3.0 instead of 2.1. Why migrate to a version that's already obsolete?

There is a rudimentary Web interface available for adTempus 2.1 here, which is built using classic ASP using VBScript. You might be able to use that as a starting point. There is a nicer Web interface for adTempus 3.0 here; it's built with ASP.NET.

There is an example in the API documentation (here) that shows how to get a job by name.

The GetObjectsWhere method you are trying to use does not accept a SQL statement directly; you must pass an IObjectRequestFilter interface to an object that provides the selection criteria. This is tough to do in ASP because of the limitations of VBScript; it's easier to use the approach shown in the example cited above. The 3.0 API documentation has an example that shows how to use GetObjectsWhere to get jobs by name in ASP.NET (here).
]]> Thu, 30 Oct 2008 10:43:19 +0000 http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=97&PID=260#260 API : adTempus 2.0 API - ASP http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=97&PID=259#259 Author: slick50
Subject: adTempus 2.0 API - ASP
Posted: 29 October 2008 at 4:46pm

Hi. I was able to fight my way through developing a simple web interface with ASP using the Arcana API. The web interface provided some rudimentary control over scheduled jobs.
 
I'm in the process of trying to migrate that ASP code to adTempus 2.x, but I'm having difficulty understanding the API documentation. Because I am not a programmer, I get lost in all the object/interfaces/classes jargon.
 
 
I don't quite understand what the arguments are for the GetObjectsWhere method. From the doc it appears I should be using "IObjectRequestFilter", but I can't figure out how the doc of that "interface" translates into ASP/vbscript:
 
set objADTempus = CreateObject("ADTempus.Application")
set objScheduler = objADTempus.Connect("","")
set objJob = objScheduler.GetObjectsWhere("SELECT * from job where name=bogus_name", 0, true)
 
This ends with a "Type mismatch: 'GetObjectsWhere'" error.
 
Can someone please provide me with simple ASP/vbscript code which will allow me to select a particular job based on the known job name?
]]> Wed, 29 Oct 2008 16:46:12 +0000 http://www.arcanadev.com/forums/forums/forum_posts.asp?TID=97&PID=259#259