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.
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[
{
"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 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 column | JSON | XML |
|---|---|---|
AnnouncementId | id | id |
- Format: Text, matched exactly, capitals included.
- Required: Yes.
- Example:
ANN001
Title
The heading reps see.
| CSV column | JSON | XML |
|---|---|---|
Title | title | title |
- Format: Text.
- Required: No.
- Example:
Christmas deliveries
Message
The message itself.
| CSV column | JSON | XML |
|---|---|---|
Message | message | message |
- Format: Text.
- Required: No.
- Example:
The last delivery before Christmas is on 22 December.
ValidFrom
First day it shows. Blank means now.
| CSV column | JSON | XML |
|---|---|---|
ValidFrom | date_posted | date_posted |
- Format: A date.
2026-12-31is 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 column | JSON | XML |
|---|---|---|
ValidUntil | expires_at | expires_at |
- Format: A date.
2026-12-31is always read; other shapes are in Dates. - Required: No.
- Example:
2026-12-22
IsActive
Yes to show it, No to hide it.
| CSV column | JSON | XML |
|---|---|---|
IsActive | is_active | is_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