Forum Discussion

kmd's avatar
kmd
Contributor II
17 hours ago

Mass modification of a Metadata member attribute

Hi all,

Does anyone happen to have the correct syntax for an XML file that modifies a single attribute (member property) and can be uploaded to OneStream without resetting other member properties?

A bit of background, I have to add content to the Text7 field of over 3000 members.  
I tried one version of a XML that only referred to the Text7 property for a single member
But when I loaded the xml, some (but not all) of the properties for that member reverted back to original defaults.  On the plus side, it DID update the Text 7 field.

I'm clearly not defining my XML properly so if anyone has an example of the syntax I can use to update a property without affecting anything else, I would love to see it.

I realize I can extract all 3000 members to an XML, but if the Text7 property is not assigned anything, then that property doesn't get included in the extract (otherwise I could simply do a global search/replace):  in order to fix this I would have to write a script to run against the contents of the XML and 'add' a line identifying that property and it's contents.

I'm hoping there's something more straightforward out there?  Fingers crossed.

Thanks in advance for any examples you might have.

Metadata

2 Replies

  • ckattookaran's avatar
    ckattookaran
    VIP
    16 hours ago

    Not in front of a system now. But if the property tag is in the XML, then you need all the tags inside it for it to work. If you don't have that, then every property will be reverted to their default value. 

    A typical way is to get the existing ones and then add it in the XML that you are loading. 

    • Henning's avatar
      Henning
      Valued Contributor II
      2 hours ago

      Agreed.

      Use Regular Expressions (or RegEx) for a "smart" find and replace if needed. Or you just find and replace the prior property that is in the file, e.g. Text6 and replace it with Text6 and Text7. Other than that, RegEx or a simple script are not very complex either and I would guess one of the common LLMs will spit out the script in a matter of seconds for that.