RecursionError with pyinstaller creating an executable file

[Darnok93]

Hello Community,

I can't convert the following code with pyinstaller into an executable file. I also tried to alter my customspec.spec file with:
import sys
sys.setrecursionlimit(5000) # Adjust the recursion limit to a specific value
"""

I always receive a RecursionError:
"A RecursionError (maximum recursion depth exceeded) occurred.
For working around please follow these instructions" ...

My program searches in word files for Ident Pattern and saves them in an excel file, it works if I execute it with a compiler.

The code I want to convert is the following:

import os
from docx import Document
import re
import pandas as pd
import tkinter as tk
from tkinter import filedialog, messagebox

# Get data from word (function)
def get_data_from_word(path_to_file):
    doc_reader = Document(path_to_file)
    data = ""
    try:
        for p in doc_reader.paragraphs:
            data += p.text + "\n"
            for table in doc_reader.tables:
                for row in table.rows:
                    for cell in row.cells:
                        for paragraph in cell.paragraphs:
                            data += paragraph.text + "\n"
    except Exception as e:
        print(f"An error occurred: {e}")
    return data

# Reverse the Idents (function)
def custom_split(identifier):
    reversed_ident = identifier[::-1]
    parts = reversed_ident.split('-', maxsplit=3)

    if len(parts[0]) == 2:
        return parts[3][::-1], parts[2][::-1], parts[1][::-1], parts[0][::-1]
    elif len(parts[0]) == 3:
        return parts[2][::-1], parts[1][::-1], parts[0][::-1]
    else:
        return identifier.split('-')  # No pattern found, split normally

# Separate GUI-related functions
def get_file_path():
    root = tk.Tk()
    root.withdraw()
    return filedialog.askopenfilename(title="Select a Word file", filetypes=[("Word files", "*.docx")])

def save_file_dialog():
    return filedialog.asksaveasfilename(defaultextension=".xlsx", filetypes=[("Excel files", "*.xlsx")], title="Save As")

def show_info(message):
    messagebox.showinfo("Success", message)

def show_warning(message):
    messagebox.showwarning("No Matches", message)

def show_error(message):
    messagebox.showerror("Error", message)

def process_data(extracted_data):
    pattern = r'\b(?:\w+-){2,}\w+\b'
    matches = re.findall(pattern, extracted_data)
    
    if not matches:
        show_warning("No matches found or pattern does not match the expected format.")
    else:
        unique_matches = pd.unique(matches).tolist()
        df = pd.DataFrame(unique_matches, columns=['ident'])
        df[['Dokument', 'Art', 'Teil', 'Vs']] = df['ident'].apply(lambda x: pd.Series(custom_split(x)))

        output_filename = save_file_dialog()

        if output_filename:
            df.to_excel(output_filename, index=False)
            show_info(f"Data exported to '{output_filename}'")
            
            # Open the created Excel file using the default application
            try:
                os.startfile(output_filename)
            except AttributeError:
                # For non-Windows systems or environments that don't support os.startfile()
                import subprocess
                subprocess.run(['xdg-open', output_filename], check=True)
        else:
            show_warning("Something went wrong.")

def process_file():
    file_path = get_file_path()
    if file_path:
        try:
            extracted_data = get_data_from_word(file_path)
            process_data(extracted_data)
        except Exception as e:
            show_error(f"An error occurred: {e}")
    else:
        show_warning("Please select a Word file.")

# Call the function to initiate the process
process_file()

My customspec.spec file looks the following:

from PyInstaller.utils.hooks import collect_submodules

# Define the Python script to be converted into an executable
script = 'C:\\Users\\..

# Set the recursion limit adjustment
recursion_limit_code = """
import sys
sys.setrecursionlimit(5000) 
"""

# PyInstaller spec file configuration
a = Analysis(
    [script],
    pathex=['C:\...
    binaries=[],
    datas=[],
    hiddenimports=collect_submodules(''),  # No specific module mentioned
    hookspath=[],
    runtime_hooks=[],
    excludes=[],
    win_no_prefer_redirects=False,
    win_private_assemblies=False,
    noarchive=False
)

# Insert the recursion limit adjustment code into the beginning of the script
script = recursion_limit_code + '\n' + script

# Add the recursion limit adjustment code to the EXE
exe = EXE(
    a.scripts,
    a.binaries,
    a.zipfiles,
    a.datas,
    [],
    [],
    name='Ident_Extraction_create_the_exe_2',
    debug=False,
    bootloader_ignore_signals=False,
    bootloader_blacklist=None,
    runtime_tmpdir=None,
    console=True,
    strip=False,
    upx=True,
    upx_exclude=[],
    runtime_upx_exclude=[],
    upx_opts=[],
    output=OutBin,
    get_startupinfo=None,
    target_arch=None,
    codesign_identity=None,
    entropy=0.0
)

# Include the recursion limit adjustment code in the final EXE
coll = COLLECT(
    exe,
    a.binaries,
    a.zipfiles,
    a.datas,
    [],
    name='Ident_Extraction_create_the_exe_2',
    debug=False,
    bootloader_ignore_signals=False,
    bootloader_blacklist=None,
    runtime_tmpdir=None,
    console=True,
    strip=False,
    upx=True,
    upx_exclude=[],
    runtime_upx_exclude=[],
    upx_opts=[],
    output=OutColl,
    get_startupinfo=None,
    target_arch=None,
    codesign_identity=None,
    entropy=0.0
)

Thanks for your help :)

[bwoodsend]

Sounds like you're using full blown Anaconda containing every package that pandas shouldn't optionally depend on but does anyway. Even if you got past the recursion error, your application would likely be huge. Build in a clean virtual environment.

[Darnok93]

It worked. Thanks for your patience :)

[rokm]

How on Earth did you end up with that spec file? Did ChatGPT hallucinate it for you?

It's full of non-existing options, and that "Insert the recursion limit adjustment code into the beginning of the script" is just plain wrong.

If you want to raise the recursion limit, you need to add

import sys
sys.setrecursionlimit(5000) 

to the .spec file itself, so that the limit is raised for the PyInstaller's analysis within the same process that is executing the .spec file.

[Darnok93]

I understand my python skript, to be fair, the spec file is chatgtps work. Just getting into it.

I try the virtual environment approach and learn how to set up a proper spec file.

Thanks for your help - Greetings from a beginner.