Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Copying Attributes From Attribute Table Not Working For MS SQL Server Tables #57237

Open
2 tasks done
zachwright95 opened this issue Apr 24, 2024 · 0 comments
Open
2 tasks done
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter!

Comments

@zachwright95
Copy link

What is the bug or the crash?

I am trying to copy records from a mapping layer directly into Excel, which works for various file formats, such as .TAB, .MID/MIF and .SHP, however with MS SQL Spatial tables, it pastes the records in Excel with only NULL under the field "wkt_geom", then the rest of the table's columns are shown at the top with blank values under them, even though these are all populated in QGIS.

I've tried this on two different devices, probably half a dozen layers and three different versions of QGIS (including the latest 3.36.1-Maidenhead - 3e58945).

Steps to reproduce the issue

  1. Under MS SQL Server in the Browser, create a SQL Spatial connection to a server. Find the database, and have the checkboxes "Also list tables with no geometry" "Use estimated table parameters" and all schemas ticked. Click on "OK" to add the table.

  2. Go to the added database in the browser and select a table within it and add it to the QGIS project.

  3. Right click on the newly added layer, select "Open Attribute Table"

  4. Open Excel.

  5. Select all or some records in the QGIS attribute table, copy the records.

  6. Go to Excel and attempt to paste in cell A1 of a blank sheet.

Versions

QGIS version
3.36.1-Maidenhead
QGIS code revision
3e58945
Qt version
5.15.3
Python version
3.9.18
GDAL/OGR version
3.8.4
PROJ version
9.3.1
EPSG Registry database version
v10.098 (2023-11-24)
GEOS version
3.12.1-CAPI-1.18.1
SQLite version
3.41.1
PDAL version
2.6.0
PostgreSQL client version
16.2
SpatiaLite version
5.1.0
QWT version
6.1.6
QScintilla2 version
2.13.4
OS version
Windows Server 2016 Version 1809

Active Python plugins
qfieldsync
v4.2.0
grassprovider
2.12.99
MetaSearch
0.3.6
processing
2.12.99

Supported QGIS version

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

New profile

Additional context

No response

@zachwright95 zachwright95 added the Bug Either a bug report, or a bug fix. Let's hope for the latter! label Apr 24, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter!
Projects
None yet
Development

No branches or pull requests

1 participant