SalesPartner Real Estate Software
p +6444711849
  • News
  • Home
  • Software
    • SalesPartner Cloud
    • Websites
  • Pricing
  • Downloads
  • Contact us
  • Log in

How to fix: extra blank page appears on double sided flyer template

13/12/2019

0 Comments

 
For a custom two-sided landscape A4 booklet, a third blank page is appearing in between the cover and back pages. This is caused by the vertical height of the cover page report band being too long to fit the available canvas area. The solution is to calculate the maximum possible height of the report band and adjust accordingly.
In Report, Options in the top menu ribbon we can check that the paper height is 210mm. The top and bottom margins are both 10mm so deducting 20mm from 210mm gives us our maximum band height which is less than 190mm.
Picture
First we left click an empty area to select the band, then right-click to open the band options and view the height which is currently 200.03mm. The extra height is pushing into the next page so this needs to be reduced to 190mm. Note for this particular template the band needed to be reduced to 185mm to publish only two pages. It may help to adjust any objects contained within the band so that they don't protrude beyond the border.
Picture
In this example the lower banners should be lifted higher to reveal the full 10mm margin. The lower margin can be reduced slightly via Report, Options if your printer supports print to edge.
Picture
0 Comments

Lightweight feed automation

11/12/2019

0 Comments

 
To free up precious server resources in Cloud servers here is a feed automation design for ListingsSynchronizer.

Synchro as a service

The server admin installs SynchroServer and creates the necessary Network Address Translation endpoints on the session host. Then SynchroServer is run as a service so that listings can still be transferred on demand when the server is idling, and a user account does not need to be logged in. This frees up significant resources for other workloads.

Cloned VM: the Jump Server

A small basic Windows virtual machine is created in one of our lab environments at SalesPartner HQ. The main data is  backed up and restored into SalesPartner, then all photos are synced to produce a replica of the central server. This VM is the stepping stone or jump server where the data is processed and forwarded on to the website FTP server. An automatic transfer scheduled is established to persistently update the listings data at regular intervals.

Scheduled uploads

The synchronization schedule is loaded to work alongside the ListingsSynchronizer app which forwards the data on to the website FTP destination.
Picture
0 Comments

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.

Notes

For an office's custom complex magazine template, anomalies began to occur where for various properties the icons would randomly show or hide. The solution was to rename all of the icon and numerical objects, and also rename them in the SQL script.
Picture
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
<<Previous
    AnyDesk Windows Link
    AnyDesk Mac Link
    Log in

    Admin
    Geoff Duncan

    Archives

    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    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
www.agentmonday.com


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