CSV File Error in Console..

[southbayjay]

Getting errors in the console for missing csv file (see pic) but when I check the directory the files are there. Any idea how to fix this?

Error. No naistyles.csv found. Put your naistyles.csv in the custom_nodes/ComfyUI_NAI-mod/CSV directory of ComfyUI. Then press "Refresh".

[curreta]

Just had this issue personally.

I believe the message is being caused due to a combination of ComfyUI Manager (which pulls extension-node-map.json).

extension-node-map.json (or something down that way) contains:

This repo on line https://github.com/KoreTeknology/ComfyUI-Universal-Styler/blob/main/naistyler_nodes.py#L261 appears to be using some names from other existing custom_node packages. (e.g. ShowText|pysssss)

[curreta]

More info. So what I think happened, is that this was installed because I used the "Install all missing" from a previous workflow on a fresh install. ShowText|pysssss was a node I used, and then it installed and then tried to use this package.

[thomaswan]

#1 (comment)

read this

[southbayjay]

#1 (comment)

read this

I don't understand what the solution is? I've got the error on my windows and linux machines.

[thomaswan]

#1 (comment)
read this

I don't understand what the solution is? I've got the error on my windows and linux machines.

it is about the root cause.

[tobylewis]

The problem looks like the name of the node has been changed from "ComfyUI-NAI-styler" to "ComfyUI-Universal-Styler". The code is still referring to the path along the old name. The code sets up the path at the top with
DATAPATH = BASE_DIR.joinpath("custom_nodes","ComfyUI-NAI-styler","CSV")
but then fails to use the constant and restates the old path in the errors or more importantly in the
def INPUT_TYPES(cls):
cls.naistyles_csv = cls.load_naistyles_csv(os.path.join(folder_paths.base_path, "custom_nodes\ComfyUI-NAI-styler\CSV\naifilters.csv"))

This whole node needs work to make it usable and the readme needs to actually explain how any of this is supposed to work.

[jokerfree]

在你的插件库中把ComfyUI-Universal-Styler文件夹中的所有ComfyUI-NAI-styler替换成ComfyUI-Universal-Styler，就可以解决。
猜测是作者上传代码的时候脑子一激灵给他的工程改了个漂亮的名字，却忘记了他代码中写死的文件路径，这是一个不负责任的作者。

[chinamaler]

Modify "ComfyUI-NAI-styler" in "naistyler_nodes.py" to "ComfyUI-Universal-Styler"

[ricperry]

This node is completely broken for me. Even fixing the folder path name didn't work. This node is a mess.

[rugabunda]

Modify "ComfyUI-NAI-styler" in "naistyler_nodes.py" to "ComfyUI-Universal-Styler"

It worked temporarily but I had to repeat this every single time i checked for updates in comfy ui... This bug causes a delay in the load time when refreshing the browser tab. I disabled this node because its such a mess and the maintainer hasn't fixed it.

It shouldn't be listed in comfy ui managers repos if its not kept

[Piscabo]

This is so annoying that I fix it and every time I update my Comfy, it breaks my fix. Removing this node for good...

[rafstahelin]

same

[pif41982]

naistyler_nodes - Copie.txt
The debug (by me) file rename in naistyler_nodes.py

[eiddor]

There's already a PR to fix this in #6 - Just use that fork for now until the author has a chance to merge it.

[ImmortalPie]

I just ran into this also, ended up trying to fix it myself only as I'm still learning this stuff.
My quick fix was to open up naistyler_nodes.py using notepad++, then find and replace all ComfyUI-NAI-styler with ComfyUI-Universal-Styler and the errors are gone.
I will say I am only using the get text node in my workflow so the error has not affected me at all, just stops the error.

[jonny7737]

I have partially corrected the code (not all logging is fixed) but this should get past the loading errors:

naistyler_nodes.py:

import os
import re
import folder_paths

from pathlib import Path

#DEBUG pathlib (to replace folder_path from OS)
print(Path.cwd())
print("############################################")
BASE_DIR = Path.cwd()
DATAPATH = BASE_DIR.joinpath("custom_nodes","ComfyUI-Universal-Styler","CSV")
print(DATAPATH)
print("############################################")
my_database = [str(file) for file in DATAPATH.glob("*.csv")]
print(my_database)
print("############################################")


################
# NAI Show text v0.3 ##########################################################################
################

class ShowText:
    @classmethod
    def INPUT_TYPES(s):
        return {
            "required": {
                "text": ("STRING", {"forceInput": True}),
            },
            "hidden": {
                "unique_id": "UNIQUE_ID",
                "extra_pnginfo": "EXTRA_PNGINFO",
            },
        }

    INPUT_IS_LIST = True
    RETURN_TYPES = ("STRING",)
    FUNCTION = "notify"
    OUTPUT_NODE = True
    OUTPUT_IS_LIST = (True,)

    CATEGORY = "✴️ Universal NAI Nodes"

    def notify(self, text, unique_id=None, extra_pnginfo=None):
        if unique_id is not None and extra_pnginfo is not None:
            if not isinstance(extra_pnginfo, list):
                print("Error: extra_pnginfo is not a list")
            elif (
                not isinstance(extra_pnginfo[0], dict)
                or "workflow" not in extra_pnginfo[0]
            ):
                print("Error: extra_pnginfo[0] is not a dict or missing 'workflow' key")
            else:
                workflow = extra_pnginfo[0]["workflow"]
                node = next(
                    (x for x in workflow["nodes"] if str(x["id"]) == str(unique_id[0])),
                    None,
                )
                if node:
                    node["widgets_values"] = [text]

        return {"ui": {"text": text}, "result": (text,)}


################
# NAI STYLER v0.3 ##########################################################################
################

class NaiStylerComplexCSVLoader:

    # Part 1
    
    @staticmethod
    def load_naistyles_csv(naistyles_path: str):
        """Loads csv file, Ignore the first row (header).
        Returns:
            list: List of naistyles. Each style is a dict with keys: style_name and value: [positive_prompt, negative_prompt]
        """
        naistyles = {"Error loading naistyles.csv, check the console": ["",""]}
        if not os.path.exists(naistyles_path):
            print(f"""Error. No naistyles.csv found. Put your naistyles.csv in the  {DATAPATH} directory of ComfyUI. Then press "Refresh".
                  Your current root directory is: {folder_paths.base_path}
                  Looked for naistyles.csv in: {naistyles_path}
            """)
            return naistyles
        try:
            with open(naistyles_path, "r", encoding="utf-8") as f:    
                naistyles = [[x.replace('"', '').replace('\n','') for x in re.split(',(?=(?:[^"]*"[^"]*")*[^"]*$)', line)] for line in f.readlines()[1:]]
                naistyles = {x[0]: [x[1],x[2]] for x in naistyles}
        except Exception as e:
            print(f"""Error loading naistyles.csv. Make sure it is in the {DATAPATH} directory of ComfyUI. Then press "Refresh".
                    Your current root directory is: {folder_paths.base_path}
                    Error: {e}
            """)
        return naistyles
    
    # part 2

    @staticmethod
    def load_naifilters_csv(naifilters_path: str):
        """Loads filtercsv file, Ignore the first row (header).
        Returns:
            list: List of naistyles. Each style is a dict with keys: style_name and value: [positive_prompt, negative_prompt]
        """
        naifilters = {"Error loading naistyles.csv, check the console": ["",""]}
        if not os.path.exists(naifilters_path):
            print(f"""Error. No naistyles.csv found. Put your naifilters.csv in the {DATAPATH} directory of ComfyUI. Then press "Refresh".
                  Your current root directory is: {folder_paths.base_path}
                  Looked for naifilters.csv in: {naifilters_path}
            """)
            return naifilters
        try:
            with open(naifilters_path, "r", encoding="utf-8") as f:    
                naifilters = [[x.replace('"', '').replace('\n','') for x in re.split(',(?=(?:[^"]*"[^"]*")*[^"]*$)', line)] for line in f.readlines()[1:]]
                naifilters = {x[0]: [x[1],x[2]] for x in naifilters}
        except Exception as e:
            print(f"""Error loading naistyles.csv. Make sure it is in the {DATAPATH} directory of ComfyUI. Then press "Refresh".
                    Your current root directory is: {folder_paths.base_path}
                    Error: {e}
            """)
        return naifilters
    
    # part 3

    @staticmethod
    def load_naitypes_csv(naitypes_path: str):
        """Loads filtercsv file, Ignore the first row (header).
        Returns:
            list: List of naistyles. Each style is a dict with keys: style_name and value: [positive_prompt, negative_prompt]
        """
        naitypes = {"Error loading naistyles.csv, check the console": ["",""]}
        if not os.path.exists(naitypes_path):
            print(f"""Error. No naistyles.csv found. Put your naitypes.csv in the {DATAPATH} directory of ComfyUI. Then press "Refresh".
                  Your current root directory is: {folder_paths.base_path}
                  Looked for naitypes.csv in: {naitypes_path}
            """)
            return naitypes
        try:
            with open(naitypes_path, "r", encoding="utf-8") as f:    
                naitypes = [[x.replace('"', '').replace('\n','') for x in re.split(',(?=(?:[^"]*"[^"]*")*[^"]*$)', line)] for line in f.readlines()[1:]]
                naitypes = {x[0]: [x[1],x[2]] for x in naitypes}
        except Exception as e:
            print(f"""Error loading naitypes.csv. Make sure it is in the {DATAPATH} directory of ComfyUI. Then press "Refresh".
                    Your current root directory is: {folder_paths.base_path}
                    Looked for naitypes.csv in: {naitypes_path}
                    Error: {e}
            """)
        return naitypes
        
    # Data
    
    @classmethod
    def INPUT_TYPES(cls):
        cls.naistyles_csv = cls.load_naistyles_csv(os.path.join(folder_paths.base_path, "custom_nodes/ComfyUI-Universal-Styler/CSV/naifilters.csv"))
        cls.naifilters_csv = cls.load_naifilters_csv(os.path.join(folder_paths.base_path, "custom_nodes/ComfyUI-Universal-Styler/CSV/naistyles.csv"))
        cls.naitypes_csv = cls.load_naitypes_csv(os.path.join(folder_paths.base_path, "custom_nodes/ComfyUI-Universal-Styler/CSV/naitypes.csv"))
        return {
            "required": {
                #"mute": (["On", "Off"],),
                "naifilters": (list(cls.naistyles_csv.keys()),),
                "naistyles": (list(cls.naifilters_csv.keys()),),
                "naitypes": (list(cls.naitypes_csv.keys()),),
                #"clip": ("CLIP", ),
            },                      
        }

    RETURN_TYPES = ("STRING","STRING")
    RETURN_NAMES = ("Full prompt","Short prompt")
    FUNCTION = "execute"
    CATEGORY = "✴️ Universal NAI Nodes"   

    def execute(self, naistyles, naifilters, naitypes):
            return str(self.naistyles_csv[naistyles][0], self.naistyles_csv[naistyles][1],self.naifilters_csv[naifilters][0], self.naifilters_csv[naifilters][1],self.naitypes_csv[naitypes][0], self.naitypes_csv[naitypes][1],)

################
# NAI STYLER v0.1 ##########################################################################
################

class NaiStyler:
    """
    A new custom node
    """

    def __init__(self):
        pass
    
    @classmethod
    def INPUT_TYPES(s):
        """
            All param and values
        """
        return {
            "required": {
                "clip": ("CLIP", ),
                "mute": (["On", "Off"],),
                "mix": ("INT", {
                    "default": 50, 
                    "min": 0, 
                    "max": 100, 
                    "step": 1,
                    "display": "slider" #"number" or "slider"
                }),
                "float_field": ("FLOAT", {
                    "default": 0.5,
                    "min": 0.0,
                    "max": 1.0,
                    "step": 0.01,
                    "round": 0.001,
                    "display": "slider"}),
                "string_field": ("STRING", {
                    "multiline": True,
                    "default": "Define Object"
                }),
                "string_field2": ("STRING", {
                    "multiline": True, 
                    "default": "Define Background"
                }), 
            },
        }

    RETURN_TYPES = ("CONDITIONING","STRING","STRING","INT")
    RETURN_NAMES = ("Compiled prompt","Value","Value2","mix")
    FUNCTION = "test"
    #OUTPUT_NODE = False
    CATEGORY = "✴️ Universal NAI Nodes"

    def test(self, string_field, string_field2, mix, float_field, mute):
        if mute == "On":
            print(f"""Your input contains:
                string_field aka input text: {string_field}
                int_field: {mix}
                float_field: {float_field}
            """)

################
# NAI concat v0.1 ##########################################################################
################

class ConcatenateFields:     

    @classmethod
    def INPUT_TYPES(cls):
               
        return {"required": {       
                    "text1": ("STRING", {"multiline": False, "default": "Hello"}),
                    "text2": ("STRING", {"multiline": False, "default": "World"}),
                    }
                }

    RETURN_TYPES = ("STRING",)
    FUNCTION = "concatenate_text"
    CATEGORY = "✴️ Universal NAI Nodes"

    def concatenate_text(self, text1, text2):

        text_out = text1 + " " + text2
        
        return (text_out,)

################
# NODES MAPPING ##########################################################################
################

NODE_CLASS_MAPPINGS = {
    "ShowText|pysssss": ShowText,
    "Load Nai Styles Complex CSV": NaiStylerComplexCSVLoader,
    "Universal_Styler_Node": NaiStyler,
    "concat": ConcatenateFields,
}
NODE_DISPLAY_NAME_MAPPINGS = {
    "ShowText|pysssss": "✴️ U-NAI Get Text",
    "Load Nai Styles Complex CSV": "✴️ U-NAI Styles Launcher",
    "Universal_Styler_Node": "✴️ U-NAI Styler - v0.2.1",
    "concat": "✴️ U-NAI Fields Concatenate",
}

[jonny7737]

The main problem seems to be in the v0.3 definition of INPUT_TYPES. The file paths do not seem to be defined correctly.

[annnguyen]

I came across this error while running on a Linux machine. I just created a pull request (above).

• Use of pathlib more liberally for it to be OS agnostic
• Fixes the ComfyUI-NAI-styler path
• Cleans up the logging to refer to the correct csv file it's referencing.

[qq13998239]

import os
import re
import folder_paths
from pathlib import Path

强制设置 base_path 为 E:\comfyui

folder_paths.base_path = "E:\comfyui"

调试路径

print(f"folder_paths.base_path: {folder_paths.base_path}")

构建 CSV 文件路径

BASE_DIR = Path.cwd()
DATAPATH = BASE_DIR.joinpath("custom_nodes", "ComfyUI-Universal-Styler", "CSV")
my_database = [str(file) for file in DATAPATH.glob("*.csv")]

打印路径以调试

print(f"当前工作目录: {Path.cwd()}")
print(f"BASE_DIR: {BASE_DIR}")
print(f"DATAPATH: {DATAPATH}")
print(f"CSV 文件列表: {my_database}")

################

NAI Show text v0.3

################

class ShowText:
@classmethod
def INPUT_TYPES(s):
return {
"required": {
"text": ("STRING", {"forceInput": True}),
},
"hidden": {
"unique_id": "UNIQUE_ID",
"extra_pnginfo": "EXTRA_PNGINFO",
},
}

INPUT_IS_LIST = True
RETURN_TYPES = ("STRING",)
FUNCTION = "notify"
OUTPUT_NODE = True
OUTPUT_IS_LIST = (True,)

CATEGORY = "✴️ Universal NAI Nodes"

def notify(self, text, unique_id=None, extra_pnginfo=None):
    if unique_id is not None and extra_pnginfo is not None:
        if not isinstance(extra_pnginfo, list):
            print("Error: extra_pnginfo is not a list")
        elif (
                not isinstance(extra_pnginfo[0], dict)
                or "workflow" not in extra_pnginfo[0]
        ):
            print("Error: extra_pnginfo[0] is not a dict or missing 'workflow' key")
        else:
            workflow = extra_pnginfo[0]["workflow"]
            node = next(
                (x for x in workflow["nodes"] if str(x["id"]) == str(unique_id[0])),
                None,
            )
            if node:
                node["widgets_values"] = [text]

    return {"ui": {"text": text}, "result": (text,)}

################

NAI STYLER v0.3

################

class NaiStylerComplexCSVLoader:

@staticmethod
def load_naistyles_csv(naistyles_path: str):
    """Loads csv file, Ignore the first row (header)."""
    naistyles = {"Error loading naistyles.csv, check the console": ["", ""]}
    if not os.path.exists(naistyles_path):
        print(f"""Error. No naistyles.csv found. Put your naistyles.csv in the custom_nodes/ComfyUI-Universal-Styler/CSV directory of ComfyUI. Then press "Refresh".
              Your current root directory is: {folder_paths.base_path}
        """)
        return naistyles
    try:
        with open(naistyles_path, "r", encoding="utf-8") as f:
            naistyles = [
                [x.replace('"', '').replace('\n', '') for x in re.split(',(?=(?:[^"]*"[^"]*")*[^"]*$)', line)] for
                line in f.readlines()[1:]]
            naistyles = {x[0]: [x[1], x[2]] for x in naistyles}
    except Exception as e:
        print(f"""Error loading naistyles.csv. Make sure it is in the custom_nodes/ComfyUI-Universal-Styler/CSV directory of ComfyUI. Then press "Refresh".
                Your current root directory is: {folder_paths.base_path}
                Error: {e}
        """)
    return naistyles

@staticmethod
def load_naifilters_csv(naifilters_path: str):
    """Loads filter csv file, Ignore the first row (header)."""
    naifilters = {"Error loading naifilters.csv, check the console": ["", ""]}
    if not os.path.exists(naifilters_path):
        print(f"""Error. No naifilters.csv found. Put your naifilters.csv in the custom_nodes/ComfyUI-Universal-Styler/CSV directory of ComfyUI. Then press "Refresh".
              Your current root directory is: {folder_paths.base_path}
        """)
        return naifilters
    try:
        with open(naifilters_path, "r", encoding="utf-8") as f:
            naifilters = [
                [x.replace('"', '').replace('\n', '') for x in re.split(',(?=(?:[^"]*"[^"]*")*[^"]*$)', line)] for
                line in f.readlines()[1:]]
            naifilters = {x[0]: [x[1], x[2]] for x in naifilters}
    except Exception as e:
        print(f"""Error loading naifilters.csv. Make sure it is in the custom_nodes/ComfyUI-Universal-Styler/CSV directory of ComfyUI. Then press "Refresh".
                Your current root directory is: {folder_paths.base_path}
                Error: {e}
        """)
    return naifilters

@staticmethod
def load_naitypes_csv(naitypes_path: str):
    """Loads type csv file, Ignore the first row (header)."""
    naitypes = {"Error loading naitypes.csv, check the console": ["", ""]}
    if not os.path.exists(naitypes_path):
        print(f"""Error. No naitypes.csv found. Put your naitypes.csv in the custom_nodes/ComfyUI-Universal-Styler/CSV directory of ComfyUI. Then press "Refresh".
              Your current root directory is: {folder_paths.base_path}
        """)
        return naitypes
    try:
        with open(naitypes_path, "r", encoding="utf-8") as f:
            naitypes = [
                [x.replace('"', '').replace('\n', '') for x in re.split(',(?=(?:[^"]*"[^"]*")*[^"]*$)', line)] for
                line in f.readlines()[1:]]
            naitypes = {x[0]: [x[1], x[2]] for x in naitypes}
    except Exception as e:
        print(f"""Error loading naitypes.csv. Make sure it is in the custom_nodes/ComfyUI-Universal-Styler/CSV directory of ComfyUI. Then press "Refresh".
                Your current root directory is: {folder_paths.base_path}
                Error: {e}
        """)
    return naitypes

@classmethod
def INPUT_TYPES(cls):
    # 构建 CSV 文件路径
    naistyles_path = os.path.join(folder_paths.base_path, "custom_nodes", "ComfyUI-Universal-Styler", "CSV",
                                  "naistyles.csv")
    naifilters_path = os.path.join(folder_paths.base_path, "custom_nodes", "ComfyUI-Universal-Styler", "CSV",
                                   "naifilters.csv")
    naitypes_path = os.path.join(folder_paths.base_path, "custom_nodes", "ComfyUI-Universal-Styler", "CSV",
                                 "naitypes.csv")

    # 打印路径以调试
    print(f"naistyles_path: {naistyles_path}")
    print(f"naifilters_path: {naifilters_path}")
    print(f"naitypes_path: {naitypes_path}")

    # 加载 CSV 文件
    cls.naistyles_csv = cls.load_naistyles_csv(naistyles_path)
    cls.naifilters_csv = cls.load_naifilters_csv(naifilters_path)
    cls.naitypes_csv = cls.load_naitypes_csv(naitypes_path)

    return {
        "required": {
            "naifilters": (list(cls.naifilters_csv.keys()),),
            "naistyles": (list(cls.naistyles_csv.keys()),),
            "naitypes": (list(cls.naitypes_csv.keys()),),
        },
    }

RETURN_TYPES = ("STRING", "STRING")
RETURN_NAMES = ("Full prompt", "Short prompt")
FUNCTION = "execute"
CATEGORY = "✴️ Universal NAI Nodes"

def execute(self, naistyles, naifilters, naitypes):
    full_prompt = (
            self.naistyles_csv[naistyles][0] + " " +
            self.naifilters_csv[naifilters][0] + " " +
            self.naitypes_csv[naitypes][0]
    )
    short_prompt = (
            self.naistyles_csv[naistyles][1] + " " +
            self.naifilters_csv[naifilters][1] + " " +
            self.naitypes_csv[naitypes][1]
    )
    return (full_prompt, short_prompt)

################

NAI STYLER v0.1

################

class NaiStyler:
"""
A new custom node
"""

def __init__(self):
    pass

@classmethod
def INPUT_TYPES(s):
    """
        All param and values
    """
    return {
        "required": {
            "clip": ("CLIP",),
            "mute": (["On", "Off"],),
            "mix": ("INT", {
                "default": 50,
                "min": 0,
                "max": 100,
                "step": 1,
                "display": "slider"  # "number" or "slider"
            }),
            "float_field": ("FLOAT", {
                "default": 0.5,
                "min": 0.0,
                "max": 1.0,
                "step": 0.01,
                "round": 0.001,
                "display": "slider"}),
            "string_field": ("STRING", {
                "multiline": True,
                "default": "Define Object"
            }),
            "string_field2": ("STRING", {
                "multiline": True,
                "default": "Define Background"
            }),
        },
    }

RETURN_TYPES = ("CONDITIONING", "STRING", "STRING", "INT")
RETURN_NAMES = ("Compiled prompt", "Value", "Value2", "mix")
FUNCTION = "test"
# OUTPUT_NODE = False
CATEGORY = "✴️ Universal NAI Nodes"

def test(self, string_field, string_field2, mix, float_field, mute):
    if mute == "On":
        print(f"""Your input contains:
            string_field aka input text: {string_field}
            int_field: {mix}
            float_field: {float_field}
        """)

################

NAI concat v0.1

################

class ConcatenateFields:

@classmethod
def INPUT_TYPES(cls):
    return {"required": {
        "text1": ("STRING", {"multiline": False, "default": "Hello"}),
        "text2": ("STRING", {"multiline": False, "default": "World"}),
    }
    }

RETURN_TYPES = ("STRING",)
FUNCTION = "concatenate_text"
CATEGORY = "✴️ Universal NAI Nodes"

def concatenate_text(self, text1, text2):
    text_out = text1 + " " + text2

    return (text_out,)

################

NODES MAPPING

################

NODE_CLASS_MAPPINGS = {
"ShowText|pysssss": ShowText,
"Load Nai Styles Complex CSV": NaiStylerComplexCSVLoader,
"Universal_Styler_Node": NaiStyler,
"concat": ConcatenateFields,
}
NODE_DISPLAY_NAME_MAPPINGS = {
"ShowText|pysssss": "✴️ U-NAI Get Text",
"Load Nai Styles Complex CSV": "✴️ U-NAI Styles Launcher",
"Universal_Styler_Node": "✴️ U-NAI Styler - v0.2.1",
"concat": "✴️ U-NAI Fields Concatenate",
}