Forum Discussion

cambrianexplosion's avatar
cambrianexplosion
Ideator I
6 years ago

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>         <I...
AML
Batch Load
Files
Upload Files
cambrianexplosion's avatar
cambrianexplosion
Ideator I
6 years ago

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's avatar
paul_sheehy
Ideator I
6 years ago

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

  • cambrianexplosion's avatar
    cambrianexplosion
    Ideator I
    6 years ago

    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

    • paul_sheehy's avatar
      paul_sheehy
      Ideator I
      6 years ago

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

      • cambrianexplosion's avatar
        cambrianexplosion
        Ideator I
        6 years ago

        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"