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 »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Which data structures best suit my needs?
Pages: [1]

Author Topic: Which data structures best suit my needs?  (Read 1599 times)

jupitercreativesolutions

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.2.1
  • CMS version: Wordpress
  • MySQL version: 2.4.3.1
  • PHP version: 5.5.27
Which data structures best suit my needs?
October 22, 2012, 07:32:13 am
I am a full time web developer and CiviCRM newcomer. I read about 25% of the CiviCRM user and administrator guide and I was hoping the community could save me some time before I read the whole thing.

My website will feature a cycle of actions that will repeat every 6 months. A user will apply for a program submitting an abstract, faculty will review all applications, some will be accepted, those accepted will attend a workshop. Also I need functionality to run reports on applicants and accepted applicants, and be able to search for and through submitted and accepted abstracts (attachments)- I think this should be pretty standard though no?

After my reading I found that I could use CiviCase and create a new case for each applicant, I read through the section on CiviCase but I am not sure if CiviCase is my best option. I am not looking for someone to map out this project for me but rather point me in the right direction so I don't misuse Civi elements and run into problems down the road.

Any suggestions are massively appreciated, thank you in advance.

Jason W

  • I post frequently
  • ***
  • Posts: 197
  • Karma: 12
  • jason@civitrainingtutorials.com
  • CiviCRM version: 4.2
  • CMS version: Drupal 7
  • MySQL version: 5.x
  • PHP version: 5.x.x
Re: Which data structures best suit my needs?
October 22, 2012, 08:30:16 am
Hello jupitercreativesolutions,

From the information you have provided, it sounds like CiviCase would work well for your organization. It's ability to track related activities, and automate followups cuts down on quite a bit of confusion. A lot of people get hung up on the xml aspects that are required for it's use, but once you get past that, this component is one of the most incredible parts of CiviCRM.

Check out this link for a little bit more information on using the sample configuration:
http://wiki.civicrm.org/confluence/display/CRMDOC41/CiviCase+-+Using+the+Sample+Configuration

Run through it a time or two and you'll see how much this program can help your... program.

As far as misuse of components, there are always people using components for purposes that they weren't necessarily designed for. Sometimes they run into some snags, but, surprisingly often they end up hitting upon some creative workarounds that benefit them in the long run. Don't be afraid to stretch the "limits" (maybe not on a live site), and let us know if you come up with any tricks that might help someone.

Cheers,
Jason
civiTrainingTutorials
"Helping You Help Others"

jupitercreativesolutions

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.2.1
  • CMS version: Wordpress
  • MySQL version: 2.4.3.1
  • PHP version: 5.5.27
Re: Which data structures best suit my needs?
October 22, 2012, 09:04:17 am
Hey Jason,

I am going to look into using CiviCase then, thank you very much! At first the XML setup seemed like a turn-off to me but hearing from you that CiviCase is a great component I am confident it will be a small hurdle.

Thank you very much- if any one else has any suggestions or ideas of other components that might compliment CiviCase in my program that would be great to hear. I will be sure to post back and return the favor when I learn more about CiviCRM.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Which data structures best suit my needs?
October 22, 2012, 11:31:37 am
It does sound like CiviCase makes sense for you.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

jupitercreativesolutions

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.2.1
  • CMS version: Wordpress
  • MySQL version: 2.4.3.1
  • PHP version: 5.5.27
Re: Which data structures best suit my needs?
October 23, 2012, 10:18:10 am
Thanks Hershel,

I am going to re-read the CiviCase section of the book tonight and then test it out tomorrow.

Will I need to implement any specific Civi components to gain the functionality to allow users to be able to search for/through things like the attachments uploaded during the application process or the applicants themselves from the front end?

Thanks again for your help.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Which data structures best suit my needs?
October 23, 2012, 10:32:15 am
Searching for applicants is easy because they will become Contacts. So that's built in.

Searching for attachments uploaded during the application process is another story. What do you want to search on? The file name or the content? A file name search could be built but I don't think any such thing exists. To search on the contents would be an even more serious undertaking as the files I presume would be .doc or .pdf and so you would need tools to read those in PHP.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

jupitercreativesolutions

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.2.1
  • CMS version: Wordpress
  • MySQL version: 2.4.3.1
  • PHP version: 5.5.27
Re: Which data structures best suit my needs?
October 23, 2012, 10:38:51 am
I would want to search on tags or keywords attached to those documents, could I attach keywords to them?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Which data structures best suit my needs?
October 23, 2012, 10:57:37 am

currently no, but someone else has also expressed an interest in this. If that project goes thru, we will spin out a Make It Happen to improve notes and attachments

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Which data structures best suit my needs?
October 23, 2012, 11:04:09 am
Quote from: jupitercreativesolutions on October 23, 2012, 10:38:51 am
I would want to search on tags or keywords attached to those documents, could I attach keywords to them?

The only other option (for right now) would be to add a "tag" field for each file field. Or you could consider doing the application aspect in Drupal and then the searching would be in Drupal also. It would all still be associated with the CiviCRM Contact of course, but the application data would be in Drupal.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

jupitercreativesolutions

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.2.1
  • CMS version: Wordpress
  • MySQL version: 2.4.3.1
  • PHP version: 5.5.27
Re: Which data structures best suit my needs?
October 23, 2012, 11:15:25 am
I am using Wordpress as my CMS. Unfortunately searching/running reports on applications and/or attachments by keyword was a  large goal for this site, I will have to find some sort of alternative I suppose.

demeritcowboy

  • Ask me questions
  • ****
  • Posts: 570
  • Karma: 42
  • CiviCRM version: Always the latest!
  • CMS version: Drupal 6 mostly, still evaluating 7.
  • MySQL version: Mix of 5.0 / 5.1 / 5.5
  • PHP version: 5.3, usually on Windows
Re: Which data structures best suit my needs?
October 23, 2012, 11:48:21 am
There is the fulltext search feature in civi that searches activity details. I'm not sure if it's available as a block in wordpress like it is in drupal, but anyway you can get to it from the menu under search -> custom searches.

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Which data structures best suit my needs?
October 23, 2012, 11:52:45 am
Hi,

What you could do is to have each abstract as an activity, add a custom field "file" and either a tagset or several tags/keyword linked to activities.

So you can then create that abstract, upload the file and put the tags.you want. You can find them later searching on all activities of type abstract that have the keywords you want.

If you want to go all fancy, you could write an extension to submit the content of the file to open calais and use it automatically tagged (we used it for a project to scan political documents, works mostly ok)

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

jupitercreativesolutions

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.2.1
  • CMS version: Wordpress
  • MySQL version: 2.4.3.1
  • PHP version: 5.5.27
Re: Which data structures best suit my needs?
October 23, 2012, 07:25:16 pm
Thank you everyone for your help.

I just finished re-reading the CiviCase section of the User & Admin Guide Book and I didn't see anything in there about creating a case when a user fills out a form.

Ideally I would want a user to come to the site, fill out the form for their application submission and attach their abstract. This would create a case on the fly with the first activity (something like 'applied') completed. Then the case would follow a pattern from then on. Is there any way to initiate a case like this? I am afraid the office work will become to time consuming if we must create each case manually from data entered on an unrelated form.

I apologize if I am getting too off topic for this thread, just let me know I will be more than happy to post elsewhere.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Which data structures best suit my needs?
October 24, 2012, 06:33:57 am

in drupal, you can create your application with webform_civicrm and automatically create a case.

this feature does not exist as yet for wordpress. would be good to get integration with gravity forms or something equivalent

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Which data structures best suit my needs?

This forum was archived on 2017-11-26.