You cannot post messages because only members can post, and you are not currently a member.
|
Query with sysid range giving me 0 result
|
| |
Hi, I have tried to fetch all the data from rets server. But I'm facing some problem, As long as rets no longer support offset so I fetch the all sysid first then I put some range with sysid and trying to fetch the data. but it not working $class = 1; $limit = 1000; $query = "(sysid=62203534+)"; // where this id is the lowest one... more »
|
|
|
Database Design: RETS -> SQL
|
| |
I'm hoping someone can offer some advice to me on this subject. I was
originally going to try to use one table for all property classes but
I am starting to think that is not the best idea as I approach room
data / sizes because none of the columns are reused. Do most people
use a table per property class or are people doing just fine with a... more »
|
|
|
Unable to change User-Agent
|
| |
Hello -
This may be a silly question, but what is the best way to activate a
script which queries a RETS server, while preserving a specified User-
Agent?
I'm attempting to access a script which runs a RETS query (via
SearchQuery) through my browser, but after setting by User Agent (via
$rets->AddHeader("User-Agent", $rets_user_agent); ) it always defaults... more »
|
|
|
Search for field that contains values
|
| |
How do I search for a field that is not empty?
For example I want only properties that have a field with a value in
the field.
I have tried (RESISPEC="B*) thinking if it starts with the B but I get
0 returned yet I know some of the listings have data in that field if
I import them all
Al
|
|
|
PHRETS (Marketlinx RETS Connector Issue)
|
| |
Hi everyone,
I am trying to use PHRETS to get data from MarketLinx. I am using the
following settings and it seems that the issue is with the User Agent.
I used "RETSConnector/1.0" RETS User Agent which I found it that it
was the MarketLinx RETS Connector User and I should be using PHRETS/
1.0... more »
|
|
|
$rets->SearchQuery - Cities
|
| |
Thanks to the group for such a fast response. I now need to include multiple cities in the query to return less data. I do this: $query = "(26=Asher),(54=ACT)"; this works - returning data for the specified city that is ACTive. But $query = "(26=Asher),(26=Elk),(54=ACT)" ; don't work - and of course it don't - it don't make since.... more »
|
|
|
$rets->SearchQuery - Help
|
| |
I have this set: $query = "(26=Asher)"; $search = $rets->SearchQuery("Property", "1", $query, array( 'Limit' => 30, 'Count' => 1, 'Format' => 'COMPACT-DECODED' )); This dose return data for City of Asher. But I now need to add "Listing Status" [54] = Active But now I ger nothing in the return.... more »
|
|
|
Wrong Images and Truncated MLSNUM
|
| |
I have been trying to retrieve the correct images for each listing. I
have been using many of the scripts found on the PHRETS website and
stuck with no solution.
The listings data comes over no problem and clearly identified with
the correct PictureId, however, when either retrieving the image and... more »
|
|
|
Database Schema for RETS Data
|
| |
Hello, Currently I'm syncing one table from the CARETS database and it's around 322 columns (the property table). It's getting pretty cumbersome to work with, and, I am going to have to start supporting more than one MLS soon. I was wondering if anyone here had advice on how to normalize the data from... more »
|
|
|
Required Fields
|
| |
Does anyone know how to query a list of possible values for a field?
For example, there are only a dozen or so possible values for a Status
column, how would I go about getting a list of those?
|
|
|
Mailing list for the RETS PHP Library.