Comments for David Turner

Comment on Arena as a CMS by Robby Morales

Robby Morales — Mon, 08 Mar 2010 14:48:14 +0000

Thanks for the post Steve. I was a pastor for 4 years and we used Shelby. Cost was definitely an issue so I can sympathize with Glenn. On the other hand, I worked with Open Source solutions as well and the security was very sketchy. I finally decided on http://churchinsight.com and it addressed both the security and cost issues. Thanks again!

Comment on Can You See Me Now? by la martina polo

la martina polo — Fri, 08 Jan 2010 23:35:21 +0000

Interesting post. I really appreciate you for posting this.

la martina polo

Comment on eRA by David Turner

David Turner — Tue, 13 Oct 2009 15:01:21 +0000

Also need this view…

CREATE VIEW [dbo].[cust_ccv_v_family_giving_weekend]
AS
SELECT DISTINCT
[dbo].[util_funct_saturday](C.contribution_date) as weekend_date,
family_id
FROM ctrb_contribution C
INNER JOIN core_family_member FM ON FM.person_id = C.person_id
WHERE C.currency_amount > 0

Thanks Austin.

Comment on Sample Metric by Wesley Jones

Wesley Jones — Tue, 06 Oct 2009 16:25:10 +0000

David,

Thanks for the scripts. I used the historical script so I could see what everything looked like.

Now I would like to use the script that uses the agent to collect the information. Do I delete all the membership status metrics and run the top script or just run the top script on this page?

Thanks for any help!

Comment on Staff Anniversaries by Nick

Nick — Mon, 03 Aug 2009 17:14:19 +0000

We also discovered if a person did not have a position value set, they would not show up in the anniversary report. To fix that, I changed the POS.varchar_value SELECT in the second half of the stored procedure to this: ISNULL( POS.varchar_value, ” )

Comment on Staff Anniversaries by Nick

Nick — Thu, 16 Jul 2009 19:15:23 +0000

BTW, we’re using your “Staff Anniversaries” technique now and everyone loves it. We only tweaked the style a bit to make it a tad smaller. Thanks again – great job!

Comment on Arena as a CMS by In the Arena : Doing Your Homework

In the Arena : Doing Your Homework — Wed, 15 Jul 2009 18:28:25 +0000

[...] for the application that best fits your needs. Check out Renewing Mind and this blog for starters. Published Monday, July 13, 2009 11:03 AM by [...]

Comment on Staff Anniversaries by David Turner

David Turner — Tue, 07 Jul 2009 15:09:55 +0000

Updated stored procedure to use a connection specific temporary table instead of a global temporary table (renamed all occurrences of ##StaffHtmlTable to #StaffHtmlTable). Hopefully that fixes the ‘Table already exists’ errors we’re getting sometimes. The HtmlFroStoredProcedure module really could benefit from some output caching.

Comment on Staff Anniversaries by David Turner

David Turner — Tue, 07 Jul 2009 15:06:16 +0000

Nick, No really haven’t thought about it much. Probably should though. I see that Jason is implementing some lower-level caching in the framework he’s using for the HR modules. I’m interested in seeing more of what he’s doing.

Comment on Arena as a CMS by chrisrivers

chrisrivers — Mon, 22 Jun 2009 14:40:45 +0000

Well said Steve!