Re: [variman-discuss] Metadata file is created successfully, the mapped fields are not visible to the Client (Rets Connector 1.0 MarketLinx).

[Keith Garner]

A few things come to mind...

1) Did you restart the RETS server after the changes? (Mark is this required still? I forget. In the old days it was.)

2) Have you tried another client (like the awesome and free ezRETS[1]) to verify the findings?

3) Are all the metadata items like default set with sane values? (i.e. A client will never show you something with -1 in default.)

Keith

[1] I'm the main author of ezRETS, I get to do hyperbole

On Jul 5, 2011, at 7:20 AM, Orville wrote:

> When we make any changes to the mappings between our database and RETS
> through the RETS server (Variman Admin 3.2.3) and save it, although
> the metadata file is created successfully, the mapped fields are not
> visible to the Client (Rets Connector 1.0 MarketLinx). We are able to
> make a successful connection to the RETS Server so it does not seem to
> be a connection issue.
>
> Any clues would be appreciated

--
Keith T. Garner - kga...@realtors.org - 312-329-3294 - http://realtor.org/
National Association of REALTORS® - VP - Information Technology Services

[Orville]

[Mark Klein]

On Jul 5, 2011, at 7:49 AM, Keith Garner wrote:

> A few things come to mind...
>
> 1) Did you restart the RETS server after the changes? (Mark is this
> required still? I forget. In the old days it was.)

By default, it is, though there is a way to enable update notification
through Spring.

> [1] I'm the main author of ezRETS, I get to do hyperbole

Nothing wrong with pride in authorship!

> On Jul 5, 2011, at 7:20 AM, Orville wrote:
>
>> When we make any changes to the mappings between our database and
>> RETS
>> through the RETS server (Variman Admin 3.2.3) and save it, although
>> the metadata file is created successfully, the mapped fields are not
>> visible to the Client (Rets Connector 1.0 MarketLinx). We are able to
>> make a successful connection to the RETS Server so it does not seem
>> to
>> be a connection issue.
>>
>> Any clues would be appreciated

And, check the logs. Turn logging up to DEBUG, restart your server and
see if it reports that it is seeing the tables for your resources/
classes. You'll see a series of messages like:

-> Found metadata.xml at: /Users/admin/Documents/NAR/variman/
demo_metadata/metadata.xml
05 Jul 2011 18:12:41,945 DEBUG [ ]
org.realtors.rets.server.metadata.XmlMetadataDao
-> Merging metadata into a single XML document.
05 Jul 2011 18:12:42,545 DEBUG [ ] org.realtors.rets.server.RetsServer
-> Initializing group filter
05 Jul 2011 18:12:42,549 DEBUG [ ] org.realtors.rets.server.RetsServer
-> Setting tables for Property:COM

[sagar shitole]

Fisrt I mapped four database fields to RETS and saved.They are now
available to RETS connector 1.0 client.

After this, I map New field(town) to RETS and save the metadata.After
this I restarted the RETS server.

I tried it on RETS connector 1.0 as well as ezRETS Client.But both
are not displaying the newly added field

Below is the sample Metadata file table entries.

- <METADATA-TABLE Version="1.01.00001" Date="2011-06-28T18:30:00Z"
Resource="Property" Class="Property Class">
<COLUMNS>Alignment DataType DBName Default EditMaskID ForeignField
ForeignKeyName Index InKeyIndex Interpretation KeyQuery KeySelect
LongName LookupName Maximum MaximumLength MaxSelect MetadataEntryID
Minimum ModTimeStamp Precision Required Searchable SearchHelpID
ShortName StandardName SystemName Unique Units UseSeparator</COLUMNS>
<DATA>Left Int ListingID 0 1 0 1 1 ListingID 999999999 9 0 1 0 1 0 0
1 ListingID ListingID ListingID 1 0</DATA>
<DATA>Left Character headline 0 1 0 1 1 headline 0 1000 0 2 0 1 0 0
1 headline headline 0 0</DATA>
<DATA>Left Int AgencyID 0 1 0 1 1 AgencyID 999999999 9 0 3 0 1 0 0 1
AgencyID AgencyID 0 0</DATA>
<DATA>Left Decimal Price 0 0 0 1 1 Price 999999999 11 0 4 0 1 2 0 1
Price Price 0 0</DATA>
<DATA>5 town City town town town 1000 Character 0 1 Left 0 0 1 0 0 0
0 0 1 1 1 0</DATA>
</METADATA-TABLE>

I observed that the way RETS saved the first four table
entries(ListingID,headline,AgencyID,Price ) and newly added 5th table
entry (town) are the different.

That might be the the reason of this issue of newly added field is not
available to client.

If this is the case , let us know if we had missed some RETS setttings
that should fix the problem.

[Mark Klein]

On Jul 6, 2011, at 4:37 AM, sagar shitole wrote:

> I observed that the way RETS saved the first four table
> entries(ListingID,headline,AgencyID,Price ) and newly added 5th table
> entry (town) are the different.
>
> That might be the the reason of this issue of newly added field is not
> available to client.
>
> If this is the case , let us know if we had missed some RETS setttings
> that should fix the problem.
>

Did you play with the metadata model or the strict flags at all? That
last row is in a different order than the column map shows it should
be. You can try deleting it using the GUI, but if all else fails, open
the file in your favorite editor and delete the row. Then try adding
it again.

[sagar shitole]

Thanks !for your reply.

The steps I followed :

1.Installed the variman RETS server.
2.Added the database properties and test the connection.
3.Added the user and user groups.
4.Enter the fields in "System" node in the Metadata tab.
5.Try add the "Resource" but unable to add the the resource. It was
giving the vaildation error "ClassCount: A positive whole number."
as strict flag is enabled by default.
6. I then disabled the strict flag and then added resource , class &
tables field success fully.

At this stage ,
I observed that the table entries in the metadata field are saved
starting from "MetadataEntryID" field.This fields are visible to
Client (RETS connector 1.0) also.

7. When I add new table fields and save the metadata, the order of
saving the previous metadata fields starts from "Alignment" and for
the new field it starts from "MetadataEntryID".

At this stage,
the Previous fields are visible to client but newly added fields are
invisible to client.

I did try to add the new fields but the order of saving of the old and
new fileds are always different.

Please let us know if we missed somethig.
If the "strict" flag triggers the issue , let us know how to add the
resource in the metadata, because if "strict" flag is enabled , it
gives validation error as explained above.

[Mark Klein]

On Jul 6, 2011, at 11:27 PM, sagar shitole wrote:

>
> Thanks !for your reply.
>
> The steps I followed :
>
> 1.Installed the variman RETS server.
> 2.Added the database properties and test the connection.
> 3.Added the user and user groups.
> 4.Enter the fields in "System" node in the Metadata tab.
> 5.Try add the "Resource" but unable to add the the resource. It was
> giving the vaildation error "ClassCount: A positive whole number."
> as strict flag is enabled by default.
> 6. I then disabled the strict flag and then added resource , class &
> tables field success fully.

Yeah, I duplicated it. Looks like there is an issue when you add your
very first class to a resource. Note that when in strict mode, the
field values are validated against what the RETS spec says they should
be ... and if you want to pass compliance, you need to be in strict
mode. But, in strict mode, the # of classes is defined as a positive
(non-zero) number. So it fails checking. You will have to turn off
strict just to get the very first class in.

It also appears that the column order is affected when in strict mode
and when not in strict mode. If you change the strict flag, you need
to select "reload metadata" to make sure things get shuffled around
properly. If you just toggle strict without that, the column ordering
appears to get messed up.

The safest way to do this is probably to turn off strict before adding
that very first class to a resource. Next, save the data. Then turn
strict back on and exit the GUI. Re-enter the GUI and then you can
continue editing.

[sagar shitole]

Thanks ! for your help.The soloution works for me.

Now the metadata column ordering is proper and also client can get the
changed metadata fields.

[sagar shitole]

Hi Mark,

We are using the RETS connector 1.0(v 1.1.1.6238) as Client and
Variman Admin Server(v.3.2.3).Both are on the same machine.
The RETS connector 1.0 does behave erratically sometimes that it does
not connect to the RETS server on the first few tries but connects
after multiple tries. When it failed we are getting the below message.

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


-- REQUEST: --
http://localhost:6103/rets/logout

RETS-Request-ID: 9aedbe00-59bf-458c-ab27-fbb95019a72d
RETS-Version: RETS/1.7.2
Accept: */*
User-Agent: RETSConnector/1.0
RETS-UA-Authorization: Digest 66d731c75fe67c937cb4af895ebb64ff
Authorization: Digest username="test",realm="RETS
Server",nonce="de866a54ee666f7774c059ebf010702f",uri="/rets/
logout",cnonce="ed6fd65784e2a7052c004c85a93bb5b7",nc=00000001,qop="auth",response="f17bacd28dc48dc381b8ba1dae08839b",opaque="4fa59be56780904573b3d0c8ea1f120a"
Host: localhost:6103
Cookie: JSESSIONID=A2148B92B92FE0955BAB71341FB5D0B6


-- RESPONSE: --
200 OK

Content-Length: 53
Content-Type: text/xml
Date: Thu, 14 Jul 2011 05:38:42 GMT
Server: Apache-Coyote/1.1


<RETS ReplyCode="20701" ReplyText="Not logged in"/>
------------------------

Let us know if there are some RETS server setting that should affect
the server connection.

Thanks,

Sagar Shitole

[sagar shitole]

Hi Mark ,

Sub:How to download the Images from RETS connectot 1.0

Our SQL database table contains the ListingID & Image URL.
e.g.ListingID-->4913 &Image URL->http://corcoran.hreo.com/
graphics2/13257.jpg

We have created the Resource->class->table and mapped these two fields
in RETS SERVER & saved the metadata.

When we download these class through the RETS connector 1.0 it
downloads the ListingID & ImageURL in txt/xml format.

But i want to download the image using the ImageURL, So what settings
should we have to do on on RETS server side andalso Client side to get
the image.

Please provide us any link if any , explaining the example for
downloading the image through the RETS connector. That would be the
helpful.



Thanks,

Sagar Shitole.

[Mark Klein]

On Jul 13, 2011, at 10:42 PM, sagar shitole wrote:

> Hi Mark,
>
> We are using the RETS connector 1.0(v 1.1.1.6238) as Client and
> Variman Admin Server(v.3.2.3).Both are on the same machine.
> The RETS connector 1.0 does behave erratically sometimes that it does
> not connect to the RETS server on the first few tries but connects
> after multiple tries. When it failed we are getting the below message.

There are one or two clients out there that mishandle cookies and
associated authentication headers. As a result, they lose track of the
authentication "stuff" and in turn, causes Variman to disassociate the
session ID with the authentication response. The log below seems to
indicate this is one of them. Note in the Authorization header that
the "nc" is 1 ... it should only be 1 at the start of a a session.

Nothing Variman can do about that.

[Mark Klein]

On Jul 14, 2011, at 6:25 AM, sagar shitole wrote:

> Please provide us any link if any , explaining the example for
> downloading the image through the RETS connector. That would be the
> helpful.

You're asking a fundamental RETS question. See the RETS spec in
section 5.4 about the Location parameter. That determines whether or
not (if the sever supports it) you'll get the images or a URI to the
image.

As for how you do that with RetsConnector, I can't help you there. I
suggest you contact the supplier of RetsConnector.

[sagar shitole]

Thanks for your help.

Can you give us the list of those clients which are working perfectly
and doesn't lost server connection erratically ?

It will be more helpful for us.

Thanks,
Sagar Shitole.

> >> continue editing.- Hide quoted text -
>
> - Show quoted text -

[sagar shitole]

Thanks for your help.

sure ,we will contact the RetsConnector for this.

Thanks,
Sagar Shitole.