not working

[templelamp]

Hi

I am getting this message. I'm definitely opening the correct file.
There was an error processing your data ☹️ , please double check the loaded file is correct: "Apple Music Play Activity.csv".

[AlieGG]

It's not working for me either. Been trying to debug it but not getting anywhere. Any ideas for debugging @PatMurrayDEV ?

[larahmarie]

I tried to submit a commit. Basically Apple Music Play Activity.csv now has the columns come in alphabetical order which is not how the script currently parses it (the current order seems more random).

In the meantime, you have to manually reorder your CSV file through OpenOffice Calc or Excel. It is a pain, but the only way to make it work.

Current parsing order:
const keys = [
"Apple Id Number",
"Event End Timestamp",
"Event Received Timestamp",
"Device Identifier",
"Build Version",
"Milliseconds Since Play",
"Source Type",
"Metrics Bucket Id",
"Event Start Timestamp",
"Feature Name",
"Store Country Name",
"Start Position In Milliseconds",
"Play Duration Milliseconds",
"Event Type",
"End Position In Milliseconds",
"Metrics Client Id",
"Media Type",
"End Reason Type",
"Item Type",
"Event Reason Hint Type",
"Media Duration In Milliseconds",
"Offline",
"UTC Offset In Seconds",
"Apple Music Subscription",
"Client IP Address",
"Content Provider",
"Content Name",
"Genre",
"Artist Name",
"Content Specific Type",
"Original Title"
];