Problems regarding uploading a shapefile in a db spatialite

[gabrieledipalma81]

Hi everobody,

I tried to upload in a spatialite the attached shapefile. The attached shapefile was downloaded by the following url: http://dev.ondata.it/projs/zoneomi/zone_omi_poligoni.zip

1. First of all I chose the attributes I needed, related to the city of Bari (deleting the rows I didn't need);
2. I created a db spatialite from the browser of QGis;
   3 From Db Manager I connected to the spatialite and I tried to upload my shp, but failed. It said: Error 7 Import failed and in the db it uploaded just an empty attribute table without any geometry.
3. I modified my shp adding several fields, pasting data and calculations that were in a spreadsheet I created - I opened the dbf file related to my shp and I modified it;
4. I was able, finally, to upload it, but the geometries were messy because I ordered the columns of the dbf file and there was no order between the geometries and the attributes;
5. then I decided to write the attribute table of my shp in QGis, opening it and pasting one by one alla my indicators;
6. Since the BB Manager gave me the same error 7, I solved the issue saving the shp as a sqlite file, as suggested by https://lists.osgeo.org/. Finally it worked and I was able to have my shp as a sqlite db, and now I'm working with this.
7. Now the problem is that I cannot save the style in the db sqlite. It creates an empty attribute table and I cannot load it. So I don't know how to format my data in order to share them.

The version of QGis I use: 3.10.1-A Coruña Compiled against SQLite | 3.28.0.

Thanks!

zone_omi_dati Bari.zip

[gioman]

@gabrieledipalma81 replaces by #33883