Transfer Value of Field to Another Field under Content Type Manage Fields

Question

I have created several content types and unfortunately, I made a mistake on some of the fields. The fields are field_image and field_screenshot.

Under manage fields, I use field_image and sometimes field_screenshot. Now I want to use one field only for featured image on my node content. So, how can I transfer the value of field_image to field_screenshot? Is this possible?

Answer 1

No, this is not easily possible through the Drupal interface. You will need to execute a custom SQL query to move your data from one field to another.

The following two queries will copy all field data from field_image to field_screenshot for each entity where field_screenshot is empty.

INSERT INTO field_data_field_screenshot
SELECT a.* 
FROM field_data_field_image a
LEFT JOIN field_data_field_screenshot b ON a.entity_id = b.entity_id
AND a.entity_type = b.entity_type
WHERE b.entity_id IS NULL

and

INSERT INTO field_revision_field_screenshot
SELECT a.* 
FROM field_revision_field_image a
LEFT JOIN field_revision_field_screenshot b ON a.entity_id = b.entity_id
AND a.entity_type = b.entity_type
WHERE b.entity_id IS NULL

After running this you can then delete the first field.

If field_screenshot alreadly has data that you want to overwrite you will need to delete it first using these queries. Make sure this is what you want to do first because this WILL delete your data

TRUNCATE TABLE field_data_field_screenshot
TRUNCATE TABLE field_revision_field_screenshot

Answer 2

Here is how you can do it in a module with COMBO of db_query and db_insert

$result = db_query('SELECT a.* 
  FROM {field_data_field_image} a
  LEFT JOIN {field_data_field_screenshot} b ON a.entity_id = b.entity_id
  AND a.entity_type = b.entity_type
  WHERE b.entity_id IS NULL'
);

$records = $result->fetchAll();
foreach ($records as $record) {
  db_insert('field_data_field_screenshot') // Table name no longer needs {}
        ->fields(array(
          'entity_type' => $record->entity_type,
          'bundle' => $record->bundle,
          'deleted' => $record->deleted,
          'entity_id' => $record->entity_id,
          . // All Columns
          .
          .
          .
        ->execute();
}

And repeat the revision field as well.