This is my final entry in the series on SQL queries for Patron Edge. Today let’s take a look at the access control tables, so we can do some cool stuff with barcode scanning results: select * from Barcodes_Log inner join Barcodes on Barcodes.brtSourceCode = Barcodes_Log.brtlCrossRefID and Barcodes.brtSourceTable...

Continuing on yesterday’s theme, here are a few more tables and joins to do with what you will. We’ll start with the SubsStaticReport table this time, which is a data warehouse table that contains all of your subscriptions and memberships. select * from SubsStaticReport inner join Clients on Clients...

While giving a session at the Museum Computer Network conference on extracting data from a Patron Edge database, one of the attendees suggested creating a handful of sample queries. The idea is that with some samples showing the important table joins, users can run with them, expand on them, or even...

We are happy to announce that we have released new versions of The Patron Edge and The Patron Edge Online. Here are a few things to get excited for: Patron Edge 3.401: Coupon codes: You can now use Alphanumeric codes for Coupons! They no longer need to be things like 1234, they could be BOGO (Buy One...

Being the type who always wants to use technology to take things to the next level, I've done some more experimenting with screencasting. This video will take you through an update for Patron Edge 3.401 and Patron Edge Online 3.4.1. The video is about 17 minutes and should answer any questions you...

During our conference we discussed segmentation and social media. Here are excerpts from those discussions. In particular delegates acknowledged that the demographics of their audience are evolving, whilst attendance had generally held well throughout the economic downturn (to date). Social Media / Networking...

Thank you to everyone that attended our conference in London - 12th and 13th October. We reworked the Arts and Culture track this year, as part of the wider Relationship Management Conference. A significant element of the programme were guest speakers, from Arts and Cultural organisations across the...

Thanks to everyone who was on the update webinar today. Amie did a great job of explaining the process and showing the new features, and we heard some really good questions. With that in mind, I wanted to go ahead and post the information so those of you who missed the webinar can still catch the highlights...

I know some of you have looked into getting Wireless Access Control for Patron Edge, and then reconsidered after seeing how much a quality wireless scanner costs these days. The Symbol MC55 is about $1000 a piece, and lower-end scanners tend to be less reliable in scanning successfully. One of our clients...

As updates to our security release continue over the summer and our PA-DSS-compliant build is being finished, we've hit all of the usual issues that come up with any update. Here are a few things you can do now that will make sure your update goes as smoothly as possible. Get the environment right...