Ask Your Question

jgnorris's profile - activity

2019-09-06 15:38:42 -0500 received badge  Notable Question (source)
2019-09-06 15:38:42 -0500 received badge  Popular Question (source)
2019-08-27 11:58:37 -0500 received badge  Notable Question (source)
2019-07-25 17:32:39 -0500 marked best answer MAAR Listing status restrictions

URL = http://maar.rets.paragonrels.com:80/r...

User = V000CLALL

Hi,

We need to verify our RETS profile with MAAR. It seems we cant pull listings that have a L_Status = Contingent. We're not entirely sure when this changed, but we definitely have L_Status = contingent in our history tables as of yesterday.

Thanks!

2019-07-25 17:30:39 -0500 commented answer MAAR Listing status restrictions

Yes, thank you. I was able to find where that was being added to all the queries and I removed it.

2019-07-25 11:02:01 -0500 asked a question MAAR Listing status restrictions

MAAR Listing status restrictions URL = http://maar.rets.paragonrels.com:80/rets/fnisrets.aspx/MAAR/login User = V000CLA

2019-07-25 10:49:55 -0500 received badge  Famous Question (source)
2019-06-07 11:51:02 -0500 commented question L_SquareFeet missing from REIS feed?

Well I thought it was missing from all property classes. Now it looks like its only missing from MF_4. If they really

2019-06-07 11:21:00 -0500 asked a question L_SquareFeet missing from REIS feed?

L_SquareFeet missing from REIS feed? L_SquareFeet field missing from Southern Kentucky REIS. Starting about 1:00 PM Ce

2019-06-07 11:03:36 -0500 received badge  Autobiographer
2019-06-07 08:54:00 -0500 received badge  Citizen Patrol (source)
2019-06-06 09:19:22 -0500 received badge  Commentator
2019-06-05 15:41:04 -0500 answered a question Could data field [L_SquareFeet] be re-added to the Texarkana Paragon feed?

We are seeing this same field missing from Southern Kentucky REIS. Starting about 1:00 PM Central time.

2018-09-27 17:22:35 -0500 received badge  Popular Question (source)
2018-09-20 10:55:18 -0500 marked best answer Is there a different offset value for agents vs. property

URL = http://maar.rets.paragonrels.com/rets...

User = V000CLALL

Can you tell me if they have set up the ActiveAgents class with a different offset value that what we use for property classes. We believe the offset value for property is 2500. It appears to us they may be using a value of 1000 for ActiveAgents.

Thanks, Jeff Norris | Database Developer, Information Technology | Crye-Leike Group of Companies 901-758-5640 | jeff.norris@crye-leike.com | www.crye-leike.com

2018-09-20 10:55:07 -0500 commented answer Is there a different offset value for agents vs. property

Thanks for the super quick response!

2018-09-20 10:02:14 -0500 asked a question Is there a different offset value for agents vs. property

Is there a different offset value for agents vs. property URL = http://maar.rets.paragonrels.com/rets/fnisrets.aspx/MAAR

2018-06-26 09:55:08 -0500 received badge  Popular Question (source)
2018-06-21 12:49:16 -0500 marked best answer Zero rows returned for Open House queries

For West KY MLS we can see the metadata for Open Houses on RETSMD, but when we run these queries, we get zero rows returned. Can you check our access to this data?

URL = http://westky.rets.fnismls.com/rets/f... UserName = cryeleike

Thanks,

Jeff Norris | Database Developer, Information Technology | Crye-Leike Group of Companies 901-758-5640 | jeff.norris@crye-leike.com | www.crye-leike.com

2018-06-20 15:44:13 -0500 asked a question Zero rows returned for Open House queries

Zero rows returned for Open House queries For West KY MLS we can see the metadata for Open Houses on RETSMD, but when we

2017-10-31 11:12:02 -0500 marked best answer missing data in remarks

For Huntsville MLS, we are getting all nulls in LR_remarks33 for Property Class CI_4. All other Property Classes return values in this column. I looked back at our logs and this changed after 6/1/2017.

URL = http://huntsville.retsiq.com/contactl...

UserName = CLCOMPLETE

Thanks,

Jeff Norris | Database Developer, Information Technology | Crye-Leike Group of Companies 901-758-5640 | jeff.norris@crye-leike.com | www.crye-leike.com

2017-10-31 11:11:52 -0500 commented answer missing data in remarks

This appears to be fixed now. Thanks!!

2017-10-30 10:56:13 -0500 received badge  Notable Question (source)
2017-10-27 16:12:12 -0500 received badge  Popular Question (source)
2017-10-24 17:16:52 -0500 asked a question missing data in remarks

missing data in remarks For Huntsville MLS, we are getting all nulls in LR_remarks33 for Property Class CI_4. All other

2017-08-07 14:43:03 -0500 received badge  Famous Question (source)
2017-06-22 15:37:51 -0500 marked best answer MAAR - Miscellaneous Search Error. Error collecting Join metadata

For MAAR (Memphis) we are getting this error on all property classes except for RE_1 since yesterday morning (6/21).

URL = http://maar.rets.paragonrels.com/rets... Username = V000CLALL

Thanks,

Jeff Norris | Database Developer, Information Technology | Crye-Leike Group of Companies 901-758-5640 | jeff.norris@crye-leike.com | www.crye-leike.com

2017-06-22 15:37:34 -0500 commented answer MAAR - Miscellaneous Search Error. Error collecting Join metadata

Yes, everything is working now. Thank you.

2017-06-22 15:36:53 -0500 received badge  Notable Question (source)
2017-06-22 13:18:38 -0500 received badge  Popular Question (source)
2017-06-22 10:22:33 -0500 asked a question MAAR - Miscellaneous Search Error. Error collecting Join metadata

MAAR - Miscellaneous Search Error. Error collecting Join metadata For MAAR (Memphis) we are getting this error on all pr

2017-06-22 10:11:19 -0500 received badge  Notable Question (source)
2017-03-21 11:35:02 -0500 received badge  Popular Question (source)
2017-03-17 16:05:06 -0500 asked a question CWTAR - property resource queries only return active statuses

URL = http://cwtar.rets.fnismls.com/rets/fn...
Account = 1234

I am hoping you can verify something for me. We only receive active status listings from CWTAR. Their RETS admin claims our profile should receive all statuses (Sold, Expired, etc.). Can you verify our account settings? I have an example MLS# 173647. Our broker says this property closed 1/10/2017. The last update I was able to receive had an update date = 2016-12-02T21:13:00 with a status = 'Back On Market'. If I run a query on just that MLS#, I get no response.

Thanks,

Jeff Norris | Database Developer, Information Technology | Crye-Leike Group of Companies 901-758-5640 | jeff.norris@crye-leike.com | www.crye-leike.com

2016-11-09 17:47:11 -0500 commented question We are unable to query ActiveAgent/ActiveOffice resources

We found an error in a control table entry. Our system is largely soft coded and table driven because we pull from about 40 RETS servers. We corrected the error and now it works as expected. Sorry for the trouble. I will withdraw the question.

2016-11-08 15:15:03 -0500 asked a question We are unable to query ActiveAgent/ActiveOffice resources

We have no problem with property resource, but when we attempt to pull ActiveAgent or ActiveOffice resources, the query fails at the authorization step and we get "Unauthorized Query" returned from Paragon. I have asked the RETS admin in Huntsville and she claims she can run these queries no problem using our credentials. Can you verify this?

2016-02-22 11:21:59 -0500 received badge  Popular Question (source)
2016-02-22 11:21:59 -0500 received badge  Famous Question (source)
2016-02-22 11:21:59 -0500 received badge  Notable Question (source)
2016-02-09 18:46:21 -0500 marked best answer Agents missing from our RETS feed

We have an ongoing issue where from time to time we are unable to receive data for a few agents when we pull all the agents in the Agent resource. We use U_user_is_active=1 in the query to pull these. The particular example we have right now is agent Misti Holland. When we get listing data for this agent, her listings show LA1_UserCode = 10515 and L_ListAgent1 = 433. She does not appear in the data we receive from the Agent resource. This is for CARMLS (Little Rock) MLS.

URL = http://carmls.rets.fnismls.com/rets/f...

UserName = 11065

Thanks,

Jeff Norris Crye-Leike Information Technology

2016-02-09 18:46:07 -0500 received badge  Supporter (source)
2016-02-09 15:08:26 -0500 edited question Fields in metadata but missing from RETS feed - reInsight

This question is for a reInsight RETS feed.

URL = http://gamls.rets.reinsightmls.com/Re...

User = CRYE

When we pull RETS listing data (property resource) we have several missing columns compared to what we see in the metadata. For example, in SFD class we see 229 columns in the metadata, but we only get 187 columns in the actual data file we receive. This is for GAMLS.