Uploading a local file to Innovator using the Batch Loader

I'm having issues uploading a local file to an instance of Innovator using the Batch Loader. I have the following XML:


    <Item type="Document File" action="add">
      <related_id>
        <Item type="File" action="add">
          <actual_filename>C:\some\file\path\@1</actual_filename>
          <filename>@1</filename>
        </Item>

This currently fails. I had to search to find out the <actual_filename> 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.

Parents Reply Children
  • <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"

  • Thanks . 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.