Using Drupal as a people database - this should be easy, no?

hypothesis - September 19, 2009 - 14:03

I run a talent agency and I am trying to use Drupal as a database for everyone.

To give you an idea how I have organized it is as follows:

I use taxonomy broken into four vocabularies:

Artist Type: This defines what kind of artist it is, such as actor, model, MC, dancer, etc
Look: Describing the physical appearance in words such as caucasian, black, brown, old, young, etc
Language: what languages/accents they can speak in

Crew: If they can do crew work, like lighting, camera, photography, etc...

I also have two custom CCK fields for phone and email.

Now all I want is this:

1. A search by taxonomy, able to select multiple criteria easily
2. Search results with Photos and contact info (right now all the photos as attachments to each node)
3. Ability to select certain search results and export them, as a separate web page, a pdf, or just the photos, or something, so I don't have to manually pick up each photo.

On my wishlist is:

1. The ability for clients to browse the database without seeing names or contact info.
2. The ability to send clients a custom URL that will give them a view of online results also without contact info or names

I am currently trying:
Taxonomy Filter- > Which does not seem to work, as it seems to return zero results most of the time, and zero result all of the time when using more than one term
Teaser Thumbnail (with depended modules installed)-> which just doesn't seem to work

I have installed and uninstalled more modules than I can remember...

It is just devolving into a big mess... I thought it would be easy to achieve this wort of functionality

It sounds like your best bet

scubasmurf - September 19, 2009 - 14:18

It sounds like your best bet is CiviCRM.

_

WorldFallz - September 19, 2009 - 14:17

For 1: use views with 'exposed filters' to setup any kind of search you want (just add filters to the items you want users to interact with, click the 'expose' button, and set the options as desired). For an example of how this work visit any issue queue on drupal.org.

For 2: theme the search results. If you're using views to create the lists you can setup the view however you want through the ui and theme it for more control.

For 3: see http://drupal.org/project/views_datasource, http://drupal.org/project/views_bonus, and possibly http://drupal.org/project/print with #341686: Views 2 Support?.

For wishlist 1) use the content permissions module of cck

For wishlist 2) can be done with a view and/or content permissions

_
Don't be a Help Vampire - read and abide the forum guidelines.
If you find my assistance useful, please pay it forward to your fellow drupalers.

Views problem

hypothesis - September 19, 2009 - 14:54

I am having a problem with views, when I try to view the page it always gives me "page not found". even using the link in views that says: View "Page"

Maybe something is setup wrong?
Maybe I just installed too much stuff?

Sorry, my mistake, I was

hypothesis - September 19, 2009 - 15:01

Sorry, my mistake, I was using the wrong type of view... works now, thanks

For 2:

hypothesis - September 21, 2009 - 08:56

I have been though views setup and theming and it all seems a bit overwhelming.

Is there

-a simple way to just show all the pictures attached to a node (in the views results)

or

- should I take the time and effort to put each image into a CCK image field? I preferred the images as attachments as they seemed easier to work with as they are retained as files directly on the server

I am really stuck on this part, I have been digging through all sorts of "image" plugins to no avail.

Image nodes

hypothesis - September 21, 2009 - 09:32

There are also some modules/plugins that allow you to upload images as nodes to make galleries and all that, but I want the images to be within the nodes themselves, as I don't want them getting mixed up.

How about using JQuery? This seems like a viable option but all of the modules seem outdated.

_

WorldFallz - September 21, 2009 - 13:42

Either way, if you're not using views for the search, I think you need to theme the search results to get images to appear. I know it can appear overwhelming, but it's really not that bad. Copy the 'search-result.tpl.php' file the modules/search directory to the directory for your theme and alter as desired.

_
Don't be a Help Vampire - read and abide the forum guidelines.
If you find my assistance useful, please pay it forward to your fellow drupalers.

I am using views for search,

hypothesis - September 24, 2009 - 10:32

I am using views for search, and I have tried unsuccessfully to use modules such as the thumbnail one that is supposed to make thumbnails from the images attached to each node.

I would rather not delve into the code to keep things simple and also offer an easily replicable solution both for myself and others in the same situation.

In any case, if themeing is the only way to achieve this, then I guess I 'll have to dive in.

_

WorldFallz - September 24, 2009 - 10:58

If you're using views, you shouldn't have to theme-- unless you want to tweak the output. Simply add the image file attachments to the view as a field ('upload' in the field drop down). If you use imagecache, you can choose the image size you wish to display.

_
Don't be a Help Vampire - read and abide the forum guidelines.
If you find my assistance useful, please pay it forward to your fellow drupalers.

I am using imagecache

hypothesis - September 24, 2009 - 15:20

I am using imagecache but I don't see how to link it up with my views.

All I can get is a list of the attached files. I have a couple of presets in imagecache but I am not sure how to apply these.

_

WorldFallz - September 24, 2009 - 15:55

Try this:

1. add the 'upload: attached files' field
2. click the "rewrite the output of this field" option
3. put <img src=/sites/default/files/imagecache/thumb/[upload_fid_1-name] /> in the textbox, be sure to replace '[upload_fid_1-name]' with the correct token from the replacement patterns list and 'thumb' with the desired imagecache preset.

_
Don't be a Help Vampire - read and abide the forum guidelines.
If you find my assistance useful, please pay it forward to your fellow drupalers.

It seems to work if the node

hypothesis - September 24, 2009 - 18:49

It seems to work if the node has just one image attachment.

If there is more than one it just refuses to show anything. It seems to concatenate all the file names into one tag.

_

WorldFallz - September 24, 2009 - 19:18

hmmm... it works fine on my nodes with multiple images. Scroll to the bottom of the field settings and try setting display type to "simple separator", removing the comma, and using a space. That's what I have working atm.

_
Don't be a Help Vampire - read and abide the forum guidelines.
If you find my assistance useful, please pay it forward to your fellow drupalers.

Gives the same result

hypothesis - September 24, 2009 - 19:58

I had is with a comma before, but tried it as a space and still no go.

Here is my replacement text: <img src=/sites/default/files/imagecache/mainview/[upload_fid] />

[upload_fid] is the my proper replacement pattern.

The code output is as follows:

1 image attachment:
(image attachment name: 339_48c76db20fa20.jpg)

<div class="views-field-upload-fid">
                <span class="field-content"><img src="/sites/default/files/imagecache/mainview/339_48c76db20fa20.jpg"></span>
  </div>

Multiple image attachments:
(image attachment names: 1.jpg, 2.jpg, 3.jpg, 4.jpg, 5.jpg )

  <div class="views-field-upload-fid">
                <span class="field-content"><img src="/sites/default/files/imagecache/mainview/1.jpg%202.jpg%203.jpg%204.jpg%205.jpg"></span>
  </div>

as you see it is plunking all the image names into one tag.

_

WorldFallz - September 24, 2009 - 20:30

Wierd-- this is what I get with 2 attachments:

<div class="views-field-upload-fid-1">
<span class="field-content">
<img src="/sites/default/files/imagecache/thumb/registered.png"/>
<img src="/sites/default/files/imagecache/thumb/moderator.png"/>
</span>
</div>

Couple of things to try-- one, update to latest dev of views, 2 try it with garland if you're using a different theme.

_
Don't be a Help Vampire - read and abide the forum guidelines.
If you find my assistance useful, please pay it forward to your fellow drupalers.

My imagecache version is the

hypothesis - September 25, 2009 - 08:09

My imagecache version is the latest: 6.x-2.0-beta10

I upgraded my views to: 6.x-2.6 but now I have no option to rewrite the output of the field :-S

I am using the stock Garland theme with no changes at all.

_

WorldFallz - September 25, 2009 - 11:03

Try views 6.x-2.x-dev -- that's what I have.

_
Don't be a Help Vampire - read and abide the forum guidelines.
If you find my assistance useful, please pay it forward to your fellow drupalers.

Simplicity is key

hypothesis - September 21, 2009 - 09:44

I guess the goal is to have the simplest solution possible, something that requires the smallest setup that can be used as a template for anyone else that has a similar request.

I think searching by taxonomy with photos in results is something I think that would be useful to many people.

The solution

hypothesis - October 15, 2009 - 05:57

Thanks to WorldFallz, here is the complete simple solution with minimal fuss:

1. Install Views (latest version), Imagecache, cck, cck imagefield
2. Create your nice content type with all the fields you need including an imagefield
2. Create a view with exposed filters
3. add all fields you want to see in your nice list, including the imagecache preset

For added niceness:
4. Install Lightbox2 for image viewing goodness
5. add a cck embedded media field to get youtube videos and other nice stuff in your view
6. drink beer and build websites, it's far more fun

 
 

Drupal is a registered trademark of Dries Buytaert.