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
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.
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).
Pierre-Henri
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="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:aras="http://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
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...
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.
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
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.