Skip to content
PiCortex Help

Sites: codes, access notes and importing a list

Last updated 2026-11-07 · PiCortex Team

Sites

A site is a place where your team does work for a customer: a tower, a branch, a depot. Open Sites in the sidebar to see them all, on a list and a map.

What a site holds

  • Name: what your team calls it. Names are different for every site.
  • Customer: whose site it is.
  • Location: the address, and the point on the map.
  • Site code: the customer's own number for the site, such as a Vodacom site ID. A customer can't have two sites with the same code. The code shows after the site's name, for example Midrand Tower (VC1234), so you can find a site on a job by typing its code.
  • Access notes: what someone needs to get in: gate codes, where the keys are, who to ask on arrival.

Import sites from a spreadsheet

  1. Open Sites and choose Import sites.
  2. Choose the customer the sites belong to, or leave it on From the file's Customer column when your file has one.
  3. Choose your file: Excel (.xlsx) or CSV, up to 2,000 sites.
  4. Check the preview. Each row says New, Update or Can't import, and why a row can't be imported.
  5. Choose Import.

The import preview: two new sites, and a row that can't be imported with the reason

Nothing is saved until you choose Import.

The file needs a row of headings, then one row per site. These headings are understood:

HeadingAlso understood as
NameSite name, Site
Site codeCode, Site ID, Site number
CustomerClient
LatitudeLat
LongitudeLong, Lng, Lon
AddressPhysical address, Location
Access notesNotes, Access

Other columns are left out, and the preview names them.

A row updates an existing site when the customer already has a site with the same site code, or the same name when the row has no code. Empty cells never clear what a site already has.

A row can't be imported when:

  • it has no name;
  • its latitude or longitude is missing, isn't a number or is out of range;
  • its code or name appears twice in the file;
  • another site already has its name;
  • there's no customer, or more than one customer with that name.

Directions from a job

On a job with a site, the job's details show the site's Access notes and a Directions link. On a phone, it opens your maps app with the route from where you are.

Was this article helpful?

Still need help?

Contact us on WhatsApp and we'll assist you.

Sites: codes, access notes and importing a list | PiCortex Help