Actions31
- Table Actions
- View Actions
- Column Actions
- Share Actions
- Import Actions
- Row Actions
Overview
This node enables importing CSV data into Nextcloud Tables. It is designed to facilitate bulk data uploads by mapping CSV columns to table columns, handling various CSV formats and import options. Typical use cases include migrating data from spreadsheets or other CSV exports into Nextcloud Tables for further collaboration and management.
For example, a user can import a customer list stored in a CSV file into a Nextcloud Table, specifying how columns like "Name", "Email", and "Signup Date" map to the table's columns, while controlling delimiters, text qualifiers, and whether the first row contains headers.
Properties
| Name | Meaning |
|---|---|
| Table | Select the target Nextcloud Table to import data into. You can choose from a list of tables or specify the table ID directly. |
| CSV File | The CSV content or path to the CSV file that contains the data to be imported. |
| Import Options | Various settings controlling how the CSV is parsed and imported: - First Row Contains Headers: Whether the first CSV row has column headers. - Delimiter: Character separating columns (Comma, Semicolon, Tab, Pipe, or Custom). - Custom Delimiter: Specify if delimiter is set to Custom. - Text Qualifier: Character enclosing text values (Quote, Apostrophe, or None). - Skip Empty Rows: Whether empty rows should be ignored. - Skip Invalid Rows: Whether rows with errors are skipped instead of aborting the import. |
| Column Mapping | Optional explicit mapping between CSV columns and Nextcloud Table columns. Each mapping includes: - CSV Column: Name or zero-based index of the CSV column. - Table Column: Target column in the Nextcloud Table. - Data Type Conversion: How to convert the data (Automatic, Text, Number, Date/Time, Boolean). Without mappings, columns are matched automatically by name or order. |
Output
The node outputs JSON objects representing the result of the import operation. Each output item corresponds to an import attempt and contains details such as success status, number of rows imported, or error information if applicable.
No binary data output is produced by this node.
Dependencies
- Requires a valid API authentication token credential to connect to Nextcloud Tables.
- Relies on Nextcloud Tables API endpoints to perform table lookups, column retrievals, and data import operations.
- The node uses internal helper modules for handling CSV parsing, column mapping, and API communication.
Troubleshooting
Common Issues:
- Incorrect table ID or inaccessible table: Ensure the selected table exists and the API token has permissions.
- Malformed CSV content or wrong delimiter settings: Verify the CSV format matches the specified delimiter and text qualifier.
- Mismatched column names or missing mappings: If automatic matching fails, define explicit column mappings.
- Import aborted due to invalid rows: Enable "Skip Invalid Rows" to continue import despite some errors.
Error Messages:
Unknown resource: Indicates an invalid resource parameter; ensure "import" is selected.- API errors related to authentication or permissions: Check API credentials and access rights.
- Parsing errors: Review CSV formatting and import options.