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”).