Problem connecting to Interealty

[David Baldwin]

I am attempting to connect to an Interealty server with VieleRETS without
success. I do not have problems connecting with RETSconnector. I have
looked through past posts on this topic and can�t seem to pull a solution
out from them. I have tried various options on the initial connection page,
but I always receive a password mismatch error. The name of the server is:
http://inr.rets.interealty.com/Login.asmx/Login

Any ideas? Does anyone have Viele working with Interealty?

Best Regards,

David Baldwin

[Tony Russo]

Hi David,



Possibly a User Agent issue?



Some Interealty accounts require a User Agent and Password.



Tony

[Alan Pinstein]

David- I had similar problems. Out-of-the-box, 1.1.6 won't connect to
Interealty. I had to hard-code some things. You can see this post for
more info:

http://mail.crt.realtors.org/pipermail/viele-dev/2008-January/001001.html

I had to add this line at line 314 in common/rets_lite/io.php:

# diff vieleRETS-1.1.6-a/common/rets_lite/io.php vieleRETS-1.1.6/
common/rets_lite/io.php
315d314
< $this->setRetsVersion('1.5');

So that Interealty would be happy during connection attempts. I asked
how to do the above without hard-coding, but didn't get an answer.

Also, here's what my source data looks like:

define("RETS_SERVER_ACCOUNT","usenrame");
define("RETS_SERVER_PASSWORD","password");
define("RETS_SERVER_URL","http://domain/Login.asmx/Login");
define("RETS_CLIENT_PASSWORD","differentpassword");
define("RETS_DEFAULT_PORT","80");
define("APPLICATION","RETSConnector");
define("VERSIO N","1.0");
define("KEEP_ALIVE_SERVER",true);
define("ENCODE_REQUESTS",false);
define("POST_REQUESTS",true);
define("STANDARD_SERVER_RESPONSE",true);
define("DETECTED_SERVER_NAME","Microsoft-IIS/6.0");
define("SERVER_TIME_DIFFERENCE","");
define("SELECTION_RESOURCE","Property");
define("SELECTION_CLASS","1");
define("DETECTED_STANDARD_NAMES",false);
define("UNIQUE_KEY","sysid");
define("DETECTED_MAXIMUM_RETS_VERSION","");
define("COMPACT_DECODED_FORMAT",true);
define("PAGINATION",false);
define("OFFSET_ADJUSTMENT","");
define("MEDIA_MULTIPART",false);
define("MEDIA_LOCATION",false);
define("MEDIA_LIST_ZERO_START",false);

While I did finally get connected, viele failed to reverse-engineer
properly and I got stuck there. It was suggested that I downgrade to
1.1.5 but I haven't yet had a chance to.

Please let me know if/how you get things working.

Hopefully that'll help.

Alan

On Feb 1 6, 2008, at 1:28 AM, David Baldwin wrote:

> I�m still a little confused by the User-Agent. Is the User-Agent
> different than the �Application/Version�? If I do get a User-Agent
> username and password from my MLS where do they go? Is User-agent
> password �RETS_CLIENT_PASSWORD� and username �APPLICATION/VERSION�?
>
> -------------------------
>
> Below are my connection settings and all of the options I have tried
> in each.
>
> RETS_SERVER_ACCOUNT - username from MLS
> RETS_SERVER_PASSWORD - password from MLS
> RETS_SERVER_URL - http://inr.rets.interealty.com/Login.asmx/Login
> RETS_CLIENT_PASSWORD - blank, password from MLS
> RETS_DEFAULT_PORT - 80, 6103
> APPLICATION - VieleRETS, VieleRETS/1.1.6, blank
> VERSION - 1.1.6, blank
> KEEP_ALIVE_SERVER - checked, unchecked
> ENCODE_REQUESTS - checked, unchecked
> POST_REQUESTS - checked, unchecked
> STANDARD_SERVER_RESPONSE - checked, unchec ked
> SERVER_TIME_DIFFERENCE - 0
>
> ----------------------
>
> Here is an error I get the screen after the "mismatched username/
> password' message...
>
> SENDING ... POST /Login.asmx/Login HTTP/1.1 POST /Login.asmx/Login
> HTTP/1.1 SERVER requires authorization PAYLOAD ... Unauthorized
> Request.
> Server Error in '/' Application.
>
> Access is denied.
>
> Description: An error occurred while accessing the resources
> required to serve this request. This may have been caused by an
> incorrect user name and/or password.
>
> Error message 401.1: Logon credentials were not recognized. Make
> sure you are providing the correct user name and password.
> Otherwise, contact the Web server's administrator for help.
>
> SENDING ... POST /Login.asmx/Login HTTP/1.1 POST /Login.asmx/Login
> HTTP/1.1 SERVER requires second authorization PAYLOAD ...
> Unauthorized Request. Error code: -98. Error Message: Unregistered
> RETSAppID.
> Server Error in '/' Application.
>
> Runtime Error
>
> Description: An application error occurred on the server. The
> current custom error settings for this application prevent the
> details of the application error from being viewed remotely (for
> security reasons). It could, however, be viewed by browsers running
> on the local server machine.
>
> Details: To enable the details of this specific error message to be
> viewable on remote machines, please create a tag
> within a "web.config" configuration file located in the root
> directory of the current web application. This tag
> should then have its "mode" attribute set to "Off".
>
>
>
>
>
>
>
>
>
> Notes: T he current error page you are seeing can be replaced by a
> custom error page by modifying the "defaultRedirect" attribute of
> the application's configuration tag to point to a
> custom error page URL.
>
>
>
>
>
>
> > defaultRedirect="mycustompage.htm"/>
>
>
>
> SENDING ... POST /Login.asmx/Login HTTP/1.1 POST /Login.asmx/Login
> HTTP/1.1 Credentials do not match
>
>
> Thank you.
>
> Best Regards,
> David Baldwin
> _______________________________________________
> viele-dev mailing list
> viel...@crt.realtors.org
> http://mail.crt.realtors.org/mailman/listinfo/viele-dev

-------------------------------------------------

Alan Pinstein
ShowCase Web Sites
Web: http://www.showcaseRE.com
Email: api nst...@showcaseRE.com
tel: 404-812-9209

[Mark Lesswing]

From the setup menu, you can set the RETS version of the server from
the "Override Auto-Detection" screen.

I would be interested in hearing about your experience with 1.1.6 BETA.

On Saturday 16 February 2008, Alan Pinstein wrote:
> David- I had similar problems. Out-of-the-box, 1.1.6 won't connect to
> Interealty. I had to hard-code some things. You can see this post for
> more info:
>
> http://mail.crt.realtors.org/pipermail/viele-dev/2008-January/001001.html
>
> I had to add this line at line 314 in common/rets_lite/io.php:
>
> # diff vieleRETS-1.1.6-a/common/rets_lite/io.php vieleRETS-1.1.6/
> common/rets_lite/io.php
> 315d314
> < $this->setRetsVersion('1.5');
>
> So that Interealty would be happy during connection attempts. I asked
> how to do the above without hard-coding, but didn't get an answer.
>
> Also, here's what my source data looks like:
>

> define("RETS_SERVER_ACCOUN T","usenrame");

> define("RETS_SERVER_PASSWORD","password");
> define("RETS_SERVER_URL","http://domain/Login.asmx/Login");
> define("RETS_CLIENT_PASSWORD","differentpassword");
> define("RETS_DEFAULT_PORT","80");
> define("APPLICATION","RETSConnector");

> define("VERSION","1.0");

> define("KEEP_ALIVE_SERVER",true);
> define("ENCODE_REQUESTS",false);
> define("POST_REQUESTS",true);
> define("STANDARD_SERVER_RESPONSE",true);
> define("DETECTED_SERVER_NAME","Microsoft-IIS/6.0");
> define("SERVER_TIME_DIFFERENCE","");
> define("SELECTION_RESOURCE","Property");
> define("SELECTION_CLASS","1");
> define("DETECTED_STANDARD_NAMES",false);
> define("UNIQUE_KEY","sysid");
> define("DETECTED_MAXIMUM_RETS_VERSION","");
> define("COMPACT_DECODED_FORMAT",true);
> define("PAGINATION",false);
> define("OFFSET_ADJUSTMENT","");
> define("MEDIA_MULTIPART",false);
> define("MEDIA_LOCATION",false);

> define("MEDIA_LIST_ZERO_STA RT",false);

>
> While I did finally get connected, viele failed to reverse-engineer
> properly and I got stuck there. It was suggested that I downgrade to
> 1.1.5 but I haven't yet had a chance to.
>
> Please let me know if/how you get things working.
>
> Hopefully that'll help.
>
> Alan
>

> > Notes: The current error page you are seeing can be replaced by a

> > custom error page by modifying the "defaultRedirect" attribute of
> > the application's configuration tag to point to a
> > custom error page URL.
> >
> >
> >
> >
> >
> >
> > > > defaultRedirect="mycustompage.htm"/>
> >
> >
> >

> > SENDING ... POST /Login.asmx /Login HTTP/1.1 POST /Login.asmx/Login

> > HTTP/1.1 Credentials do not match
> >
> >
> > Thank you.
> >
> > Best Regards,
> > David Baldwin
> > _______________________________________________
> > viele-dev mailing list
> > viel...@crt.realtors.org
> > http://mail.crt.realtors.org/mailman/listinfo/viele-dev
>
> -------------------------------------------------
>
> Alan Pinstein
> ShowCase Web Sites
> Web: http://www.showcaseRE.com

> Email: apin...@showcaseRE.com
> tel: 404-812-9209



--
Mark

[David Baldwin]

Thanks Brad. Just in the past few minutes I got a few listings to download
with an RDB target. Hooray! However, no images. I�ll keep trying as it
seems I am inching closer.

By RETS administrator, do you mean my MLS tech contact or someone from
Interealty? I have spoken to my MLS tech person. He hadn�t heard of Viele.
I told him that it seemed as though Interealty was causing a lot of problems
for people. He responded with �Welcome to my world.� Not very comforting.
Ha.

Best Regards,
David

[David Baldwin]

Has anyone actually been successful in downloading listings from an
Interealty server via VieleRETS in the past or am I in uncharted waters
here? Judging by the posts on this site, it looks like those on Interealty
servers have eventually given up. I would very much like to get this
working, but am not sure where to go from here. I�ve gotten connected,
downloaded metadata, mapped the fields in the extract...but everytime I run
the batch I get no listings.

Best Regards,
David Baldwin

[Brad Ediger]

I used to use VieleRETS on Interealty successfully, and I currently
have a libRETS client connecting to the same server. I think
Interealty may vary depending on the market (Interealty vs. First
American MLS vs. Marketlinx). Have you enabled tracing on the batch (I
believe it's the defines in common/rets_lite/exchange.php) and tried
talking with your RETS administrator?

Br ad Ediger
Tasman Labs, Inc.
http://www.tasmanlabs.com/

[Dave Melnick]

Hi David,

Thanks for replying. I am cross eyed from the number of permutations I
have tried, including trial and error with the true/false options. The
mailing list archive was the first place I researched and I do recall
trying your suggestion. Didn't work for me.

With the default configuration I do get the "Verify Connection" screen
with the following:

Looking for the Server Success (Microsoft-IIS/6.0)
Making a connection Failure (Report to Provider)

The server has responded with the following message:


From this I am assuming it finds their server, but fails the
connection. I must be missing something.

Again, thanks

Cheers,
David Baldwin wrote:
> Hello Dave:
> I am on a Mac for development and LAMP for production and both seem to work. I kept all defaults on the connection screen. The one change that got me connected was to set the application to "RETSConnector" and versio n to "1.0". Have you tried that?

[Dave Melnick]

Greetings,

Is there still a forum in VieleRETS future? Mailing lists are a pain.

I am duplicate of David Baldwin issue and question here:
http://mail.crt.realtors.org/pipermail/viele-dev/2008-February/001019.html

As with David's the RETSconnector works on my desktop windows server,
but I need Viele on my linux web server.

Have tried the different recommendations suggested and still no go.

Keep getting a:
/Logon credentials were not recognized. Make />/ > sure you are
providing the correct user name and password. />/ > Otherwise, contact

the Web server's administrator for help.

at this url:
http://rml.rets.interealty.com/Login.asmx/Login
/
Anyone gotten this to work?

Cheers,

[Tony Russo]

David,



Take a look in your RETSconnector configuration and see what user-agent and
password they're using.



Or if you're familiar with WireShark you can take a packet trace when
RETSconnector is running to see what they are passing as user-agent and
password.



Tony



-----Original Message-----
From: Tony Russo [mailto:tony...@bellsouth.net]
Sent: Saturday, February 16, 2008 9:36 AM
To: 'For discussion on the development of viele rets'
Subject: RE: [viele-dev] Problem connecting to Interealty



Hi David,



In our client we always use a user-agent and version and it seems like most
of the RETS servers do not care what we used.



However we have a few accounts that do require a user-agent in the form of
name/version.



All our Interealty accounts require both a user-agent and user-agent
password.



I'm unf amiliar with the vieleRETS configuration as we only use the vieleRETS
rets-lite classes.



The user agent is usually expressed as Application/Version (for example
VieleRETS/1.1.6)



Having said that, I believe in the vieleRETS config you would have something
like:



Application - user-agent name (without the version) can be assigned by the
association.

Version - user-agent version can be assigned by the association and
typically something like 1.0 or 1.5 or 1.5.1 or something formatted like
that.

Client Password - password typically always assigned by the association

Tony









-----Original Message-----
From: viele-de...@crt.realtors.org
[mailto:viele-de...@crt.realtors.org] On Behalf Of David Baldwin
Sent: Saturday, February 16, 2008 1:28 AM
To: viel...@crt.realtors.org
Subject: [viele-dev] Problem connectin g to Interealty

and/or password.

Error message 401.1: Logon credentials were not recognized. Make sure you
are providing the correct user name and password. Otherwise, contact the Web

server's administrator for help.

SENDING ... POST /Login.asmx/Login HTTP/1.1 POST /Login.asmx/Login HTTP/1.1
SERVER requires second authorization PAYLOAD ... Unauthorized Request. Error
code: -98. Error Message: Unregistered RETSAppID.
Server Error in '/' Application.

Runtime Error

Description : An application error occurred on the server. The current custom
error settings for this application prevent the details of the application
error from being viewed remotely (for security reasons). It could, however,
be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable
on remote machines, please create a tag within a "web.config"
configuration file located in the root directory of the current web
application. This tag should then have its "mode" attribute
set to "Off".









Notes: The current error page you are seeing can be replaced by a custom
error page by modifying the "defaultRedirect" attribute of the application's

configuration t ag to point to a custom error page URL.






defaultRedirect="mycustompage.htm"/>

SENDING ... POST /Login.asmx/Login HTTP/1.1 POST /Login.asmx/Login HTTP/1.1

[Tony Russo]

Hi David,



In our client we always use a user-agent and version and it seems like most
of the RETS servers do not care what we used.



However we have a few accounts that do require a user-agent in the form of
name/version.



All our Interealty accounts require both a user-agent and user-agent
password.

I'm unfamiliar with the vieleRETS configuration as we only use the vieleRETS

rets-lite classes.



The user agent is usually expressed as Application/Version (for example
VieleRETS/1.1.6)



Having said that, I believe in the vieleRETS config you would have something
like:



Application - user-agent name (without the version) can be assigned by the
association.

Version - user-agent version can be assigned by the association and
typically something like 1.0 or 1.5 or 1.5.1 or something formatted like
that.

Client Password - p assword typically always assigned by the association

configuration tag to point to a custom error page URL.

[David Baldwin]

Thanks Brad. I now have both the data and media downloading without errors!
This really is an incredibly useful package. Many thanks to Mark and the
CRT. I still have a ton of questions, but have included my source, target,
extract and batch files below for an Interealty 1.5 server. Perhaps it will
help someone...

INTEREALTY 1.5 SERVER
SOURCE, TARGET, EXTRACT, BATCH

---------------------------------------------
SOURCE - sources/{source_file}
---------------------------------------------

define("APPLICATION","");

//
// Identification Settings
//

define("APPLICATION","RETSConnector");
define("VERSION","1.0");

//
// Connection Settings
//
define("RETS_SERVER_ACCOUNT","username");

define("RETS_SERVER_PASSWORD","password");

define("RETS_SERVER_URL","server");
define("RETS_CLIENT_PASSWORD","");

define("RETS_DEFAULT_PORT","80");

define("KEEP_ALIVE_SERVER",true);
define("ENC ODE_REQUESTS",true);
define("POST_REQUESTS",true);
define("SERVER_TIME_DIFFERENCE","0");

//
// detected settings
//

define("DETECTED_SERVER_NAME","Microsoft-IIS/6.0");

define("DETECTED_DEFAULT_RETS_VERSION","1.5");
define("DETECTED_MAXIMUM_RETS_VERSION","1.5");
define("DETECTED_STANDARD_NAMES",false);
define("PAGINATION",true);

//
// Streaming Settings
//
define("STREAM_PROCESSING",true);
define("SIMULTANEOUS_LOGINS",false);

//
// Display Settings
//
define("DISPLAY_PERFORMANCE",false);
define("DISPLAY_RETS",false);
define("DISPLAY_PROVIDER_NOTICE",false);
define("DISPLAY_ACCOUNT",false);

//
// Text Query Settings
//

define("SELECTION_RESOURCE","Property");

define("SELECTION_CLASS","2");

define("UNIQUE_KEY","sysid");

define("COMPACT_DECODED_FORMAT",true);
define("OWNERSHIP_VARIABLE","AGENTID");
define("DATE_VARIABLE","LD");
define("DETAIL_ITEMS","sysid");
define ("SUMMARY_ITEMS","sysid,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1
9,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44
,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,
70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,9
5,96,97,98,99,100,101,102,103,104,105,106,107,108,109,111,112,113,114,115,11
6,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,13
5,136,137,138,139,141,142,143,144,145,146,147,148,149,150,151,152,153,154,15
5,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,17
4,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,19
3,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,21
2,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,23
1,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,25
0,251,252,253,254,255,256,257,258,2 59,260,261,262,263,264,265,266,267,268,26
9,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,28
8,289,290,291,292,293,294,295,296,297,298,299,301,302,303,304,305,306,307,30
8,309,310,311,312,313,314,315,316,505,506,507,508,509,510,511,512,513,514,51
5,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,741,746,87
1,872,873,874,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,10
21,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,103
6,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051
,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,
1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1
082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,13
02,1307,1308,1309,1310,1313,1314,1315,1320,1325,1330,1331,1332,1333,1334,133
5,1336,1337,1338,1339,1340,1341,1342,1343,1344,1345,1346,1347,13 48,1349,1350
,1353,1354,1357,1358,1361,1363,1364,1370,1375");
define("GALLERY_ITEMS","sysid");
define("QUERY_ITEMS","134");
define("STANDARD_SERVER_RESPONSE",true);
define("RESTRICTED_INDICATOR","");
define("OFFSET_ADJUSTMENT","0");
define("MEDIA_BYPASS",false);

//
// Media Query Settings
//
define("MEDIA_TYPE","Photo");
define("MEDIA_MULTIPART",true);
define("MEDIA_LOCATION",true);
define("MEDIA_LIST_ZERO_START",false);
define("MEDIA_VALIDATE",false);
define("MEDIA_PROXY","./media_proxy.php");
define("NON_STANDARD_MEDIA",false);
define("NON_STANDARD_MEDIA_RESOURCE","");
define("NON_STANDARD_MEDIA_CLASS","");
define("NON_STANDARD_MEDIA_TYPE","");

$ListPrice_FORM=array("Less than $300,0000"=>"300000-","Between $300,000 and
$400,000"=>"300000-400000","Greater than $400,000"=>"400000+");
$x134_FORM=array("Active"=>"|ACT","Expired"=>"|EXP","Leased"=>"|LSE","Pendin
g"=>"|PEND","Released"=>"|RELD","Sol d"=>"|SOLD","Withdrawn"=>"|WITH");



---------------------------------------------
TARGET - targets/{target_file}
---------------------------------------------

//
// Target Settings
//
define("TYPE","RDB");

define("DESCRIPTION","Relational Database");

define("BRAND","mysql");

define("SERVER","localhost");

define("ACCOUNT","user");

define("PASSWORD","password");

define("DATABASE","database");

define("DATA_TABLE","listing_data_table_name");

define("DATA_TABLE_KEY","unique_key_in_listing_data_table");

define("INCLUDE_IMAGES",true);

define("IMAGE_REFERENCE_ONLY","false");

define("IMAGE_TABLE","image_table_name");

define("IMAGE_TABLE_KEY","unique_key_in_image_table");

define("IMAGE_DOWNLOAD_PATH","path_to_download_images");

define("AUTO_CREATE",false);

define("COLUMN_LIST","c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16
,c17,c18,c 19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,c34,c35
,c36,c37,c38,c39,c40,c41,c42,c43,c44,c45,c46,c47,c48,c49,c50,c51,c52,c53,c54
,c55,c56,c57,c58,c59,c60,c61,c62,c63,c64,c65,c66,c67,c68,c69,c70,c71,c72,c73
,c74,c75,c76,c77,c78,c79,c80,c81,c82,c83,c84,c85,c86,c87,c88,c89,c90,c91,c92
,c93,c94,c95,c96,c97,c98,c99,c100,c101,c102,c103,c104,c105,c106,c107,c108,c1
09,c110,c111,c112,c113,c114,c115,c116,c117,c118,c119,c120,c121,c122,c123,c12
4,c125,c126,c127,c128,c129,c130,c131,c132,c133,c134,c135,c136,c137,c138,c139
,c140");

define("IMAGE_COLUMN_LIST","c1,c2,c3,c4,c5,c6");



---------------------------------------------
EXTRACT - extracts/{target_file}
---------------------------------------------

//
// Extract Settings
//
define("SOURCE","IR");

define("TARGET","IR");

define("USER","");

define("REFRESH",true);

define("MLS_ONLY",false);

define("CLASS_NAME_STYLE","");
define("TRACE",false);

define("USE_PROXY",false);

define("BATCH_SIZE",10);

define("MAX_IMAGE_COUNT","10");

define("COLUMN_LIST","");

define("WORKING_FILE_PATH","SPECIFY THIS");

define("CACHE_SIZE",2048);

define("LIMIT","10");

$MAP=array("TARGET"=>
array("0"=>"c1","1"=>"c2","2"=>"c3","3"=>"c4","4"=>"c5","5"=>"c6","6"=>"c7",
"7"=>"c8","8"=>"c9","9"=>"c10","10"=>"c11","11"=>"c12","12"=>"c13","13"=>"c1
4","14"=>"c15","15"=>"c16","16"=>"c17","17"=>"c18","18"=>"c19","19"=>"c20","
20"=>"c21","21"=>"c22","22"=>"c23","23"=>"c24","24"=>"c25","25"=>"c26","26"=
>"c27","27"=>"c28","28"=>"c29","29"=>"c30","30"=>"c31","31"=>"c32","32"=>"c3
3","33"=>"c34","34"=>"c35","35"=>"c36","36"=>"c37","37"=>"c38","38"=>"c39","
39"=>"c40","40"=>"c41","41"=>"c42","42"=>"c43","43"=>"c44","44"=>"c45","45"=
>"c46","46"=>"c47","47"=>"c48","48"=>"c49","49"=>"c50","50"=>"c51","51"=>"c5
2","52"=>"c53","53"=>"c54","54"=>"c55"," 55"=>"c56","56"=>"c57","57"=>"c58","
58"=>"c59","59"=>"c60","60"=>"c61","61"=>"c62","62"=>"c63","63"=>"c64","64"=
>"c65","65"=>"c66","66"=>"c67","67"=>"c68","68"=>"c69","69"=>"c70","70"=>"c7
1","71"=>"c72","72"=>"c73","73"=>"c74","74"=>"c75","75"=>"c76","76"=>"c77","
77"=>"c78","78"=>"c79","79"=>"c80","80"=>"c81","81"=>"c82","82"=>"c83","83"=
>"c84","84"=>"c85","85"=>"c86","86"=>"c87","87"=>"c88","88"=>"c89","89"=>"c9
0","90"=>"c91","91"=>"c92","92"=>"c93","93"=>"c94","94"=>"c95","95"=>"c96","
96"=>"c97","97"=>"c98","98"=>"c99","99"=>"c100","100"=>"c101","101"=>"c102",
"102"=>"c103","103"=>"c104","104"=>"c105","105"=>"c106","106"=>"c107","107"=
>"c108","108"=>"c109","109"=>"c110","110"=>"c111","111"=>"c112","112"=>"c113
","113"=>"c114","114"=>"c115","115"=>"c116","116"=>"c117","117"=>"c118","118
"=>"c119","119"=>"c120","120"=>"c121","121"=>"c122","122"=>"c123","123"=>"c1
24","124"=>"c125","125"=>"c126","126"=>"c127","127"=>"c128","128"=>"c 129","1
29"=>"c130","130"=>"c131","131"=>"c132","132"=>"c133","133"=>"c134","134"=>"
c135","135"=>"c136","136"=>"c137","137"=>"c138","138"=>"c139","139"=>"c140")
,"SOURCE"=>
array("0"=>"sysid","1"=>"1","2"=>"6","3"=>"--NOT_USED--","4"=>"--NOT_USED--"
,"5"=>"--NOT_USED--","6"=>"--NOT_USED--","7"=>"--NOT_USED--","8"=>"--NOT_USE
D--","9"=>"--NOT_USED--","10"=>"--NOT_USED--","11"=>"--NOT_USED--","12"=>"--
NOT_USED--","13"=>"--NOT_USED--","14"=>"--NOT_USED--","15"=>"--NOT_USED--","
16"=>"--NOT_USED--","17"=>"--NOT_USED--","18"=>"--NOT_USED--","19"=>"--NOT_U
SED--","20"=>"--NOT_USED--","21"=>"--NOT_USED--","22"=>"--NOT_USED--","23"=>
"--NOT_USED--","24"=>"--NOT_USED--","25"=>"--NOT_USED--","26"=>"--NOT_USED--
","27"=>"--NOT_USED--","28"=>"--NOT_USED--","29"=>"--NOT_USED--","30"=>"--NO
T_USED--","31"=>"--NOT_USED--","32"=>"--NOT_USED--","33"=>"--NOT_USED--","34
"=>"--NOT_USED--","35"=>"--NOT_USED--","36"=>"--NOT_USED--","37"=>"--NOT_USE
D- -","38"=>"--NOT_USED--","39"=>"--NOT_USED--","40"=>"--NOT_USED--","41"=>"-
-NOT_USED--","42"=>"--NOT_USED--","43"=>"--NOT_USED--","44"=>"--NOT_USED--",
"45"=>"--NOT_USED--","46"=>"--NOT_USED--","47"=>"--NOT_USED--","48"=>"--NOT_
USED--","49"=>"--NOT_USED--","50"=>"--NOT_USED--","51"=>"--NOT_USED--","52"=
>"--NOT_USED--","53"=>"--NOT_USED--","54"=>"--NOT_USED--","55"=>"--NOT_USED-
-","56"=>"--NOT_USED--","57"=>"--NOT_USED--","58"=>"--NOT_USED--","59"=>"--N
OT_USED--","60"=>"--NOT_USED--","61"=>"--NOT_USED--","62"=>"--NOT_USED--","6
3"=>"--NOT_USED--","64"=>"--NOT_USED--","65"=>"--NOT_USED--","66"=>"--NOT_US
ED--","67"=>"--NOT_USED--","68"=>"--NOT_USED--","69"=>"--NOT_USED--","70"=>"
--NOT_USED--","71"=>"--NOT_USED--","72"=>"--NOT_USED--","73"=>"--NOT_USED--"
,"74"=>"--NOT_USED--","75"=>"--NOT_USED--","76"=>"--NOT_USED--","77"=>"--NOT
_USED--","78"=>"--NOT_USED--","79"=>"--NOT_USED--","80"=>"--NOT_USED--","81"
=>"--NOT_USED--","82"=>"--NOT_U SED--","83"=>"--NOT_USED--","84"=>"--NOT_USED
--","85"=>"--NOT_USED--","86"=>"--NOT_USED--","87"=>"--NOT_USED--","88"=>"--
NOT_USED--","89"=>"--NOT_USED--","90"=>"--NOT_USED--","91"=>"--NOT_USED--","
92"=>"--NOT_USED--","93"=>"--NOT_USED--","94"=>"--NOT_USED--","95"=>"--NOT_U
SED--","96"=>"--NOT_USED--","97"=>"--NOT_USED--","98"=>"--NOT_USED--","99"=>
"--NOT_USED--","100"=>"--NOT_USED--","101"=>"--NOT_USED--","102"=>"--NOT_USE
D--","103"=>"--NOT_USED--","104"=>"--NOT_USED--","105"=>"--NOT_USED--","106"
=>"--NOT_USED--","107"=>"--NOT_USED--","108"=>"--NOT_USED--","109"=>"--NOT_U
SED--","110"=>"--NOT_USED--","111"=>"--NOT_USED--","112"=>"--NOT_USED--","11
3"=>"--NOT_USED--","114"=>"--NOT_USED--","115"=>"--NOT_USED--","116"=>"--NOT
_USED--","117"=>"--NOT_USED--","118"=>"--NOT_USED--","119"=>"--NOT_USED--","
120"=>"--NOT_USED--","121"=>"--NOT_USED--","122"=>"--NOT_USED--","123"=>"--N
OT_USED--","124"=>"--NOT_USED--","125"=>"--NOT_USED--","126" =>"--NOT_USED--"
,"127"=>"--NOT_USED--","128"=>"--NOT_USED--","129"=>"--NOT_USED--","130"=>"-
-NOT_USED--","131"=>"--NOT_USED--","132"=>"--NOT_USED--","133"=>"--NOT_USED-
-","134"=>"--NOT_USED--","135"=>"--NOT_USED--","136"=>"--NOT_USED--","137"=>
"--NOT_USED--","138"=>"--NOT_USED--","139"=>"--NOT_USED--"));

$IMAGE_MAP=array("TARGET"=>
array("0"=>"c1","1"=>"c2","2"=>"c3","3"=>"c4","4"=>"c5","5"=>"c6"),"SOURCE"=
>
array("0"=>"ID","1"=>"INDEX","2"=>"URL","3"=>"PATH","4"=>"--NOT_USED--","5"=
>"--NOT_USED--"));



---------------------------------------------
BATCH - batch_control_files/{target_file}
---------------------------------------------



IR





2


|ACT


2008-02-18T22:43:06




David Baldwin

[David Baldwin]

Dave:
I was able to leave the client password as null, but others have suggested that some Interealty servers will require a specific client password and/or application/version. You may try asking your MLS to see if they require this.

Best Regards,
David Baldwin

[David Baldwin]

I�m still a little confused by the User-Agent. Is the User-Agent different
than the �Application/Version�? If I do get a User-Agent username and
password from my MLS where do they go? Is User-agent password
�RETS_CLIENT_PASSWORD� and username �APPLICATION/VERSION�?

-------------------------

Below are my connection settings and all of the options I have tried in
each.

RETS_SERVER_ACCOUNT - username from MLS
RETS_SERVER_PASSWORD - password from MLS
RETS_SERVER_URL - http://inr.rets.interealty.com/Login.asmx/Login
RETS_CLIENT_PASSWORD - blank, password from MLS
RETS_DEFAULT_PORT - 80, 6103
APPLICATION - VieleRETS, VieleRETS/1.1.6, blank
VERSION - 1.1.6, blank
KEEP_ALIVE_SERVER - checked, unchecked
ENCODE_REQUESTS - checked, unchecked
POST_REQUESTS - checked, unchecked
STANDARD_SERVER_RESPONSE - checked, unchecked
SERVER_TIME_DIFFERENCE - 0

----------------------

Here is an err or I get the screen after the "mismatched username/password'

configuration tag to point to a custom error page URL.< br>

[David Baldwin]

Thanks for the replies. I was able to connect with the 1.1.6 beta by using
�RETSConnector/1.0� as the user-agent. I left the Client Password as NULL.
I also changed a number of the override settings but am still running into
problems when running the batch. Below is my Source setup and Batch file
process. As you can see, it returns no records. Anything stick out that
looks problematic, especially as it relates to the sysid key?


SOURCE SETUP

---------------------------------------------

define("APPLICATION","");

//
// Identification Settings
//
define("APPLICATION","RETSConnector");
define("VERSION","1.0");

//
// Connection Settings
//
define("RETS_SERVER_ACCOUNT","username");
define("RETS_SERVER_PASSWORD","password");

define("RETS_SERVER_URL","http://inr.rets.interealty.com/Login.asmx/Login");

define("RETS_CLIENT_PASSWORD","");
define("RETS_DEFAULT_PORT","80");

defi ne("KEEP_ALIVE_SERVER",true);
define("ENCODE_REQUESTS",false);
define("POST_REQUESTS",false);

define("SERVER_TIME_DIFFERENCE","0");

//
// detected settings
//
define("DETECTED_SERVER_NAME","Microsoft-IIS/6.0");
define("DETECTED_DEFAULT_RETS_VERSION","1.5");
define("DETECTED_MAXIMUM_RETS_VERSION","1.5");
define("DETECTED_STANDARD_NAMES",false);

define("PAGINATION",false);

//
// Streaming Settings
//
define("STREAM_PROCESSING",true);

define("SIMULTANEOUS_LOGINS","");

//
// Display Settings
//
define("DISPLAY_PERFORMANCE",false);
define("DISPLAY_RETS",false);
define("DISPLAY_PROVIDER_NOTICE",false);
define("DISPLAY_ACCOUNT",false);

//
// Text Query Settings
//
define("SELECTION_RESOURCE","Property");

define("SELECTION_CLASS","1");

define("UNIQUE_KEY","sysid");
define("COMPACT_DECODED_FORMAT",true);

define("OWNERSHIP_VARIABLE","sysid");
define("DATE_VARIABLE","14,20,53 ,91,96,123,124,151,159,162,164,179,307,482,4
87,1010,1024,1031,1034,1055,1066,1068");
define("DETAIL_ITEMS","Garage,County,StreetNumber,ListingID,CloseDate,City,A
gentID,Beds,TotalRooms,LivingArea,YearBuilt,ListingStatus,ListDate,PostalCod
e,ContractDate,ClosePrice,UnitNumber,StreetName,OfficeID,StateOrProvince,Boa
rd,Baths,ListPrice,ModificationTimestamp,StreetDirPrefix,Type");
define("SUMMARY_ITEMS","sysid,1,2,3,4,6,7,9,10,11,12,14,15,18,20,21,22,23,24
,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,48,49,51,53,54,55,
62,63,64,65,66,67,68,71,72,73,74,75,76,77,81,91,92,93,94,99,100,104,106,107,
120,122,123,124,125,131,132,133,134,135,136,137,141,142,143,145,146,147,148,
149,150,151,152,154,155,157,158,162,163,164,165,167,168,169,174,175,176,177,
179,180,181,184,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,
204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,
223,224,225,226,227,228,229,2 30,231,232,233,234,235,236,240,241,242,243,244,
246,250,254,255,256,263,264,269,270,272,273,274,276,278,279,281,289,290,295,
301,302,305,306,307,308,310,312,315,316,470,472,474,475,476,477,478,479,480,
481,482,483,484,485,487,488,489,490,491,492,493,494,495,496,498,500,502,503,
504,871,872,873,874,1012,1019,1027,1046,1055,1062,1064,1065,1066,1067,1068,1
070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,10
85,1086,1087,1088,1089,1090,1091,1092,1302,1309,1313,1314,1315,1320,1330,133
1,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1342,1343,1344,1345,1346
,1347,1348,1349,1350,1353,1354,1357,1361,1363,1364,1365,1375");
define("GALLERY_ITEMS","Garage,County,StreetNumber,ListingID,CloseDate,City,
AgentID,Beds,TotalRooms,LivingArea,YearBuilt,ListingStatus,ListDate,PostalCo
de,ContractDate,ClosePrice,UnitNumber,StreetName,OfficeID,StateOrProvince,Bo
ard,Baths,ListPrice,ModificationTimestamp,StreetDirPrefix,Type");
de fine("QUERY_ITEMS","sysid,1,2,3,23");

define("STANDARD_SERVER_RESPONSE",true);
define("RESTRICTED_INDICATOR","");
define("OFFSET_ADJUSTMENT","0");
define("MEDIA_BYPASS",false);

//
// Media Query Settings
//
define("MEDIA_TYPE","Photo");
define("MEDIA_MULTIPART",true);

define("MEDIA_LOCATION",false);

define("MEDIA_LIST_ZERO_START",false);
define("MEDIA_VALIDATE",false);
define("MEDIA_PROXY","./media_proxy.php");
define("NON_STANDARD_MEDIA",false);
define("NON_STANDARD_MEDIA_RESOURCE","");
define("NON_STANDARD_MEDIA_CLASS","");
define("NON_STANDARD_MEDIA_TYPE","");

$ListPrice_FORM=array("Less than $300,0000"=>"300000-","Between $300,000 and
$400,000"=>"300000-400000","Greater than $400,000"=>"400000+");

$x1_FORM=array("Commercial Land"=>"|CLN","Commercial
Multi-Family"=>"|CMF","Commercial Office"=>"|COF","Commercial
Retail"=>"|CRE","Commercial/Industrial"=>"|CIN","Farms & Agricultural
Land"=>"|FRM","M ulti-Family"=>"|MUL","Residential
Lease"=>"|LSE","Residential/Condo"=>"|RES","Vacant Lots/Land"=>"|VAC");
$x3_FORM=array("<1/2 Acre"=>"|LES12","<1/4 Acre"=>"|LES14",">20
Acres"=>"|MOR20",">50 Acres"=>"|50MOR","1-2 Acres"=>"|1-2AC","1-3
Acres"=>"|1-3AC","1/2-1 Acre"=>"|1/2-1","1/2-3/4 Acre"=>"|1/2-3/4","1/4-1/2
Acre"=>"|1/4-1/2","10-14 Acres"=>"|10-14","10-20 Acres"=>"|10-20","15-19
Acres"=>"|15-19","2-3 Acres"=>"|2-3AC","20-29 Acres"=>"|20-29","3-4
Acres"=>"|3-4AC","3-5 Acres"=>"|3-5AC","3/4-1 Acre"=>"|3/4-1","30-39
Acres"=>"|30-39","4-5 Acres"=>"|4-5AC","40-49 Acres"=>"|40-49","5-10
Acres"=>"|5-10A","5-9
Acres"=>"|5-9AC","CndHPRCoop"=>"|HPRCP","Other"=>"|OTHER","See
Remarks"=>"|RMRKS");
?>



RUN BATCH PROCESS
------------------------------------------
$ php -f ./run_interactive_job.php batch_control_files/IR
--------------------------------------------------
VieleRETS 1.1.6
Copyright(C) 2005-2007 National Assoc iation of REALTORS(R)
--------------------------------------------------

Reading arguments from Batch Control file [batch_control_files/IR].

-----------------------
EXTRACT IR
-----------------------
------------
QUERY
No QUERY Values being used
------------

Capture debug information (y)?>y
Debug capture device (./logs/batch.log)>y

Starting Download with [IR] at February 16, 2008 4:45:11 PM

MLS data only, User supplied information will be overwritten
All MLS listings will be fetched
Selection Fields: 150,1,6,11,51,4,154
DMQL Query: (sysid=0+)
New MLS listings will be added and any existing listings will be refreshed
No data map for UNIQUE_KEY EXTRACT check configuration
- Listing replacement disabled
Limit Govenor set by EXTRACT to 10 listings
Only 10 listings will be processed
Pagination not supported by the server
Using in-memory workaround

Warning: Divisi on by zero in /Users/david/Sites/viele/common/download.php on
line 1276
Items to be processed: 0
Batchs to be processed: 0
Batch size: 0


Download with [IR] Completed at February 16, 2008 4:45:17 PM

Listings Processed: 0
Additions: 0
Duplicates found: 0
Refreshed: 0
Skipped: 0

Images Processed: 0
Full: 0
Thumbnails: 0
Missing or Corrupt: 0

Performance Total Elapsed Seconds: 6
MLS Server: 1
VieleRETS: 1
Items per Second: 0.0000
Seconds per Item: 0.0000
No Listings were Found



Best Regards,

David Baldwin

[Alan Pinstein]

> From the setup menu, you can set the RETS version of the server from
> the "Override Auto-Detection" screen.

Ah ok good to know. I'll update to the latest beta and try again next
week. I'll let you know.

[David Baldwin]

Hello Dave:
I am on a Mac for development and LAMP for production and both seem to work. I kept all defaults on the connection screen. The one change that got me connected was to set the application to "RETSConnector" and version to "1.0". Have you tried that?

Best Regards,
David Baldwin

[Brad Ediger]

David Baldwin wrote:
> Thanks Brad. Just in the past few minutes I got a few listings to
> download with an RDB target. Hooray! However, no images. I�ll keep
> trying as it seems I am inching closer.

Congratulations! The media settings can be tricky, too.

> By RETS administrator, do you mean my MLS tech contact or someone from
> Interealty? I have spoken to my MLS tech person. He hadn�t heard of
> Viele. I told him that it seemed as though Interealty was causing a
> lot of problems for people. He responded with �Welcome to my world.�
> Not very comforting. Ha.

Yes, I meant the MLS tech contact. We usually have to go through the MLS
tech people to get to Interealty anyway, but that can depend on MLS
board structure.

Yes, they seem to be causing pain for many others. In one region, they
implement the RETS 1.5 standard, but require some 1.7 extensions such as
User-Agent authentication (while still "speaking" the 1.5 standard). We
all have Mark Lesswing and Keith Garner from the CRT to thank for
supporting some of their nonstandard weirdness in libRETS (and, by
extension, VieleRETS).

Regards,
Brad