Forum Discussion

hadrien_guiducci's avatar
hadrien_guiducci
Ideator I
7 years ago

batchloader to import several generation

Hi 

I am trying to import several generation of an item.

In AML I can do it with 

<Item type='myItem' action='merge' where="[myItem]._title='123456'">
  <_title>523556</_title>
  <_start_date>2019-09-30T00:00:00</_start_date>
  <_end_date></_end_date>
  <_status>New</_status>
</Item>

This AML request works it gives :

But in the batchloader I got an error since I could not make a aml like <Item type='myItem' action='merge' where="[myItem]._title='@2'"> 

Any Idea ? Thanks.

Best regards

Hadrien

AML
Batch Load
Import Data
Versioning

2 Replies

  • Gopikrishnan's avatar
    Gopikrishnan
    Ideator I
    6 years ago

    Hi Harien

    You can use merge action in batch loader also

    Create an EXCEL file with columns title, start_date, end_date and status

    Fill the Values in excel

    Save Excel file as text tab limited file

    Example:

    title start_date end_date  status
    523556 2019-09-30T00:00:00 2019-09-30T00:00:00 New
    523556 2019-08-30T00:00:00 2019-08-30T00:00:00 Closed
    523556 2019-07-30T00:00:00 2019-07-30T00:00:00 Released
    523556 2019-06-30T00:00:00 2019-06-30T00:00:00 New
    523556 2019-05-30T00:00:00 2019-05-30T00:00:00 Active
    523556 2019-04-30T00:00:00 2019-04-30T00:00:00 Active

    Create a XML file with below query and save as AMLQuery.xml

    <Item type='myItem' action='merge' where="[myItem]._title='@1'">
    <_start_date>@2</_start_date>
    <_end_date>@3</_end_date>
    <_status>@4</_status>
    </Item>

    Steps to load multiple Part BOM using Batch Loader are

    Open Batch Loader.exe (Available in ARAS Installation CD)

    Select ‘New’ in Batch Loader

    Update the below parameters in Batch Loader
    • Server : ARAS URL (Example : localhost/InnovatorServer
    • Database : Innovator Server (Select from the drop-down menu)
    • User : root
    • DataFilePath : inputfile.txt (Select the input file)
    • Delimiter : \t (Select tab delimiter)
    • WorkerProcess : 2
    • Threads : 4
    • LinesPerProcess : 100
    • Encoding : Unicode (UTF-8)
    • FirstRow : 1
    • LastRow : -1
    • LogFilePath : outputfile.txt(Create any text file and select)
    • LogLevel : 2
    • PreviewRows : 1000
    • MaxColumns : 10
    • FirstRowColumnNames: False (True in case if input file has header)

    Click load and select AMLQuery.xml
    Click Verify and provide the root password
    Verification Message: Verification successfully Passed: the template does not contain invalid item types or properties.
    Click Load

    This should work.

    Thank You

    Gopikrishnan R