Smart CSV Import for Migraine Buddy Data

[crmne]

Add ability to detect and properly import data from Migraine Buddy exports.

Features

• Detect Migraine Buddy CSV format from column headers
• Map Migraine Buddy fields to appropriate Cluster Headache Tracker fields
• Convert intensity scales if needed
• Handle any special formatting or data conventions

Technical Considerations

• Need sample Migraine Buddy exports for testing
• Document Migraine Buddy's data format
• Create separate import logic for detected format
• Handle potential conflicts or data mismatches
• Provide clear feedback if import fails

[PhilTee]

I've got a very basic export file from MigraineBuddy in CSV format now. I'll see what can be done to map fields across.

[crmne]

I've got a very basic export file from MigraineBuddy in CSV format now. I'll see what can be done to map fields across.

Awesome! This could be a really great feature.

Can you anonymise it or remove data and post it here too? I'm curious to see what they track, I'm sure we can learn something from it.

[PhilTee]

"Date","Time Period","Description","Notes"
"No ongoing events recorded during this period.","","",""

"#","Started","Lasted","Start UTC Offset (min)","End UTC Offset (min)","Geohash","Attack Types","Attack Location","Pain Level","Affected Activities","Potential Triggers","Symptoms","Most Bothersome Symptom","Premonitory Symptoms","Pain Positions","Helpful Medication","Somewhat Helpful Medication","Unhelpful Medication","Unsure Medication","Helpful Non Drug Relief Methods","Somewhat Helpful Non Drug Relief Methods","Unhelpful Non Drug Relief Methods","Unsure Non Drug Relief Methods","Notes"
"1","11/16/24 13:12","01h 00m","0","0","","","","4","","Stress","Sensitivity to light, Throbbing pain","","","Right Back of Head (Lower), Left Back of Head (Lower)","","","","No medication","","","","",""