Timeline for Column headers ignored when importing .xlsx file to postgres via QGIS DB Manager
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 16, 2022 at 13:26 | comment | added | J.R | You may also check that none of the header are a reserved word (like DATE or FROM) or contains any space, accented character, special character,... or start with a number.... | |
| Nov 16, 2022 at 13:19 | answer | added | Atriplex | timeline score: 4 | |
| Oct 10, 2022 at 8:32 | answer | added | Antonis Michalakis | timeline score: 0 | |
| Apr 20, 2020 at 15:17 | comment | added | Kristen G. | My colleague and I have tried so many things at this point. It's bizarre. She even noticed that the field lengths in postgres are limited to 63 characters (and one of the field names was 68). I edited all field names to be under the limit, almost positive that would solve the problem, and it still hasn't. | |
| Apr 14, 2020 at 2:48 | comment | added | Leo Cardona | I don't know why it happens, my solution was to export the xxx file as csv | |
| Apr 14, 2020 at 2:02 | comment | added | she_weeds | I don't have an answer for you but xlsx headers can be pretty fickle even when you think it's fine. Sometimes I drag very similar sheets into QGIS and one has its headers detected properly while the other doesn't. I can't always figure out why. Have you tried formatting the data as a table in Excel and saving that? Removing all formatting? Maybe ensuring that the first column is numeric (if possible?) Deleted all empty rows and columns (which is not always straightforward)? (I would recommend an addon like ASAP Utilities to make data cleaning a lot easier) | |
| Apr 13, 2020 at 21:50 | history | asked | Kristen G. | CC BY-SA 4.0 |