Thanks both for the tips @DavidSolari @AlfredBaldenweck ! I do have a subtype of DEPT in my feature class, in which the DIVISION field is dependent on. So a user would select a value in DEPT, from which specific domains would be made available in the DIVISION field.
I've looked into the arcpy.da.ListSubtypes (new to this) but am still getting the coded domain value instead of the full domain description from the domain for DIVISION written to the docx.
import arcpy
import docx
from datetime import datetime
import os
# Define the paths
inputfilename = r"C:\Users\USer\Desktop\Table\FieldSummary_TEMPLATE.docx"
outputfolder = r"C:\Users\User\Desktop\Table\GeneratedDocuments"
feature_class = r"C:\Users\User\Documents\ArcGIS\Projects\ACCS\ACCS.gdb\GTAFieldWork"
# Function to replace text in paragraphs and tables
def docx_find_replace_text(doc, old_text, new_text):
for paragraph in doc.paragraphs:
if old_text in paragraph.text:
for run in paragraph.runs:
if old_text in run.text:
run.text = run.text.replace(old_text, new_text)
for table in doc.tables:
for row in table.rows:
for cell in row.cells:
for paragraph in cell.paragraphs:
if old_text in paragraph.text:
for run in paragraph.runs:
if old_text in run.text:
run.text = run.text.replace(old_text, new_text)
# Function to replace text in headers
def docx_find_replace_header(doc, old_text, new_text):
for section in doc.sections:
header = section.header
for paragraph in header.paragraphs:
replace_text_in_paragraph(paragraph, old_text, new_text)
for table in header.tables:
for row in table.rows:
for cell in row.cells:
for paragraph in cell.paragraphs:
replace_text_in_paragraph(paragraph, old_text, new_text)
# Function to replace text in footers
def docx_find_replace_footer(doc, old_text, new_text):
for section in doc.sections:
footer = section.footer
for paragraph in footer.paragraphs:
replace_text_in_paragraph(paragraph, old_text, new_text)
for table in footer.tables:
for row in table.rows:
for cell in row.cells:
for paragraph in cell.paragraphs:
replace_text_in_paragraph(paragraph, old_text, new_text)
# Function to handle fragmented runs in paragraphs
def replace_text_in_paragraph(paragraph, old_text, new_text):
full_text = ''.join(run.text for run in paragraph.runs)
if old_text in full_text:
updated_text = full_text.replace(old_text, new_text)
for run in paragraph.runs:
run.text = ""
if paragraph.runs:
paragraph.runs[0].text = updated_text
# Function to replace the date in the footer
def replace_date_in_footer(doc):
current_date = datetime.now().strftime("%d %B %Y")
docx_find_replace_footer(doc, "<<DATE2>>", current_date)
# Define the mapping between placeholders and feature class fields
field_mapping = {
"<<PROJECT_NAME>>": "PROJECT_NAME",
"<<FIELD_DATE>>": "FIELD_DATE",
"<<ARCH_CREW>>": "ARCH_CREW",
"<<PERMIT>>": "PERMIT",
"<<DIVISION>>": "DIVISION",
"<<METHOD>>": "METHOD",
"<<DIST_EXIST>>": "DIST_EXIST",
"<<DESCRIPTION>>": "DESCRIPTION",
"<<DIST_REQ>>": "DIST_REQ",
"<<HISTORY>>": "HISTORY",
"<<SUB_OB>>": "SUB_OB",
"<<ARCH_OB>>": "ARCH_OB",
"<<REC>>": "REC",
"<<DEPT>>": "DEPT"
}
# Add the subtype field to the fields being queried
subtype_field = "DEPT"
feature_fields = list(field_mapping.values()) + ["last_edited_date", subtype_field]
# Retrieve domain descriptions for the DEPT field
domains = arcpy.da.ListDomains(arcpy.Describe(feature_class).path)
dept_domain = next((d for d in domains if d.name == subtype_field), None)
dept_coded_values = dept_domain.codedValues if dept_domain else {}
# Iterate through the feature class
with arcpy.da.SearchCursor(feature_class, feature_fields) as cursor:
for feature in cursor:
last_edited_date = feature[-2]
subtype_code = feature[-1]
# Skip records with no last_edited_date
if last_edited_date is None:
print("Skipping record with no last_edited_date.")
continue
project_name_index = feature_fields.index("PROJECT_NAME")
project_name = feature[project_name_index]
# Generate output filename
output_filename = os.path.join(outputfolder, f"{project_name}_FieldSummary.docx")
# Check if the document needs to be updated
if os.path.exists(output_filename):
doc_mod_time = datetime.fromtimestamp(os.path.getmtime(output_filename))
if doc_mod_time >= last_edited_date:
print(f"Skipping {output_filename}, already up-to-date.")
continue
# Create or update the document
doc = docx.Document(inputfilename)
for placeholder, field in field_mapping.items():
field_index = feature_fields.index(field)
value = feature[field_index]
# Map DEPT (subtype) to its description
if field == "DEPT" and value in dept_coded_values:
value = dept_coded_values[value]
# Handle DIVISION with subtypes and domains
if field == "DIVISION":
subtype_group = arcpy.da.ListSubtypes(feature_class)
if subtype_code in subtype_group:
subtype_info = subtype_group[subtype_code]
field_values = subtype_info.get("FieldValues", {})
division_info = field_values.get("DIVISION", None)
if isinstance(division_info, tuple) and len(division_info) > 1:
domain_name = division_info[1]
division_domain = next((d for d in domains if d.name == domain_name), None)
if division_domain and value in division_domain.codedValues:
value = division_domain.codedValues[value]
# Replace placeholders in the template
docx_find_replace_text(doc, placeholder, str(value))
if placeholder in ["<<PROJECT_NAME>>", "<<DESCRIPTION>>"]:
docx_find_replace_header(doc, placeholder, str(value))
# Replace the date in the footer
replace_date_in_footer(doc)
# Save the document
doc.save(output_filename)
print(f"Created or updated: {output_filename}")
print("Process completed.")
