topic Re: ADDREPORT DIALOGUE BOX - Scripting & Macros in Fabrication CADmep Forum

ADDREPORT DIALOGUE BOX - Scripting & Macros

Anonymous — Fri, 20 Feb 2015 12:57:02 GMT

Does anyone know if there is a way to use 'Addreport' fully through the command line.

i'm wanting to ultimately create a script to run a certain report in a certain position on several drawings however when using the addreport command the dialogue box always displays.

I am aware that macros can be a added to buttons in the cui of autocad however i would also like to know if a macro can be created inside a script for the same reasons as above.

Re: ADDREPORT DIALOGUE BOX - Scripting & Macros

jmerch — Fri, 20 Feb 2015 13:25:53 GMT

You can do it via LISP and also have LISP execute your script.

(command (addreport "REPORT NAME" (ssget)))

Re: ADDREPORT DIALOGUE BOX - Scripting & Macros

Anonymous — Mon, 23 Feb 2015 09:54:11 GMT

Hi, thanks for the reply. I'm fairly new to scripting and lisp routines so i'm initially just trying to get my head around it and think of process' which can be sped up.

I used what you sent me at the command line and it worked ok. however what i want to ultimately end up with is either a lisp routine or script that lets me create approx 4 different reports on a Model tab then exports them to a specifc location with the dwg name in the title.

Don't know how to do this but any help would be appreicated, as i am trauling through various websites at the moment to try and find out info on lisp routines

Re: ADDREPORT DIALOGUE BOX - Scripting & Macros

jmerch — Mon, 23 Feb 2015 22:51:42 GMT

I totally understand, we've all been there. Here's a question. Why are you concerned with placing the table in CAD then exporting it out? Why not just create a report (using the REPORTS) command and then you can print them to PDF and go from there?

If you're wanting to still create a report in CAD, here's a quick LISP to do such:

(command (addreport "REPORT NAME" (ssget "all") (list pt1 pt2 pt3)))

where "pt1" "pt2" "pt3" are x,y,z coordinates you define eary on in the LISP using (setq pt1 "NUMBER"), etc.

Re: ADDREPORT DIALOGUE BOX - Scripting & Macros

Anonymous — Tue, 24 Feb 2015 08:06:15 GMT

I need the table to be in a format that i can export it to excel (CSV), so i can merge all files to one file then create reports from excel

It must be possible - If only i could surpress the dialogue box when it suggests a location to save the csv file it would be great

I'm happy i can now add reports to a specific location, however i just want to take it a little further.

Re: ADDREPORT DIALOGUE BOX - Scripting & Macros

davidronson — Wed, 04 Mar 2015 14:51:43 GMT

With Bluebeam you can export a pdf report into Excel. I believe you can also do this with Adobe. We do it all the time here. Maybe someday Autodesk will make it possible to send our reports straight to Excel. One can always hope!

Re: ADDREPORT DIALOGUE BOX - Scripting & Macros

MOatman — Mon, 04 May 2015 12:36:43 GMT

What about CSVEXPORT command in Fabrication CADMEP?

Re: ADDREPORT DIALOGUE BOX - Scripting & Macros

cam-nav — Tue, 10 May 2016 14:35:42 GMT

CSVEXPORT can be used like ADDREPORT in LISP form so you can setup a CSV report and call it using (csvexport "report name").

This would be your automation and export to Excel all in one.