Announcements file

Messages from the office that appear on every rep’s tablet, between two dates if you want.

File name: Announcements.csv, Announcements_2026-11-01.json or Announcements-export.xml. The name starts with the record type, in any case, and anything after a _ or - is yours.

Required: AnnouncementId. Everything else may be left out or left blank.

Example

One complete record, in each format. All three import as the same record. The CSV is the sample file for announcements.

CSV
AnnouncementId,Title,Message,ValidFrom,ValidUntil,IsActive
ANN001,Christmas deliveries,The last delivery before Christmas is on 22 December.,2026-12-01,2026-12-22,Yes
JSON
[
  {
    "id": "ANN001",
    "title": "Christmas deliveries",
    "message": "The last delivery before Christmas is on 22 December.",
    "date_posted": "2026-12-01",
    "expires_at": "2026-12-22",
    "is_active": true
  }
]
XML
<?xml version="1.0" encoding="UTF-8"?>
<Feed>
  <Announcement>
    <id>ANN001</id>
    <title>Christmas deliveries</title>
    <message>The last delivery before Christmas is on 22 December.</message>
    <date_posted>2026-12-01</date_posted>
    <expires_at>2026-12-22</expires_at>
    <is_active>Yes</is_active>
  </Announcement>
</Feed>

In XML each record is a <Announcement> element; the element around them can be called anything.

Fields

AnnouncementId

Your code for the message.

CSV columnJSONXML
AnnouncementIdidid
  • Format: Text, matched exactly, capitals included.
  • Required: Yes.
  • Example: ANN001

Title

The heading reps see.

CSV columnJSONXML
Titletitletitle
  • Format: Text.
  • Required: No.
  • Example: Christmas deliveries

Message

The message itself.

CSV columnJSONXML
Messagemessagemessage
  • Format: Text.
  • Required: No.
  • Example: The last delivery before Christmas is on 22 December.

ValidFrom

First day it shows. Blank means now.

CSV columnJSONXML
ValidFromdate_posteddate_posted
  • Format: A date. 2026-12-31 is always read; other shapes are in Dates.
  • Required: No.
  • Example: 2026-12-01

ValidUntil

Last day it shows, that day included. Blank means until removed.

CSV columnJSONXML
ValidUntilexpires_atexpires_at
  • Format: A date. 2026-12-31 is always read; other shapes are in Dates.
  • Required: No.
  • Example: 2026-12-22

IsActive

Yes to show it, No to hide it.

CSV columnJSONXML
IsActiveis_activeis_active
  • Format: Yes or no: see Yes and no below.
  • Required: No.
  • Example: Yes

Rules for every field

  • A blank cell keeps what the tablet has, with Ignore blank cells on, as it ships. Switched off, a blank clears the field.
  • A column the file does not have always keeps what the tablet has, whatever that setting says.
  • A value that cannot be read, such as a date, number or yes/no in a shape the app does not know, stops that record importing. The sync log names the field and the value, and the record keeps what it had. A field whose tip says otherwise is the exception.
  • Column names are matched without case and ignoring surrounding spaces.

Yes and no

In any case:

  • Yes: true, t, yes, y, 1, -1, x, on, active, enabled
  • No: false, f, no, n, 0, off, inactive, disabled