Ask Your Question

jgnorris's profile - activity

2020-12-01 13:26:17 -0600 received badge  Popular Question (source)
2020-11-19 16:17:24 -0600 marked best answer CGMLS - No rows returned from query

We have a new RETS data feed for CGMLS and we are getting no rows returned from Property and Open House resources. We have several other Paragon data feeds and I think we are using similar queries for CGMLS.

Please advise.

URL = http://cgmls.rets.paragonrels.com/ret... UserName = RETSCLeike

Thanks, Jeff Norris Database Programmer Crye-Leike Realtors

2020-11-19 16:03:11 -0600 commented answer CGMLS - No rows returned from query

Yes, the MLS fixed it. We can only get active status, but we will work with them on that. Thanks for your help!

2020-11-19 11:53:40 -0600 received badge  Famous Question (source)
2020-11-19 11:53:40 -0600 received badge  Notable Question (source)
2020-11-19 10:40:39 -0600 asked a question CGMLS - No rows returned from query

CGMLS - No rows returned from query We have a new RETS data feed for CGMLS and we are getting no rows returned from Prop

2020-09-20 15:27:45 -0600 received badge  Popular Question (source)
2020-09-01 12:16:19 -0600 marked best answer L_IdxInclude

URL = http://reis.rets.fnismls.com/rets/fni... USER = CL9017585640

We are getting the following exception on search requests for all property classes:

Unknown Query Field [L_IdxInclude].

As far as I can tell, we are not requesting this field in the search and it doesn't exist in the metadata. Please advise.

Thanks.

2020-09-01 12:15:47 -0600 edited question L_IdxInclude

L_IdxInclude URL = http://reis.rets.fnismls.com/rets/fnisrets.aspx/REIS/login?rets-version=rets/1.5 USER = CL9017585640

2020-09-01 12:14:39 -0600 commented answer L_IdxInclude

Yes, it is working now. Thanks!

2020-08-31 16:19:57 -0600 asked a question L_IdxInclude

L_IdxInclude URL = http://reis.rets.fnismls.com/rets/fnisrets.aspx/REIS/login?rets-version=rets/1.5 USER = CL9017585640

2019-09-06 15:38:42 -0600 received badge  Notable Question (source)
2019-09-06 15:38:42 -0600 received badge  Popular Question (source)
2019-08-27 11:58:37 -0600 received badge  Notable Question (source)
2019-07-25 17:32:39 -0600 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 -0600 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 -0600 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 -0600 received badge  Famous Question (source)
2019-06-07 11:51:02 -0600 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 -0600 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 -0600 received badge  Autobiographer
2019-06-07 08:54:00 -0600 received badge  Citizen Patrol (source)
2019-06-06 09:19:22 -0600 received badge  Commentator
2019-06-05 15:41:04 -0600 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 -0600 received badge  Popular Question (source)
2018-09-20 10:55:18 -0600 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 -0600 commented answer Is there a different offset value for agents vs. property

Thanks for the super quick response!

2018-09-20 10:02:14 -0600 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 -0600 received badge  Popular Question (source)
2018-06-21 12:49:16 -0600 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 -0600 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 -0600 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 -0600 commented answer missing data in remarks

This appears to be fixed now. Thanks!!

2017-10-30 10:56:13 -0600 received badge  Notable Question (source)
2017-10-27 16:12:12 -0600 received badge  Popular Question (source)
2017-10-24 17:16:52 -0600 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-25 08:59:18 -0600 marked best answer 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

2017-08-07 14:43:03 -0600 received badge  Famous Question (source)
2017-06-22 15:37:51 -0600 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 -0600 commented answer MAAR - Miscellaneous Search Error. Error collecting Join metadata

Yes, everything is working now. Thank you.

2017-06-22 15:36:53 -0600 received badge  Notable Question (source)
2017-06-22 13:18:38 -0600 received badge  Popular Question (source)
2017-06-22 10:22:33 -0600 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 -0600 received badge  Notable Question (source)