FTP, CSV, and MySQL: CSV Drop Import Template
A scheduled import that picks up a CSV file dropped on an FTP server, validates the rows, and loads them into a MySQL table.
What It Builds
A Schedule trigger runs on your chosen cron and uses the ftp connector to download the latest dropped CSV file. The csv utility parses and validates each row, and a mysql Connector node in Direct mode inserts the clean rows into your target table. Bad rows are skipped so one malformed line never blocks the whole import.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Build a workflow that runs every morning at 6am, downloads the newest CSV file from the /incoming folder on our FTP server, parses it, skips any rows missing an email or order id, and inserts the valid rows into the orders table in our MySQL database.Connectors Used
- Schedule trigger - fires the run on a cron schedule in your timezone.
- ftp - downloads the dropped CSV file from the remote folder.
- csv - parses the file into rows and validates the fields.
- mysql - inserts the validated rows into your table.
Customize It
Change the cron time, the FTP folder path (/incoming), the required fields to validate, and the target table name (orders) right in the prompt. You can also tell Miraxa to update existing rows on a matching key instead of inserting, or to move processed files to an archive folder afterward.
Tips
- Use a mysql node in Direct mode for a single deterministic insert with no AI cost.
- Give the FTP connection read and write access if you want Spojit to archive files after import.
- Add a Condition node to email a summary only when rows were skipped.