There was an error processing your data

[noelbode]

Hi, I'm not sure why, but I'm getting an error every time I try to upload the "Apple Music Play Activity.csv" file. The file was in "Apple Media Services information" > "Apple Media Services" > Apple Music Activity" as there was not a folder named "App_Store_iTunes_Store_iBooks_Store_Apple_Music"

But I'm sure the file I'm uploading is "Apple Music Play Activity.csv"

[malcolmrbnsn]

I have the same issue. I checked the column names against the list and they are all the same.

[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" ];

[malcolmrbnsn]

That seems to work. I still had some issues with a year being NaN and the stats being off but it parses.