My RETS Provider is switching to a new system that has SubTables as a Resource of information that relates to the main listing. Thus, I have a dRealty Connection that has the main listing information and a second connection to the SubTable that has related information to the main listing (See Below).

How do I set this up to work in dRealty? I have Query Paramaters in the Main Connection that limit the number of listings I return. How do I get the data from the subtable that relates only to the listings I have in my stream. How do I handle multiple values from the subtable for each of the fields? Right now if I set up a field for say Room Type and then another for say Room Level, displaying them looks terrible because its not under 1 room category, each multiple value for the field shows and then the multiple values for the next field.

Subtable Values:
Listing_MUI Searchable Field Listing MUI Long 19
matrix_unique_id Searchable Field Key Field Matrix Unique Id Long 19
MatrixModifiedDT Searchable Field Matrix Modified DT DateTime 23
RoomDescription Searchable Field Room Description Character 255
RoomDimensions Searchable Field Room Dimensions Character 25
RoomFeatures Searchable Field Room Features Character 1000 Values
RoomLength Searchable Field Room Length Character 25
RoomLevel Searchable Field Room Level Character 75 Values
RoomType Searchable Field Room Type Character 75 Values
RoomWidth Searchable Field Room Width Character 25

Any Help would be great.

Cheers

Comments

izaiah’s picture

My provider is also doing this. Have you found a solution?

DrupalRanger’s picture

I do not yet have a solution on this item. I am sure someone would have to write a sub module to link the subtable id to the listing ID so that you can create a connection that only downloads subtable items related to the specific listings you are downloading in your stream. I guess subtable items would be created as separate entities and then somehow linked so that you could populate fields in the Property Type with those values.

shauntyndall’s picture

Status: Active » Closed (cannot reproduce)

@drupalranger were you able ever formulate a dRealty solution for this?