csv import instructions

CSV Import Instructions — Segment Feedback

Use this note to guide the import of new segment feedback entries from Formidable Forms into this folder.

---

1. Download the CSV

Export all entries from the Formidable Forms form named “Intro Segment Feedback”. The CSV filename follows the pattern: DDMMYYHHMM_intro-segment-feedback_formidable_entries.csv Save it to ~/Downloads/.

---

2. Find the cutoff date

In the terminal or with a tool, grep the date: frontmatter property across all existing notes:

grep -r "^date:" /path/to/segment-feedback/ | sort -t: -k2 | tail -5

The latest date is the cutoff — only import CSV rows with a Timestamp strictly after this date.

---

3. Identify new entries

Run the following Python snippet (adjust the cutoff date):

import csv
from datetime import datetime

cutoff = datetime(2026, 2, 21, 23, 59, 59)  # update to latest existing date

with open('path/to/export.csv') as f:
    rows = list(csv.DictReader(f))

new_rows = [r for r in rows if datetime.strptime(r['Timestamp'], '%Y-%m-%d %H:%M:%S') > cutoff]
for r in new_rows:
    print(r['Timestamp'], r['Name'], r['Segment'])

Skip test entries — e.g. rows where all content fields are literally “test”.

---

3b. Handling duplicate submissions (same person, same segment)

When a person submits more than once for the same segment, check the content of each submission before deciding what to keep.

Drop the duplicate if it contains placeholder language indicating the person knew they had already submitted — e.g. “I already answered this”, “already submitted”, “ditto”, “na”, “merci” repeated across all fields, or similar. Keep the entry with the actual experiential content.

Keep both if both entries contain real, practice-related content (genuine reflections, observations, different sessions). In that case, merge them into a single note under one file. Format with a ## Submission N — YYYY-MM-DD heading for each, and ### Section sub-headings within each submission block. Use the earliest submission date in the frontmatter date: field.

---

4. File naming convention

s{segment-number}-{segment-slug}-{firstname}-{lastname}.md

Examples:

• s05-movement-transitions-france-vachon.md
• s06-ignition-guylaine-demers.md

Name parts should be lowercased, accents removed, spaces replaced with hyphens.

---

5. Segment number → slug mapping

Segment name (CSV)	segment-number	slug
Forms	02	forms
Focus	03	focus
Intensity Modification	04	intensity-modification
Movement Transitions	05	movement-transitions
Ignition	06	ignition
Assimilation	07	assimilation
Cyclicity	08	cyclicity
Journaling	09	journaling
Outcomes	10	outcomes

---

6. Note format

Single submission:

---
type: segment-feedback
segment: {Segment name from CSV}
segment-number: {two-digit number}
respondent: {Full Name from CSV}
course: primer
date: {YYYY-MM-DD from Timestamp}
---

# Segment Feedback — {Segment}: {Full Name}

## Most interesting

{CSV: "What was the most interesting in this segment?"}

## Unusual or difficult to understand

{CSV: "What did you find unusual or difficult to understand?"}

## Movement habits / changes noticed

{CSV: "Anything interesting you've noticed about your movement habits or any changes you've experienced?"}

## What could have been better

{CSV: "What do you feel could have been better about this segment? (if anything)"}

## Additional comments

{CSV: "Any additional Comments? (Optional)"}

Multiple genuine submissions (merged into one note):

---
type: segment-feedback
segment: {Segment name from CSV}
segment-number: {two-digit number}
respondent: {Full Name from CSV}
course: primer
date: {YYYY-MM-DD of earliest submission}
---

# Segment Feedback — {Segment}: {Full Name}

## Submission 1 — {YYYY-MM-DD}

### Most interesting

{content}

### Movement habits / changes noticed

{content}

## Submission 2 — {YYYY-MM-DD}

### Most interesting

{content}

Omit any section whose CSV field is empty. Only include sections that have actual content.

---

7. CSV column → frontmatter / section mapping

CSV column	Used as
Name	respondent: frontmatter + heading
Segment	segment: frontmatter + heading
Timestamp	date: frontmatter (date part only)
What was the most interesting...	## Most interesting
What did you find unusual...	## Unusual or difficult to understand
Anything interesting you've noticed...	## Movement habits / changes noticed
What do you feel could have been better...	## What could have been better
Any additional Comments?	## Additional comments

Columns User ID, Email, Next Lesson URL, Post ID, Last Updated, Created By, Updated By, Entry Status, IP, ID, Key are not imported into the notes.