Automate download of CAD files to send to Supplier

Hi Paul,

The Download Multiple Files community project works by downloading the files a user has selected in the grid, but you can use the same general process for downloading multiple files from a structure.

You can split this into a couple smaller problems.

1. Do a recursive call to get all of the items in the CAD Structure
2. Get a list of Files that need to be downloaded
3. Download all of the Files in the list to the server

The first problem of performing a recursive call can be solved by using the GetItemRepeatConfig action described in this blog post. We use the Part -> Part BOM structure as the example in that blog post, but you can easily rewrite the AML to work with CAD -> CAD Structure.

The second is to get a list of all of the Files that need to be downloaded. You can do this pretty simply by using an XPath selector like //native_file/text() to avoid manually iterating through the entire structure. Depending on your exact AML query, this will get you a list of IDs for the Files that exist in your CAD Structure.

For the last step of downloading all the files, you can look at the Create Zip on Server method of the Download Multiple Files project for some sample code that uses the Aras.IOME.CheckoutManager class to download a collection of File items to a location on the server. You can find a full reference of this class in the API guide available by logging into Aras Innovator as an admin and selecting Admin > API Reference (.NET) in the user menu. Once the files are in a common location on the server, you can package them up however you want to deliver them to the supplier.

Chris

Christopher Gillis

Aras Labs Software Engineer

Chris, thanks for the great feedback! I've got the AML query working to get all the child items:

<Item type='CAD' select='item_number, native_file' action='GetItemRepeatConfig' id='{CAD parent id here}'>

<Relationships>

<Item type='CAD Structure' select='related_id' repeatProp='related_id' repeatTimes='0'></Item>

</Relationships>

</Item>

But my xPath skills aren't very good. In trying to take those results and get a list of FileIDs, via:

Item fileIds = qryResults.getItemsByXPath("//Item[@type='CAD']/native_file/text()");

I get an error that the xPath does not resolve to Item nodes. Do I use another function instead of getItemsByXPath?

Thanks!

Paul

Where you ever able to figure this out?  I am trying to do the same thing.

Hi Nathan

Try below server method. This need to be configured in the Scheduler if you want to run and download the files automatically. Also you need to add the condition to pass the CAD item ID

Innovator innovator = this.getInnovator();
Item cadItem = innovator.newItem("CAD", "GetItemRepeatConfig");
cadItem.setAttribute("select", "item_number,native_file");
cadItem.setID("BF3D2A06F8234971988E063527E486D0");
Item cadStructure = innovator.newItem("CAD Structure", "get");
cadStructure.setAttribute("select", "related_id");
cadStructure.setAttribute("repeatProp", "related_id");
cadStructure.setAttribute("repeatTimes", "0");
cadItem.addRelationship(cadStructure);
cadItem = cadItem.apply();
if(cadItem.isError())
{
return cadItem;
}
Item queryItem = cadItem.getItemsByXPath("//Item[@type='CAD']");
var fileItemId = new List <string>();
for(int i = 0; i < queryItem.getItemCount(); i++)
{
if(!string.IsNullOrEmpty(queryItem.getItemByIndex(i).getProperty("native_file")))
{
fileItemId.Add(queryItem.getItemByIndex(i).getProperty("native_file"));
}
}
if(fileItemId.Any())
{
string folderPath = @"C:\Temp\Aras\MultipleFileDownload\" + innovator.getUserID();
string filePath = folderPath + "\\Files";
string zipPath = folderPath + "\\Zip";
if (System.IO.Directory.Exists(filePath))
{
System.IO.Directory.Delete(filePath, true);
}
System.IO.DirectoryInfo di = System.IO.Directory.CreateDirectory(filePath);
System.IO.DirectoryInfo zdi = System.IO.Directory.CreateDirectory(zipPath);
Item files = innovator.newItem("File", "get");
files.setAttribute("idlist", String.Join(",", fileItemId.ToArray()));
files = files.apply();
if (files.isError())
{
return files;
}
Aras.IOME.CheckoutManager cm = new Aras.IOME.CheckoutManager(files);
cm.DownloadFiles(filePath, 1);
string currentDateString = DateTime.Now.ToString(@"yyMMddHHmmss", CultureInfo.CreateSpecificCulture("en-US"));
string zipName = string.Format(CultureInfo.InvariantCulture, "ZipFiles_{0}.zip", currentDateString);
string fullZipPath = String.Format("{0}\\{1}", zipPath, zipName);
try
{
System.IO.Compression.ZipFile.CreateFromDirectory(filePath, fullZipPath);
if (System.IO.Directory.Exists(filePath))
{
System.IO.Directory.Delete(filePath, true);
}
}
catch (InvalidDataException)
{
return innovator.newError("Could not create .zip archive");
}
}
return this;

This will download the file to C:\Temp\Aras\MultipleFileDownload\AD30A6D8D3B642F5A2AFED1A4B02BEFA\Zip location

Gopikrishnan,

Thank you for this information.  The big problem I have is the JavaScript method to pass the information.  I am trying to set this up as an Action.  Thank you again for this help.

Nate

Gopikrishnan,

Thank you for this information.  The big problem I have is the JavaScript method to pass the information.  I am trying to set this up as an Action.  Thank you again for this help.

Nate