I’ve been working on updating our metadata. First by aligning the values with Suggested Values.
But in some cases, the simple text value had a qualifier directly in it. I separated the values from their qualifiers, so far so good.
Now I’m thinking of a way to add those already existing qualifiers. My thinking goes like this:
- Creating as many resources as they’re gonna be qualifiers in the resource table.
- Adding the resource id list to the value annotation table.
- Creating values with the actual qualifying value in the value table with their respective resource-id.
- Finally, adding the resource id to the values that are the subject of the qualifications.
I haven’t checked yet if it would work, I just want to share this in hopes that somebody knows if it can work or has an easier way of doing things (I mean, it’s not that hard technically). For now it doesn’t seem CSV Import allows for annotations?
Thanks in advance !