[support] HELP! with Views and relational data

Chris McCreery chris.mccreery at gmail.com
Wed Mar 4 23:10:21 UTC 2009


Alright Shai I am now up and running in Drupal 6 and have got my site back
to where I had it before minus the Views. Based on my initial requirements
would you be able to give me a hand with how I should set up these views?

Thanks

On Wed, Mar 4, 2009 at 10:14 AM, Chris McCreery <chris.mccreery at gmail.com>wrote:

> Thanks Shai, I've decided to just start over from scratch rather than
> upgrading. I think it will be more beneficial to start again and rethink
> some of my decisions.
>
> So based on that any suggestions as to which modules to use in 6 or the
> best ways to properly create the relations between user and program, user
> and attendance tracking, program and attendance-tracking?
>
>
> On Wed, Mar 4, 2009 at 9:35 AM, Shai Gluskin <shai at content2zero.com>wrote:
>
>> Chris,
>>
>> Check out... Content Profile
>>
>> http://drupal.org/project/content_profile
>>
>> Shai
>>
>>
>> On Wed, Mar 4, 2009 at 8:48 AM, Chris McCreery <chris.mccreery at gmail.com>wrote:
>>
>>> I was using Usernode in Drupal 5 is there a new replacement for that? or
>>> how will I upgrade that?
>>>
>>>
>>> On Wed, Mar 4, 2009 at 8:47 AM, Chris McCreery <chris.mccreery at gmail.com
>>> > wrote:
>>>
>>>> Quicky.... Alright Shai you've convinced me. I am running 6 on a few
>>>> other sites and yes it is great. I'll give it a try and let you know how I
>>>> make out. Thanks again for all the help.
>>>>
>>>>
>>>> On Tue, Mar 3, 2009 at 9:50 PM, Shai Gluskin <shai at content2zero.com>wrote:
>>>>
>>>>> Chris,
>>>>>
>>>>> A quicky version of upgrading, you might want to check other sources.
>>>>>
>>>>>
>>>>>    1. Back up your files and database.
>>>>>    2. Hopefully, you haven't hacked core or contrib modules. If you
>>>>>    have, document them well.
>>>>>    3. If you don't have update_status installed, install it now now
>>>>>    and run it. Then update all your Drupal 5 modules to their most current
>>>>>    version in for *Drupal 5*. Along the way, you should probably check
>>>>>    the project page for each of your modules to see if there are any relevant
>>>>>    notes for upgrading to Drupal 6. Definitely read the instructions for
>>>>>    upgrading for CCK.
>>>>>    4. Turn off all contrib module and themes. (Some people don't do
>>>>>    this on "point upgrades" (e.g. 5.14 to 5.15) -- but I think it is the
>>>>>    consensus to do this on major upgrades (e.g. D5 - D6).
>>>>>    5. You can now dispose of the files in your installation except be
>>>>>    sure to keep handy customizations you have made to. (I keep these all in a
>>>>>    separate place though, start with a fresh install and place the
>>>>>    customizations back into the fresh installation:
>>>>>       1. .htaccess file in the root directory
>>>>>       2. a php.ini file if you have one.
>>>>>       3. connection settings and any other settings you've turned on
>>>>>       in the settings.php file
>>>>>       4. files directory
>>>>>       5. custom modules you've created
>>>>>       6. custom theme
>>>>>    6. Download via tar balls or CVS the D6 core and the D6 versions of
>>>>>    all your modules.
>>>>>    7. Place your contrib modules in: sites/all/modules
>>>>>    8. Go to sites/default/default.settings.php and:
>>>>>       1. duplicate it
>>>>>       2. change the new copy's name to: settings.php
>>>>>       3. edit the file to put in the connection settings and any other
>>>>>       settings turned on that you previously needed.
>>>>>    9. If you had made changes to your site's .htaccess file, you can
>>>>>    now make those same changes to the fresh install
>>>>>    10. navigate to example.com/update.php (don't freak out if there
>>>>>    are errors)
>>>>>    11. Turn on CCK and run update.php again (follow the instructions
>>>>>    on the project page of cck)
>>>>>    12. Turn on the rest of your modules
>>>>>    13. Turn on the theme
>>>>>
>>>>> Some of your views might not work -- just create them again with the
>>>>> new Views. It's good practice. You might as well learn the new Views on
>>>>> views that your already understand well. Views2 is amazing, but there is a
>>>>> learning curve.
>>>>>
>>>>> You might need to place your blocks again.
>>>>>
>>>>> Your custom theme might need some work. There is lots of info at
>>>>> Drupal.org about this. Shouldn't be too hard though, depending on
>>>>> complicated your site is.
>>>>>
>>>>> Good luck. It is really worth it. Drupal 6 is awesome!
>>>>>
>>>>> Report back.
>>>>>
>>>>> Shai
>>>>>
>>>>>
>>>>> On Tue, Mar 3, 2009 at 9:02 PM, Chris McCreery <
>>>>> chris.mccreery at gmail.com> wrote:
>>>>>
>>>>>> Well when I first started this project there were a number of modules
>>>>>> that weren't ready for drupal 6 and of course the client has taken their
>>>>>> sweet time getting back to me on every possible detail so I bet now
>>>>>> everything would work in drupal 6 but I'm not very familiar with the entire
>>>>>> upgrade process nor can I afford the time currently to upgrade the site. I
>>>>>> might just start over from scratch at this point.
>>>>>>
>>>>>> Is there any particular detail I should be worried about upgrading? I
>>>>>> have a custom theme that I had to create and a bunch of calculations in cck
>>>>>> computed fields. Is it fairly straightforward to upgrade all those aspects?
>>>>>>
>>>>>> After upgrading to 6 what would be my best option for getting the
>>>>>> results I wanted from what I detailed before?
>>>>>>
>>>>>> Thanks again for the help.
>>>>>>
>>>>>>
>>>>>> On Tue, Mar 3, 2009 at 4:35 PM, Shai Gluskin <shai at content2zero.com>wrote:
>>>>>>
>>>>>>> Chris,
>>>>>>>
>>>>>>> What you are talking about is really complex in D5 requiring custom
>>>>>>> coding. It is almost trivial to do in D6 with Views2.
>>>>>>>
>>>>>>> Also, it isn't really that hard to upgrade sites to D6, depending of
>>>>>>> course on complexity. But you wouldn't have to start over.
>>>>>>>
>>>>>>> What is the functionality that D5 provides that you think D6 doesn't?
>>>>>>>
>>>>>>> Shai
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Tue, Mar 3, 2009 at 4:09 PM, Chris McCreery <
>>>>>>> chris.mccreery at gmail.com> wrote:
>>>>>>>
>>>>>>>> Ok unfortunately I have already started this project and some other
>>>>>>>> areas rely on some 5 modules so I can't convert to 6.
>>>>>>>>
>>>>>>>> This is what I want to accomplish.
>>>>>>>> User logs in creates a profile(usernode) which includes location
>>>>>>>> information
>>>>>>>> The user can then create a Program(eg. indoor basketball)
>>>>>>>> Now the user can create an attendance tracking node for the program
>>>>>>>> they created above.
>>>>>>>> Users only have access to the content they created.
>>>>>>>>
>>>>>>>> For reporting purposes as the administrator I would like to be able
>>>>>>>> to see all the programs created for example by province, organization, or
>>>>>>>> other data stored in the user profile(usernode) as well I would like to see
>>>>>>>> all the attendance reports by organization, province, postal code, etc. The
>>>>>>>> issue I think here is that the user shouldn't have to select their own
>>>>>>>> organization or  province, postal code when creating a new program or
>>>>>>>> attendance tracking as this should be created by a relationship to the
>>>>>>>> usernode. Sorry if i'm not too clear here I'm a bit confused as to how I can
>>>>>>>> do this in drupal.
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>>
>>>>>>>>
>>>>>>>> On Tue, Mar 3, 2009 at 1:39 PM, Shai Gluskin <shai at content2zero.com
>>>>>>>> > wrote:
>>>>>>>>
>>>>>>>>> Chris,
>>>>>>>>>
>>>>>>>>> This is not a comprehensive response...
>>>>>>>>>
>>>>>>>>> First, what you are talking about is much easier to do in Drupal
>>>>>>>>> 6/Views 2 than it is with Drupal 5.
>>>>>>>>>
>>>>>>>>> The Sign up module is excellent: http://drupal.org/project/signup
>>>>>>>>>
>>>>>>>>> It works with either a Date field or with the Event module. I'm not
>>>>>>>>> sure if the signup module has Views integration.
>>>>>>>>>
>>>>>>>>> So in short, I'd start with D6, Views, Signup, and Date as the core
>>>>>>>>> components to build what you want.
>>>>>>>>>
>>>>>>>>> Shai
>>>>>>>>>
>>>>>>>>> On Tue, Mar 3, 2009 at 10:33 AM, Chris McCreery <
>>>>>>>>> chris.mccreery at gmail.com> wrote:
>>>>>>>>>
>>>>>>>>>> Hi I am creating a site that has the following content types:
>>>>>>>>>>
>>>>>>>>>>    - Organization (Usernode)
>>>>>>>>>>    - Program (define a program)
>>>>>>>>>>    - Attendance Tracking (track attendance for that program)
>>>>>>>>>>
>>>>>>>>>> I would like to create an admin view that shows me all the details
>>>>>>>>>> for either program or the attendance tracking with data from the usernode.
>>>>>>>>>> For example:
>>>>>>>>>>
>>>>>>>>>> Program Name
>>>>>>>>>> Organization Name
>>>>>>>>>> Province
>>>>>>>>>> Country
>>>>>>>>>> Postal Code
>>>>>>>>>>
>>>>>>>>>> I'm just wondering what is the best way to have the Program and
>>>>>>>>>> Attendance tracking content types reference this data. Would I need to
>>>>>>>>>> create computed fields that query the database separately to get them into
>>>>>>>>>> the content type?
>>>>>>>>>>
>>>>>>>>>> Thanks, any help would be much appreciated.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> Chris McCreery
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> [ Drupal support list | http://lists.drupal.org/ ]
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> [ Drupal support list | http://lists.drupal.org/ ]
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> Chris McCreery
>>>>>>>>
>>>>>>>> --
>>>>>>>> [ Drupal support list | http://lists.drupal.org/ ]
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> [ Drupal support list | http://lists.drupal.org/ ]
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Chris McCreery
>>>>>>
>>>>>> --
>>>>>> [ Drupal support list | http://lists.drupal.org/ ]
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> [ Drupal support list | http://lists.drupal.org/ ]
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Chris McCreery
>>>>
>>>
>>>
>>>
>>> --
>>> Chris McCreery
>>>
>>> --
>>> [ Drupal support list | http://lists.drupal.org/ ]
>>>
>>
>>
>> --
>> [ Drupal support list | http://lists.drupal.org/ ]
>>
>
>
>
> --
> Chris McCreery
>



-- 
Chris McCreery
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20090304/e5c31c87/attachment-0001.htm 


More information about the support mailing list