Another Attendance Register Form Question

RevWJones · Post by **RevWJones** » Wed Mar 28, 2007 6:20 pm

We use the Attendance Register Form (ARF) as a sign-in sheet for tracking attendance. Power Church, v10 allowes us to sort by Roles but each time we add a new role, we have to resort our many roles. This is a very painstaking process. Is there anyway to save the sorting even after adding a new role? Or, is there a way to print the roles after we've sorted them so we can use it as a template to assist in the resorting later?

RevWJones · Post by **RevWJones** » Thu Mar 29, 2007 10:17 am

We ended up last night typing our roles (only have 94) into Excel to keep the order and manipulate as required. Now the question is, "Is there any way to import the Excel data, and maintain the order, into PowerChurch?" ---- Please help. Thanx

NeilZ · Post by **NeilZ** » Thu Mar 29, 2007 12:16 pm

RevWJones wrote:We ended up last night typing our roles (only have 94) into Excel to keep the order and manipulate as required. Now the question is, "Is there any way to import the Excel data, and maintain the order, into PowerChurch?" ---- Please help. Thanx

I know as a long-time user there is no way to import Excel data into Powerchurch.

FWIW .. exactly why are you trying to sort this data. Perhaps if you give us all an idea on how you're using the roles tag, we may come up with an idea to save you time.

Post by **Zorak** » Thu Mar 29, 2007 2:12 pm

If I understand the original question, I think this is in regards to the report options in the Attendance Register Form allowing you to set an active sort by role. You can click and drag the roles into the order you want them to be in. The report saves your preferences from one run to the next.

When you add a new role, we are discarding the saved orders in the Attendance Register Form. If that is the case, we may be able to do something about that.

I will go ahead and write this up as an issue / suggestion in v10.

Just for my own curiosity, what are some examples of your roles? 94 sounds like a lot of roles to be using...

RevWJones · Post by **RevWJones** » Sat Apr 07, 2007 3:29 pm

We have a role for every human funtion across all of our ministries. We have "delivery" as a role. We have the same number of Asst. Roles as we have of regular roles. In all of our ministries, we have the standard President, Vice President, Chaplan, Secretary. We have the following as well: Deacon, Trustee, Church Clerk, Church Secretary, Jr. Deacon, First Lady, Member, Student, Teacher, Visitor, Tutoror, Student Teacher, 1st Vice, 2nd Vice, 3rd . ., 4th . ., 5th . ., Associate Minister, Minister, Evangelist, Director, etc. All of these roles have been utilized in our church for more than 100 years. The 94 probably doesn't complete the list but it covers the majority. So when we add a new role because we've missed one, we have to go back through the sorting again.

Just to re-state our purpose for using these roles: We provide the Attendance Register Form for all activities to track attendance. I have to say, that more and more, our members, wherever they're serving, have begun to really look forward to seeing their names on these lists. It sortof provides a deep sense of belonging and fellowship for them. Our attendance has greatly improved since we've started to use these forms. But, since we've sorted our role order, we place the leadership positions on the top of the form and the student, members and other positions following that. This format provides a level of respects for our leaders and also help to quickly identify our classes and groups by the leaders names.

Another question:
Is it possible to sort these roles and then somehow apply this sorting to others who also print these type of forms w/out having to manually re-sort under each PC user?

Last question:
What is the minimum level of access needed to simply print this form and log the attendance? We don't want to allow these people to add new students to classes or drop students from the class. We just want them to be able to print their list and log their attendances.

Again, thanks for anything you can do.

A growing PC user.

NeilZ · Post by **NeilZ** » Sun Apr 08, 2007 12:35 am

Quick question ...

do you have these 'roles' setup by activity department, and type ?? And are these assigned to each person under each activity ??

Post by **Jeff** » Sun Apr 08, 2007 6:42 pm

As a follow on to Neil's questions, are all these roles used in Sunday School Classes? You will only need to resort the roles if you add a new role to be included in the attendance register forms.

Post by **Zorak** » Mon Apr 09, 2007 9:10 am

The issue with the sorting has been addressed in the latest v10 Maintenance Release, dated 4/3/2007. Newly added roles will appear at the top of your previously sorted list.

Is it possible to sort these roles and then somehow apply this sorting to others who also print these type of forms w/out having to manually re-sort under each PC user?

I will put that in as a suggestion. Currently, it is per user.

What is the minimum level of access needed to simply print this form and log the attendance? We don't want to allow these people to add new students to classes or drop students from the class. We just want them to be able to print their list and log their attendances.

Having the minimum "Access" level set will allow a user to print reports.

RevWJones · Post by **RevWJones** » Mon Apr 09, 2007 2:50 pm

NeilZ wrote:Quick question ...

do you have these 'roles' setup by activity department, and type ?? And are these assigned to each person under each activity ??

Yes. And, had I put this question/issue out here earlier, your response was what we needed back then as we had to revisit these roles/types/depts on several times before we had a clearer understanding of just how they worked. Good catch just the same.

However, since upgrading to v10, the dept. were not appearing when selecting the activity. Just noiced that since the 4/3 MR, the types are also not showing up when selecting the activity. However, this is less of a problem that the sorting issue.

RevWJones · Post by **RevWJones** » Mon Apr 09, 2007 2:56 pm

Jeff wrote:As a follow on to Neil's questions, are all these roles used in Sunday School Classes? You will only need to resort the roles if you add a new role to be included in the attendance register forms.

Thanks, Jeff for your question and response. You are exactly correct in your analysis. This is the exact way we're using these roles. But following the 4/3 MR, my sorts are maintained! Now all I have to do is the position the new roles where desired! When these roles are sorted, and you print your Attendance Register forms for sign-in sheets. It really looks very nice on paper. It really helps our teachers to not hunt through the many names to find theirs. There they are, right there on top! And especially in our teens and junior's classes, it separates the student and teacher roles and, believe me, in our church, that helps in more than one way!

RevWJones · Post by **RevWJones** » Mon Apr 09, 2007 3:00 pm

Zorak wrote:The issue with the sorting has been addressed in the latest v10 Maintenance Release, dated 4/3/2007. Newly added roles will appear at the top of your previously sorted list.

Wow! Thank you very much!

Is it possible to sort these roles and then somehow apply this sorting to others who also print these type of forms w/out having to manually re-sort under each PC user?

I will put that in as a suggestion. Currently, it is per user.

Thank you for your support. At least when I set them now, I don't have to touch them again until adding a new role.

What is the minimum level of access needed to simply print this form and log the attendance? We don't want to allow these people to add new students to classes or drop students from the class. We just want them to be able to print their list and log their attendances.

Having the minimum "Access" level set will allow a user to print reports.

Great!!! Now my teachers and leaders can print their own. However, it doesn't appear that they can enter their attendance data with this minminum access level. Right?

All-in-all. THANKS!!!!!!!

Post by **Zorak** » Mon Apr 09, 2007 4:21 pm

RevWJones wrote:We just want them to be able to print their list and log their attendances.

Sorry, I didn't catch the second half of that. They would need to have "add/change" rights as well to enter new attendance data.