mdean's profile - activity

This has been corrected. There was a mistake in one of the settings in the RETS profile attached to your account that limited the maximum number of records to return to 1. I changed the setting to reflect the other classes and was able to pull multiple records.

L_UpdateDate is what you want. Here is a list of the meanings of those fields:

• L_ListingDate - the date the property was listed
• L_HotSheetDate - the last hotsheet entry date for this listing
• L_StatusDate - the date the status last changed
• L_PriceDate - the date the price last changed
• L_InputDate - the timestamp when the listing was input into the system
• L_UpdateDate - the timestamp the listing was last changed

There is also another field that may be of concern, if you care about photos.

• L_Last_Photo_Updt - the timestamp the listing last had any photo changes (add, modify, reorder, delete)

Note that photo changes only update L_Last_Photo_Updt, and do not affect L_UpdateDate.

Have you tried adding something like this to the start of your PHP script? It looks like PHRETS does not utilize the mb functions (there is a strlen call that should be mbstrlen, for example). But, this is what I use in one of my PHP projects to set the PHP runtime to UTF-8 all around. There are some additional settings for the databases, too, depending on what you are using.

mb_internal_encoding('UTF-8');
mb_detect_order('UTF-8');
mb_regex_encoding('UTF-8');

Please post this question to the Community link from within Paragon. This forum is primarily for RETS and third party vendors - you will get better support at Community.

All Paragon RETS responses are UTF-8 encoded. What client library are you using to perform downloads?

The listing you reference only has one image in the MLS. Do you have more examples where you believe there should be multiple images? I reviewed the MLS configuration for your account and did not see any obvious limitations in place.

Eric, you may want to read my answer to this question: What is the best method of customizing a site using RETS?

We'll need to see your HTTP conversation (via Fiddler or Charles, for example). If you have a small code snippet that demonstrates the problem, that would also be useful.

You have to login to the server before running any transactions.

Why would you want to do this? RETS is an API, and although you could do certain things in a browser, it wouldn't be very useful.

What does your HTTP call that generates this message look like?

In answer to one part of your question...

You might be interested in the following projects for PHP support:

• https://github.com/troydavisson/PHRETS
• https://github.com/NationalAssociatio...

Concerning the 412 error. This error is only sent by transactions other than login when it doesn't have a valid session. This could be caused by a missing or corrupt "RETS-Session-ID=" cookie or if the session referred to by that cookie is expired or is not found. The login request returns the "RETS-Session-ID=" cookie on successful login and it should be returned with any subsequent transactions.

The session should not be a problem unless your application is idle for a period of time. Do you receive any other information about the error? Does it always fail on the same request?

I am in the midst of making a website, I have all the property info and photos pulling fine, I ran into issues when I tried to retrieve an agents photo using the following code:

echo 'Presented By: ' . $record['LA1_UserFirstName'] . ' ' . $record['LA1_UserLastName'] . "\n";
print_r($record['LO1_OrganizationName']);

$agentPhoto = $rets->GetObject("Agent", "Photo", $record['LA1_AgentID'], "0", 1);

foreach ($agentPhoto as $aphoto){
    if($aphoto['Success'] == true) {
        echo '<div class="preview-image"  style="border: 1px solid #4C3C1B; padding: 2px;">';
        $imageSrc = $photo['Location'];
        echo '<img class="" src="'.$imageSrc.'" />';
        echo '</div>';
    }                    
}

It seems as though no object is found this way, even though in the feed, under Agent resource, Photo is listed as one of the objects. Has anyone had better luck than I?

Cheers!

The standards are hosted by RESO (http://www.reso.org/) and are available online as well as in PDF form.

If you want to get up and running, your best bet is to find a plugin or library that will do the heavy lifting of RETS for you. There appear to be several WordPress plugins available, but we cannot vouch for any of them.

An alternative, if you are not adverse to writing code, is to use something like libRETS to wrap the RETS server access in an easy-to-use interface. libRETS is written in C++, but uses SWIG bindings for languages like PHP, Ruby, Python, or .NET.

Also, you may be interested in this similar question: What is the best method of customizing a site using RETS?

That depends on how your site is updating data from RETS. The RETS server itself is on top of the live MLS database, but your site is likely running a replicated copy of the listing data. This data could be updated every 15 minutes, every hour, or even once a day.

how often does the information in RETS update on my site?

You will need to get in contact with the agent's MLS to get access. As far as integration, this would require custom coding and potentially hosting your own database. Is the integration going to be done via RETS?

The Paragon RETS server displays live data directly from the MLS database.

I regenerated the metadata for your profile and now see the LO1_ShortName field in Property:LD_2.

We'll look into getting the metadata updated for you.

This possibly means that the last time metadata was generated, your profile didn't have access to that field. Access could have been granted afterwards, but the metadata for your profile wasn't regenerated. That would cause this very scenario to occur.

The RETS server for CREN can produce customized metadata per your RETS profile settings, so it could be affecting what you see. I was able to login with your account and see that the field was missing from the metadata, even though your profile is granting access to it.

We need more information to help, like your RETS login URL, what transaction is giving you this error, etc.

<field> <metadataentryid>016A664842951738</metadataentryid> <systemname>LO1_ShortName</systemname> <standardname></standardname> <longname>LO1Office Abbreviation</longname> <dbname>LO1OfcAbrv</dbname> <shortname>LO1OfcAbrv</shortname> <maximumlength>25</maximumlength> <datatype>Character</datatype>

I see LO1_ShortName in the returned metadata for this resource and class. Metadata version info: <metadata-table system="CREN" resource="Property" class="LD_2" version="15.8.16922" date="2015-08-11T18:02:01.1Z">

If you are able to get the code sample, please ask them to omit the credentials from it so they aren't exposed to everyone here.

I was able to authenticate successfully as this user both in the browser and via our RETS web UI. The SNAPSHOT designation also implies they are running an unreleased version of the libRETS library. Are you able to get a small code sample from them that demonstrates the issue?

It looks like something else has changed to me, too. The user agent presented in the information above says "librets/1.6.2-SNAPSHOT". The user agent in the RETS audit report for this user is "RETSConnector/1.0". This means there is a change in RETS clients.

You will need to download both fields and combine them yourself, if you wish to display the full name. You can always download the current metadata from the RETS server. Open houses are in the OpenHouse resource.

L_ListingId is the actual, underlying system ID for a listing. The L_DisplayId field is the user presentable listing number (which could be alphanumeric, depending on how the MLS is configured).

L_ListAgent1 really refers to the U_AgentID field in the agent resource, so it is a key value with a data type of integer. If you want to cross reference the agent resource fields, you'll need to look at the fields that start with LA1_ (like LA1_UserFirstName and LA1_UserLastName).

The fields are listed in the property resource metadata, so you should be able to get a list of what is available from there.

You will need to contact the vendor for streeturls.com. This is not a site we maintain or support.

This turned out to be how the MLS configured the Bridge server. You will need to work with the MLS directly to resolve this.

Any further updates? Are you still having issues?

I don't have access to the Bridge servers, but I am able to run the query and get both captions and descriptions directly from the Paragon RETS server. We'll reach out to Bridge and see if we can find a resolution.

<RETS ReplyCode="0" ReplyText="SUCCESS" >
<COUNT Records="14"/>
<DELIMITER value="09" />
<COLUMNS>   L_ListingID MED_sequence    MED_caption MED_description </COLUMNS>
<DATA>  1014115 0       Ranch house, great for any size family. Huge mbr w/ 2 his/her walk-in closets, 2nd mbr w/ priv bath, 2 bdrms great for teens. Baths have dbl vanity sinks/tubs. 35x12 lvng/dng rm w/ view of mtns. Full-len kit counter w/ rm for 5. Large 2 car garage.    </DATA>
<DATA>  1014115 1       Great house plan with 1999 square feet on a 1 acre lot in a country setting.    </DATA>
<DATA>  1014115 2       Gorgeous view of the mountains visible with your morning coffee out the french double-doors.    </DATA>
<DATA>  1014115 3       Spacious 2-car garage has separate entries and easy walk way access to the front door.  </DATA>
<DATA>  1014115 4   Kitchen Kitchen offers ample storage space, stove with backsplash, dishwasher and microwave. Laundry room has a pantry, half-bath and back door entry to the garage.    </DATA>
<DATA>  1014115 5   Kitchen Kitchen counter can be used as a serving area for parties/large get-togethers or as an eating area with comfortable seating for 5.  </DATA>
<DATA>  1014115 6   Living Room Spacious living/dining room area can be arranged to suit your needs and has a french double-door entry to the back yard.    </DATA>
<DATA>  1014115 7   Kitchen Kitchen counter can be used as a serving area for parties/large get-togethers or as an eating area with comfortable seating for 5.  </DATA>
<DATA>  1014115 8   Dining Room Spacious living/dining room area can be arranged to suit your needs. Nook area is great for a china cabinet.    </DATA>
<DATA>  1014115 9       Master bathroom offers a double-vanity sink, toilet and tub/shower area.    </DATA>
<DATA>  1014115 10      View of the entry foyer and center hallway from the master bedroom. </DATA>
<DATA>  1014115 11      All 3 bathrooms offer double-vanity sinks with all-in-one tubs/showers. </DATA>
<DATA>  1014115 12      Closets abound and the Master Bedroom sports both a his and hers walk-in closet.    </DATA>
<DATA>  1014115 13      There are 2 linen closets in the hallway and 2 closets in the foyer area.   </DATA>
</RETS>

We'll need more information to help you. What is the MLS you are working with? Do you have a sample listing ID with photos that have descriptions?

What MLS are you working with?

Document access can be made available through RETS GetObject if the MLS allows it. To get access, you would request access through the MLS for your particular account.

This occurs while trying to run our download file through VieleRETS Persistent Downloader. We pull the listings to our site and into a database.

This is what is on the screen: Trace Activating MLS data only, User supplied information will be overwritten All MLS listings will be fetched Selection Fields: L_City, L_Address, L_ListingID, L_Status, LM_Char10_21, LM_Char25_20, LM_Int2_10, LM_Int2_5, LM_Int1_14, LM_Int1_1, L_Remarks, LM_Char10_7, L_AskingPrice, L_Zip, L_State, L_AddressNumber, L_AddressStreet, LM_Int1_3, LM_Char10_20, LFD_SpecialConditions_19, LFD_InteriorFeatures_25, LA1_AgentID, L_ListOffice1, VT_VTourURL, LM_Char10_14, LM_Char10_16, LM_Char10_18, L_Area, LA1_AgentID DMQL Query: (L_ListingID=0+) New MLS listings will be added and any existing listings will be refreshed Images accessed directly via RETS (if required) Limit Govenor not Activated

This service is temporarily not available Trace Deactivated

At the bottom of the summary, it says No Listings are Found.

Can you please provide more information? Is this occurring during the login or search transaction? If searching, what is the query you are trying to run?

What resource, class, and query are you trying to run?

Photo information is provided in the media resource, but only for those images that have captions and/or descriptions. GetObject with location=1 would be your best bet if you need to get URLs for images.

We hope to add all images to the media resource in the future, but currently have no timeline on implementing that functionality.

EDIT: We do not currently include the URLs in the media resource, even for those that have captions and/or descriptions.