Media and RETS 

RETS accesses the media servers on the NTREIS MLS System.  Media added to the MLS system is immediately available to RETS users. 

You can download media from the media servers using “GetObject” and the MLS Number or you can link to the media on the NTREIS MLS media servers.  Currently, the media is 200GB in size.  By linking to the media as opposed to downloading the actual files, you will minimize the amount of space you need for storage and not have to manage the media files.  Linking to the media also decreases the amount of bandwidth needed, allowing for better performance by all.  Linking to the media on the NTREIS Media Servers may be the optimal way to access the media.

NTREIS previously used a separate NTREIS Media Server where the Media Table contained fields with the URL’s for the low resolution and high resolution media.  Although the Media Class on the NTREIS RETS Server does not contain the URL’s, you can generate your own URL by using the TABLEUID and MEDIASOURCE from the Media class.  You would then use this URL as a link that will access the images on the media server. 

As an example, these are the URL’s for the low and high resolution images for MLS Number 10442368:

http://ntreispictures.marketlinx.com/MediaDisplay/37/HR2019637-1.jpg

http://ntreispictures.marketlinx.com/MediaDisplay/37/LR2019637-1.jpg

Pasting these into your browser will display the images for this property.  The URL consists of:

1)  “http://ntreispictures.marketlinx.com/MediaDisplay/”

2)  the last two digits of the TableUID,

3)  “/HR/” for high resolution media or “/LR/” for low resolution media; and

4)  the MEDIASOURCE

Below is first few lines of the SQL Script that NTREIS uses to generate the media URL’s.  You would modify this as necessary to insert the URL into your media table. 

select

'http://ntreispictures.marketlinx.com/MediaDisplay/' + RIGHT(TableUID, 2)

+ '/HR' + MEDIASOURCE,

'http://ntreispictures.marketlinx.com/MediaDisplay/' + RIGHT(TableUID, 2)

+ '/LR' + MEDIASOURCE

For reference, a similar script was run on the MLS Data that returned the MLSNUM, TableUID, MEDIASOURCE, and the generated High Res URL.  The results are below:

Deleting Media Files

The MarketLinx Tempo MLS System does not have an intrinsic method to identify media that has been deleted from the MLS System.  When a user deletes an image or other media from MLS, the corresponding file is removed form the Media Table with no indication to RETS users that the image is no longer in MLS.  This requires users to download 2.8 million rows in the media table to keep the user’s Media Table current.

NTREIS recognized that RETS users needed a simpler method to keep their Media Table current, especially as users request frequent updates on the listings and media.  NTREIS created a process that identifies which UID’s in the Media Table have been deleted and outputs these UID’s to DeleteMedia.txt file.  User’s can download this file from http://www.ntreis.net/resources/DeleteMedia.txt. DeleteMedia.txt includes the date the media was deleted. 

An updated DeleteMedia.txt will be available at half past each hour and will contain the last 30 days of day. 

NTREIS recognizes you may have media information that has been out of date for some time.  There is a much larger file that can be downloaded from http://www.ntreis.net/resources/MASTERDeleteMedia.txt  which is a list of UID’s from the past few years that have been removed from MLS.  You may want to use this MASTERDeleteMedia.txt file once initially and the DeleteMedia.txt file on a regular basis.

If your media table becomes out of synch with the MLS Media Table, you can download the full MLS Media Table via RETS and then apply the current DeleteMedia.txt to remove the most recently deleted UID’s. 

Media Types

There are three MEDIATYPES in the Media Class:

Updated: 2/19/2008