Uploading a local file to Innovator using the Batch Loader

Question

I'm having issues uploading a local file to an instance of Innovator using the Batch Loader. I have the following XML:
&nbsp;&nbsp;&nbsp; &lt;Item type="Document File" action="add"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;related_id&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Item type="File" action="add"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;actual_filename&gt;C:\some\file\path\@1&lt;/actual_filename&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;filename&gt;@1&lt;/filename&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/Item&gt;
This currently fails. I had to search to find out the &lt;actual_filename&gt; tag is used for the fully qualified path of the file, yet it is not present in the File Item when inspecting it through Innovator Client.

Any help with this would be appreciated.

cambrianexplosion · Answer

This is the template I used for the file upload/association to document.
&lt;Item type="Document" action="edit" where="[Document].item_number='@2' and [Document].frame_number='@12' and [Document].sheet_number='@9' and [Document].subsheet='@48' "&gt;
&lt;Relationships&gt;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Item type="Document File" action="add"&gt;&nbsp;&nbsp;&nbsp;&nbsp; &lt;related_id&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Item type="File" action="add"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;actual_filename&gt;@68&lt;/actual_filename&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;filename&gt;@21&lt;/filename&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &lt;Relationships&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Item type="Located" action="add"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;related_id&gt;67BBB9204FE84A8981ED8313049BA06C&lt;/related_id&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &lt;/Item&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/Relationships&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/Item&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/related_id&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/Item&gt; &lt;/Relationships&gt;
&lt;/Item&gt;

Notice the where clause to narrow down the document (If you have an ID even better) and the action of "edit"

cambrianexplosion · Answer

I've realized now that I need to specify a relationship to a vault&nbsp; and have changed the AML to the following: 
&nbsp; &lt;Item type="Document File" action="add"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;related_id&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Item type="File" action="add"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;actual_filename&gt;C:\some\file\path\@1&lt;/actual_filename&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;filename&gt;@1&lt;/filename&gt;&lt;Relationships&gt;&lt;Item type="Located" action="add"&gt;&lt;related_id&gt;67BBB9204FE84A8981ED8313049BA06C&lt;/related_id&gt;&lt;/Item&gt;&lt;/Relationships&gt; &lt;/Item&gt;

However now I am greeted with a "File does not exists" exception even though the file does exist at the fully qualified path specified by &lt;actual_filename&gt; tag

paul_sheehy · Answer

I am trying to do the exact same thing (in 11SP15), and getting the same Batch Loader error: 'The system cannot find the file specified.'
I've moved the file to different locations thinking Batch Loader only had permissions to read from certain locations, but I keep getting the same error.
I'm very interested if someone knows how to resolve this! Thanks, Paul&nbsp;

cambrianexplosion · Answer

I had to add another column to my CSV file that held the full file path of the file associated with each record then used that in the AML template

<actual_filename>@25</actual_filename> (if the full file path column is column 25)

paul_sheehy · Answer

&lt;Item type="Document" action="edit" version="0" id="@1"&gt; &lt;Relationships&gt; &lt;Item type="Document File" action="add"&gt; &lt;related_id&gt; &lt;Item type="File" action="add"&gt;&lt;actual_filename&gt;@2&lt;/actual_filename&gt; &lt;filename&gt;@3&lt;/filename&gt; &lt;Relationships&gt; &lt;Item type="Located" action="add"&gt; &lt;related_id&gt;67BBB9204FE84A8981ED8313049BA06C&lt;/related_id&gt; &lt;/Item&gt; &lt;/Relationships&gt; &lt;/Item&gt; &lt;/related_id&gt; &lt;/Item&gt; &lt;/Relationships&gt;&lt;/Item&gt;

I did that as well. @2 =&nbsp;C:	emp\filename.PNG and @3 =&nbsp;filename.PNG
Still get error:&nbsp;The system cannot find the file specified.

Forum Discussion

Uploading a local file to Innovator using the Batch Loader

8 Replies

Recent Discussions

Welcome to the New Aras Community!

UI doesn't load for one user - anyone had a similar problem?

Aras 12 SP16 i can't find TOC editor

Using Aras to Manage Aras Upgrade Planning, Test Plans, Test Records

Batch Loader displays fail message when uploading mass data in PLMA