Ask Your Question
0

Lookup value not in lookup table - using RETS Connector

asked 2016-03-30 12:34:22 -0600

onepath gravatar image

updated 2016-03-30 12:55:56 -0600

I was just given notice yesterday that the FTP feed is being discontinued tomorrow and I need to switch to RETS. In attempt to just manually get data for a few days until I can create a permanent PHP solution, I was told to use RETS Connector to download data.

I have know idea what I am doing and I am freaking out, because RETS is new to me. I was able to get a username and password for my MLS RETS (Western KY MLS) and tried to run a basic query to pull active listings for the Residential class as a test. Everything seemed straight forward until after running the query, I got the error below after retrieving about 1200 records. When I looked at the meta resource lookup table for the field, I confirmed there is no school named "Dawson" in the list. So what do I do now?

Server: http://westky.rets.fnismls.com/rets/f...

Search query: (L_Status=|1_0) 1340 records downloaded Error detected: server failed the request Error detected: server failed the request Request: SearchType=Property&Class=RE_1&Format=COMPACT-DECODED&QueryType=DMQL2&Query=(L_Status=|1_0)&Select=L_Keyword2,L_Keyword3,L_Keyword1,LFD_Access_4,L_Address,L_Address2,L_AddressDirection,L_AddressNumber,L_AddressSearchNumber,L_AddressStreet,L_ListAgent1,LVC_Agent_Hit_Count,LFD_Appliances_32,LM_Char10_22,LM_Char25_3,L_NumAcres,L_Keyword7,L_SquareFeet,LM_int4_40,L_AskingPrice,LFD_Assocfeeincludes_8,L_listings_associated_doc_count,LFD_Attic_26,L_Keyword6,LFD_Basement_29,LM_Int4_4,LM_Int4_5,LFD_Bathfeatures_33,LM_char10_38,LM_Char10_11,LM_char10_39,LM_Char10_12,LM_char10_40,LM_Char10_13,LM_Char10_1,LM_char10_36,LM_Char10_9,L_Keyword5,L_City,L_Keyword8,L_Class,LVC_Client_Hit_Count,L_ClosingDate,LFD_Construction_18,L_ContractDate,LFD_Cooling_24,LM_Dec_1,L_Area,LM_Char25_2,LM_char10_41,LM_Char10_14,LM_char10_32,LM_Char10_5,LFD_Diningkitchen_31,LM_char255_1,L_LastDocUpdate,L_Keyword10,LFD_Documentsonfile_9,L_DOM,L_DOMLS,LFD_DoorsAndwindows_28,LFD_Easements_40,LFD_ElectricCompany_14,LM_Char10_16,L_ExpirationDate,LFD_Exteriorfeatures_37,LFD_Exteriorfinish_20,LFD_Extras_38,LM_char10_33,LM_Char10_6,LFD_Fireplacewoodstove_35,L_FirstPhotoAddDt,LFD_Floorcovering_34,LM_char5_13,LFD_Foundation_19,L_Keyword4,LFD_Garagetype_22,LFD_GasCompany_13,LMD_MP_AddressLine,LMD_MP_Latitude,LMD_MP_Longitude,LMD_MP_MatchCode,LMD_MP_MatchedMethod,LMD_MP_PostalCode,LMD_MP_PrimaryCity,LMD_MP_Quality,LMD_MP_SecondaryCity,LMD_MP_Subdivision,LMD_MP_UpdateDate,LMD_MP_ZoomLevel,LM_char10_34,LM_Char10_7,LFD_Heating_23,LM_Char10_20,LM_Int4_8,L_HowSold,L_IdxInclude,LFD_Interiorfeatures_36,LM_char10_35,LM_Char10_8,LA1_UserFirstName,LA1_UserLastName,LA1_AgentID,LA2_UserFirstName,LA2_UserLastName,LFD_Landusetopography_5,LFD_Laundrylocation_30,L_ListAgent2,L_ListingDate,L_ListOffice1,L_ListOffice2,LM_char10_31,LM_Char10_4,LO1_BranchOfOrgID,LO1_HiddenOrgID,LO1_OrganizationName,LO1_OrgState,LO2_BranchOfOrgID,LO2_HiddenOrgID,LO2_OrganizationName,L_Keyword9,LFD_Location_3,LM_Char10_3,LM_Int4_3,LM_Int4_1,LM_char10_37,LM_Char10_10,LM_Char10_17,L_DisplayId,LFD_Occupant_1,L_OriginalPrice,LM_Char1_1,LM_Char25_1,L_PictureCount,L_Last_Photo_updt,LFD_Possession_6,L_PricePerAcre,L_PricePerSQFT,LM_char10_59,L_Remarks,LR_remarks11,LFD_Restrictions_39,LM_Char10_21,LFD_Roof_21,SA2_UserFirstName,SA2_UserLastName,SA2_UserMI,L_SaleRent,L_SystemPrice,LFD_Sewer_12,LFD_Showinginstructions_2,SO1_HiddenOrgID,SO1_OrganizationName,SO2_BranchOfOrgID,SO2_HiddenOrgID,SO2_OrganizationName,LM_Char10_19,LFD_Specialconditions_41,LFD_Specialitems_7,LM_Char25_6,LM_Char10_18,L_State,L_Status,L_StatusCatID,L_StatusDate,LFD_Style_17,LM_Char10_2,L_ListingID,T_tax_db_id,LM_Char25_4,T_list_tax_property_id,LFD_TVCable_16,L_Type_,L_UpdateDate,LM_Int4_2,LFD_Utilitiesavailable_10,LM_char10_42,LM_Char10_15,VT_VTourURL,VT_ExtVTourURL1,VT_ExtVTourURL2,VT_ExtVTourURL3,LFD_Walls_27,LFD_Water_11,LFD_WaterCompany_15,LFD_Waterheater_25,L_Zip RETS Status code = 20203: Undecoded values were sent: Miscellaneous Search Error. Lookup: value Dawson not found in Lookup table Elem_Lkp_1 for Resource 1. [LM_Char10_16] Miscellaneous Search Error. Lookup: value Dawson not found in Lookup table Middle_Lkp_1 for Resource 1. [LM_Char10_17] Miscellaneous Search Error. Lookup: value Dawson not found in Lookup table SrHigh_Lkp_1 for Resource 1. [LM_Char10_18]

Any help would be great, because I only have one day left till I am cutoff. I learned yesterday the MLS was given notice back in August about this change, but I was never notified until I called yesterday about a problem I was experiencing with one of the data files from my ftp access.

Randell

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2016-03-31 14:35:55 -0600

Randell,

I have confirmed with the Support Manager for the MLS that the RETS metadata has been refreshed. This is an issue that comes up when a value has been added to the system but has not been added to the metadata.

Please try again to pull data.

Here is a post outlining a similar issue for another board.

http://vendorsupport.paragonrels.com/...

If you run into any other issues please let us know.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-03-30 12:34:22 -0600

Seen: 598 times

Last updated: Mar 31 '16