How To Read A Calyx Point File in ColdFusion

Well, after the huge success of my last custom tag, I decided to write another. This time, it is incredibly useful, but at the same time completely useless (instead of just partially useless). I'll explain the useful part first.

This tag is designed to read and decrypt a file, but not just any file. In my time working for a large mortgage company, I discovered that the majority of mortgage brokers and loan officers use a piece of software called Calyx Point to manage their loans. Point stores its files on the computer in an "encrypted" format. I did manage to find a plug-in that would read a Point file, but only in VB6. Obviously, this did me no good. So I managed to "crack" the encryption, and wrapped the whole thing in a custom tag. Now, you (or anyone else for that matter) can now process and read Point files via the web using ColdFusion. This saves the broker(s) from having to retype all the borrower/loan information twice (i.e. once in Point, and once on your site, now just once in Calyx Point)

Now for the useless part. Unless you've been under a rock, I'm sure that you've noticed that there has been a major shake up in the financial industry, particularly as it relates to mortgages. So, with mortgage companies shutting down left and right, there is not much need for this any more. At least for the next little while.
In any event, here it is. This tag receives the absolute path of a valid Calyx Point .BRW file. This is the raw file where Point stores its data (so don't do an export or anything). It also requires the name of the result in which to store the data. The result is an array.

The only other thing you need to know is the point field numbers. There are something like 10,000 fields that Calyx Point stores. I have not named them all; however, I have kept the same numbering as Point. So for example, the borrower first name is 11, so here you would just reference it as myData[11]. Unlike point, the array that is created has every field number. If it does not exist in Point, it WILL exist in the array, just as an empty string. There is a way to print out all of the field numbers in Point, but I'll see if I can't find an copy and post it here.
That's pretty much it. This is not perfect, as there is not much error handling and such. Also, there are a few problems with the Point comment fields, as Calyx Point does not handle comments very well. Perhaps if I return to the mortgage industry, I could perfect this tag; for now, it works.

CF_Point Custom Tag

Enjoy!