Connect to FTP to eventually import into Mysql

Questions
, ,
1

Information on your n8n setup

  • n8n 1.42.1:
  • Database (default: SQLite):
  • running on Proxmox LXC:
  • Linux:

Hi All,

I am new to n8n and excited to delve in as there are so many options available.
What I’m trying to do is
Connect to FTP - this I’ve managed to do.

Download XML Files - I am getting stuck here.
Not sure if I need to download the files first before then importing to a database?
I can successfully list all the files using the ‘list’ option.

When trying to download the xml files, I am getting the below error

image
image1347×577 36.4 KB

Add to MYSQL database

Then eventually extract from the database applying an xsl template.

This is about as far as I’ve gotten so far
image

Any tips or pointers would be greatly appreciated!

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

Hey @gezburga,

Welcome to the community :cake:

It looks like you have the right idea, For the path though I would probably use {{ $json.path }} instead of the name that way you get the full path.

Once you have done that the XML node may help you read the file so you can get the data into items to use for inserting into your Database.

4

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