Extract from CSV stops working

Hello,

I’m using an Extract from File Node after a Read from File Node to get data from a CSV. However it stops working after the first 6 (7 if you count the header) lines. There is no difference in the way the CSV is structured between lines. There’s no error message.

Information on your n8n setup

  • n8n version: 1.84.1
  • Database (default: SQLite): default
  • n8n EXECUTIONS_PROCESS setting (default: own, main): default
  • Running n8n via (Docker, npm, n8n cloud, desktop app): npm
  • Operating system: Win11

hello @Corvin

Can you please provide a sample file?

description|isNew|halal|gluten|lactose|veggie
Aurora Sauce|False|False|True|True|True
Blumenkohl und Brokkoli mit Mandeln|False|True|True|True|True
Butterreis|False|True|True|True|True
Cordon bleu|False|False|False|True|False
Essig & Öl|False|True|True|True|True
Grillschinken mit Honig-Orangenpfeffer-Kruste|False|False|True|True|False
Hähnchenoberkeulenrolle ""Baronesse""|False|True|True|True|False
Joghurt-Dressing|False|True|True|False|True
Karotten-Lauch-Gemüse à la créme|False|True|True|True|True
Kartoffelgratin|False|True|True|True|True
Panna-cotta mit Mangoschaum im Glas|False|True|True|True|True
Pfannengemüse mit Zucchini, Aubergine und Paprika|False|True|True|True|True
Putengeschnetzelte mit feiner Rahmsauce|False|False|True|True|True
Rahmsauce mit Champignons|False|True|True|True|False
Sauce Hollandaise hausgemacht|False|True|False|False|True
Spätzle in Butter gebraten|False|True|False|True|True
gemischter Salat|False|True|True|True|True

This is the used CSV

Wild guess on the first thing I see: “&” and “Ö” could mess up some things. When using special chars and spaces it’s usually recommended to put the content in " ".

First thing to try out: remove the & and see if it’s getting processed.


It actually reads that one, I don’t think that’s the issue, also it’d be kinda bad for me if I couldn’t use those characters since I need to use them later.

Ah okay, in your screenshot there is one more record compared to the sample you’ve posted. Can you share your whole workflow? You can copy the json and paste it here in the </> block.

Seems the quotes here causing the issue. If you will remove them, will it work?

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.