• Replies 5 replies
  • Subscribers 28 subscribers
  • Views 14181 views
  • Users 0 members are here
Options
Related

Innovator Admin - loading data from flat file

Klaus Wroblewski
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>
Parents
  • Former Member
    Former Member
    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'.
Reply
  • Former Member
    Former Member
    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'.
Children
No Data

Copyright © 2025 Aras. All rights reserved.