&). If you are starting with a SQL table, you could also write your SQL statement to generate AML with the same caveat.
A B C lt_oem_code lt_oem_name description VW Volkswagen A description & more GM General Motors Another descriptionYou could write the following formula in cell D2 and then copy it down.
="<Item type='LT_OEM' where=""lt_oem_code='" & SUBSTITUTE(A2,"&","&") & "'"" action='merge'> <lt_oem_code>" & SUBSTITUTE(A2,"&","&") & "</lt_oem_code> <lt_oem_name>" & SUBSTITUTE(B2,"&","&") & "</lt_oem_name> <description>" & SUBSTITUTE(C2,"&","&") & "</description> </Item>"Then, within Innovator Admin paste all of the
<Item>queries into the window and wrap them in an
<AML>tag such as
<AML> <Item type='LT_OEM' ... <Item type='LT_OEM' ... <Item type='LT_OEM' ... <Item type='LT_OEM' ... </AML>Then, use the menu next to the Run button to select Run Batch… to execute the AML in reasonably-sized batches to optimize performance. Hopefully that helps. If not, let me know.
action='merge'is useful if you don't know if the item exists. It will create the item if it doesn't, or edit the item if it does. Otherwise,
action='edit'work just as well.
<Item type='Part' action='edit' where="[Part].[config_id] = 'CONFIG_ID'"><!-- edits --></Item>
action='edit'does not work on old revisions of a versionable item (where
is_current <> '1'). In those situations, you have to perform three queries: