Importing Data into a QGIS Created File Based Geodatabase

[northrivergeo]

What is the bug or the crash?

When importing data into File Based Geodatabse (created in QGIS) the attributes shift one column to the left.

In the screenshot all the data should be in the column to the right.

Steps to reproduce the issue

1. Download this ESRI File Based Geodatabase: https://tnmap.tn.gov/NG911/TN_NG911.zip
2. Add Centerlines to QGIS
3. Create File Based Geodatabase using the browser
4. Drag and Drop the Centerline into the new File Geodatabase
5. Open Attribute Table - In the newly imported layer - Pretype will be the names of roads. Everything shifts one column left.
   Example:

Versions

3.28.2 On Fedora (using the conda installer) and Windows 10

Supported QGIS version

• I'm running a supported QGIS version according to the roadmap.

New profile

• I tried with a new QGIS profile

Additional context

There is no problem with editing. The only problem seems to be importing this into a new file geodatabase. I can save it out to geopackage and I'm fine. I tried a ESRI File Based Geodatabase -> Geopackage -> QGIS Produced File Based Geodatbase and it still shifted the data one column to the left. .

[rjhale1971]

Aaaand I inadvertently used the wrong github account to file this. Yay.

[agiudiceandrea]

@rjhale1971, it seems the file cannot be downloaded. Could you please attach it (or, better, the layer with only one sample feature) directly to this issue report?

[rjhale1971]

Atached. I went ahead and moved the data into a Geopackage - the problem is the same. Create a new File Based Geodatabase and drag and drop the Centerlines Table into it and the data shifts one column to the left.

Hopefully this helps - and thanks again.

example.zip

[rjhale1971]

Unzipping the geopackage should give you one file called example.gpkg with a Centerlines layer in it. I shouldn't have called it a table I guess.

[agiudiceandrea]

Issue confirmed using QGIS 3.28 on Windows. It only occurs dragging and dropping the layer to an Esri File Geodatabase using the browser, while it doesn't occur exporting the layer to an ESRI File Geodatabase layer.

[rjhale1971]

Thanks! That also made me realize I'm missing an export to ESRI FileGDB on Linux - but not on windows. I'm guessing that's a symptom of running this through Conda. I'll send them an bug report.

[rjhale1971]

You rock!