Hi,
Is there any possibility with Innovator Admin tool loading data from a flat file into Aras Innovator?
How do I reference to the data file?
I know this is possible with Batch Loader like this example
<Item type="LT_OEM" where="lt_oem_code='@1'" action="merge">
<lt_oem_code>@1</lt_oem_code>
<lt_oem_name>@2</lt_oem_name>
<description>@3</description>
</Item>
You most definitely can. A few more advanced tips to keep in mind:
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.
If you attempt to edit the current version of an automatically versioning item (like a part) multiple times, the id of the item you want to edit will continually be changing. In this situation, it is useful to construct a query such as <Item type='Part' action='edit' where="[Part].[config_id] = 'CONFIG_ID'"><!-- edits --></Item>
For some obscure reason (probably a bug), 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'.
You most definitely can. A few more advanced tips to keep in mind:
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.
If you attempt to edit the current version of an automatically versioning item (like a part) multiple times, the id of the item you want to edit will continually be changing. In this situation, it is useful to construct a query such as <Item type='Part' action='edit' where="[Part].[config_id] = 'CONFIG_ID'"><!-- edits --></Item>
For some obscure reason (probably a bug), 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'.
