The Spotlight
The Official Blog for Arts and Cultural Organizations

Browse by Tags

All 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...
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...
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...
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...
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...
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...
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...
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...
Three Questions About Virtualizing Patron Edge
I've been on upgrade planning calls with about a dozen organizations in the last few weeks, and several have asked about putting Patron Edge in a virtual environment. Three questions have come up repeatedly and I want to address them and give some...
The 20-Minute Test Environment, Part I
Things have been quiet on the blogging front for the last couple of weeks; I've been playing with some cool technologies like the CodeIgniter framework for creating web applications and the jQuery library (with these awesome video tutorials ) for...
Best Practices for PE/RE integration, part III
This is the final part of my three part series on integration between Patron Edge and The Raiser's Edge. In this part, I'm going to go over one of the things that all organizations battle with, regardless of the CRM application used - duplicate...
Sweet New Features for Patron Edge
If your organization is running Patron Edge 3.340, patch 2 is now available for download at http://downloads.blackbaud.com . It includes fixes for the following reported issues: BB575312 - Error: Microsoft OLE DB Provider for ODBC Drivers: [Microsoft...
Patch 11 for Patron Edge 3.310 has been released
Patch 11 for Patron Edge 3.310 is now available for download at http://downloads.blackbaud.com . This patch adds compatibility with the upcoming release of The Raiser's Edge 7.9. Make sure you have a patch plan and can handle the downtime it takes...
Feature Preview: Gift Certificate/Voucher Report
So I'm always talking about using multimedia to engage your audience online, whether it is telling your story through pictures, audio or video. I decided to walk the talk a little bit and created this brief screencast to give you an idea of what to...
Patron Edge 3.310 patch 10 is now available
Happy integration patch day! Patch 10 for Patron Edge 3.310 is now available for download at http://downloads.blackbaud.com and includes fixes for the following reported issues: BB350540 - Error synchronizing membership for : Field is read only: Type...
More Posts Next page »