Author Topic: How would you organize/setup this schema? (Read 3496 times)

alextronic · March 26, 2009, 08:13:43 am

OK, first of all thanks to people like Donald and Kurund (edit> and Dave!).
Second, sorry for my english.
Third, I'm using Drupal 6.10 with CiviCRM 2.2.0.

So, we have this website to make for a NPO and the copydeck/schema that they have given us implies the following structure: This NPO has a series of Affiliates who perform humanitarian projects around the globe. So user can do the following:
1-donate to the NPO
2-donate to an affiliate
3-donate to an affiliate's project

How would you create/configure 'projects' as associated to 'affiliates'?
Should I consider each project just as a contribution page? And in this case, how can I implement fields such as 'type of project' and 'project description' etc when creating a new project/contribution?

And also, when I create a contribution page, how can I...
a- ...associate it to an affiliate/project?
b- ...insert the project's information into the contribution page (as a kind of introductory text)?

For now that's all. Thanks again in advance.

Donald Lobo · March 26, 2009, 12:46:24 pm

to some extent depends on how big this group is:

1. how many affliates are there

2. how many projects / affliate on an average

3. Who manages these affliates, i.e. do affliate staff self manage their data. whats the permissioning scheme etc with regard to controlling, configuring and modifying the data

lobo

alextronic · March 27, 2009, 03:07:51 pm

Thank you Donald,

I'm gathering that info, but for now I can tell you that even if the number of affiliates/projects is relatively big already, the idea is to make is scalable because the NPO knows that the number is going to be even bigger. But if specific numbers are needed I will answer, of course, thankful as I am for your reply.

About who manages the affiliates, the idea is that the NPO registers and admins their records, but I don't know if they want the affiliates to edit their own data, maybe some of it. I will give more details soon, we have asked them about this and as soon as we know I will post it here.

Thanks again.

Donald Lobo · March 27, 2009, 03:44:05 pm

if number of affliate or projects is large, you might want to consider building some functionality into CiviCRM to handle your use case. you might also want to get some details on what exactly they want in a donation page. the more common use case is each affliate wants to tightly control the donation page and have specific text etc in additon to different donation amounts etc.

However if the NPO just wants a different intro for all donation pages based on affliate and project, i suspect this is relatively easy with a few extensions to CiviCRM. I also think that some of these extensions might be applicable to other use cases and we'd like to see a generalized version in core

the permissioning structure is kinda important to get right or at least a good handle on early in the process

lobo

alextronic · March 27, 2009, 08:37:35 pm

Quote

"the NPO just wants a different intro for all donation pages based on affliate and project"

<- This is exactly the case... the affiliates should not have a tight control of the donation page, only the NPO, which would include an intro for each donation page based on affiliate and project. The permissioning structure should be based on that concept. What sort of extensions would then be necessary? I am very aware that this early process is very important and appreciate your advice.

Thanks

Alex.

Donald Lobo · March 27, 2009, 10:12:29 pm

u basically will need to extend the civicontribute code and schema to add the concept of affliate id and affliate project id. create a way of storing the specific intro for an affliate / project and tie that to the ids.

on rendering a contribution page, use the intro from the above table and also store the ids in the civicontribution record. you'll also need to modify the contribution display code to show users the affliate / project id etc

lobo

alextronic · March 28, 2009, 06:55:00 am

Hhmm... that sounds right; only I'm not proficient to try it all on my own, has anyone tried something similar before? I'll appreciate a little guiding (I'm a civiCRM first-timer).
Then I'd describe here the problems/limitations I might encounter (or not). Thanks again lobo.

Alex

Donald Lobo · March 28, 2009, 06:57:13 am

not sure of your php/mysql/OOP skills. you might want to get some help from folks at: http://civicrm.org/professional/

lobo

alextronic · March 31, 2009, 06:31:13 am

Ouch...

We really cannot afford that.

We are very interested in learning/improving; ...is it a very complicated task to extend the code to include affiliate/project? Maybe it has done before with different names, or someone has tried a workaround.

If not, I'd appreciate a 'how to' guide, even if it's not very detailed, I'm sure I can work it out.

Thank you.

Alex

Donald Lobo · March 31, 2009, 07:11:54 am

Your best bet might to sticking to whats part of standard CiviCRM and using it. You can read about the code architecture etc here:

http://civicrm.org/architecture

for more specific code related questions, ping us on IRC: http://embed.mibbit.com/?server=irc.freenode.net&channel=%23civicrm&forcePrompt=true

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: How would you organize/setup this schema? (Read 3496 times)

alextronic

How would you organize/setup this schema?

Donald Lobo

Re: How would you organize/setup this schema?

alextronic

Re: How would you organize/setup this schema?

Donald Lobo

Re: How would you organize/setup this schema?

alextronic

Re: How would you organize/setup this schema?

Donald Lobo

Re: How would you organize/setup this schema?

alextronic

Re: How would you organize/setup this schema?

Donald Lobo

Re: How would you organize/setup this schema?

alextronic

Re: How would you organize/setup this schema?

Donald Lobo

Re: How would you organize/setup this schema?