SalesPartner Real Estate Software
p +6444711849
  • Home
  • Software
    • SalesPartner Cloud
    • Websites
    • Testimonials
  • News
  • Pricing
  • Apps
    • Pocket SalesPartner
    • Open Home Register
  • Learn
  • Video
    • Download Listings
  • Downloads
  • Contact us

REINZ sales import troubleshooting notes

10/12/2019

0 Comments

 
Here are a few notes for importing a sales statistics CSV file from the REINZ website into SalesPartner.
  • From 2019 onward all exported CSV files use the same spreadsheet layout category option: Residential. Even if you only export Rural sales, you should still check Residential in SalesPartner. This legacy option was developed when the statistics export used to have different columns for Rural sales. Now the same consistent layout is produced for all property categories.
Picture
  • Avoid opening exported sales statistics CSV files in Excel prior to importing them into SalesPartner. Viewing the spreadsheet in Excel or Google Sheets may disrupt the format compatibility with SalesPartner and lead to import errors. The CSV file should be saved into Documents or Downloads so you can fetch it from the SalesPartner import wizard.
Picture
  • When you export a sales statistics CSV file from REINZ, check that every column is marked as shown under Table Preferences. This ensures that the column layout is compatible with SalesPartner.
Picture
0 Comments

Bed, Bath, Garaging report icons explained

10/12/2019

0 Comments

 
In many flyer and report templates, icons are shown to represent how many bedrooms, bathrooms, garages, and living areas a property has. This guide looks at the scripting behind these icons which makes them show if the number is greater than zero, and hide if the number is zero or blank.
Picture
In this example template there are three script rules per icon.
  • A rule which forces the numerical character to only show if the number is greater than zero, and not blank.
  • A rule which forces the icon to only show if the number is greater than zero, and not blank.
  • A rule which forces the icon background shadow to only show if the number is greater than zero, and not blank.
Each element is uniquely named - this is how the script rules are linked back to the icons.
In edit mode right click on an icon, shadow, or data field and click Options to view the Name. Here are the image names for the bedroom icon's three related elements:
  • ImageBed = the bedrooms icon
  • BEDSHADOW = the grey background shadow
  • BED = the number
Picture
Now right click on an empty area of the same report band to view Scripts. Note the three lines of arguments which relate back to each of the bedroom elements. These SQL rules state that each item must only show if the number of bedrooms is not zero or blank.
SETBOOLPROP('ImageBed', 'Enabled', Listings.Bedrooms <> 0)
Picture

Tips

If you're swapping in new icons, you will probably need to rename each image with a unique name like 'ImageBed2' and then also copy and paste another matching rule into scripts. Often a name cannot be recycled.
If your rule is <> '' instead of <> 0, this will work if the Listing Entry fields are left blank, but if zeros have been entered (e.g for sections or bare land) then the number zero may appear on reports.
0 Comments

Are dual listing agents supported for REAXML feeds?

9/12/2019

0 Comments

 
Yes - for REAXML uploads to company sites as well as portals such as Oneroof.co.nz, and Neighbourly the second agent is included in the feed data. As shown in the example XML script below the individual contact information is supplied for both salespeople. Individual salesperson photos are not uploaded from SalesPartner because those images are typically maintained separately via the website's admin control panel, and then linked to the listing agent's name.
Picture
0 Comments

Editing reports: Colour matching tips

6/12/2019

0 Comments

 
If you have a logo or style guide that requires certain colours for your flyers or window cards, you can create elements with custom colours to closely match your specifications.
In this example we'll add a flyer banner background and match the custom colour to a supplied logo.

Step 1. Microsoft Paint

Locate your example logo or graphic and right click, open with > Paint. Tip: Use Ctrl+PrtScn to snapshot your screen if you want to copy a sample from a google image search and then paste that into MS Paint.
Picture
In Tools select the dropper and then click on the area you wish to colour match. The colour will appear in the Colour 1 panel. Click Edit colours
Picture
In Edit colours, make a note of the RGB codes for your custom colour. These codes will be used to colour match the element in SalesPartner.
Picture

Editing an element in SalesPartner

Bring up your custom report in edit mode and double click into the object you wish to colour match. Note you can create a new object using the tools in the left hand menu. Open the Color menu and in Define Custom Colours enter your RGB (Red, Green, Blue) codes you obtained from Paint.
Click Add to Custom Colours and then select your new custom colour and click OK. Repeat this step for both shape Color menus to ensure that the border as well as the fill use the same custom colour.
Picture
0 Comments

Uploading Rental listings to Trade Me

27/11/2019

0 Comments

 
An operator encountered this error when attempting to upload a Rental listing to Trade Me via API:
No "Available From", fill this in the Alert field on Features Tab ...Please enter the date that the flat becomes available.
Picture
Solution: Open the Features tab and enter the listing's Available Date into the Alert field.
Picture
Now the upload issue should be resolved.
Picture
0 Comments
<<Previous

    Admin
    Geoff Duncan

    Archives

    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013

    Categories

    All

    RSS Feed

Picture
"SalesPartner helps me extract maximum value from my
biggest asset - my database".

Andrew Duncan
Relatable Limited


Picture
Developed in Wellington, New Zealand
SalesPartner Software - established in 1993
Leading edge software for real estate salespeople