ADDREPORT DIALOGUE BOX - Scripting & Macros

Anonymous · ‎02-20-2015

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.

jmerch · ‎02-20-2015

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

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

Anonymous · ‎02-23-2015

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

jmerch · ‎02-23-2015

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.

Anonymous · ‎02-24-2015

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.

davidronson · ‎03-04-2015

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!

______________________________________________
Don't forget to "Accept As Solution" and "Give Kudos" when an acceptable solution has been given.
|| LinkedIn || LinkedIn Fabrication Group ||

MOatman · ‎05-04-2015

What about CSVEXPORT command in Fabrication CADMEP?

cam-nav · ‎05-10-2016

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.