Phfdln - Monday, July 20, 2009 10:32 AM:
Dear all,
In a previous compagny, I used an SAP module that perform a Multi-level extraction of documents.
The main interest is to send a product snapshot that can be used as a base of work.
Is it possible to do the same with Aras? I can't find anything on document extraction...
Thank you in advance
Brian - Wednesday, July 22, 2009 6:49 AM:
Not sure that there is anything out of the box that would allow you to extract all of the documents but you can certainly get a Multi Level Product structure including all Parts and Documents.
From the Table Of Contents select Design. Select Parts. Search for the top level part that you want the structure for. Right click the part and select Product Structure.
This will open a complete multi level hierarchy including all Documents and associated Files.
Is that what you are looking for?
Cheers,
Brian.
Phfdln - Wednesday, July 22, 2009 10:37 AM:
Thank you for your answer!
I have already look at the structure browser (for part only, I can't have a product brower in my menus).
Currently, it's not easy to export a BOM structure... and to check documents.
I think that what I'm looking for is not existing currently, so I will try to create a new report type: Multilevel BOM for part and documents (the data query will be the easy part then the paging will be a little bit hardest).
Cheers,
Pierre-Henri
RobMcAveney - Wednesday, July 22, 2009 12:23 PM:
Try this for the query:
<Item type="Part" action="GetItemRepeatConfig" select="item_number,name" id="{@id}">
<Relationships>
<Item type="Part BOM" repeatProp="related_id" repeatTimes="0" select="sort_order,quantity,related_id(item_number,name)"/>
<Item type="Part Document" select="sort_order,related_id(item_number,name,major_rev)"/>
</Relationships>
</Item>
and here is a simple stylesheet to display it:
<xsl:stylesheet version="1.0" xmlns:xsl="www.w3.org/.../Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:aras="www.aras-corp.com">
<xsl:output method="html" omit-xml-declaration="yes" standalone="yes" indent="yes"></xsl:output>
<xsl:template match="/">
<html>
<style>
td {border:1px #000000 solid; }
table {empty-cells:show; border-collapse:collapse; border-style:solid; border-width:1;}
th {border:1px #000000 solid; text-align:center; font-weight: bold;}
</style>
<table>
<tr>
<th>Level</th>
<th>Type</th>
<th>Number</th>
<th>Name</th>
<th>Revision</th>
<th>Quantity</th>
</tr>
<xsl:apply-templates select="//Item[@type='Part' or @type='Document']"/>
</table>
</html>
</xsl:template>
<xsl:template match="Item">
<tr>
<td><xsl:value-of select="count(ancestor::Relationships)"/></td>
<td><xsl:value-of select="@type"/></td>
<td><xsl:value-of select="item_number"/></td>
<td><xsl:value-of select="name"/></td>
<td><xsl:value-of select="revision"/></td>
<td><xsl:value-of select="../../quantity"/></td>
</tr>
</xsl:template>
</xsl:stylesheet>
If you want paging, you're probably better off using Reporting Services. I can provide a sample SQL query to do the same as above if you need it.
Rob
Phfdln - Wednesday, July 22, 2009 12:32 PM:
Wow, That works really well! And yous query is so simple (compared to what I had done since one hour...)
Thank you very much!
If you have an idea about document extraction...
Pierre-Henri
RobMcAveney - Wednesday, July 22, 2009 12:42 PM:
By "document extraction" do you mean putting all the files attached to the documents into a single folder? Or providing links to the files? Give me a little more detail and I'll see what I can do to help.
Rob
Phfdln - Wednesday, July 22, 2009 12:50 PM:
I mean putting it into a folder / inside a folder organisation like the BOM.
Currently, if I want to get a part design file / specification, I need to view it and then save it on local... If I want to send a part definition, it can take a lot of time to open each file and save it on local machine...
Thank you
Pierre-Henri
Ron - Wednesday, July 22, 2009 1:04 PM:
Hi Pierre
What you are asking for is very possible, I had the folks at Aras write a method to do exacly what you are looking for. The method will blow thru the entrie BOM structure and extract all related documents including AML data sheets and place copies of these into your working folder.
you can contact me directly and I will send you the code.
rvdijk - Wednesday, November 21, 2012 6:01 AM:
Hi Ron,
I am very much interested in this method you mention.
Can I also get a copy of this code?
Thanks an best regards,
Rob
vasant - Wednesday, November 21, 2012 6:17 AM:
Hi Rob,
For this type of utility go to below url:
www.steepgraph.com/.../
and click on "Download Utilities" and select "Download CAD Structure" Utitlity for download code.
It will popup a form for registartion and then send you the code for the same to your email address.
This utility extracts all Parts and downloads all attached documents in same structured manner into user's working directory.
Thanks,
Vasant
