Bolt mto (bolt report) macro

Dear friends

I would be thankful if anyone could send me a macro through which I could extract Line wise BOLT MTO from PDMS 12 in different columns including below mentioned items.

1-line No.
2-Bolt spec
3-Bolt size(bore)
4-Bolt length
5-Bolt Description
6-Bolt Material
7-Quantity per line

Thanks for your kind attention and cooperation

 

https://aveva.dev-verintcommunity.com/cfs-file/__key/communityserver-discussions-components-files/1613/266792macBol.mac

Dear Mr. Satish,
kindly so thanks for this file but it's not working.

[COLOR=#222222][FONT=Times New Roman]Hi Mr. Mehrban, good morning.

I would like to know what was the error message!.

Pls note,

Itemcode or sapcode are mentioned in isodraft option file.

If Itemcode is refered from SPREF  then use syntax as follows

$m /c:\temp\macBol.mac  $<'SPREF'$>

else

$m /c:\temp\macBol.mac $<'UDANAME'$>


UDANAME-->if you use UDA for ITEMCODE generation instead of SPREF

if UDANAME is :ITEMCODE then use following syntax

$m /c:\temp\macBol.mac $<':ITEMCODE'$>

here :ITEMCODE is used as default in macro.
[/FONT][/COLOR]

 

Dear Mr. Satish,
thank you very much,
so so thanks

[COLOR=#417394]Dear admin.satish

your macro report bolt with line name
can we report bolt without line name, and sumary automatically?[/COLOR]

Hi,

Sorry, I dont know how to do..

This is coming with line name, good for cross reference.

If you want sumary then take help of ms-excel once it is extracted from pdms.

HI admin.satish!

Your tiny macro runs really good.:calm:
I did some modifications on the path (C:\...) to %pdmsuser%
and some changes in Units and other options.

Thank you for sharing!:joyous:

Hello,
The macro is very good, but I have some problem to get the Bolt mark, which for me is defined like UDA Name.
I've tried and many ways to pick this information but is impossible.
If I'm running the ISODRAFT, I have the relevant mark without problem.
Can you please tell me if there is a way to find which is report template used by the ISODRAFT?

Thank you,