Bug report #15305

importing layers to MS SQL Server via browser drag & drop

Added by James Burn almost 4 years ago. Updated almost 2 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Data Provider/MSSQL
Affected QGIS version:2.18.7 Regression?:No
Operating System:Windows 8.1 / 10 Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:23237

Description

occasionally fails to import and appears to be based on multi-geom types (multiline etc.); when it does import, it appears to drop the values from the first field, and shift the remaining values over, leaving the last field with nulls. predictable issues with the field values shifting (text to number, float to integer). Does not seem to matter which format the import is coming from - have tried shp, mif, tab and spatialite.

Associated revisions

Revision b7f5a3c1
Added by Nyall Dawson almost 2 years ago

[mssql] Fix shifted attributes after importing layers via browser
drag and drop

Fixes #15305

History

#1 Updated by Giovanni Manghi over 3 years ago

  • Subject changed from importing layers to SQL Server vis browser drag n drop to importing layers to MS SQL Server via browser drag & drop
  • Category changed from Data Provider/MSSQL to Browser
  • Priority changed from High to Normal

#2 Updated by Giovanni Manghi about 3 years ago

  • Easy fix? set to No
  • Regression? set to No

#3 Updated by James Burn about 3 years ago

just an update - it is still happening in 2.18.7

#4 Updated by Giovanni Manghi about 3 years ago

  • Affected QGIS version changed from 2.16.0 to 2.18.7

#5 Updated by Nyall Dawson almost 2 years ago

  • Category changed from Browser to Data Provider/MSSQL

#6 Updated by Nyall Dawson almost 2 years ago

  • Status changed from Open to In Progress

#7 Updated by Nyall Dawson almost 2 years ago

  • % Done changed from 0 to 100
  • Status changed from In Progress to Closed

Also available in: Atom PDF