By joe4 on

Adoption Agency http://www.adoptionagencyratings.com website for reviews.

I used 26 non core modules such as:
Fivestar - for the rating. I like that it automatically links comment rating to parent node.

Node_import - I imported 1200 records. Be sure and do a descending sort on the data if you want it to be sorted alfa after you upload. Had to add php_value max_execution_time 18000 to my .htaccess file and could still only get around 300 records per import. Also had to run SQL UPDATE node SET comment=2 WHERE type='agency'; to turn comments on for imported nodes.

Contemplates - for all the views.

Gmap, Gmap location - for the map http://www.adoptionagencyratings.com/map/node 1200 adoption agencies take a long time to load. Still want to add the fivestar rateing to the popup.

pathauto - SEO the titles.

Image CAPTCHA - reduce comment spam. I have used it on other sites and even with very relaxed settings never got any spam.

Comments have been converted to "Reviews" I had to hand edit some files. I think my only problem now is when I start the forum it may not work right.

I plan on adding a forum, poll and tagging soon. Still need to import around 300 reviews by hand :-(

Questions / Comments welcomed.

Comments

Thomasr976’s picture

Thomasr976 commented

Very nice site. Will refer my users to it. How did you convert the comments to reviews? (See previous comment).

It would be nice to add an About us link to your website so that people get an idea of who's behind the website. Thanks in advance for sharing your information and your future assistance.

joe4’s picture

joe4 commented

Only changes I had to make for comments to be reviews was the way it prints out. Basically where I found the word "comment" changed to "review".

I tried to do this with a new language file but I think some of the comment stuff is hard coded.

After that fivestar already has the ability for comment to be rated and averages attached to the parent node.

_____________________________________________
Adoption Agency Reviews http://www.adoptionagencyratings.com

Thomasr976’s picture

Thomasr976 commented

and then using the comment module to allow you site visitors to comment/rate them. You are not allowing your visitors to submit agencies for review. Right?

Thanks for your quick response and btw I really like the google mapping.

joe4’s picture

joe4 commented

I am not allowing visitors to submit agencies if they do not exist. I want to modify the search results so if you get 0 results it will allow the user to add the agency.

Example.
User searches for American Adoption Agency Inc.
If they get 0 results I want it to have a quick add function in the search result so they could add the adoption agency and then review it. Like when you search for something that does not exist in wikipedia it ask if you want to add it.

---------------------------------------
Adoption Agency Reviews http://www.adoptionagencyratings.com

Thomasr976’s picture

Thomasr976 commented

It makes sense though. I guess it is a matter of deciding whether or not you as an admin want to add content (adoption agencies) to kick things off or have your users do it. What approach are u going to use to allow users to submit an agency? Would you create a special content type usig CCK?

In the case of another webiste http://www.beerreviewjournal.com/, I believe they are doing both approaches- allowing users to submit content (i.e. breweries and beers) and also adding the material themselves. They don't have the exact search function that you have but they can search via zip code http://www.beerreviewjournal.com/search/location

Have you developed that search feature yet?

joe4’s picture

joe4 commented

I will make a new content type so I can track it easier.

I have not developed the search feature yet but I do not think it will be very hard.

-------------
Adoption Agency Reviews http://www.adoptionagencyratings.com

bananamuffin’s picture

bananamuffin commented

I love your website and the features you've incorporated. I definitely think a forum would be a great addition because it will allow more user interaction to have users discuss the reviews and agencies in more detail. I just created my first two Drupal sites and one of them is an adoption related site

http://adoptionbaby.net

Mostly it's intended to be more casual, just a place for people to hang out and discuss their adoption stories. I will find a way to link to your site from mine. It's still a work in progress since I'm a Drupal newbie.

thanks and great job!

joe4’s picture

joe4 commented

Thanks for the complements. I am not going to do the forum anymore, I have way to much work remaining on creating the review system.

Adoption Agency Reviews http://www.adoptionagencyratings.com

Thomasr976’s picture

Thomasr976 commented

to import your agency data? I just tried the Import Module today. I am using the latest version. It worked but I could not import States since they are part of a CCK dropdown list. Have you experienced this issue? If so, could you share how you are dealing with it. Thanks Joe in advance.

joe4’s picture

joe4 commented

I had to convert the list in excel using a list of states and VLOOKUP

=VLOOKUP(Sheet1!I1194,Sheet2!A:B,2,FALSE)

Then use =PROPER(A1194) to case correct the final output.

Adoption Agency Reviews http://www.adoptionagencyratings.com

Thomasr976’s picture

Thomasr976 commented

Need a tip on how to get Node Import to work as I want to import at least 1200 nodes. I have a CCK type called Store ratings. Simple fields---name, type (drop down), address, city, state (dropdown), and country (dropdown). Users can also use this cck type to enter their own ratings of other stores.

I entered about 10 ratings in an Excel spreadsheet and saved the sheet as a cvs file. The header of the file has the same headings.

When I go through the node import I can see the data, but when I go to the next steps and preview the nodes, I get the name, address, and city only. Guess it only likes text and not the drop downs.

Can you tell me what you think I am doing wrong and propose a solution or work around? Thanks for your help.

mrgoltra’s picture

mrgoltra commented

location module?

mrgoltra’s picture

mrgoltra commented

thanks to this thread. finally.. now to customize..

ceo3141’s picture

ceo3141 commented

That is a great Drupal site. I am looking to do something similar with the map -- that is, the map of the US where you have all of the agencies displayed. I would like to create a map showing many locations. The locations are defined by a custom node; there are CCK fields in the node for name, address, etc. How do you take all of the names and addresses in those nodes and put them on one map?

Outside of Drupal, I know how to take a file of data and create a simple Mashup Map of all of the locations in the file. So my question is how do you do that within Drupal, when you already have all of the locations defined in your custom content types.

Again, great site, any instructions you can give me on how you did the Map would be greatly appreciated.

joe4’s picture

joe4 commented

I think this is what the location module is used for.

Adoption Agency Reviews http://www.adoptionagencyratings.com

ceo3141’s picture

ceo3141 commented

The location module is in development, and it is not well documented. Could you give me even a brief outline of what you did to put all of the agency locations on 1 map?
Many thanks.

joe4’s picture

joe4 commented

I installed Gmap and Gmap Location. It was a long time ago but I do not remember doing anything custom. I will take a look at my config and see what else I changed.

Adoption Agency Reviews http://www.adoptionagencyratings.com