CiviCRM Community Forums (archive)

Hey. Its been 2-3 days since I last posted an update. I added an event page which is under development and needs some improvement. This page basically has an overview of information regarding events and their participants.
The information include

• Type of Event
• Duration of Event
• Whether a past event or upcoming[\li]
  
  • Participant Status[\li]
    
  I am trying to create a dataviz particularly for an event. Which will further focus on participation. I will also add comparison option for the same. If you can help me with a dataset which uses events extensively that will be great.
  
  Thanks, looking forward to write my first blogpost soon.

two discussions related to the extension (the extracting data part of it)

http://forum.civicrm.org/index.php/topic,33165.0.html
http://forum.civicrm.org/index.php/topic,33196.0.html

Here is an update for the last 2 days. I have completed the blog, got it reviewed from Xavier as well. Is waiting for the blogging permission.

Also, I have noticed two bugs in civicrm website. One is with the login button redirecting you to home page(can be a feature as well). The other is the search icon in chrome is not at its right position. I dont know where the code is as I can surely help solving it.

I also read about APIs and how smarty templates handle request. Trying to understand most about templating sql queries.

Hi Xavier, I was talking about the main civi website. Though the login is handled by drupal, clicking login on any page redirects you to home first and then log in.

Hi,

I hope all of you following this topic are doing well. I have an update regarding the data retrieval system for civisualize. The system till now used to accept just one parameter using url that was can be accessed in template as $id. It was nothing but any string that was in the url after the template name. So if we put our url as ../civicrm/dataviz/contacts/4, $id was assigned the value of 4.

Also we had no particular way of passing variables to a SQL query. I and xavier, after going through the topics http://forum.civicrm.org/index.php/topic,33165.0.html and http://forum.civicrm.org/index.php/topic,33196.0.html and a lot of discussion decided that what we want can be achieved with the help of just two smarty functions.

The function we created was {crmRetrieve var="" name="" type=""} which uses CRM_Utils_Request::retrieve() this is basically to retrieve data from the url.

The second function we modified was our {crmSQL} which now accept JSON files of the following format
abc.json = {"query":"SELECT * from abc where a=%1 group by %2", "params":{"1":{"name":"a","type":"Integer"},"2":{"name":"b","type":"String"}}}
now to run this what we need to do is

{crmSQL json="abc" a="2" b="hello"}
Hope these functions will solve a lot of issues and act as a better framework for developers who would want to make their own dataviz. Suggestions and Feedback will be appreciated.

Hi guys,

I finally have a per event page describing demographics of the user that cab be accessed from civicrm/dataviz/event/<event_id>. Please suggest what all can be added to this.

The next plan is to create a viz for donor trends(https://github.com/micahflee/org.eff.donortrends). Just mentioning my plans for this Visualization,

Instead of using the Donor Trends extension, I think doing it in Civisualize itself is a better idea, that ways we can use crmSQL function or maybe create a new crmDonor function.

This will also keep everything at one place, which according to me will be better, as developers can than refer to different type of visualization, not just the viz created with tpl file but the viz created using their own separate php file.

Donor Trends ask users to choose a base year. As our dataviz needs to be general, can we have any other way apart from asking the users to choose a year.

I want suggestion on accessing the data as one way can be access it all using javascript only.

Hi John,

For donor trends, we have added age, a trends graph, gender graph and a table with list of all donations.
Please checkout the http://github.com/TechToThePeople/civisualize for the donortrends visualization.