Prioritize Reference Files 6e4111

Read all relevant reference files before any web searches:

# Example: Read provided Excel file
file_content = read_file(file_path="Massabama active listings.xlsx", filetype="xlsx")

# Example: Read provided CSV
file_content = read_file(file_path="data.csv", filetype="csv")

# Example: Read provided PDF
file_content = read_file(file_path="report.pdf", filetype="pdf")

Important: Handling DOCX Read Failures

If read_file(filetype='docx') fails with an error (common issue), use this fallback method:

# Method 1: Unzip and parse XML directly (docx is a zip archive)
mkdir -p temp_docx && cd temp_docx
unzip -o ../document.docx
# Extract text from word/document.xml
cat word/document.xml | grep -oP '(?<=>)[^<>]+' > extracted_text.txt

# Method 2: Use python-docx via shell
run_shell(command="python -c \"from docx import Document; doc = Document('document.docx'); print('\n'.join([p.text for p in doc.paragraphs]))\"")

# Method 3: Use shell_agent for robust extraction
extraction_result = shell_agent(task="Extract all text content from document.docx using any reliable method (unzip+XML, python-docx, or pandoc)")

After extracting via fallback:

1. Verify the extracted content is complete and readable
2. Proceed to use this extracted data as your reference file content
3. Continue with Step 3 (Extract and Validate Data) using the fallback-extracted content

Step 3: Extract and Validate Data

• Extract structured data from the reference files
• Verify the data is complete and relevant to your task
• Map the file data to your required output format

Step 4: Use Reference Data as Primary Source

• Populate outputs using data from reference files
• Cite the reference files when using their data
• Only mark data as "to be verified" if reference files are incomplete

Step 5: Search Web Only When Necessary

Web searches should only occur when:

• Reference files do not contain the needed information
• You need to verify or supplement reference file data
• The task explicitly requires current/external information

# Decision flow example
if has_reference_file("listings.xlsx"):
    data = extract_from_excel("listings.xlsx")
    # Use this data for output