Vjylku

What are these boxed doors outside store fronts in New York?

Languages that we cannot (dis)prove to be Context-Free

What's the point of deactivating Num Lock on login screens?

Email Account under attack (really) - anything I can do?

What do you call a Matrix-like slowdown and camera movement effect?

Accidentally leaked the solution to an assignment, what to do now? (I'm the prof)

"to be prejudice towards/against someone" vs "to be prejudiced against/towards someone"

What is the word for reserving something for yourself before others do?

Adding span tags within wp_list_pages list items

Theorems that impeded progress

Do VLANs within a subnet need to have their own subnet for router on a stick?

Why do falling prices hurt debtors?

Why "Having chlorophyll without photosynthesis is actually very dangerous" and "like living with a bomb"?

What's the output of a record cartridge playing an out-of-speed record

Prove that NP is closed under karp reduction?

Has the BBC provided arguments for saying Brexit being cancelled is unlikely?

Python: next in for loop

Have astronauts in space suits ever taken selfies? If so, how?

Why does Kotter return in Welcome Back Kotter?

What would happen to a modern skyscraper if it rains micro blackholes?

Why are electrically insulating heatsinks so rare? Is it just cost?

Can divisibility rules for digits be generalized to sum of digits

Is it tax fraud for an individual to declare non-taxable revenue as taxable income? (US tax laws)

Minkowski space

Sharing properties for SQL server table in QGIS?

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;
}

4

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

share|improve this question

edited Mar 23 '18 at 3:31

PolyGeo♦

53.9k1781245

asked Mar 16 '18 at 5:16

JohannaJohanna

691721

bumped to the homepage by Community♦ 19 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  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 | 

4

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

share|improve this question

edited Mar 23 '18 at 3:31

PolyGeo♦

53.9k1781245

asked Mar 16 '18 at 5:16

JohannaJohanna

691721

bumped to the homepage by Community♦ 19 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  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

share|improve this question

edited Mar 23 '18 at 3:31

PolyGeo♦

53.9k1781245

asked Mar 16 '18 at 5:16

JohannaJohanna

691721

share|improve this question

edited Mar 23 '18 at 3:31

PolyGeo♦

53.9k1781245

asked Mar 16 '18 at 5:16

JohannaJohanna

691721

share|improve this question

edited Mar 23 '18 at 3:31

PolyGeo♦

53.9k1781245

asked Mar 16 '18 at 5:16

JohannaJohanna

691721

edited Mar 23 '18 at 3:31

PolyGeo♦

53.9k1781245

edited Mar 23 '18 at 3:31

PolyGeo♦

53.9k1781245

asked Mar 16 '18 at 5:16

JohannaJohanna

691721

asked Mar 16 '18 at 5:16

JohannaJohanna

691721

1 Answer
1

active

oldest

votes

0

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/)

share|improve this answer

edited Mar 23 '18 at 3:32

PolyGeo♦

53.9k1781245

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
});


}
});

draft saved

draft discarded

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

Name

Email

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

Name

Email

Required, but never shown

0

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/)

share|improve this answer

edited Mar 23 '18 at 3:32

PolyGeo♦

53.9k1781245

answered Mar 19 '18 at 11:38

CartographerCartographer

936

add a comment | 

0

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/)

share|improve this answer

edited Mar 23 '18 at 3:32

PolyGeo♦

53.9k1781245

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/)

share|improve this answer

edited Mar 23 '18 at 3:32

PolyGeo♦

53.9k1781245

answered Mar 19 '18 at 11:38

CartographerCartographer

936

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')

share|improve this answer

edited Mar 23 '18 at 3:32

PolyGeo♦

53.9k1781245

answered Mar 19 '18 at 11:38

CartographerCartographer

936

edited Mar 23 '18 at 3:32

PolyGeo♦

53.9k1781245

edited Mar 23 '18 at 3:32

PolyGeo♦

53.9k1781245

answered Mar 19 '18 at 11:38

CartographerCartographer

936

answered Mar 19 '18 at 11:38

CartographerCartographer

936