Working with CREA RETS and need the download.php TODO code
David Hollebone
Jason Graham
David Hollebone
Eliot Jones
Tom Ashworth
did you ever find your example code? I would like this also, especially for version 2. Hard to find that info anywhere...
Brady Edgar
Patrick Lyver
Peter van Schaik
I have used the sample code from realtorlink.ca, but it keeps returning "No records found"
Is there a setting in the DDF Dashboard that I am missing?
David Hollebone
Here's the script that I pieced together and has been working for my CREA DDF. It generates a csv (getdata_Property.csv) file in my root directory, which I then retreive manually right after I have called this script (I was not able to automate the uploading of the csv file to mySQL database, so I do it manually):
<?php require_once "../Connections/crealogon.php";
$rets_modtimestamp_field = "LastUpdated";
// use http://retsmd.com to help determine the names of the classes you want to pull.
// these might be something like RE_1, RES, RESI, 1, etc.
$property_classes = array("Property");
// DateTime which is used to determine how far back to retrieve records.
// using a really old date so we can get everything
$previous_start_time = "1980-01-01T00:00:00";
//////////////////////////////
require_once("phrets.php");
// start rets connection
$rets = new phRETS;
echo "+ Connecting to {$rets_login_url} as {$rets_username}<br>\n";
$connect = $rets->Connect($rets_login_url, $rets_username, $rets_password);
if ($connect) {
echo " + Connected<br>\n";
}
else {
echo " + Not connected:<br>\n";
print_r($rets->Error());
exit;
}
foreach ($property_classes as $class) {
echo "+ Property:{$class}<br>\n";
$file_name = "getdata_{$class}.csv";
$fh = fopen($file_name, "w+");
$maxrows = true;
$offset = 1;
$limit = 100;
$fields_order = array();
while ($maxrows) {
$query = "({$rets_modtimestamp_field}={$previous_start_time}+)";
// run RETS search
echo " + Query: {$query} Limit: {$limit} Offset: {$offset}<br>\n";
$search = $rets->SearchQuery("Property", $class, $query, array('Limit' => $limit, 'Offset' => $offset, 'Format' => 'COMPACT-DECODED', 'Count' => 1));
if ($rets->NumRows() > 0) {
if ($offset == 1) {
// print filename headers as first line
$fields_order = $rets->SearchGetFields($search);
fputcsv($fh, $fields_order, $delimiter = ',', $enclosure = '"');
}
// process results
while ($record = $rets->FetchRow($search)) {
$this_record = array();
foreach ($fields_order as $fo) {
$this_record[] = $record[$fo];
}
fputcsv($fh, $this_record, $delimiter = ',', $enclosure = '"');
}
$offset = ($offset + $rets->NumRows());
}
$maxrows = $rets->IsMaxrowsReached();
echo " + Total found: {$rets->TotalRecordsFound()}<br>\n";
$rets->FreeResult($search);
}
fclose($fh);
echo " - done<br>\n";
}
echo $search;
echo "+ Disconnecting<br>\n";
$rets->Disconnect();
--
You received this message because you are subscribed to a topic in the Google Groups "PHRETS" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/phrets/JVsjwmgrOjs/unsubscribe.
To unsubscribe from this group and all its topics, send an email to phrets+un...@googlegroups.com.
To post to this group, send email to phr...@googlegroups.com.
Visit this group at https://groups.google.com/group/phrets.
For more options, visit https://groups.google.com/d/optout.
Gifford Boake
Peter van Schaik
Can you also post the contents of your crealogon.php
Gifford Boake
OR: If you are using the live feed
Gifford Boake
How are you guy getting access to Realtor link assuming your not Realtors? The CREA sample feed sucks.
--
You received this message because you are subscribed to the Google Groups "PHRETS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to phrets+un...@googlegroups.com.