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 = 2 inner join ...

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.cltCode = ssrSubsNum ...

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 just push them directly into Excel to do pivot ...

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 have. If you missed the update webinar a few ...

To get around this for IE, I've read that you can drop a file named favicon.ico into the root of your public site folder and IE will download and use it automatically. That's because IE doesn't allow you to dynamically change a favicon, which is the method used here. Hope this helps!

One of the sessions at November's Blackbaud conference will be Effective Pricing and Discounting Strategies for Arts & Cultural Organizations. With that in mind, we wanted to gather as much feedback as possible to tailor the session to your needs. If you can, please check out the quick, five-question survey below.  Please email your ...

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. When will Windows 7 and Windows ...

Not too long ago, I got a really interesting Raiser's Edge question. "How can I find a constituent's longest stretch of consecutive years given, for my giving clubs?" You may have a great donor who gave from 1995-2005, missed a year, and then started giving again. He wouldn't show up in a Consecutive Years Giving report due ...

Is this PEO or just websites in general?  For PEO, the site folder will have your CSS file(s) in its root, and images are generally in the \images folder and its subfolders, though they could be in the root as well, depending on where they were uploaded.

My colleague Chad recently wrote about 6 Dogooding Webby Things Your Nonprofit Should Check Out, and I wanted to show how quick and easy it is to implement one of those webby things, the Facebook Fan Box. It's not a fit for every organization, but if you have a strong Facebook presence and want to promote it on your website, don't let the ...