I’m having a hell of a time mapping the outputs of different operations and bundles and then updating them.
I’m trying to import items from Scrivener which are exported in content-metadata pairs. The filename of the content is in the form “Content whatever” and that of the the metadata is “Content whatever MetaData”. I’ve managed to import them into a datastore with content files in rows and the metadata files in their rows with the metadata nicely parsed etc. I’ve also tagged the content with the name of its matching metadata by appending " MetaData" to its filename and store it in the “MetaData” column. This part is in blueprint_6.3.json (58.5 KB).
The problem I’m stuck on is merging the parsed metadata columns (in the METADATA rows) with the content rows. My latest attempt is in blueprint_7.json (19.7 KB).
I’ve viewed a crap load of help articles, posts, How to’s and videos, and am now spinning my wheels in circles.
Read it more than once. I might be missing some fundamental concept because I’ve read tons of little tidbits like that and none of them helped with this particular problem.
I’ve done as you suggested but don’t see how I’m any further ahead. blueprint_7.1.json (19.7 KB)
What I can’t get me head around is how to access, modify, etc. the object that contains all 4 bundles – from 4 different operations – so that I can merge (for example) the collection in bundle 1 from operation 1 with the one from operation 2 into a single object (collection/array) containing ‘MD Title’ (the record ‘key’), ‘MD ID’ and ‘Content ID’.