Multiple Keyword Search/preview/database dump

15 posts by 4 authors in: Forums > CMS Builder
Last Post: October 19, 2009   (RSS)

  • Archived  

By (Deleted User) - October 14, 2009

Hi Chris,

I am still having same problems. I downloaded the the newer version of the software so I could get multiple keyword searching with commas separating words and no luck.

Looks like this in section editor>listings> search tab>search fields- for the editor list page search menu bar.

title, location, listing_number, internet_number_sales, internet_number_rental, property_type, property_status, price, rental_time_period, rental_period_price, agent_comments, address, city, lot_size, bedrooms, bathrooms, extra_rooms, basement, fireplace, hot_tub, pool, tennis_court, garage, pool_guest_house, pets_ok, air_conditioning, house_style, proximity_to_water, description, owner_last_name

I can only get it to find 1 keyword- i.e.: location="east hampton".

If I put 2 keywords i.e.: location="east hampton", owner_last_name= "smith", I get no records match this etc. Even though each keyword separaetly shows a match.

As for the xml feed. The RE companies will only take an xml feed from me, even thought the RSS feed you taught me works great! The XML I tried to make keeps giving me an error message like this: error on line 1 at column 37: Document is empty

It should look something like this:
<?php header('Content-type: application/xml; charset=utf-8'); ?>
<?php echo('<?xml version="1.0" encoding="utf-8"?>'); ?>
<properties>
<property>
<location>
<street-address/>
<city-name/>
<zipcode/>
<state-code/>
</location>
<details>
<listing-title/>
<price/>
<year-built/>
<num-bedrooms/>
<num-bathrooms/>
<lot-size/>
<square-feet/>
<property-type/>
<description/>
<landing-page/>
<lp-url/>
<listing-type/>
<status/>
<site/>
<site-url/>
<site-name/>
<pictures/>
<picture/>
<picture-url/>
<picture-caption/>
<picture-description/>
<picture-seq-number/>
<agent/>
<agent-name/>
<agent-phone/>
<agent-email/>
<agent-picture-url/>
<broker/>
<broker-name/>
<broker-phone/>
<broker-email/>
<broker-website/>
<broker-logo-url/>
<broker-address/>
<broker-street-address/>
<broker-city-name/>
<broker-zipcode/>
<broker-state-code/>
<office/>
<office-name/>
<office-phone/>
<office-email/>
<office-website/>
<tax/>
<tax-type/>
<tax-year/>
<tax-amount/>
<detailed-characteristics/>
<cooling-systems/>
<cooling-system/>
<heating-systems/>
<heating-system/>
<heating-fuel/>
<architecture-style/>
<exterior-type/>
<room-count/>
<num-floors/>
<has-basement/>
<has-dock/>
<has-fireplace/>
<has-hot-tub-spa/>
<has-lawn/>
<has-pool/>
<has-sportscourt/>
<is-waterfront/>
</details>
</property>
</properties>

Thanks for trying to help me with this

Re: [randyprod] Multiple Keyword Search/preview/database dump

  • Archived  

By (Deleted User) - October 19, 2009

Hi Chris,

Not sure if yu got my last message below from last week. I am still having trouble getting multiple keyword searches from editor listings page. Also still wanted to know about making xml feed not rss feed. Please see more descriptive email below.

Re: [Damon] Multiple Keyword Search/preview/database dump

  • Archived  

By (Deleted User) - October 19, 2009

Hi Damon,

How's this:

I am still having same problems. I downloaded the the newer version of the software so I could get multiple keyword searching with commas separating words and no luck.

Looks like this in section editor>listings> search tab>search fields- for the editor list page search menu bar.

title, location, listing_number, internet_number_sales, internet_number_rental, property_type, property_status, price, rental_time_period, rental_period_price, agent_comments, address, city, lot_size, bedrooms, bathrooms, extra_rooms, basement, fireplace, hot_tub, pool, tennis_court, garage, pool_guest_house, pets_ok, air_conditioning, house_style, proximity_to_water, description, owner_last_name

I can only get it to find 1 keyword- i.e.: location="east hampton".

If I put 2 keywords i.e.: location="east hampton", owner_last_name= "smith", I get no records match this etc. Even though each keyword separaetly shows a match.

As for the xml feed. The RE companies will only take an xml feed from me, even thought the RSS feed you taught me works great! The XML I tried to make keeps giving me an error message like this: error on line 1 at column 37: Document is empty

It should look something like this:
<?php header('Content-type: application/xml; charset=utf-8'); ?>
<?php echo('<?xml version="1.0" encoding="utf-8"?>'); ?>
<properties>
<property>
<location>
<street-address/>
<city-name/>
<zipcode/>
<state-code/>
</location>
<details>
<listing-title/>
<price/>
<year-built/>
<num-bedrooms/>
<num-bathrooms/>
<lot-size/>
<square-feet/>
<property-type/>
<description/>
<landing-page/>
<lp-url/>
<listing-type/>
<status/>
<site/>
<site-url/>
<site-name/>
<pictures/>
<picture/>
<picture-url/>
<picture-caption/>
<picture-description/>
<picture-seq-number/>
<agent/>
<agent-name/>
<agent-phone/>
<agent-email/>
<agent-picture-url/>
<broker/>
<broker-name/>
<broker-phone/>
<broker-email/>
<broker-website/>
<broker-logo-url/>
<broker-address/>
<broker-street-address/>
<broker-city-name/>
<broker-zipcode/>
<broker-state-code/>
<office/>
<office-name/>
<office-phone/>
<office-email/>
<office-website/>
<tax/>
<tax-type/>
<tax-year/>
<tax-amount/>
<detailed-characteristics/>
<cooling-systems/>
<cooling-system/>
<heating-systems/>
<heating-system/>
<heating-fuel/>
<architecture-style/>
<exterior-type/>
<room-count/>
<num-floors/>
<has-basement/>
<has-dock/>
<has-fireplace/>
<has-hot-tub-spa/>
<has-lawn/>
<has-pool/>
<has-sportscourt/>
<is-waterfront/>
</details>
</property>
</properties>

Thanks for trying to help me with this

Re: [randyprod] Multiple Keyword Search/preview/database dump

  • Archived  

By Dave - October 19, 2009

Hi Randy,

Can you start a new thread for each of these questions (XML and searching) it will make it easier for us to keep track of and allow us to respond faster. Just reference this thread "This is a continuation of this thread here: ... "

For the XML feed, can you post an url to your xml viewer and attach the file you are using to generate it? (And create a new thread just about that issue).

And for the searching, if you search for "east hampton smith" if will only find records that have all those keywords in the same field. So you'd need to set it up to display two different search fields. It didn't look like you had it setup that way but I wasn't sure.

Probably for that one the simplest would be if you could submit a second level support ticket with your CMS login details so we can take a look at your setup. You can do that here: https://www.interactivetools.com/support/email_support.cgi

Note: Don't post login details to the forum, use the secure support form.

PS: I'm going to lock this thread, just continue a new one on each topic. It lets us split up the work easier and makes it less confusing.

Thanks!
Dave Edis - Senior Developer
interactivetools.com