Large CSV file handling

Created on 15 October 2024, 2 months ago

Problem/Motivation

By default, the module caches the remote files in order to make subsequent loads faster. However, if the file is too large, you might see an error like this:

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: ....

Steps to reproduce

Create a view and in the Query plugin, link to a large, remote CSV file (this has been an issue for me with files larger than 15MB). You are no longer able to open the CSV Field settings and will see an error message at the top of the view.

Proposed resolution

Check if the cache duration is 0; if so, do not apply the cache. Add some descriptions to help users know about this feature.

User interface changes

Updated description in the settings form and for the CSV file link.

✨ Feature request
Status

Active

Version

1.0

Component

Code

Created by

πŸ‡ΊπŸ‡ΈUnited States andileco

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Merge Requests

Comments & Activities

Production build 0.71.5 2024