&
with &
). If you are starting with a SQL table, you could also write your SQL statement to generate AML with the same caveat.<AML></AML>
tag.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='add'
or 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: action='lock'
, action='update'
, and action='unlock'
.