[support] HELP! with Views and relational data
Chris McCreery
chris.mccreery at gmail.com
Wed Mar 4 15:14:25 UTC 2009
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20090304/06740977/attachment-0001.htm
More information about the support
mailing list