batchloader to import several generation

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:

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