How To Read A Calyx Point File in ColdFusion

Posted At : October 26, 2007 4:31 PM | Posted By : Phillip Gagnon
Related Categories: 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!

Comments (10) |

Print |

Send |

del.icio.us |

Digg It! |

Linking Blogs | 682 Views

Comments

[Add Comment]

Unfortunately it is true that firefox 3 final is slower and even worse than 2.0.14. I used two copies of firefox 2.0.14 http://www.picktorrent.com on two computers, one is XP sp3, one is Vista sp1, both of them have plenty of unused memory.

# Posted By kathro | 8/12/09 11:59 AM

http://www.b2c2u.com/ air jordan
http://www.handbagsaol.com gucci handbags
http://www.mallaol.com/ air max shoes
http://www.mallaol.com/ nike air jordan
http://www.mallaol.com/ nike air max
http://www.mallaol.com/ nike shox
http://www.mallaol.com/ Football Jerseys

# Posted By air jordan | 3/23/10 10:19 AM

http://www.saleairmax.com nike air max
http://www.saleairmax.com/Max_90.html air max 90
http://www.saleairmax.com Nike air max shoes 2009

# Posted By air max | 4/1/10 11:08 PM

Cooking
Another good skill to pick up. Some of the better meats give bonuses like +12 to spirit for 20 minutes. Stuff like that helps in the long run.

# Posted By wow power leveling | 4/3/10 1:27 AM

# Posted By ed hardy | 4/6/10 2:26 AM

# Posted By air jordan shoes | 4/14/10 5:44 AM

# Posted By air jordan shoes | 4/15/10 4:17 AM

http://www.sale-sunglasses.net aviator sunglasses
http://www.sale-sunglasses.net sunglasses hut
http://www.sale-sunglasses.net sunglasses 2010
http://www.sale-sunglasses.net new sunglasses

"Love is not a thing to understand.
Love is not a thing to feel.
Love is not a thing to give and receive.
Love is a thing only to become
And eternally be. ."----------?love?

# Posted By aviator sunglasses | 4/16/10 5:33 AM

http://www.mbtshoesaleonline.com mbt shoes
http://www.mbtshoesaleonline.com mbt shoes online
http://www.mbtshoesaleonline.com mbt shoes online
http://www.coach-handbags-outlet.com/ coach handbags
http://www.coach-handbags-outlet.com/ coach bags outlet
http://www.coach-handbags-outlet.com/ coach handbags on sale
http://www.coach-handbags-outlet.com/ coach bags on sale

# Posted By Coach Maggie Bags | 8/9/10 3:53 AM

We are traveling by train. Out timberland hiking boots windows, we drink in the passing scene of cars on nearby highways, of children timberland shoe company waving at a crossing, of cattle grazing on a distant timberland boots hillside, of smoke pouring from a power plant, of row upon row of corn and wheat, of flatlands and timberland wheat shoes valleys, of mountains and rolling classic 3 eye timberland boat hillsides, of city skylines and village halls.But uppermost in our black timberland boots minds is the final destination.

# Posted By timberland shoe company | 8/27/10 9:16 PM

[Add Comment]

Sun	Mon	Tue	Wed	Thu	Fri	Sat
			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30