Issues with CSV Loading in Files App and Custom App Development

💻 Development
1

Hello Nextcloud community,

I’m encountering two separate but related issues with CSV files in Nextcloud, and I would greatly appreciate any assistance or guidance.

Issue 1: Unable to Load CSV Files in Nextcloud Files App

When selecting a CSV file in the Nextcloud Files app, it fails to load properly. The viewer doesn’t display the CSV content as expected.

Steps to reproduce:

  1. Open the Nextcloud Files app
  2. Navigate to a folder containing a CSV file
  3. Click on the CSV file to view it
  4. The file doesn’t load or display correctly

Expected behavior: The CSV file should open and display its contents in a readable format.
Actual behavior: The file fails to load or display properly.

Issue 2: Server Request Error When Extracting Drone Flight Data from CSV in Custom App

I’m developing a custom app to extract drone flight data from CSV files. However, I’m encountering a server request error when trying to process the CSV file.

Steps to reproduce:

  1. Upload a CSV file containing drone flight data to Nextcloud
  2. Attempt to process the file using my custom app
  3. Receive a server request error

Questions:

  1. For the Files app issue, are there any known limitations or configuration settings that might affect CSV file viewing?
  2. Regarding the custom app development, are there best practices or recommended approaches for handling CSV files and extracting specific data in Nextcloud?
  3. Are there any specific permissions or settings I need to check to ensure proper file access and processing?

Any insights, suggestions, or resources you can provide would be immensely helpful. Thank you in advance for your assistance.

스크린샷 2024-10-12 054033
스크린샷 2024-10-12 0540331903×893 15.9 KB

2

https://www.papaparse.com/

3

Common issues with CSV loading in files apps and custom mobile web app development include:

  1. Data Formatting Errors: Incorrect delimiters or misplaced quotes can disrupt loading. Ensure proper formatting and use validation tools.
  2. File Size Limitations: Large files may cause performance issues. Use chunking or streaming for efficient loading.
  3. Encoding Problems: Different file encodings can result in corrupted data. Stick to a consistent encoding like UTF-8.
  4. Data Type Mismatches: Mixed data types in columns can cause errors. Validate and sanitize data before importing.
  5. Inadequate Error Handling: Without proper error handling, apps may crash on issues. Implement clear error messages and logs.

Addressing these challenges will ensure smoother CSV imports in apps.