Create a Memory Reel

Folder layout

• Memory JSON

  web/data/communities/<group-id>/memories/<memory-id>/memory.json

• Photos

  …/memories/<memory-id>/gallery/photos/

• Video

  …/memories/<memory-id>/gallery/video/

• Audio / music

  …/memories/<memory-id>/gallery/audio/

• Documents

  …/memories/<memory-id>/gallery/documents/

• Memories index

  web/data/communities/<group-id>/memories_index.json

Every reel includes

1. Opening title slide (group, event, date, place, purpose)
2. Photo / video memory sequence
3. Optional background music (starts after viewer tap)
4. Closing credit slide — Created with LifeLoveMe
5. Link back to the group memory page

Reel timeline file (Excel — edit this, not JSON)

Edit the reel in memory_reel_timeline.xlsx inside the memory folder. The viewer reads memory_reel_timeline.json, which is generated from Excel — do not edit JSON by hand.

Sheets: MemoryInfo, VisualTimeline, AudioTimeline, ImportReport.

After editing Excel, regenerate JSON:

python3 scripts/convert_memory_timeline_xlsx_to_json.py --group <group-id> --memory <memory-id>

Validation: memory_reel_timeline_validation_report.json and memory_reel_timeline_validation.xlsx

When the timeline JSON exists, the viewer plays from it. Use ?regenerate=1 or ?shuffle=1 to rebuild in the browser (does not write back to disk).

Add ?admin=1 on the viewer to show original filenames and debug info.

Duration presets

Short 30s · Medium 60s (default) · Long 90s · or custom durationSeconds in memory.json.

Import Memory Folder

Source folder may use subfolders (photos/, audio/, …) or a single mixed folder (jpg/mp3/mp4/pdf together). Files are copied as 3-digit numeric names (001.jpeg, 002.mp3) — original names stay in media_manifest.json only.

Creates memory.json, media_manifest.json, copies gallery files with 3-digit numeric names (001.jpeg), generates memory_reel_timeline.xlsx + JSON, and updates the group memories index. Mixed source folders supported (all file types in one folder).

Viewer URL pattern

/communities/memory-viewer/index.html?group=<group-id>&memory=<memory-id>

Open DOSTI pilot memory