running a script from a .set file???? from automatic reports

[Anonymous]

Hi All,

Currently using automatic reports (.rgf file) to create a tag-bom and comp output to an excel file.

I want to also add in a drawing list report which for reasons only known to Autodesk isnt included in the automatic reports function.

Using the api command below (which is embedded into a script file), i can get the info i require automatically

(c:ace_dwglst_rpt_dbx (nth 5 (c:wd_proj_wdp_data)) "C:/PID SCHEDULE/dwglst.set" t)

The question is can this script file be invoked from within the .set files in the automatic reports function.

i.e. 

the comp.set file looks thus:

Report = Component
Format = (1 11 12 39 15 21 22 )
Title = ("ITEM" "TAGNAME" "CNT" "UNITS" "SUBQTY" "MFG" "CAT" "DESC1" "DESC2" "DESC3" "REF" "INST" "LOC" "RATING1" "RATING2" "RATING3" "RATING4" "RATING5" "RATING6" "RATING7" "RATING8" "RATING9" "RATING10" "RATING11" "RATING12" "CATDESC" "QUERY1" "QUERY2" "MISC1" "MISC2" "USER1" "USER2" "USER3" "P1C2" "WDBLKNAM" "BLOCK" "HDL" "CATEGORY" "ASSYCODE" "SH" "SHDWGNAM" "SEC" "SUBSEC" "FAMILY" "WDTAGALT" "WDTYPE" "FILENAME" )
Title UDA = ("POS" "TYPE" "CUB1" "CUB2" "CUB3" "CUB4" "OREF" "OTYPE" "ODUTY" "OVOLTAGE" "OFLC" "OKW" "OTAG" "ONETWORK" "ONODE" "ODOOR" )
Tag UDA = ("CONN" "TYPE" "CUBREF#1" "CUBREF#2" "CUBREF#3" "CUBREF#4" "OREF" "OTYPE" "ODUTY" "OVOLTAGE" "OFLC" "OKW" "OTAG" "ONETWORK" "ONODE" "ZDOOR" )
Characters = (3 15 3 3 3 3 3 3 3 3 3 4 4 3 3 13 3 3 3 3 3 7 8 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 )
Characters UDA = (3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 )
Justification = ("R" "L" "R" "L" "R" "L" "L" "L" "L" "L" "R" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" "L" )
Justification UDA = ("ML" "ML" "ML" "ML" "ML" "ML" "ML" "ML" "ML" "ML" "ML" "ML" "ML" "ML" "ML" "ML" )
Sorting = (1 34 13 13 )
Output File Type = XLS
Output File Name = "c:/pid schedule/comp.xls"
Include Options = ("0" "0" "1" "1" "1" "1" "0" "0" "0" "0" "0" "0" "0" "0" "PI" "0" )
Location Options = (nil nil )
Installation Options = (1 "" )

can the script be tagged on the end anyway??

thanks in advance!

Chris

[VinodBalasubramanian]

I don't think its possible to run a script from within a set file. 

Copying @zhonghua.shou 

[Anonymous]

Ok, your familiar with AutoLISP... so...

User Post...

Looks like with enough fiddling... you can make it do the user post for the relevant report.

You can get the filename of the excel file (fnam) and then post process it anyway you can code it to.

there are helpful APIs to work with the excel file, and for getting information out of the project database.

Once you master those tools... the force will be strong with you.

[Anonymous]

another thought...

Looks like you have a set filename... probably a set file location relevant to the WDP file location...

Many of the reports will report the "sheet" value, you could use the API "(c:wd_proj_wdp_data)" to get the filename for that sheet value...

Or the DWGIX value if it reports the DWGIX you can get at the database to get what the filename is for the DWGIX, there's a table just for that (PDS_DWGINDEX).

then just use the other APIs to alter the excel spreadsheet with the filename instead of the sheet/dwgix number

Lots of opportunities...

may the force be with you