Uploading a local file to Innovator using the Batch Loader

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 

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)

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

I did that as well. @2 = C:\temp\filename.PNG and @3 = filename.PNG

Still get error: The system cannot find the file specified.

I remember now in some other Forum thread it was suggested to split the addition of documents from the upload of files. That worked for me. I would recommend adding the Documents first, and then making the File associations. Of course to do this you will need to sufficiently narrow down the document to which you wish to associate a File. (Use of where clause can help). Perhaps use a "merge" action instead of edit? I'm also not sure if you're version might have something to do with it

<Item type="File" action="add">
<actual_filename>@2</actual_filename>
<filename>@3</filename>
<Relationships>
<Item type="Located" action="add">
<related_id>67BBB9204FE84A8981ED8313049BA06C</related_id>
</Item>
</Relationships>
</Item>

I tried that as well, isolating just the File add command in Batch Loader, but I kept getting the same error.

This is the template I used for the file upload/association to document.

<Item type="Document" action="edit" where="[Document].item_number='@2' and [Document].frame_number='@12' and [Document].sheet_number='@9' and [Document].subsheet='@48' ">

<Relationships>
     <Item type="Document File" action="add">
     <related_id>
         <Item type="File" action="add">
         <actual_filename>@68</actual_filename>
         <filename>@21</filename>
            <Relationships>
                <Item type="Located" action="add">
                <related_id>67BBB9204FE84A8981ED8313049BA06C</related_id>
                </Item>
            </Relationships>
       </Item>
       </related_id>
       </Item>
</Relationships>

</Item>

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

This is the template I used for the file upload/association to document.

<Item type="Document" action="edit" where="[Document].item_number='@2' and [Document].frame_number='@12' and [Document].sheet_number='@9' and [Document].subsheet='@48' ">

<Relationships>
     <Item type="Document File" action="add">
     <related_id>
         <Item type="File" action="add">
         <actual_filename>@68</actual_filename>
         <filename>@21</filename>
            <Relationships>
                <Item type="Located" action="add">
                <related_id>67BBB9204FE84A8981ED8313049BA06C</related_id>
                </Item>
            </Relationships>
       </Item>
       </related_id>
       </Item>
</Relationships>

</Item>

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

Thanks cambrianexplosion. i tried my approach in a different aras instance and it worked. so i know the problem is not in the batch loader or aml query. i'll keep troubleshooting. thanks again.