• Replies 5 replies
  • Subscribers 29 subscribers
  • Views 12420 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
  • Offline
    Given an Excel file like so: 
         A            B                C
lt_oem_code  lt_oem_name     description
VW           Volkswagen      A description & more
GM           General Motors  Another description
    You could write the following formula in cell D2 and then copy it down. 
    ="<Item type='LT_OEM' where=""lt_oem_code='" & SUBSTITUTE(A2,"&","&amp;") & "'"" action='merge'>
<lt_oem_code>" & SUBSTITUTE(A2,"&","&amp;") & "</lt_oem_code>
<lt_oem_name>" & SUBSTITUTE(B2,"&","&amp;") & "</lt_oem_name>
<description>" & SUBSTITUTE(C2,"&","&amp;") & "</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.
Reply
  • Offline
    Given an Excel file like so: 
         A            B                C
lt_oem_code  lt_oem_name     description
VW           Volkswagen      A description & more
GM           General Motors  Another description
    You could write the following formula in cell D2 and then copy it down. 
    ="<Item type='LT_OEM' where=""lt_oem_code='" & SUBSTITUTE(A2,"&","&amp;") & "'"" action='merge'>
<lt_oem_code>" & SUBSTITUTE(A2,"&","&amp;") & "</lt_oem_code>
<lt_oem_name>" & SUBSTITUTE(B2,"&","&amp;") & "</lt_oem_name>
<description>" & SUBSTITUTE(C2,"&","&amp;") & "</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.
Children
No Data