Sharing properties for SQL server table in QGIS? The 2019 Stack Overflow Developer Survey Results Are In Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Adding layer to MXD from different SDE slows down ArcPy scriptHow to store attribute values from a custom form into shapefile?Limiting list values based on previous field in QGIS Forms?Shapefile/vector layer not appearing in QGISBest practise for managing shapefiles/symbology in QGISQGIS server renders blank pictureQGIS Broken Link to files on a serverQGIS: ESRI shapefile .shp no longer appears in list of file types under Add Vector LayerClear/refresh table of contents in Geoprocessing toolsHow to backup QGIS (3.2.1) layer to independent PostGIS table?
Can a flute soloist sit?
Is it ok to offer lower paid work as a trial period before negotiating for a full-time job?
What does Linus Torvalds mean when he says that Git "never ever" tracks a file?
Can withdrawing asylum be illegal?
Working through the single responsibility principle (SRP) in Python when calls are expensive
How do you keep chess fun when your opponent constantly beats you?
Could an empire control the whole planet with today's comunication methods?
Is 'stolen' appropriate word?
Match Roman Numerals
Word to describe a time interval
How many cones with angle theta can I pack into the unit sphere?
60's-70's movie: home appliances revolting against the owners
Can the Right Ascension and Argument of Perigee of a spacecraft's orbit keep varying by themselves with time?
Is there a way to generate uniformly distributed points on a sphere from a fixed amount of random real numbers per point?
Identify 80s or 90s comics with ripped creatures (not dwarves)
Why not take a picture of a closer black hole?
How did the crowd guess the pentatonic scale in Bobby McFerrin's presentation?
My body leaves; my core can stay
ELI5: Why do they say that Israel would have been the fourth country to land a spacecraft on the Moon and why do they call it low cost?
Why doesn't a hydraulic lever violate conservation of energy?
Do I have Disadvantage attacking with an off-hand weapon?
Can the DM override racial traits?
Is it ethical to upload a automatically generated paper to a non peer-reviewed site as part of a larger research?
Using dividends to reduce short term capital gains?
Sharing properties for SQL server table in QGIS?
The 2019 Stack Overflow Developer Survey Results Are In
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Adding layer to MXD from different SDE slows down ArcPy scriptHow to store attribute values from a custom form into shapefile?Limiting list values based on previous field in QGIS Forms?Shapefile/vector layer not appearing in QGISBest practise for managing shapefiles/symbology in QGISQGIS server renders blank pictureQGIS Broken Link to files on a serverQGIS: ESRI shapefile .shp no longer appears in list of file types under Add Vector LayerClear/refresh table of contents in Geoprocessing toolsHow to backup QGIS (3.2.1) layer to independent PostGIS table?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I have a project where most of the layers come from a SQL server. Most of the layers contain pointers to, and/or drop down list for, attributes so that there is consistency in data entry. This project accounts for 80% of my work
My PC was recently rebuilt in Windows 10 and I have a fresh install of QGIS 2.18. That means that I lost all recent history and connections to the database.
When I opened my project, I received the 'Handle Bad Layers' dialogue box for some of my layers. It turns out that the project had been created over time with different paths to the database. I was able to add the layers back to the project, but I have lost the pointers and drop down lists. I would like to get them back.
Luckily I have copies of the project that I can still open on a Windows 7 machine, so I can see what those pointers and lists looked like. I could go through one at a time and recreate what I need, but I would prefer something less manual and less prone to human error. There are 27 layer and each layer has 20-30 attributes.
I've been trying to research .qlr files, but I am not sure I am on the right track.
Can anyone help me, or direct me to some search terms that could help?
qgis layers fields-attributes
edited Mar 23 '18 at 3:31
PolyGeo♦
53.9k1782246
asked Mar 16 '18 at 5:16
JohannaJohanna
691721
add a comment |
I have a project where most of the layers come from a SQL server. Most of the layers contain pointers to, and/or drop down list for, attributes so that there is consistency in data entry. This project accounts for 80% of my work
My PC was recently rebuilt in Windows 10 and I have a fresh install of QGIS 2.18. That means that I lost all recent history and connections to the database.
When I opened my project, I received the 'Handle Bad Layers' dialogue box for some of my layers. It turns out that the project had been created over time with different paths to the database. I was able to add the layers back to the project, but I have lost the pointers and drop down lists. I would like to get them back.
Luckily I have copies of the project that I can still open on a Windows 7 machine, so I can see what those pointers and lists looked like. I could go through one at a time and recreate what I need, but I would prefer something less manual and less prone to human error. There are 27 layer and each layer has 20-30 attributes.
I've been trying to research .qlr files, but I am not sure I am on the right track.
Can anyone help me, or direct me to some search terms that could help?
qgis layers fields-attributes
edited Mar 23 '18 at 3:31
PolyGeo♦
53.9k1782246
asked Mar 16 '18 at 5:16
JohannaJohanna
691721
An Update. The answer provided didn't work for me and I am still researching. I was found that there had been two ways to connect to the database. Recreating the ODBC connections has meant that I can now open the original project and keep working. I now need to rebuild with all tables connecting the same way.
– Johanna
Mar 22 '18 at 21:24
add a comment |
I have a project where most of the layers come from a SQL server. Most of the layers contain pointers to, and/or drop down list for, attributes so that there is consistency in data entry. This project accounts for 80% of my work
My PC was recently rebuilt in Windows 10 and I have a fresh install of QGIS 2.18. That means that I lost all recent history and connections to the database.
When I opened my project, I received the 'Handle Bad Layers' dialogue box for some of my layers. It turns out that the project had been created over time with different paths to the database. I was able to add the layers back to the project, but I have lost the pointers and drop down lists. I would like to get them back.
Luckily I have copies of the project that I can still open on a Windows 7 machine, so I can see what those pointers and lists looked like. I could go through one at a time and recreate what I need, but I would prefer something less manual and less prone to human error. There are 27 layer and each layer has 20-30 attributes.
I've been trying to research .qlr files, but I am not sure I am on the right track.
Can anyone help me, or direct me to some search terms that could help?
qgis layers fields-attributes
edited Mar 23 '18 at 3:31
PolyGeo♦
53.9k1782246
asked Mar 16 '18 at 5:16
JohannaJohanna
691721
I have a project where most of the layers come from a SQL server. Most of the layers contain pointers to, and/or drop down list for, attributes so that there is consistency in data entry. This project accounts for 80% of my work
My PC was recently rebuilt in Windows 10 and I have a fresh install of QGIS 2.18. That means that I lost all recent history and connections to the database.
When I opened my project, I received the 'Handle Bad Layers' dialogue box for some of my layers. It turns out that the project had been created over time with different paths to the database. I was able to add the layers back to the project, but I have lost the pointers and drop down lists. I would like to get them back.
Luckily I have copies of the project that I can still open on a Windows 7 machine, so I can see what those pointers and lists looked like. I could go through one at a time and recreate what I need, but I would prefer something less manual and less prone to human error. There are 27 layer and each layer has 20-30 attributes.
I've been trying to research .qlr files, but I am not sure I am on the right track.
Can anyone help me, or direct me to some search terms that could help?
qgis layers fields-attributes
qgis layers fields-attributes
edited Mar 23 '18 at 3:31
PolyGeo♦
53.9k1782246
asked Mar 16 '18 at 5:16
JohannaJohanna
691721
edited Mar 23 '18 at 3:31
PolyGeo♦
53.9k1782246
asked Mar 16 '18 at 5:16
JohannaJohanna
691721
edited Mar 23 '18 at 3:31
PolyGeo♦
53.9k1782246
edited Mar 23 '18 at 3:31
PolyGeo♦
53.9k1782246
edited Mar 23 '18 at 3:31
PolyGeo♦
53.9k1782246
53.9k1782246
asked Mar 16 '18 at 5:16
JohannaJohanna
691721
asked Mar 16 '18 at 5:16
JohannaJohanna
691721
asked Mar 16 '18 at 5:16
JohannaJohanna
691721
691721
An Update. The answer provided didn't work for me and I am still researching. I was found that there had been two ways to connect to the database. Recreating the ODBC connections has meant that I can now open the original project and keep working. I now need to rebuild with all tables connecting the same way.
– Johanna
Mar 22 '18 at 21:24
add a comment |
An Update. The answer provided didn't work for me and I am still researching. I was found that there had been two ways to connect to the database. Recreating the ODBC connections has meant that I can now open the original project and keep working. I now need to rebuild with all tables connecting the same way.
– Johanna
Mar 22 '18 at 21:24
An Update. The answer provided didn't work for me and I am still researching. I was found that there had been two ways to connect to the database. Recreating the ODBC connections has meant that I can now open the original project and keep working. I now need to rebuild with all tables connecting the same way.
– Johanna
Mar 22 '18 at 21:24
An Update. The answer provided didn't work for me and I am still researching. I was found that there had been two ways to connect to the database. Recreating the ODBC connections has meant that I can now open the original project and keep working. I now need to rebuild with all tables connecting the same way.
– Johanna
Mar 22 '18 at 21:24
add a comment |
1 Answer
1
active
oldest
votes
May you can build the layers in a new QGIS project and copy the string for the datasource in the equal colunm in the "Handle Bad Layers" window form the old project. The old ones can provied you helpful information like in this example:
dbname='name' host=localhost port=5432 user='postgres' password='***' sslmode=disable key='id' srid=4326 type=Point table="public"."table" (geom) sql="lang" in ('de', 'en', 'cs', 'pl')
Take also a look at the changeDataSource plugin for QGIS. (https://plugins.qgis.org/plugins/changeDataSource/)
edited Mar 23 '18 at 3:32
PolyGeo♦
53.9k1782246
answered Mar 19 '18 at 11:38
CartographerCartographer
936
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f274997%2fsharing-properties-for-sql-server-table-in-qgis%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
May you can build the layers in a new QGIS project and copy the string for the datasource in the equal colunm in the "Handle Bad Layers" window form the old project. The old ones can provied you helpful information like in this example:
dbname='name' host=localhost port=5432 user='postgres' password='***' sslmode=disable key='id' srid=4326 type=Point table="public"."table" (geom) sql="lang" in ('de', 'en', 'cs', 'pl')
Take also a look at the changeDataSource plugin for QGIS. (https://plugins.qgis.org/plugins/changeDataSource/)
edited Mar 23 '18 at 3:32
PolyGeo♦
53.9k1782246
answered Mar 19 '18 at 11:38
CartographerCartographer
936
add a comment |
May you can build the layers in a new QGIS project and copy the string for the datasource in the equal colunm in the "Handle Bad Layers" window form the old project. The old ones can provied you helpful information like in this example:
dbname='name' host=localhost port=5432 user='postgres' password='***' sslmode=disable key='id' srid=4326 type=Point table="public"."table" (geom) sql="lang" in ('de', 'en', 'cs', 'pl')
Take also a look at the changeDataSource plugin for QGIS. (https://plugins.qgis.org/plugins/changeDataSource/)
edited Mar 23 '18 at 3:32
PolyGeo♦
53.9k1782246
answered Mar 19 '18 at 11:38
CartographerCartographer
936
add a comment |
May you can build the layers in a new QGIS project and copy the string for the datasource in the equal colunm in the "Handle Bad Layers" window form the old project. The old ones can provied you helpful information like in this example:
dbname='name' host=localhost port=5432 user='postgres' password='***' sslmode=disable key='id' srid=4326 type=Point table="public"."table" (geom) sql="lang" in ('de', 'en', 'cs', 'pl')
Take also a look at the changeDataSource plugin for QGIS. (https://plugins.qgis.org/plugins/changeDataSource/)
edited Mar 23 '18 at 3:32
PolyGeo♦
53.9k1782246
answered Mar 19 '18 at 11:38
CartographerCartographer
936
May you can build the layers in a new QGIS project and copy the string for the datasource in the equal colunm in the "Handle Bad Layers" window form the old project. The old ones can provied you helpful information like in this example:
dbname='name' host=localhost port=5432 user='postgres' password='***' sslmode=disable key='id' srid=4326 type=Point table="public"."table" (geom) sql="lang" in ('de', 'en', 'cs', 'pl')
Take also a look at the changeDataSource plugin for QGIS. (https://plugins.qgis.org/plugins/changeDataSource/)
edited Mar 23 '18 at 3:32
PolyGeo♦
53.9k1782246
answered Mar 19 '18 at 11:38
CartographerCartographer
936
edited Mar 23 '18 at 3:32
PolyGeo♦
53.9k1782246
edited Mar 23 '18 at 3:32
PolyGeo♦
53.9k1782246
edited Mar 23 '18 at 3:32
PolyGeo♦
53.9k1782246
53.9k1782246
answered Mar 19 '18 at 11:38
CartographerCartographer
936
answered Mar 19 '18 at 11:38
CartographerCartographer
936
answered Mar 19 '18 at 11:38
CartographerCartographer
936
936
add a comment |
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f274997%2fsharing-properties-for-sql-server-table-in-qgis%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
An Update. The answer provided didn't work for me and I am still researching. I was found that there had been two ways to connect to the database. Recreating the ODBC connections has meant that I can now open the original project and keep working. I now need to rebuild with all tables connecting the same way.
– Johanna
Mar 22 '18 at 21:24