Actions31
- Tabelle Actions
- View Actions
- Spalte Actions
- Share Actions
- Import Actions
- Zeile Actions
Overview
This node enables importing CSV data into Nextcloud Tables. It is designed to facilitate the bulk import of tabular data from CSV files directly into a specified table within Nextcloud. This is particularly useful for automating data migration, synchronizing external datasets, or batch updating tables without manual entry.
Typical use cases include:
- Importing user lists, inventory data, or financial records stored in CSV format into Nextcloud Tables.
- Automating periodic imports of exported CSV reports into Nextcloud for further processing or sharing.
- Mapping CSV columns flexibly to target table columns with optional data type conversions.
Properties
| Name | Meaning |
|---|---|
| Tabelle | Select a target table by choosing from a list or entering its ID where the CSV data will be imported. |
| CSV-Datei | The CSV file content or path to the CSV file to import. This can be raw CSV text or a file path. |
| Import-Optionen | Collection of options controlling how the CSV import behaves: - Whether the first row contains column headers. - The delimiter used in the CSV (comma, semicolon, tab, pipe, or custom). - Text qualifier character. - Whether to skip empty rows. - Whether to skip invalid rows instead of failing the import. |
| Spalten-Mapping | Optional mapping between CSV columns and target table columns. Each mapping defines: - CSV column name or index. - Target table column. - Data type conversion mode (automatic, text, number, datetime, boolean). Without mapping, columns are auto-matched. |
Output
The node outputs JSON objects representing the result of the import operation for each input item. The exact structure depends on the underlying import handler but generally includes information about the success or failure of the import, such as counts of imported rows or error details if any occurred.
No binary data output is indicated.
Dependencies
- Requires an API authentication credential to connect to Nextcloud Tables.
- Relies on Nextcloud Tables API endpoints to perform table lookups, column retrievals, and CSV import operations.
- The node uses internal helper modules for loading options dynamically (e.g., available tables and columns).
Troubleshooting
Common issues:
- Incorrect table ID or inaccessible table: Ensure the selected table exists and the API credentials have permission.
- Malformed CSV content or wrong delimiter settings: Verify the CSV file format matches the chosen delimiter and text qualifier.
- Column mapping mismatches: If using column mapping, ensure CSV column names/indices and table columns are correctly specified.
- Skipping invalid rows may hide errors; disable this option to catch issues during import.
Error messages:
- Unknown resource or operation errors indicate misconfiguration of the node parameters.
- API errors related to authentication or permissions require checking the provided API key or token.
- Parsing errors usually relate to CSV formatting problems; adjust import options accordingly.
Links and References
- Nextcloud Tables Documentation
- CSV Format Specification
- n8n documentation on Resource Locator Parameters