Events File

The Events File allows you to import either Normal Events (with appointment slots) or Roster Events (registration-style events) into pickAtime. This document outlines the required format and instructions for both types.
File Format
File Type: Tab-delimited text file (*.txt or *.tsv).
First Row: Must contain column headers.
Example Tools: Export from Excel or Google Sheets as Tab-delimited Text.
Importing Normal Events
1 – Create Your Event File
Each row represents one set of time slots for an event.
Required Columns:
EventName - The name of your event (e.g., “Vision Screening”).
EventDate - The label shown in the Event Setup page (e.g., “March 2025”).
Location - The physical or virtual location where the event is held.
TimeZone - Time zone in which the event occurs (e.g., “America/New_York”).
Resource - The name of the resource involved in the event (e.g., “Nurse”).
Date - The calendar date for the appointment slots (format: MM/DD/YYYY).
StartTime - Start time for the first appointment slot (format: HH:MM AM/PM).
EndTime - End time for the last appointment slot (format: HH:MM AM/PM).
Duration - Duration of each appointment slot in minutes (e.g., 10).
Max - Maximum number of appointments allowed per slot.
basedEvent - (Optional) ID of an existing event to use as a template.
Category - (Optional) Category label for the event.
Description - (Optional) General description or details about the event.
ResourceDescription - (Optional) Description of the resource, such as qualifications or instructions.
2 – Import Your File
Go to pickatime.com and log in.
From the left-hand menu, select Importer.
Choose Data Type: Events.
Choose Event Type: Normal.
Locate your file and import it.
Important Notes
If multiple rows in your import file share the same EventName, pickAtime will append the slot data to the existing event. It will not create duplicate events.
To create two distinct events with the same name, each must be given a unique EventName (e.g., “Bellevue Screening 1”, “Bellevue Screening 2”).
Importing Roster Events
1 – Create the Roster Event File
Each row defines one registration-type event (not based on appointment slots).
Required Columns:
EventName - The name of your event.
EventDate - The label shown in the Event Setup page.
Location - The location of the event.
TimeZone - The time zone of the event (e.g., “America/Denver”).
Max - Maximum number of participants allowed in the event.
basedEvent - (Optional) ID of an event to use as a template.
Category - (Optional) Category label for your event.
Description - (Optional) Description or event details.
2 – Import Your File
Log in at pickatime.com
From the left-hand menu, select Importer.
Choose Data Type: Events.
Choose Event Type: Roster.
Locate your file and import it.
Important Notes
If multiple rows in your import file share the same EventName, pickAtime will append the slot data to the existing event. It will not create duplicate events.
To create two distinct events with the same name, each must be given a unique EventName (e.g., “Bellevue Screening 1”, “Bellevue Screening 2”).