CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviCampaign (Moderators: Kiran Jagtap, xavier) »
  • CiviPetition Signature Count Slow, Signature Count output to views available?
Pages: [1]

Author Topic: CiviPetition Signature Count Slow, Signature Count output to views available?  (Read 2032 times)

jacobhunter

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: 3.4.2
  • CMS version: Drupal 6.22
  • MySQL version: 5.0.92-community
  • PHP version: 5.2.14
CiviPetition Signature Count Slow, Signature Count output to views available?
July 19, 2011, 02:21:22 pm
Hi,

When using CiviPetition, I have noticed the search for signatories starts to take a very long time once the number of signatures passed about 1000. Has anyone encountered this problem?

Also, is it possible to get a simple output of the number of signatures to Views and/or to the Thank you page?

Great work on this project, it's a much cleaner solution than other petition systems we've tried.

-Jacob Hunter, WhyProhibition.ca

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: CiviPetition Signature Count Slow, Signature Count output to views available?
July 19, 2011, 02:58:17 pm
Hi,

We got a few stuff in the pipe along that line, but mostly hardcoded and not ready to be shared unfortunately.

Do you have some coding skills/budget? Happy to give you some hints.

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: CiviPetition Signature Count Slow, Signature Count output to views available?
July 19, 2011, 03:37:27 pm
Hi,

I have recently given up on using survey functionality for the reason you state. I did spend some time looking at why it is slow & logged a couple of issues (this one being one: http://issues.civicrm.org/jira/browse/CRM-8502)

Basically it calls the build  profile once per row so every query that isn't cached really hurts as does the translate function.

However, signatures are just activities so you should be able to create a Civi Report based on the Activity report or a view based on the Activity object to access the data.
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

jacobhunter

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: 3.4.2
  • CMS version: Drupal 6.22
  • MySQL version: 5.0.92-community
  • PHP version: 5.2.14
Re: CiviPetition Signature Count Slow, Signature Count output to views available?
July 19, 2011, 03:44:35 pm
Xavier: I have a small budget to work with on this, and would like to contribute. Unfortunately, I do not have much in the way of coding skills. Any advice you can give, or projects that are looking for contributors, I would love to pass on to our developer.

Eileen: I've tried in Views, but the activity for petitions seems to be kept separate somehow, and from what I can tell is not outputted into Views. I've forwarded on to a few volunteers, but nobody seems to be able to find the way to make this data come up in Views. Thanks for the info on the bug reports, I will send to our developer and see if it's something that can fix within our rather meager budget.

Thanks!

-Jacob

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: CiviPetition Signature Count Slow, Signature Count output to views available?
July 19, 2011, 03:48:06 pm
Did you try out the Activity report under the reports menu in Civi to see if it would help you?
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

jacobhunter

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: 3.4.2
  • CMS version: Drupal 6.22
  • MySQL version: 5.0.92-community
  • PHP version: 5.2.14
Re: CiviPetition Signature Count Slow, Signature Count output to views available?
July 19, 2011, 05:43:57 pm
Thanks Eileen! I can use the reports to give me a total number of signatories. For anyone else having this issue and just looking for the number of signatures, Admins can change the criteria of the report to be specific to one petition, civicrm then provides a record count (number of signatories). This report generated right away, and gives the option to add matching contacts (your signatories) to a group. Thanks again!

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: CiviPetition Signature Count Slow, Signature Count output to views available?
July 19, 2011, 11:26:02 pm
@Jacob,

Sorry, thought you meant displaying a total/counter on the front office (eg for a thermometer ala avaaz). We choose to use activities for signatures precisely to make easier to use other tools like reporting on them.

Good luck for your campaign, I'm going to blog here within a week about how it's visible on twitter, stay tuned ;)

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

jacobhunter

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: 3.4.2
  • CMS version: Drupal 6.22
  • MySQL version: 5.0.92-community
  • PHP version: 5.2.14
Re: CiviPetition Signature Count Slow, Signature Count output to views available?
July 20, 2011, 06:54:50 pm
@Xavier

I was looking to do exactly that, have a signature counter on the front of the site (and on the Thank You page) just as Avaaz does. I haven't been able to get the petition activity to come up in Views though, it's lists everything but the survey related stuff. Is this a views problem?

Look forward to hearing about your twitter news, and look forward to see any code you guys have on the "thermometer" (if you are developing that).

Thanks,

-Jacob

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: CiviPetition Signature Count Slow, Signature Count output to views available?
July 31, 2011, 03:47:42 am
Quote from: jacobhunter on July 20, 2011, 06:54:50 pm
Look forward to hearing about your twitter news, and look forward to see any code you guys have on the "thermometer" (if you are developing that).

http://civicrm.org/2011-07_twitter

Here it comes. May I suggest you to change the default template for something more personalised than "Sign this, I did + url" ?

Check out how to override templates in our book, the one you want to change are templates/CRM/Campaign/Page/Petition/SocialNetwork.tpl and modify the message template from the admin UI.

If you want me to check which of the thank you page or thank you email brings more tweets, put slightly different messages and let me know.

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviCampaign (Moderators: Kiran Jagtap, xavier) »
  • CiviPetition Signature Count Slow, Signature Count output to views available?

This forum was archived on 2017-11-26.