I have multiple blocks (always) containing an attribute (called type) and (sometimes) a visibility (called kleur).
All blocknames start with ID-, EX-, EP- or EW-. I use these blocks to make an assembly. After assembling I need to export the number of blocks per block, the attribute and the visibility to excel. To accomplish that I use the data extraction tool:
It's a lot of clicks for everytime the same settings. Is it possible to do this faster?
Looks like a job for Python, Pandas and ExcelWriter, This should get nested blocks
import traceback
from pyrx_imp import Ap, Db, Ed, Ge, Gi, Gs, Rx
import pandas as pd
def PyRxCmd_doit():
try:
propname = "Visibility1"
namefilter = ("ID-", "EX-", "EP-", "EW-", "Limit")
blockmap = {"Name": [], "State": [], "QTY": []}
db = Db.curDb()
bt = Db.BlockTable(db.blockTableId())
for btrid in bt.toDict().values():
btr = Db.DynBlockTableRecord(btrid)
if not btr.isDynamicBlock():
continue
refids = []
for anon in [Db.BlockTableRecord(id) for id in btr.getAnonymousBlockIds()]:
refids.extend(anon.getBlockReferenceIds())
for ref in [Db.BlockReference(id) for id in refids]:
name = ref.getBlockName()
if not name.startswith(namefilter):
continue
dynref = Db.DynBlockReference(ref.objectId())
props = dynref.getBlockProperties()
for prop in props:
if not prop.propertyName() == propname:
continue
blockmap["Name"].append(name)
blockmap["State"].append(prop.value().getString())
blockmap["QTY"].append(1)
df = pd.DataFrame(blockmap)
gdf = df.groupby(["Name", "State"], sort=False, as_index=False).agg(
{"QTY": "sum"}
)
with pd.ExcelWriter("e:\\pandas_to_excel.xlsx") as writer:
gdf.to_excel(writer, sheet_name="sheet1", index=False)
except Exception as err:
traceback.print_exception(err)
The 3 line result is from ExportAtts.lsp which is NOT my code, @BeekeeCZ wrote that, I just typed it up for you.
ExportAV.lsp is my code and it results in 4 columns, 31 rows (see below):
The reason "TYPE" Attributes are missing is because nearly all blocks have their Attribute Definition with the property "Constant" enabled, which (to my knowledge) doesn't allow its value to be retrieved outside the block. You have to instead retrieve the value by examining each and every entity within the Block Definition until you find the Attribute Definition entity. It's not difficult, it's just that my code doesn't currently do this. Also, your blocks have a variety of names for their dynamic block Visibility Parameter, you specified "kleur" so that is all that is being searched. Any Visibility not named "kleur" is ignored. I saw one or more blocks with a Visibility parameters named "Type" (not an attribute but a visibility parameter), I don't know if you expected the state of these visibility parameters named "Type" to be entered under "Type" column, but my code is not currently doing this either.
Again, I want to be upfront, we could get my ExportAV.lsp to correctly compile the data but I'm assuming someone else is pulling this all together for you, am I correct?
