Welcome to Forums Sign in | Join | Help | Forums
in Search





Make the world a better place.

Browse by Tags

Patron Edge (RSS)
  • SQL Queries for Patron Edge, Part III

    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...
    Posted to Weblog by Nicholai Burton on 11-18-2009
  • SQL Queries for Patron Edge, Part II

    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...
    Posted to Weblog by Nicholai Burton on 11-13-2009
  • SQL Queries for Patron Edge, Part I

    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...
    Posted to Weblog by Nicholai Burton on 11-11-2009
  • 3.401 and 3.41 update released!

    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...
    Posted to Weblog by Sean Long on 10-20-2009
  • PE and PEO Updates Demystified

    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...
    Posted to Weblog by Nicholai Burton on 10-15-2009
  • Older, Wiser and Engaged in the Arts

    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...
    Posted to Weblog by Kieran Healey on 10-14-2009
  • Relationship Management Conference 2009 Part 1

    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...
    Posted to Weblog by Kieran Healey on 10-14-2009
  • Patron Edge Update Webinar FAQs

    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...
    Posted to Weblog by Nicholai Burton on 09-23-2009
  • Scanning on a Shoestring

    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...
    Posted to Weblog by Nicholai Burton on 07-27-2009
  • The Summer of Updates

    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...
    Posted to Weblog by Nicholai Burton on 07-14-2009
Page 1 of 6 (51 items) 1 2 3 4 5 Next > ... Last »