Exporting Your Historical Sold Listings From MLS Paragon (Edmonton)
In Alberta, real estate website developers are specifically not given access to sold listing data which means that we cannot automatically import your sold listings. By following the guide below, we are able to import all of your historical sold listings in one go. This is the best possible solution at this time, without access to the raw data.
Please follow each step carefully, as a small mistake can result in unusable files.
Here are the steps required to export your sold listings from the Edmonton MLS Paragon System and then get them on your website:
Step 1: Login to http://idp.alberta.safemls.net/idp/Authn/UserPassword
Step 2: Click Search > Inventory
Step 3: Click the magnifying glass icon to the right of the "Status" field. A lightbox will pop up. In that lightbox, ONLY select option 2, which will then select both SOLD and INFORMATIONAL beneath it. When your lightbox looks like my example below, click "Save" in the top right corner.
Step 4: The fifth customizable option from the top is "Selling / Listing", and there is a drop-down menu next to it. By default the drop-down option should say "Listed", but we want to change that. Change the option to "Listed or Sold".
Step 5: Click "Search" at the top right corner of the page, next to the updated listing count!
Step 6: Once it's done loading your search, you should be looking at a list of all your sold listings. Before we can export this list, we need to add a few additional fields to the search criteria. In order to get this process started, click the COG or Gear Icon then click "Fields".
Step 7: A new lightbox is going to pop open after you click "Fields", which shows you all of the available fields that you can add to your search (on the left) and all of the fields that are currently being reflected in your search (on the right). Before you do anything else, click the "Revert to Default" button underneath the box on the right. You will be asked if you're sure you want to continue, say OK. When you click OK, the lightbox will close and you will be taken back to your sold listings. Not to worry! Simply repeat Step 6 by clicking the COG icon then clicking Fields again to re-open the lightbox.
Step 8: Between the right and left boxes, you have 6 options: Add, Remove, Remove All, Move Up, Move Down, and Sort. We're going to be using the "Add" function only.
Scroll through the list on the left, find all the fields I've listed below, and make sure they are added to the list on the right. You do this by clicking the checkbox next to a field, then clicking "Add" in between the right and left boxes. This will add that field to your criteria. You can select multiple fields at once before adding them, you don't have to do this one by one. Inversely, you can also remove extra fields from the right side by checking them, and clicking "Remove" between the two boxes.
Make sure only the following 22 fields are showing in the "Selected" box on the right of the lightbox:
[-_-]~~ Ninja Tip: Type any of the following fields into the Search Bar at the top left of the lightbox to quickly find all of these fields and check their boxes off. Beats scrolling through the entire list.
- Listing ID #
- Property Class
- Area/City
- Community
- Address
- List Price
- List Date
- Sold Price
- Sold Date
- Listing Agent 1 - Agent Name
- Listing Firm 1 - Office Name
- Postal Code
- Price
- Public Remarks
- Province
- Style
- Total Baths
- Total Bedrooms
- Total Flr Area (SF)
- URL-Virtual Tour
- Year Built
- Building Type
Once you have added all of these to the box on the right, NAME your criteria something like "Historical Solds" or leave it titled "Firm Inventory" if you prefer (so long as you know what it's called). click Save at the top right of the pop up window.
Step 9: Now your data is ready to be exported. From the top of the search results, click the icon that looks like a green arrow pointing down into a box. That's the "Export" icon, and it's directly to the left of the COG icon you clicked in Step 6. After you click the Export icon, from the resulting drop-down menu click "Export to CSV".
Step 9: A small lightbox prompt will pop-up after you click "Export to CSV". Leave everything as it is in the lightbox, only make sure you've selected the 'Spreadsheet' that you just created in step 7 - Mine was called "Historical Solds" so I'll click the dropdown and select that - yours may still be called Firm Inventory, in which case you should pick that (see screenshot below).
The correct Spreadsheet should be selected by default anyways. Once you're ready, click "Export" at the top right.
Step 10: The file you just exported will be titled "Firm_Inventory.csv" unless you re-named your Spreadsheet. It should be saved directly to your Downloads Folder, unless you specified a different folder on your computer. E-mail the .CSV file you just downloaded to support@realtyninja.com and we will add them to your website.
Pretty simple, right? [-_-]~~
**NOTE** If the files you have downloaded are more than 10MB in size, please use this free service to send us large files: http://realtyninja.wetransfer.com
Also please note that it can take up to 5 business days for us to import your sold listing data once we have been provided with the files in the correct format.
Please feel free to contact us if you have any questions on how to use this guide.