Unable to process/upload CSV with URL Source

Created on 17 May 2023, over 1 year ago

Updated 8 June 2023, over 1 year ago

I've tried 4 methods for uploading a CSV:

Public Google Sheet with query parameter to make one of its sheets CSV: https://docs.google.com/spreadsheets/d/1ydQfgEDot0AC9xuT2txc39VBfuum_I1g...
Github-hosted raw csv file (link to non-raw: https://github.com/OsmosisIncentivesCommittee/OsmoIncentives/blob/main/d...)
URL of csv uploaded as media file on another local Drupal instance (public files, media module enabled)
Path (full URL) of csv uploaded as file on the same local Drupal instance (public files, virgin D10, media module disabled)

and all of them failed, with:

Both Drupal instances are local, installed by DDEV CMS Quickstart procedure.

🐛 Bug report

Status

Fixed

Version

1.0

Component

Code

Created by

🇮🇹Italy kopeboy Milan

Live updates comments and jobs are added and updated live.

Comments & Activities

Issue created by @kopeboy
Comment over 1 year ago →
🇮🇹Italy kopeboy Milan
(Using manual upload worked instead)
Comment over 1 year ago →
🇺🇸United States minnur San Francisco
I think mime types of those files probably not getting passed from github or googlesheets. I will take a look. And local file failing probably due to SSL verification issue.

Could you try an actual CSV file like this https://people.sc.fsu.edu/~jburkardt/data/csv/addresses.csv
Status changed to Fixed over 1 year ago6:55am 8 June 2023
Comment over 1 year ago →
🇺🇸United States minnur San Francisco
Comment over 1 year ago →
System Message
Automatically closed - issue fixed for 2 weeks with no activity.

Production build 0.71.5 2024