Been away for awhile, hope everyone is well. I apologize ahead of time if I’m not searching the forum properly for this question, but I don’t think I found the exact solution.
Here’s my situation:
As one of my many “day” jobs I compose music. That music is registered online with a place called ASCAP, and it has all sorts of information important to the individual music cue. When I write a new cue that will be used in a production the first thing I have to do is register it there. It’s now a giant (and growing) list of cues and info that I am able to download as an excel or CSV.
What I need create is a database where, in addition to MOST of the info at ASCAP (not all), I need to add all kinds of additional metadata (song genre, instruments used, cue description, etc.)
What I’d like to do is take the CSV or Excel from ASCAP, automatically import only a few of the attributes (song title, registration number, etc.) so that they’re ready for additional metadata. However, I’m stumped as to how to set this up so that as new cues are added to ASCAP, I can run the process to ONLY import new cues, and of course I don’t want to overwrite the existing cues and lose all the metadata I’ve added.
Is this relatively easy to do? Is this going to be easier to do with the new version of Panorama X that’s been recently announced?
Thank you in advance for any guidance, and I hope everyone is staying sane and healthy!
All the best,