jh-RLI
commented
4 weeks ago I just remembered that @chrwm also suggested a similar update to the wizard. Another good point is the ability to add/create multiple tables at once. I think this is useful for independent and linked tables (foreign keys).
https://github.com/OpenEnergyPlatform/oeplatform/issues/943
Also realated: https://github.com/OpenEnergyPlatform/oeplatform/issues/861
And since the Oep supports spatial data, it would be great if we could also allow the user to upload it via the wizard UI. In case something gets too complicated to do via the UI, this should be mentioned & and we should provide a link to a tutorial/course in the academy that shows how to use the API to do these things (like uploading spatial data).
Description of the issue
The upload wizard is helpful when uploading csv file, however if a table does not yet exist, its structure has to be created by hand and then created and only if everything goes well, the csv can be uploaded into the new table. The OEP should be able to help with this process.
Ideas of solution
Dropping a csv file into the page should prompt an analysis of the first few lines, taking column names and inferring data types. This information should either suffice to create a table or get there with minimal further user input. Maybe OMI can assist with this.
Also see: https://github.com/OpenEnergyPlatform/omi/issues/99