Import of simple XLSX/CSV from a Linux machine (LibreOffice Calc) fails fully
Open
Nobody has claimed this yet.
0. Needs triage
bug
import/export
needs info
- Dominant language
- JavaScript
- Stars
- 214
- Forks
- 52
- Avg merge
- 1d 10h
- Merged PRs (30d)
- 82
Description
Steps to reproduce
- Received XLSX file from a windows user with one column of type text
- opened in LibreOffice calc on Linux and exported as CSV (without delimiter, with ", with '; with semicolon, with comma, I tried a ton of combinations)
- Tried various ways to import this very simple file... as unchanged XLSX, as CSV variants...
Expected behavior
It should just work as typical imports work, what can I say. 🤷♂️
Actual behavior
- Import never worked, but with variants, either:
a. If got stuck in a loop asking to assign columns but did not show any columns to select for assignment
b. simply failed by saying "unknown error". - It tried import on table creation and I tried import after creating an empty table first. Nothing worked.
Uninstalled for now. Thanks for looking into that.
Tables app version
0.9.5
Browser
ungoogled-chrome
Client operating system
Debian Testing
Operating system
Linux (not sure though)
Web server
None
PHP engine version
None
Database
None
Additional info
No response
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Reproduce the import using the reported XLSX and CSV variants in Tables 0.9.5 on Debian Testing with ungoogled-Chrome. Investigate the column-assignment loop and the unknown-error path; done means a simple one-column file imports successfully during table creation and into an existing empty table.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- javascript
- Domain
- frontend
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100