Export / Import connector attributes
IMHO, not sure it’s right for you, but with 100s of drawings, you might consider using more robust tooling
With something like pandas, which is designed for data analysis and manipulation, you may de able to do your ‘wholesale changes’ with automation.
Just throwing this out there as an idea
from pyrx_imp import Rx, Ge, Gi, Db, Ap, Ed
import traceback
import pandas as pd
import openpyxl # for pandas
def processAttributes(path, db, blkname, data):
bt = Db.BlockTable(db.blockTableId())
if not bt.has(blkname):
return
btr = Db.BlockTableRecord(bt[blkname])
refs = [Db.BlockReference(id) for id in btr.getBlockReferenceIds()]
for ref in refs:
data["DWG"].append(path)
data["Handle"].append(ref.getHandle().toString())
atts = [Db.AttributeReference(id) for id in ref.attributeIds()]
for att in atts:
tag = att.tag()
if not tag in data:
data[tag] = [att.textString()]
else:
data[tag].append(att.textString())
def processDb(path, blkname, data):
sideDb = Db.Database(False, True)
sideDb.readDwgFile(path)
sideDb.closeInput(True)
processAttributes(path, sideDb, blkname, data)
def PyRxCmd_doit():
try:
# setup data
data = {"DWG": [], "Handle": []}
# setup dwg
blkName = "HCN1_11P_3C0"
path = "E:\\Source.dwg"
processDb(path, blkName, data)
# pandas party
df = pd.DataFrame(data)
print("\nquery results = {}\n..\n".format(df.query('Handle == ["988"]')))
print(df)
# save to excel
df.to_excel("e:\\output.xlsx")
except Exception as err:
traceback.print_exception(err)
