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

---

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

---
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)"}

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.