Ask Your Question

mdean's profile - activity

2016-05-18 09:17:06 -0500 received badge  Taxonomist
2016-01-14 09:32:16 -0500 answered a question Count value not matching returned results

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.

2016-01-06 16:41:57 -0500 answered a question Difference in date/timestamp fields, and GMT standardization

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.

2015-12-15 20:55:54 -0500 answered a question character encoding

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');
2015-12-15 12:43:53 -0500 commented question will not send emails to my email address

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.

2015-12-14 21:02:53 -0500 commented question character encoding

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

2015-12-14 16:24:27 -0500 commented question Feed only returning single image

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.

2015-12-07 09:42:51 -0500 commented question Website Integration Help With MLS Integration/Feed

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

2015-11-06 10:12:07 -0500 commented question 412 - Precondition set by the client failed

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.

2015-11-06 08:58:02 -0500 commented question 412 - Precondition set by the client failed

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

2015-11-06 08:56:57 -0500 commented question Calling RETS call directly in browser

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.

2015-11-05 15:54:06 -0500 commented question 412 - Precondition set by the client failed

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

2015-11-05 15:54:00 -0500 answered a question 412 - Precondition set by the client failed

In answer to one part of your question...

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

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.

2015-09-28 14:47:03 -0500 commented question Error "Could not get URL" Pulling Images

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?

2015-09-08 14:52:35 -0500 edited question Agent Photos

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!

2015-08-31 11:54:33 -0500 answered a question Documentation for setup/integration

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?

2015-08-31 11:43:00 -0500 commented question How often does the RETS information update?

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.

2015-08-28 14:29:40 -0500 edited question How often does the RETS information update?

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

2015-08-28 14:26:10 -0500 commented question Documentation for setup/integration

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?

2015-08-24 10:09:48 -0500 answered a question How often does the RETS information update?

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

2015-08-18 12:38:31 -0500 answered a question Field in returned Query not in METADATA (again)

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

2015-08-17 10:26:24 -0500 commented question Field in returned Query not in METADATA (again)

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

2015-08-17 10:26:08 -0500 commented question Field in returned Query not in METADATA (again)

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.

2015-08-17 10:24:57 -0500 commented question Field in returned Query not in METADATA (again)

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.

2015-08-14 13:43:18 -0500 commented question ReplyCode="20036" ReplyText="miscellaneous server error."

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

2015-08-14 13:41:41 -0500 commented question Field in returned Query not in METADATA (again)

<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>

2015-08-14 13:41:35 -0500 commented question Field in returned Query not in METADATA (again)

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">

2015-08-04 22:42:15 -0500 received badge  Commentator
2015-08-04 22:42:15 -0500 commented question Invalid Credentials Error

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.

2015-08-04 22:41:43 -0500 commented question Invalid Credentials Error

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?

2015-08-04 22:39:51 -0500 commented question Invalid Credentials Error

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.

2015-08-04 22:19:25 -0500 commented answer Listing agent L_ListAgent1

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.

2015-08-04 13:12:55 -0500 commented answer What happened to photo comments?

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).

2015-08-04 12:59:36 -0500 answered a question Listing agent L_ListAgent1

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.

2015-07-27 11:45:59 -0500 commented question streetsurl link dead but listing still in maxebrdi.rets.fnismls.com

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

2015-07-27 11:20:22 -0500 commented answer What happened to photo comments?

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

2015-07-23 10:03:33 -0500 commented question Issues with Rets Pull

Any further updates? Are you still having issues?

2015-07-23 09:54:17 -0500 received badge  Enthusiast
2015-07-22 10:51:23 -0500 answered a question What happened to photo comments?

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>
2015-07-13 13:14:53 -0500 commented question What happened to photo comments?

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?

2015-07-13 10:59:43 -0500 commented question Missing fields

What MLS are you working with?

2015-07-10 15:27:33 -0500 edited answer Attached Documents

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.

2015-07-09 10:31:22 -0500 commented question Issues with Rets Pull

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.

2015-07-09 09:18:06 -0500 commented question Issues with Rets Pull

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?

2015-07-07 17:16:30 -0500 commented question Error: "Miscellaneous Search Error. Performing record count"

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

2015-07-07 12:37:55 -0500 answered a question are photo urls provided?

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.