Map text in a work order's address to an existing site
Locations sends a work order to a site you already have. Each row is a piece of text and a site. When the work order's address contains the text, the job is written to that site and Formpiece doesn't search for or create one. The page is on every inbox, and the site list is Simpro or Fergus to match the inbox.
Before you start
The sites have to exist already. The site list searches the platform for them.
Step by step
- Open the inbox from Inbox, then Locations.
- Click Add location.
- Type the text in String to match, for example a building name or a street.
- Search for the site in Simpro Site or Fergus Site. Type at least 3 characters in Fergus.
- Repeat for each location.
- Click Save. The page says "Inbox locations saved."
Click Remove on a row and confirm "Confirm delete" to delete it, then click Save.
How a work order is matched
- Capitals are ignored. A row matches when the text appears anywhere in the work order's address.
- The address is tried first. The site name the parser read is tried only when the address matched nothing.
- When more than one row matches, the last one in the list wins. Rows can't be reordered, so the order is the order you added them.
- A row only counts when it has both the text and a site. String to match is required, so the browser stops Save on a row with no text. Text typed on a row that has no site is not kept.
- The text is checked against the address as written. When the parser read the street, city, state and postcode as separate fields, it is checked against those joined together.
With no match, Formpiece searches the platform for a site with the same address, then the same name. If it finds none it makes one.
How it maps to Simpro and Fergus
| Platform | A matched row |
|---|---|
| Simpro | The job's or quote's site is the Simpro site you chose. |
| Fergus | The job's site is the Fergus site you chose. |
A mapped site is not checked against the customer.
Site address format
These settings are at the bottom of Rules, under Sites and contacts. They decide how the address of a new site is written, and sit with Locations because both decide which site a work order lands on. They never change a site that already exists.
They apply when the parser reads the address as one Site Address field. A parser that reads street, city, state and postcode separately keeps them as read, apart from Country and the uppercase options on Rules.
| Setting | Choices |
|---|---|
| Street type | Spelled out (Street, Road, Avenue) or shortened (St, Rd, Ave). |
| Unit, in Room/Apartment/Building | Fergus only. With its word (Unit 1, Shop 3) or number only (1). |
| Suburb | Title Case, as written on the work order, or UPPERCASE. |
| State | Short code (VIC) or full name (Victoria). |
| City | Fergus only. Same as the suburb, or blank. Fergus marks City as required on a site. |
| Country | Free text. Starts as Australia. |
| Text in brackets after the address | Add it to the job notes, discard it, or leave it in the address. |
The settings start as: spelled out, with its word, Title Case, short code, same as the suburb, Australia, add to the job notes. Reset to defaults puts them back.
A unit in a Simpro address is written in front of the street, as in 1/43 Grenville Street, because a
Simpro site has no unit field. A Fergus site has one, so the unit goes there.
Text in brackets, such as (key #155, 1456-TT), is a note for the technician. With Add it to the
job notes it is written as "Site access: key #155, 1456-TT" in the Simpro job's or quote's notes, in a
Fergus note on the job, or in a Fergus enquiry's description. With Leave it in the address the
text stays on the street line and in the site's name. The dashboard warns that the site will not match
on the next import.
Below the settings, Preview shows how a sample address, or an address read from a work order PDF you drop on it, would look as a new site. The PDF is read in your browser and is not uploaded.
When it goes wrong
A new site was made even though I added a location
The text wasn't in the address or site name the parser read. Open the work order's record on the Dashboard, look at the fields the parser read, and use text that appears in them.
Two locations match and the wrong site is used
The last matching row wins. Put the more specific text lower in the list, or make the texts more specific.
A Fergus site no longer exists
When the mapped site was deleted in Fergus the import ignores the row for that work order and matches by address. Choose a new site on the row.
Fergus refuses to make a site
Fergus holds one site per name. The import reuses an existing site of the same name. When that site is archived, the work order stops with a message naming the site and asking you to unarchive it in Fergus.