Tuesday, November 2, 2010

Lead automation

I'm coming to the end of neat project for a Cruise Experts Travel.  They had a lead automation system in place which consisted of a number of interacting parts.  One was a small part of an application they'd used in the past (but have since moved away from) and required the regular investment of licensing fees.  Another was custom-made using Microsoft Access.

The purpose of the lead automation system is to take information from the visitors' form submissions on their various websites and have the data added directly into their CRM as a lead, so as to save on time, reduce waits, and eliminate date-entry errors.

One problem was that their lead automation solution didn't work quite right.  It was usable, but wasn't ideal.  Employees had to manually trigger its run throughout the day, and it didn't account for the way they used of their CRM (with regard to custom fields, and label conventions).

I put together a new lead automation system using C#,  MS SQL stored procedures, and a little bit of VBScript.  The C# and stored procedures were interesting to work on.  The VBScript, not so much.

There was no API, so I was forced to interact directly with the CRM's database, and I was completely unfamiliar with it.  There was no documentation on its schema, and I could find little on even the database engine.
But that's one of the fun things about and stressful things about Computer Science — solving puzzles!  Stressful  first and during; fun afterward.

One of the first things I decided to do was write a database explorer.  It allowed me to view tables, send queries, and otherwise research the system.  It was unimaginably helpful.
Actually, you can probably imagine pretty easily how helpful it was.

I extended the testing process, because I wanted to be certain that everything worked as I expected, and I'm glad I did.  Now the new lead automation system is mostly done, and is currently in use.
There's one final issue I'd like to work out, and I'm pretty sure I did so earlier today.  I'm just waiting now to confirm.

As it stands, they seem very happy with the result.  Which is always awesome.  And now that I know the system and am comfortable working with ClientBase (the CRM), it opens up a whole new set of opportunities for them and for me.

Sunday, May 9, 2010

Legend Painting

Altered effect's newest website is live, and it is LegendPainting dot com

Legend is a painting company based out of Vancouver (that's a city in British Columbia, Canada, btw) and offers a variety of services, from residential to commercial. 

Along with the design and CMS package - which allows them keep their website fresh and vibrant (painting reference, nbd) with ease - there's the website's header, which is a flash slideshow developed specifically for their design.  

And if they want to add pictures to it?  Man, that's so easy!  We've integrated it right into the CMS.

So, If you're in the market for painters, and located somewhere in the Vancouver area, just remember that you can request a quote directly from their website.  That's pretty cool, I know.  We're basically living in the future. 

Just kidding we're living in the present.

Tuesday, May 4, 2010

blog spot?

I made a blog!  Using Blogger?
Now i know what it's like, and how to connect it to a google buzz account!
I've accomplished everything i set out to, when registering this guy - but it's kind of neat.  I kind of like it.  Maybe I will use it a few times, just for fun.

But probably not.