Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Products: CMS Builder:
Multiple Keyword Search/preview/database dump

 
 


randyprod
User

Oct 7, 2009, 2:11 PM

Post #1 of 15 (7677 views)
Shortcut
     Multiple Keyword Search/preview/database dump  
Hi,

I am the web designer for Hampton Homes RE. Can someone tell me how to get a multiple keyword search in the menu bar of the listing page? I can get a single keyword search but not multiples even when I put field names followed by commas in section editors>listings>ListPage Fleids.

Also what does the preview button supposed to preview?

Lastly can you tell me where to get database dump- xml feed from?

Any help well appreciated!!!

Respectfully, Randy


Chris
Staff


Oct 8, 2009, 4:02 PM

Post #2 of 15 (7651 views)
Shortcut
     Re: [randyprod] Multiple Keyword Search/preview/database dump [In reply to]  
Hi Randy,

The ListPage Fields affect only the admin List Page (e.g. admin.php?menu=listings). If you want to search multiple fields, you can do so with commas in the field:

Example: articleList.php?title,summary,content_keyword=Vancouver

More information on how to search is available at http://www.interactivetools.com/docs/cmsbuilder/viewer_search.html

In Reply To
Also what does the preview button supposed to preview?

The Preview button is simply a link to your List Page Url. This lets you quickly check on the section of your website you're currently updating.

In Reply To
Lastly can you tell me where to get database dump- xml feed from?

I'm not sure I understand what you're looking for. Did you want to generate an RSS Feed from one of your sections?

I hope this helps. Please let me know if you have any questions.
Chris


(This post was edited by chris on Oct 8, 2009, 4:02 PM)


randyprod
User

Oct 9, 2009, 8:50 AM

Post #3 of 15 (7638 views)
Shortcut
     Re: [chris] Multiple Keyword Search/preview/database dump [In reply to]  
Hi Chrsi,

Thank you so much for answering my questions so well! I thhink I got it, I just need to know where to put the

"articleList.php?title,summary,content_keyword=Vancouver "


Chris
Staff


Oct 11, 2009, 1:26 PM

Post #4 of 15 (7614 views)
Shortcut
     Re: [randyprod] Multiple Keyword Search/preview/database dump [In reply to]  
Hi Randy,

Having reread your first post, I think I misunderstood you. I originally thought you wanted to allow your visitors to search multiple fields, but now I think you want your CMS Builder users to search multiple fields.

If that's right, you'll simply need to list the fields you want searched in the Search Fields. Admin > Section Editors > MySection > Searching tab.

Does that answer your question? Please let me know if you have any questions.
Chris


randyprod
User

Oct 11, 2009, 3:05 PM

Post #5 of 15 (7606 views)
Shortcut
     Re: [chris] Multiple Keyword Search/preview/database dump [In reply to]  
Hi Again Chris,

Thanks for the reply and clarification. You are correct but unfortunately I previously did what you suggested but it didn't seem to work. When I put multiple keywords separated by a comma and space- i.e.- location, rental time period price, the search returns no records found. It seems to only take one keyword a search not multiples. Any thoughts?

Also is there a way to convert and RSS feed to a xml feed?

Thanks again for your help!

Randy


Chris
Staff


Oct 11, 2009, 4:37 PM

Post #6 of 15 (7597 views)
Shortcut
     Re: [randyprod] Multiple Keyword Search/preview/database dump [In reply to]  
In Reply To
location, rental time period price

What exactly are the Field Names of the fields you want to search? Field Names can't have spaces in them (they often have _underscores_ in them instead.) There should be a comma between each Field Name. I'm guessing a bit here, but perhaps you should enter "location, rental_time, period, price"?

In Reply To
Also is there a way to convert and RSS feed to a xml feed?

RSS is XML. By that I mean that RSS feeds are written in XML. ATOM feeds are also written in XML. I'm not sure what you mean by an XML feed.
Chris


randyprod
User

Oct 11, 2009, 4:56 PM

Post #7 of 15 (7593 views)
Shortcut
     Re: [chris] Multiple Keyword Search/preview/database dump [In reply to]  
Hi Chris,

Below is the Field names as they are and exactly how they are entered into the search tab like you said:

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.

If I put in a listing number comma and an address it doesn't work.

AS for the RSS question I understand. I guess what I need to know is how to take the feed and turn it into a link that ends in .xml.

Thanks again especially on a Sunday!


Chris
Staff


Oct 13, 2009, 10:54 AM

Post #8 of 15 (7552 views)
Shortcut
     Re: [randyprod] Multiple Keyword Search/preview/database dump [In reply to]  
Hi Randy,

Have you tried entering the following into the Search Fields?

"location, rental_time_period, price" (omitting the first and last quote)

In Reply To
I guess what I need to know is how to take the feed and turn it into a link that ends in .xml.

It's usually not important that your filename ends with ".xml". Most people call their XML-generating PHP files "example.xml.php" to make it obvious that you're using PHP to generate XML. You may need to start your file off by setting the correct header and <?xml?> tag, for example:

Code
<?php header('Content-type: application/xml; charset=utf-8'); ?> 
<?php echo('<?xml version="1.0" encoding="utf-8"?>'); ?>
Chris


randyprod
User

Oct 13, 2009, 11:17 AM

Post #9 of 15 (7550 views)
Shortcut
     Re: [chris] Multiple Keyword Search/preview/database dump [In reply to]  
Hi Chris,

There seems to be some confusion I am trying to search for information in the records- Lisitings using the field name info. i.e. search for location=East Hampton, rental_time_period= July, price- $5,000.

I read a post last night that said there may be a beta for this type of multiple search engine?

As for the XML feed, I tried your idea about the xml it. Isn't working for me. This is the error message I got.

I made a RSS feed like you said and it works great but I need to make an XML feed to submit real estate listings to other sites. They won't take RSS just XML feeds, so I somehow confused on how to convert it.


Chris
Staff


Oct 14, 2009, 1:51 PM

Post #10 of 15 (7526 views)
Shortcut
     Re: [randyprod] Multiple Keyword Search/preview/database dump [In reply to]  
Hi Randy,

Maybe you want something like this in Search Fields?

Code
Location|location|match 
Rental Time Period|rental_time_period|match 
Price|price|match

Then you can click "advanced search" on the List Page to see your new search fields.

In Reply To
This is the error message I got.

You must have forgotten to paste the error message.

In Reply To
They won't take RSS just XML feeds...

Do they have any documentation on what exactly they mean by that? Can you find any examples of feeds they will accept?
Chris


randyprod
User

Oct 14, 2009, 7:07 PM

Post #11 of 15 (7511 views)
Shortcut
     Re: [chris] Multiple Keyword Search/preview/database dump [In reply to]  
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


randyprod
User

Oct 19, 2009, 7:12 AM

Post #12 of 15 (7460 views)
Shortcut
     Re: [randyprod] Multiple Keyword Search/preview/database dump [In reply to]  
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.


Damon
Staff / Moderator


Oct 19, 2009, 12:00 PM

Post #13 of 15 (7451 views)
Shortcut
     Re: [randyprod] Multiple Keyword Search/preview/database dump [In reply to]  
Hi Randy,

In you last post, nothing appeared after you wrote "Please see more descriptive email below".

Can you post the details again?

--------------------------------------------------- 
Cheers
Damon Edis
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/


randyprod
User

Oct 19, 2009, 12:06 PM

Post #14 of 15 (7449 views)
Shortcut
     Re: [Damon] Multiple Keyword Search/preview/database dump [In reply to]  
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


Dave
Staff / Moderator


Oct 19, 2009, 4:37 PM

Post #15 of 15 (7443 views)
Shortcut
     Re: [randyprod] Multiple Keyword Search/preview/database dump [In reply to]  
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