[support] HELP! with Views and relational data

Chris McCreery chris.mccreery at gmail.com
Wed Mar 4 13:48:01 UTC 2009


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20090304/c271350c/attachment-0001.htm 


More information about the support mailing list