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