Ask Your Question

RLS2000's profile - activity

2016-12-21 15:56:32 -0600 received badge  Famous Question (source)
2016-12-15 14:54:02 -0600 received badge  Notable Question (source)
2016-12-15 09:47:25 -0600 received badge  Popular Question (source)
2016-12-14 12:21:59 -0600 commented question ActiveAgents getting no data

This is been corrected, the MLS fixed an issue on their side.

2016-12-13 15:46:10 -0600 received badge  Notable Question (source)
2016-12-13 15:46:10 -0600 received badge  Famous Question (source)
2016-12-13 15:46:10 -0600 received badge  Popular Question (source)
2016-12-13 15:46:01 -0600 received badge  Famous Question (source)
2016-12-13 11:24:10 -0600 asked a question ActiveAgents getting no data

Hi,

For some reason I'm only getting 180 records? This is for NEREN.

2016-10-19 13:44:06 -0600 received badge  Notable Question (source)
2016-10-19 11:50:29 -0600 asked a question LR_REMARKS22 data has more characters than metadata claims it will have.

In the NEREN system, I have found the column LR_REMARKS22 to be limited to 1500 characters but when the listing comes in it has 1504 characters. Am I reading the metadata wrong?

Example: Listing ID 4499290

MetaData
System Name: ​​LR_REMARKS22
​Long Name: ​Remarks - Public
​Data Type: ​CHARACTER
Length: 1500
Interpretation: NO_INTERPETATION

LR_REMARKS22: Unique & beautiful custom-built home, originally designed for convenient 1-level living was recently upgraded to include an entire bonus suite on the 2nd floor! This impeccably maintained 1-owner home combines contemporary lines with warm, custom woodwork, including solid-wood (3-ft) arched-top doors that are echoed in the kitchen cabinetry.
Open floor plan unites the Great Room, Dining Area and Kitchen, creating the perfect place for family & friends to gather. Dramatic 16-ft vaulted ceiling is complimented by the arched-transom French Doors that lead to the patio. Perfect for the entertainer or the chef, the kitchen has abundant cabinets & countertop, and includes a stove with cooktop, plus a wall convection wall oven, built-in workspace, and huge center island with seating, storage under, and recessed lighting above. A warm & inviting Sunroom has floor-to-ceiling windows-perfect for morning coffee. Knotty pine walls,window sills & trim gives the country porch a casual and welcoming feel.. 30x30 elevated patio with custom NH metalwork surround is perfect for an outdoor great room, hot tub or pergola. Amazing sunset views and supported by steel I-beam. The 900 sf garage just below easily fits the cars, the toys, and a workshop with bench, plus storage! Landscaping includes perennial & raised beds, retaining walls, grapevines and more! All located minutes from shopping & dining, and EASY highway access. Schedule your showing in time to view the spectacular sunsets!

This field is 1504 characters.

2016-10-13 09:58:03 -0600 commented answer LFD_FeaturesInterior_15 has 1 value when it should have more.

This still has not been corrected

2016-10-13 09:32:47 -0600 received badge  Popular Question (source)
2016-10-12 15:04:37 -0600 received badge  Editor (source)
2016-10-12 12:22:51 -0600 asked a question LR_remarks2020 data is longer than meta data length

In the NEREN MLS. I'm finding that there a lot of listings with data in the field [LR_remarks2020] which is larger than the meta data length.

The Meta data says "DataType: CHARACTER" and "Length: 300"

Here is some sample data

take NH-101 W toward Manchester Airport/US-3/Bedford/Nashua.  Then 2.16 miles  Take NH-114 toward St anselm Coll/Go  Turn left onto New Boston Rd.  Then 5.64 miles  New Boston Rd becomes Chestnut Hill Rd.  Then 0.48 miles Turn sharp right  Turn left to stay on Bedford Rd.       McCurdy Rd is a sharp right.

This is 307 characters.

2016-09-21 13:26:46 -0600 commented answer LFD_FeaturesInterior_15 has 1 value when it should have more.

Please the switch over is this weekend!!! I'm not getting any info!!!

2016-09-19 07:52:39 -0600 received badge  Notable Question (source)
2016-09-16 12:52:02 -0600 answered a question LFD_FeaturesInterior_15 has 1 value when it should have more.

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)
2016-09-16 12:14:50 -0600 received badge  Popular Question (source)
2016-09-08 10:29:23 -0600 asked a question LFD_FeaturesInterior_15 has 1 value when it should have more.

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