Unable to parse CSV if not using N8N_DEFAULT_BINARY_DATA_MODE=default

[fank]

Bug Description

Using default mode causes:

Worker started execution 189 (job 91)
Invalid Opening Quote: a quote is found on field 4 at line 58863, value is "ROOMZ Display EDU SILVER incl. software subscription (1 year "
Worker finished execution 189 (job 91)

Which is strange but at least a "parser" error, which indicates it ran through.

But when using s3 or filesystem:

Worker started execution 173 (job 84)
The file selected in 'Input Binary Field' is not in csv format
Worker finished execution 173 (job 84)

All runs were using the same file downloaded and extracted from a FTP server:

I can share the workflow and the file which causes this issue via mail if wanted.

To Reproduce

1. Change N8N_DEFAULT_BINARY_DATA_MODE to other than default
2. Download and extract a csv as text fine in a workflow
3. Notice the eror in executions.

Expected behavior

Same behaviour for s3, ``filesystemanddefault`

Operating System

docker (self-hosted)

n8n Version

1.80.5

Node.js Version

20.18.3

Database

PostgreSQL

Execution mode

queue

[Joffcom]

Hey @fank,

We have created an internal ticket to look into this which we will be tracking as "GHC-1000"

[Joffcom]

Hey @fank,

Using filesystem as the binary data mode I have not been able to reproduce this, Can you try the workflow below and let me know if it works?

{
  "nodes": [
    {
      "parameters": {},
      "type": "n8n-nodes-base.manualTrigger",
      "typeVersion": 1,
      "position": [
        -60,
        220
      ],
      "id": "9c1eaac6-30d6-4f76-aef0-a1ff440f7bfb",
      "name": "When clicking ‘Test workflow’"
    },
    {
      "parameters": {
        "url": "https://drive.google.com/uc?id=1zO8ekHWx9U7mrbx_0Hoxxu6od7uxJqWw&export=download",
        "options": {}
      },
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        180,
        220
      ],
      "id": "347f6e78-aaf1-47ef-bc31-e6231420079a",
      "name": "HTTP Request"
    },
    {
      "parameters": {
        "options": {}
      },
      "type": "n8n-nodes-base.extractFromFile",
      "typeVersion": 1,
      "position": [
        400,
        220
      ],
      "id": "75d84de4-cebd-4f2f-8b22-bc2b44a96b61",
      "name": "Extract from File"
    }
  ],
  "connections": {
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request": {
      "main": [
        [
          {
            "node": "Extract from File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "pinData": {},
  "meta": {
    "templateCredsSetupCompleted": true,
    "instanceId": "13e13da6cec5a381aed49d0af7a257d6f48570c94beda6a35bc51d7a1388f782"
  }
}

[fank]

This works fine

But it does not extract from a zip before.

[fank]

@Joffcom minimal reproduction:

{
  "nodes": [
    {
      "parameters": {},
      "type": "n8n-nodes-base.manualTrigger",
      "typeVersion": 1,
      "position": [
        120,
        -340
      ],
      "id": "659edc28-cc9c-49ea-9236-3cb0ed58d0e7",
      "name": "When clicking ‘Test workflow’"
    },
    {
      "parameters": {
        "url": "https://drive.usercontent.google.com/u/0/uc?id=19RqI-1rHHGyacDzlsxY0AhKWa7sBMZ7L&export=download",
        "options": {}
      },
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        360,
        -340
      ],
      "id": "dffd9958-432f-4fb7-a76c-059b18b96840",
      "name": "HTTP Request"
    },
    {
      "parameters": {
        "options": {}
      },
      "type": "n8n-nodes-base.extractFromFile",
      "typeVersion": 1,
      "position": [
        820,
        -340
      ],
      "id": "cdbb864e-d045-4d40-9306-696ee2938195",
      "name": "Extract from File"
    },
    {
      "parameters": {},
      "type": "n8n-nodes-base.compression",
      "typeVersion": 1.1,
      "position": [
        580,
        -340
      ],
      "id": "6ea76574-b760-40d2-bc9a-95b8a25d82ed",
      "name": "Compression"
    }
  ],
  "connections": {
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request": {
      "main": [
        [
          {
            "node": "Compression",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Compression": {
      "main": [
        [
          {
            "node": "Extract from File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "pinData": {},
  "meta": {
    "instanceId": "94a4722c99e67331d954b7292a159d350b5424049db5ee23fe2d0df7fe09b001"
  }
}

[Joffcom]

Hey @fank,

If you change data to file_0 in the Extract from File node then change the file type from csv to text that example also works.

[Joffcom]

or if you want to use CSV with the text file change the Delimeter to use \t and it will also work although there is no header row in that document.

[fank]

@Joffcom Looks like an issue with the full file I have, can I mail it to help@n8n.io?

[fank]

Since other are working fine, it have the feeling its an issue of how the error in the issue description is getting handled.

[Joffcom]

Hey @fank,

Yeah if you send it there and let them know it is for me it should get here, At the moment though as it is file specific it doesn't seem like a bug as such... I will keep this open for now though as that could change.