[GIS] QGIS 2.10.1 Copy and Paste Problem – Attributes not showing

copyfields-attributesqgis-2.10

I have two shp layers with different numbers of fields and slightly different attributes of those field, like the column name or field length.
I arranged them so they are in the same order and now want to copy points from the Layer Georef_FO to the Layer Georef_FO_2.
Screenshot attached.

I put both layers in edit mode while in the attribute table window and then just copied all records from Georef_FO and pasted them into Georef_FO_2.
I get all the points on the map but no information in the Name Field, just NULL Values.
(the "Name" colums is right now the only column in Georef_FO containing any information and I want this to be copied into the layer "Georef_FO_2".

Restarting QGIS doesn´t make the values appear in Georef_FO_2. There are still only NULL Values.

I couldnt find out how to change field length of a field in an existing layer, so if that may be helpful please explain how to do that.

Best Answer

In order to copy/paste attributes, the field names must match so that QGIS knows where to correctly copy the attributes to. From the Processing Toolbox (using Processing plugin version 2.10.2), there is a tool called "Refactor fields".

This allows you to change the field structure of your shapefile such as name, length etc:

So if you want the name attributes to be copied successfully, make sure both shapefiles have a common field name.

Hope this helps!

Related Solutions

QGIS – Copy First Row of Attributes and Paste for Each Feature

Although you're asking for an answer related to value map combo-boxes, I thought to provide an alternative where you could use the following code to read the values in the first row for each column and copy it for each of the attributes. Select the layer in QGIS and copy/paste the code into the Python Console (Plugins -> Python Console or Ctrl + Alt + P):

layer = qgis.utils.iface.activeLayer()
layer.startEditing()
for field in layer.pendingFields():
    name = field.name()
    request = QgsFeatureRequest().setFilterFid(0)
    feat = layer.getFeatures(request).next()
    result = feat[name]
    for feature in layer.getFeatures():
        feature[name] = result
        layer.updateFeature(feature)

This is not automated, which is what you seem to be asking for. But I hope it helps a little anyway! Tested this on QGIS 2.8.2-Wien.

Update:

If you want to run the above script in the graphical modeler, first select the Create new script tool from Processing Toolbox -> Scripts. Note you said 7 columns but gave 8 :). Then insert the following:

##Copy attributes from first row=name
##Layer=vector

import qgis
from qgis.core import *

layer = processing.getObject(input)
layer.startEditing()
for field in layer.pendingFields():
        name = field.name()
        request = QgsFeatureRequest().setFilterFid(0)
        feat = layer.getFeatures(request).next()
        result = feat[name]
        for feature in layer.getFeatures():
                if name == 'ALT_0':
                        feature[name] = result
                        layer.updateFeature(feature)
                if name == 'ALT_1':
                        feature[name] = result
                        layer.updateFeature(feature)
                if name == 'ALT_2':
                        feature[name] = result
                        layer.updateFeature(feature)
                if name == 'ALT_3':
                        feature[name] = result
                        layer.updateFeature(feature)
                if name == 'ALT_4':
                        feature[name] = result
                        layer.updateFeature(feature)
                if name == 'ALT_5':
                        feature[name] = result
                        layer.updateFeature(feature)
                if name == 'ALT_Ideale':
                        feature[name] = result
                        layer.updateFeature(feature)
                if name == 'ALT_propos':
                        feature[name] = result
                        layer.updateFeature(feature)

Also note that I purposely did not save the changes just incase there's a mistake. If you want the script to save the changes, use the layer.commitChanges() code at the end of the script outside all the for loops.

I tested this and it seems to work so hopefully it will for you too =)

QGIS – Getting Integer Based on String Value in Another Field

Use single quotes ' as string indicator, not ". Double quotes are used as Field indicator in QGIS field calculator. So your expression compares two fields, where the second one does not exist or is not equal to your first field, thats why it always jumps to the else case. Try this:

CASE 
  WHEN "CORINE" = 'AG' 
  THEN 1
  WHEN "CORINE" = 'BG' 
  THEN 2
  WHEN "CORINE" = 'LW' 
  THEN 3
  WHEN "CORINE" = 'NW' 
  THEN 4
  WHEN "CORINE" = 'MW' 
  THEN 5
  WHEN "CORINE" = 'WW' 
  THEN 6
  WHEN "CORINE" = 'WA' 
  THEN 7
  WHEN "CORINE" = 'DK' 
  THEN 8
  WHEN "CORINE" = 'LN' 
  THEN 9
  WHEN "CORINE" = 'NV' 
  THEN 11
  WHEN "CORINE" = 'SU' 
  THEN 12
  WHEN "CORINE" = 'SV' 
  THEN 13
  WHEN "CORINE" = 'TM'
  THEN 14  
  ELSE 0
END

Best Answer

Related Solutions

QGIS – Copy First Row of Attributes and Paste for Each Feature

QGIS – Getting Integer Based on String Value in Another Field

Related Question