[support] HELP! with Views and relational data
Shai Gluskin
shai at content2zero.com
Wed Mar 4 14:35:46 UTC 2009
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/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20090304/19a90ce2/attachment.htm
More information about the support
mailing list