CSV Import Format

This document describes the CSV format for importing shot and check-in data into Pokii.

Overview

The CSV importer supports importing two types of data:

• Shots: Records of medication injections
• Check-ins: Notes and observations about your health

File Format

The CSV file must:

• Have a header row with column names
• Use UTF-8 encoding
• Support both comma (,) and tab (\t) delimiters
• Optionally quote fields containing commas or special characters

Required Columns

All rows must have these columns:

Column	Type	Description	Example
type	string	Either "shot" or "checkin"	shot
datetime	date/time	Date and time of the entry	2024-01-15 09:00:00

Shot-Specific Columns

For rows where type is "shot", these columns are used:

Column	Required	Type	Description	Example
medicineName	Yes	string	Name of the medication	Semaglutide (Compound)
dose	Yes	decimal	Dosage amount in mg	2.5
site	No	string	Injection site (see below)	stomach_upper_left
pain	No	number	Pain level (0-10)	2
notes	No	string	Additional notes	Morning dose

Supported Injection Sites

The following injection site codes are supported (use these exact values):

Arms:

• arm_left
• arm_right

Stomach:

• stomach_upper_left
• stomach_middle_left
• stomach_lower_left
• stomach_upper_right
• stomach_middle_right
• stomach_lower_right

Thighs:

• thigh_upper_left
• thigh_lower_left
• thigh_upper_right
• thigh_lower_right

Supported Medications

The medicine name must match one of Pokii's known medications (case-insensitive). Use these exact names:

• Zepbound
• Mounjaro
• Ozempic
• Wegovy
• Rybelsus
• Saxenda
• Victoza
• Trulicity
• Retatrutide
• CagriSema
• Bydureon
• Tanzeum
• Tirzepatide (Compound)
• Semaglutide (Compound)

Check-in-Specific Columns

For rows where type is "checkin" or "check-in":

Column	Required	Type	Description	Example
note	No	string	Note or observation	Feeling great today!
mood	No	integer	Mood level (1-5 scale)	4
appetite	No	decimal	Appetite level (0-10 scale)	7.5
sideEffect1	No	string	Name of side effect	Nausea
severity1	No	integer	Severity (1-5 scale)	3
sideEffect2	No	string	Name of second side effect	Constipation
severity2	No	integer	Severity (1-5 scale)	2
...	No	...	Additional side effects	sideEffect3, etc.

Common Side Effects

You can use any side effect name, but here are the most common ones tracked in Pokii:

Most Common:

• Nausea
• Constipation
• Diarrhea
• Acid Reflux

Other Common:

• Fatigue
• Headache
• Heartburn
• Indigestion
• Dizziness
• Vomiting
• Abdominal Pain
• Bloating
• Gas
• Injection Site Reaction

Date/Time Formats

The datetime column supports multiple formats:

• ISO 8601: 2024-01-15T09:00:00 or 2024-01-15T09:00:00Z
• Common formats: 2024-01-15 09:00:00
• Date only: 2024-01-15 (assumes midnight)
• US format: 01/15/2024 09:00:00 or 1/15/2024
• Unix timestamp: 1705305600 (seconds since epoch)

Example CSV File

📥 Download Sample File: sample_import.csv

Basic Example (Shots and Check-ins Only)

type,datetime,medicineName,dose,site,pain,notes
shot,2024-01-15 09:00:00,Zepbound,2.5,stomach_upper_left,2,Morning dose
checkin,2024-01-15 18:00:00,,,,,"Feeling good today"
shot,2024-01-22 09:00:00,Zepbound,5.0,stomach_upper_right,1,Increased dose

Full Example (With Side Effects, Mood, and Appetite)

type,datetime,medicineName,dose,site,pain,notes,mood,appetite,sideEffect1,severity1,sideEffect2,severity2
shot,2024-01-15 09:00:00,Zepbound,2.5,stomach_upper_left,2,Morning dose,,,,,,,,
checkin,2024-01-15 18:00:00,,,,,Feeling good today!,4,8,Nausea,1,,,
shot,2024-01-22 09:00:00,Zepbound,5.0,stomach_upper_right,1,Increased dose,,,,,,,,
checkin,2024-01-22 20:00:00,,,,,Some side effects,3,6,Nausea,3,Constipation,2,

Important Notes

1. Medicine Names: Unknown medicines will cause shots to be skipped. Pokii will report which medicines weren't recognized.
2. Empty Fields: Optional fields can be left empty. For check-ins, all shot-specific columns can be empty.
3. Quotes: Use quotes around fields containing commas:

   checkin,2024-01-15 18:00:00,,,,,"Feeling good, energy is up"

4. Data Merge: The CSV import replaces all existing data. Make sure to backup your data before importing.
5. Validation: The importer will skip invalid rows and provide a summary of what was imported and what was skipped.

Troubleshooting

"Unknown medicine" errors

• Check that the medicine name exactly matches one in Pokii
• Common issue: Missing "(Compound)" suffix for compounded medications
• Try using Pokii's medicine picker to see exact names

Date parsing errors

• Ensure dates are in one of the supported formats
• Check for typos in date strings
• Use 24-hour time format for consistency

Rows skipped

• Check that the type column contains exactly "shot" or "checkin"
• Ensure required columns (medicineName and dose for shots) are not empty
• Verify the header row matches exactly (case-insensitive)