LFD_FeaturesInterior_15 has 1 value when it should have more.

retag add tags

Resource: Property Class: RE_1 The old field INTERIORFEAT had multiple items in it. I see in the new field LFD_FeaturesInterior_15 only has 1 item in it. In the RETS metadata it looks like it should be LOOKUP_MULTI but there is no additional data from 1 feature.

Here is the Old Data

LISTINGID     INTERIORFEAT  Converted
253587         01,30,54            1st Floor Laundry, Fireplace-Wood, Mudroom
271145         17                     Ceiling Fan
2633689       13,39                 Cable, Hot Tub
2663321       01,25,53,57       1st Floor Laundry, Elevator, Master BR with BA, Pantry
2668171       01,13,14,24,38,53   1st Floor Laundry, Cable, Cable Internet, Eat-in Kitchen, Home Warranty, Master BR with BA
2669084       13,39                    Cable, Hot Tub
2677964        13,17,21,30,47,70       Cable, Ceiling Fan, Dining Area, Fireplace-Wood, Laundry Hook-ups, Sunroom
2711749       13,21,28,33,68            Cable, Dining Area, Fireplace-Gas, Furnished, Sprinkler System
2716188          01,13,14,24,28,38,47,53,54            1st Floor Laundry, Cable, Cable Internet, Eat-in Kitchen, Fireplace-Gas, Home Warranty, Laundry Hook-ups, Master BR with BA, Mudroom
2739552 01,25,53,57 1st Floor Laundry, Elevator, Master BR with BA, Pantry

Here is the New Data

L_LISTINGID   LFD_FeaturesInterior_15     converted
253587          NULL                              NULL
271145          378                                    Ceiling Fan
2633689        393                                     Hot Tub
2663321 NULL                                     NULL
2668171 NULL                                     NULL
2677964 NULL                                     NULL
2711749 NULL                                     NULL
2739552 NULL                                     NULL

asked 2016-09-08 10:29:23 -0500

This post is a wiki. Anyone with karma >75 is welcome to improve it.

edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

2 Answers

Sort by

oldest

newest

most voted

I'm finding any column that is a lookup_multi it only has 1 value in it. Does the new feed NOT do lookup_multi. These listings all should have data in the LFD_FeaturesInterior_15 but they don't. The LFD_FeaturesInterior_15 has values that match up with the old feed.

New Feed Value  New Feed Long Value Old Feed Value  Old Feed Long Value
373 Attic   06  Attic
374 Bar 10  Bar
375 Blinds  12  Blinds
377 Cedar Closet    16  Cedar Closet
378 Ceiling Fan 17  Ceiling Fan
379 Dining Area 21  Dining Area
380 Draperies   22  Draperies
381 Elevator    25  Elevator
390 Furnished   33  Furnished
391 Hearth  37  Hearth
393 Hot Tub 39  Hot Tub
397 Kitchen/Dining  44  Kitchen/Dining
398 Kitchen/Family  45  Kitchen/Family
399 Kitchen/Living  46  Kitchen/Living
400 Laundry Hook-ups    47  Laundry Hook-ups
401 Lead/Stain Glass    48  Lead/Stain Glass
406 Living/Dining   51  Living/Dining
409 Natural Woodwork    56  Natural Woodwork
410 Other   99  Other
412 Sauna   61  Sauna
415 Skylight    64  Skylight
417 Soaking Tub 86  Soaking Tub
421 Vaulted Ceiling 72  Vaulted Ceiling
422 Walk-in Closet  73  Walk-in Closet
423 Walk-in Pantry  74  Walk-in Pantry
424 Wet Bar 75  Wet Bar
425 Whirlpool Tub   76  Whirlpool Tub
427 Wood Stove Hook-up  78  Wood Stove Hook-up
428 Wood Stove Insert   79  Wood Stove Insert

Here is some data where the listings should have data.

Feed    LISTINGID   Raw converted
New Data    4005104 NULL    NULL
Old Data    4005104 01,02,05,06,12,13,14,16,17,20,21,24,27,28,36,43,44,46,47,48,49,51,53,56,57,65,67,73,76,80   1st Floor Laundry, 1st Floor Master BR, Alternative Heat Stove, Attic, Blinds, Cable, Cable Internet, Cedar Closet, Ceiling Fan, Den/Office, Dining Area, Eat-in Kitchen, Family Room, Fireplace-Gas, Handicap Modified, Island, Kitchen/Dining, Kitchen/Living, Laundry Hook-ups, Lead/Stain Glass, Library, Living/Dining, Master BR with BA, Natural Woodwork, Pantry, Smoke Det-Battery Powered, Smoke Det-Hdwired w/Batt, Walk-in Closet, Whirlpool Tub, 1 Fireplace
New Data    4155399 NULL    NULL
Old Data    4155399 01,06,15,17,20,21,23,27,37,43,50,52,54,56,58,65,73,77,83    1st Floor Laundry, Attic, Cathedral Ceilings, Ceiling Fan, Den/Office, Dining Area, DSL, Family Room, Hearth, Island, Living Room, Loft, Mudroom, Natural Woodwork, Playroom, Smoke Det-Battery Powered, Walk-in Closet, Wood Stove, 1 Stove
New Data    4247795 NULL    NULL
Old Data    4247795 01,02,06,10,11,14,15,17,18,20,24,26,27,30,31,32,35,37,39,43,44,50,52,53,54,55,57,59,61,62,66,69,70,72,73,75,76,82   1st Floor Laundry, 1st Floor Master BR, Attic, Bar, B-fast Nook/Room, Cable Internet, Cathedral Ceilings, Ceiling Fan, Central Vacuum, Den/Office, Eat-in Kitchen, Exercise Room, Family Room, Fireplace-Wood, Formal Dining Room, Foyer, Great Room, Hearth, Hot Tub, Island, Kitchen/Dining, Living Room, Loft, Master BR with BA, Mudroom, Multi Phonelines, Pantry, Recreation, Sauna, Sec Sys/Alarms, Smoke ...

(more)

RLS2000

answered 2016-09-16 12:52:02 -0500

edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments

In NEREN the Features-Interior field is set as a lookup multi. Using the IDX export I was able to return these selections for these two listings: 253587 = Fireplace - Wood,Laundry - 1st Floor 2668171 = Master BR w/ BA,Laundry - 1st Floor The remainder of the legacy options for these listings have moved to different fields. For example, the options of "Cable" was moved to a new multi-select field called "Services". The option of "Eat-in Kitchen" was moved to a Room field.

If you continue to see null values for the listings indicated above please let us know and include your Login Name so we can research your specific RETS access. Thanks!