Ask Your Question

Revision history [back]

Lookup value not in lookup table - using RETS Connector

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?

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

Lookup value not in lookup table - using RETS Connector

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/fnisrets.aspx/WESTKY/login?rets-version=rets/1.5

Search query: (L_Status=|1_0) 1340 records downloaded 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_Address2,LA1_City,LA1_Email,LA1_UserFirstName,LA1_UserLastName,LA1_LoginName,LA1_UserMI,LA1_PhoneNumber1CountryCodeId,LA1_PhoneNumber1Ext,LA1_PhoneNumber1,LA1_PhoneNumber2CountryCodeId,LA1_PhoneNumber2Ext,LA1_PhoneNumber2,LA1_PhoneNumber3CountryCodeId,LA1_PhoneNumber3Ext,LA1_PhoneNumber3,LA1_PhoneNumber4CountryCodeId,LA1_PhoneNumber4Ext,LA1_PhoneNumber4,LA1_PhoneNumber5CountryCodeId,LA1_PhoneNumber5Ext,LA1_PhoneNumber5,LA1_State,LA1_Status,LA1_HiddenUsCID,LA1_WebPage,LA1_Zip,LA1_AddressStreet,LA1_PhoneNumber1Desc,LA1_PhoneNumber2Desc,LA1_PhoneNumber3Desc,LA1_PhoneNumber4Desc,LA1_PhoneNumber5Desc,LA1_AgentID,LA2_Address2,LA2_City,LA2_Email,LA2_UserFirstName,LA2_UserLastName,LA2_UserMI,LA2_PhoneNumber1CountryCodeId,LA2_PhoneNumber1Ext,LA2_PhoneNumber1,LA2_PhoneNumber2CountryCodeId,LA2_PhoneNumber2Ext,LA2_PhoneNumber2,LA2_PhoneNumber3CountryCodeId,LA2_PhoneNumber3Ext,LA2_PhoneNumber3,LA2_PhoneNumber4CountryCodeId,LA2_PhoneNumber4Ext,LA2_PhoneNumber4,LA2_PhoneNumber5CountryCodeId,LA2_PhoneNumber5Ext,LA2_PhoneNumber5,LA2_State,LA2_Status,LA2_HiddenUsCID,LA2_WebPage,LA2_Zip,LA2_AddressStreet,LA2_PhoneNumber1Desc,LA2_PhoneNumber2Desc,LA2_PhoneNumber3Desc,LA2_PhoneNumber4Desc,LA2_PhoneNumber5Desc,LFD_Landusetopography_5,LFD_Laundrylocation_30,L_ListAgent2,L_ListingDate,L_ListOffice1,L_ListOffice2,LM_char10_31,LM_Char10_4,LO1_board_id,LO1_Char10_1,LO1_BranchOfOrgID,LO1_OrgAddressStreet,LO1_ShortName,LO1_OrgAddress2,LO1_OrgCity,LO1_EMail,LO1_HiddenOrgID,LO1_OrganizationName,LO1_PhoneNumber1,LO1_OrgState,LO1_HiddenOtyID,LO1_WebPage,LO1_OrgZip,LO1_PhoneNumber1CountryCodeId,LO1_PhoneNumber1Desc,LO1_PhoneNumber1Ext,LO2_board_id,LO2_Char10_1,LO2_BranchOfOrgID,LO2_OrgAddressStreet,LO2_ShortName,LO2_OrgAddress2,LO2_OrgCity,LO2_EMail,LO2_HiddenOrgID,LO2_OrganizationName,LO2_PhoneNumber1,LO2_OrgState,LO2_HiddenOtyID,LO2_WebPage,LO2_OrgZip,LO2_PhoneNumber1CountryCodeId,LO2_PhoneNumber1Desc,LO2_PhoneNumber1Ext,L_Keyword9,LFD_Location_3,LM_Char10_23,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,SA1_Address2,SA1_City,SA1_Email,SA1_UserFirstName,SA1_UserLastName,SA1_UserMI,SA1_PhoneNumber1CountryCodeId,SA1_PhoneNumber1Ext,SA1_PhoneNumber1,SA1_PhoneNumber2CountryCodeId,SA1_PhoneNumber2Ext,SA1_PhoneNumber2,SA1_PhoneNumber3CountryCodeId,SA1_PhoneNumber3Ext,SA1_PhoneNumber3,SA1_PhoneNumber4CountryCodeId,SA1_PhoneNumber4Ext,SA1_PhoneNumber4,SA1_PhoneNumber5CountryCodeId,SA1_PhoneNumber5Ext,SA1_PhoneNumber5,SA1_State,SA1_Status,SA1_HiddenUsCID,SA1_WebPage,SA1_Zip,SA1_AddressStreet,SA1_PhoneNumber1Desc,SA1_PhoneNumber2Desc,SA1_PhoneNumber3Desc,SA1_PhoneNumber4Desc,SA1_PhoneNumber5Desc,SA2_Address2,SA2_City,SA2_Email,SA2_UserFirstName,SA2_UserLastName,SA2_UserMI,SA2_PhoneNumber1CountryCodeId,SA2_PhoneNumber1Ext,SA2_PhoneNumber1,SA2_PhoneNumber2CountryCodeId,SA2_PhoneNumber2Ext,SA2_PhoneNumber2,SA2_PhoneNumber3CountryCodeId,SA2_PhoneNumber3Ext,SA2_PhoneNumber3,SA2_PhoneNumber4CountryCodeId,SA2_PhoneNumber4Ext,SA2_PhoneNumber4,SA2_PhoneNumber5CountryCodeId,SA2_PhoneNumber5Ext,SA2_PhoneNumber5,SA2_State,SA2_Status,SA2_HiddenUsCID,SA2_WebPage,SA2_Zip,SA2_AddressStreet,SA2_PhoneNumber1Desc,SA2_PhoneNumber2Desc,SA2_PhoneNumber3Desc,SA2_PhoneNumber4Desc,SA2_PhoneNumber5Desc,L_SaleRent,L_SystemPrice,LM_Char50_1,L_SellingAgent1,L_SellingAgent2,L_SellingOffice1,L_SellingOffice2,LFD_Sewer_12,LFD_Showinginstructions_2,SO1_board_id,SO1_Char10_1,SO1_BranchOfOrgID,SO1_OrgAddressStreet,SO1_ShortName,SO1_OrgAddress2,SO1_OrgCity,SO1_EMail,SO1_HiddenOrgID,SO1_OrganizationName,SO1_PhoneNumber1,SO1_OrgState,SO1_HiddenOtyID,SO1_WebPage,SO1_OrgZip,SO1_PhoneNumber1CountryCodeId,SO1_PhoneNumber1Desc,SO1_PhoneNumber1Ext,SO2_board_id,SO2_Char10_1,SO2_BranchOfOrgID,SO2_OrgAddressStreet,SO2_ShortName,SO2_OrgAddress2,SO2_OrgCity,SO2_EMail,SO2_HiddenOrgID,SO2_OrganizationName,SO2_PhoneNumber1,SO2_OrgState,SO2_HiddenOtyID,SO2_WebPage,SO2_OrgZip,SO2_PhoneNumber1CountryCodeId,SO2_PhoneNumber1Desc,SO2_PhoneNumber1Ext,L_SoldPrice,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,LV_vow_address,LV_vow_avm,LV_vow_comment,LV_vow_include,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

Lookup value not in lookup table - using RETS Connector

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/fnisrets.aspx/WESTKY/login?rets-version=rets/1.5

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_Address2,LA1_City,LA1_Email,LA1_UserFirstName,LA1_UserLastName,LA1_LoginName,LA1_UserMI,LA1_PhoneNumber1CountryCodeId,LA1_PhoneNumber1Ext,LA1_PhoneNumber1,LA1_PhoneNumber2CountryCodeId,LA1_PhoneNumber2Ext,LA1_PhoneNumber2,LA1_PhoneNumber3CountryCodeId,LA1_PhoneNumber3Ext,LA1_PhoneNumber3,LA1_PhoneNumber4CountryCodeId,LA1_PhoneNumber4Ext,LA1_PhoneNumber4,LA1_PhoneNumber5CountryCodeId,LA1_PhoneNumber5Ext,LA1_PhoneNumber5,LA1_State,LA1_Status,LA1_HiddenUsCID,LA1_WebPage,LA1_Zip,LA1_AddressStreet,LA1_PhoneNumber1Desc,LA1_PhoneNumber2Desc,LA1_PhoneNumber3Desc,LA1_PhoneNumber4Desc,LA1_PhoneNumber5Desc,LA1_AgentID,LA2_Address2,LA2_City,LA2_Email,LA2_UserFirstName,LA2_UserLastName,LA2_UserMI,LA2_PhoneNumber1CountryCodeId,LA2_PhoneNumber1Ext,LA2_PhoneNumber1,LA2_PhoneNumber2CountryCodeId,LA2_PhoneNumber2Ext,LA2_PhoneNumber2,LA2_PhoneNumber3CountryCodeId,LA2_PhoneNumber3Ext,LA2_PhoneNumber3,LA2_PhoneNumber4CountryCodeId,LA2_PhoneNumber4Ext,LA2_PhoneNumber4,LA2_PhoneNumber5CountryCodeId,LA2_PhoneNumber5Ext,LA2_PhoneNumber5,LA2_State,LA2_Status,LA2_HiddenUsCID,LA2_WebPage,LA2_Zip,LA2_AddressStreet,LA2_PhoneNumber1Desc,LA2_PhoneNumber2Desc,LA2_PhoneNumber3Desc,LA2_PhoneNumber4Desc,LA2_PhoneNumber5Desc,LFD_Landusetopography_5,LFD_Laundrylocation_30,L_ListAgent2,L_ListingDate,L_ListOffice1,L_ListOffice2,LM_char10_31,LM_Char10_4,LO1_board_id,LO1_Char10_1,LO1_BranchOfOrgID,LO1_OrgAddressStreet,LO1_ShortName,LO1_OrgAddress2,LO1_OrgCity,LO1_EMail,LO1_HiddenOrgID,LO1_OrganizationName,LO1_PhoneNumber1,LO1_OrgState,LO1_HiddenOtyID,LO1_WebPage,LO1_OrgZip,LO1_PhoneNumber1CountryCodeId,LO1_PhoneNumber1Desc,LO1_PhoneNumber1Ext,LO2_board_id,LO2_Char10_1,LO2_BranchOfOrgID,LO2_OrgAddressStreet,LO2_ShortName,LO2_OrgAddress2,LO2_OrgCity,LO2_EMail,LO2_HiddenOrgID,LO2_OrganizationName,LO2_PhoneNumber1,LO2_OrgState,LO2_HiddenOtyID,LO2_WebPage,LO2_OrgZip,LO2_PhoneNumber1CountryCodeId,LO2_PhoneNumber1Desc,LO2_PhoneNumber1Ext,L_Keyword9,LFD_Location_3,LM_Char10_23,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,SA1_Address2,SA1_City,SA1_Email,SA1_UserFirstName,SA1_UserLastName,SA1_UserMI,SA1_PhoneNumber1CountryCodeId,SA1_PhoneNumber1Ext,SA1_PhoneNumber1,SA1_PhoneNumber2CountryCodeId,SA1_PhoneNumber2Ext,SA1_PhoneNumber2,SA1_PhoneNumber3CountryCodeId,SA1_PhoneNumber3Ext,SA1_PhoneNumber3,SA1_PhoneNumber4CountryCodeId,SA1_PhoneNumber4Ext,SA1_PhoneNumber4,SA1_PhoneNumber5CountryCodeId,SA1_PhoneNumber5Ext,SA1_PhoneNumber5,SA1_State,SA1_Status,SA1_HiddenUsCID,SA1_WebPage,SA1_Zip,SA1_AddressStreet,SA1_PhoneNumber1Desc,SA1_PhoneNumber2Desc,SA1_PhoneNumber3Desc,SA1_PhoneNumber4Desc,SA1_PhoneNumber5Desc,SA2_Address2,SA2_City,SA2_Email,SA2_UserFirstName,SA2_UserLastName,SA2_UserMI,SA2_PhoneNumber1CountryCodeId,SA2_PhoneNumber1Ext,SA2_PhoneNumber1,SA2_PhoneNumber2CountryCodeId,SA2_PhoneNumber2Ext,SA2_PhoneNumber2,SA2_PhoneNumber3CountryCodeId,SA2_PhoneNumber3Ext,SA2_PhoneNumber3,SA2_PhoneNumber4CountryCodeId,SA2_PhoneNumber4Ext,SA2_PhoneNumber4,SA2_PhoneNumber5CountryCodeId,SA2_PhoneNumber5Ext,SA2_PhoneNumber5,SA2_State,SA2_Status,SA2_HiddenUsCID,SA2_WebPage,SA2_Zip,SA2_AddressStreet,SA2_PhoneNumber1Desc,SA2_PhoneNumber2Desc,SA2_PhoneNumber3Desc,SA2_PhoneNumber4Desc,SA2_PhoneNumber5Desc,L_SaleRent,L_SystemPrice,LM_Char50_1,L_SellingAgent1,L_SellingAgent2,L_SellingOffice1,L_SellingOffice2,LFD_Sewer_12,LFD_Showinginstructions_2,SO1_board_id,SO1_Char10_1,SO1_BranchOfOrgID,SO1_OrgAddressStreet,SO1_ShortName,SO1_OrgAddress2,SO1_OrgCity,SO1_EMail,SO1_HiddenOrgID,SO1_OrganizationName,SO1_PhoneNumber1,SO1_OrgState,SO1_HiddenOtyID,SO1_WebPage,SO1_OrgZip,SO1_PhoneNumber1CountryCodeId,SO1_PhoneNumber1Desc,SO1_PhoneNumber1Ext,SO2_board_id,SO2_Char10_1,SO2_BranchOfOrgID,SO2_OrgAddressStreet,SO2_ShortName,SO2_OrgAddress2,SO2_OrgCity,SO2_EMail,SO2_HiddenOrgID,SO2_OrganizationName,SO2_PhoneNumber1,SO2_OrgState,SO2_HiddenOtyID,SO2_WebPage,SO2_OrgZip,SO2_PhoneNumber1CountryCodeId,SO2_PhoneNumber1Desc,SO2_PhoneNumber1Ext,L_SoldPrice,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,LV_vow_address,LV_vow_avm,LV_vow_comment,LV_vow_include,LFD_Walls_27,LFD_Water_11,LFD_WaterCompany_15,LFD_Waterheater_25,L_Zip 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