My MLS (FlexMLS) apparently has cities mapped with a random string of characters which end up getting mapped to the key of the CCK field, then the Location mapping pulls that string instead of the CCK field's value. So what I end up with is the Location field for city displaying as "LWRAA597WNC". Also, Residential class is the only one that actually gets a valid city name at all, the other classes just get the cryptic key.

CommentFileSizeAuthor
#6 city.gif1.37 KBwebavant
#6 city2.gif4.4 KBwebavant

Comments

webavant’s picture

I am wondering if PIRETS is getting the possible keys for residential, then ignoring the other classes, which appear to have different keys entirely. Do I need to ask FlexMLS to format them differently? Is there something I can do? The values look right in the field options settings, it's just a problem that it displays the cryptic keys, instead of the values, on the nodes that aren't residential class, and displaying the key instead of the value in the Location field mapping. I seem to remember this not being a problem in earlier versions, but I may be wrong.

webavant’s picture

Just to make sure I'm being clear, when I query on LIST_1 (listing ID field that is mapped to PIRETS CCK's MLS Identifier field), LIST_39 (city) returns a cryptic string ("JDA8FR5MZOY" or something similar), but when I query on LIST_15 (status) instead, it returns a string with the actual name of the city ("Tillamook"). My problem is that the cryptic string is what is displaying the node.

webavant’s picture

Ok, good news, I was able to fix it by adding "?Format=COMPACT-DECODED&SearchType=Property&" to the default for URL for searching. The only problem now is that there is an extra "?" in my query string, but it seems to be working fine regardless. I think with a couple tweaks, PIRETS could support FlexMLS without a hitch. Perhaps add a less hacky way to add parameters to the query string?

webavant’s picture

This issue actually affects all PIRETS multi-select fields where the MLS returns a code, rather than a value, for its list of possible values. PIRETS seems to initially query all possible values during setup for the A class (residential class), but it does not get the values for other classes. The result, with my MLS, is that the fields populate with the code, but not the corresponding value. The results can be quite problematic, as I have noted in this other issue I created. Is there a workaround? What DMQL query can I use to determine the possible values and corresponding codes for each class? I will likely be modifying the CCK field allowed values, unless there's a better way.

Garrett Albright’s picture

webavant, are you using an older version of PIRETS? This problem should be fixed in newer versions. Try the most recent dev release - it should be stable. (Note that you'll probably have to re-install PIRETS after upgrading so that it can fetch correct values for all classes.)

For the record, the first sites that used PIRETS used the same values for lookup fields regardless of the property class. Not sure what's dumber; that RETS supports these being different per class, or that some RETS servers actually implement that.

webavant’s picture

StatusFileSize
new4.4 KB
new1.37 KB

Using most recent from drush. (drush dl pirets-6.x-3.x just yesterday). Posting file attachments just to be clear. The city in the location field should appear the same as the value of the City field, but it's picking up the MLS's code instead of the value.

For the record, the first sites that used PIRETS used the same values for lookup fields regardless of the property class.

Yes, I see that in this old issue, which I have apparently duplicated in this new issue, which is identical, yet still seems to be occurring in the most recent dev release. Feel free to close it and open the old one, or whatever.