Migrate existing files from core Upload to Filefield [#656204]

Hi,

I would like to switch from the core Upload module to FileField, but I already have file attachments which were uploaded via the core module. Can someone please give me some hints on how can I do this migration automatically, using a PHP script and the information already stored in the database?
I've created a FileField field for the content type I have, and I've looked at the "upload" table and the "content_field_CONTENT_TYPE_attachments" table created by CCK, and the information looks similar, so I tried to add a new row to the content_field_CONTENT_TYPE_attachment table, based on the info in one of the "upload" table rows, but the attachment does not appear on the page, so I guess I need to do some other modifications as well.

Can anyone give me some pointers?

Thank you.

Comment	File	Size	Author
#7	ohai.drush_.inc_.gz	1.21 KB	kaare

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

katiusha CreditAttribution: katiusha commented 22 January 2010 at 18:45

Component:	Documentation	» Code
Category:	feature	» support

Comment #2

quicksketch

he/him

CreditAttribution: quicksketch commented 23 January 2010 at 00:31

There are several examples of how to migrate from other modules (Image, Audio, Node Images) in the FileField Handbook: http://drupal.org/node/432852. I'd suggest trying to adapt one of those examples to work with Upload module. When finished, it would be helpful to others in the future to add your own solution as a new page to that handbook section.

Comment #3

stacysimpson CreditAttribution: stacysimpson commented 15 February 2010 at 04:01

Did you ever put together a script?

Comment #4

quicksketch

he/him

CreditAttribution: quicksketch commented 28 April 2010 at 23:28

Status:

Active

» Closed (fixed)

Closing after lack of activity.

Comment #5

juan.bangkok CreditAttribution: juan.bangkok commented 4 July 2010 at 04:48

I'm in the same situation as the OP. I've been looking for a script to do this in the forums without success. If there isn't one I'll try to code it and post it here before for review (it'll be my first PHP script *ever*). Otherwise it'd be great to know where to find it to avoid reinventing the wheel.

Comment #6

Anonymous (not verified) CreditAttribution: Anonymous commented 22 July 2010 at 03:03

Hey there,

I stumbled across this script here: http://castlin.net/blog/1/2009/12/migrating-d5-upload-module-d6-cck-file...

Basically, it does what you want. However, you have to check that all the names of fields/tables etc. are correct. I had to correct some typos too. Here's the version I used to migrate all my files from Upload to FileField:

<?php

function _migrate_upload_to_filefield() {
  $files = db_query("SELECT * FROM upload WHERE nid > 0 ORDER BY nid ASC, fid ASC");
 
  $nid = 0;
  
  while ($file = db_fetch_array($files)) {
//print_r($file);
    $attachment = new stdClass();
    
    // D5 didn't have weights, 
    // so we'll store things in the order they were uploaded
    if ($nid != $file['nid']) {
      $delta = 0;
      $nid = $file['nid'];
    }
    
    $attachment->vid = $file['vid'];
    $attachment->nid = $file['nid'];
    $attachment->delta = $file['weight'];
    $attachment->field_attachement_fid = $file['fid'];
    $attachment->field_attachement_list = $file['list'];
    // schema will take care of the serialization
    $attachment->field_attachement_data = array('description' => $file['description']);
print_r($attachment);
    if(drupal_write_record('content_field_attachement', $attachment)==FALSE) {print "failed\n"; }
  }
}
_migrate_upload_to_filefield();

?>

Use with caution - no warranties etc. :-)

Comment #7

kaare

him/his

Norwegian Bokmål

Tromsø

CreditAttribution: kaare commented 27 October 2010 at 18:27

File	Size
ohai.drush_.inc_.gz	1.21 KB

I've recently done this myself, and took this script and refined it a bit. It now only converts files to content types that has a valid filefield for attachment. It's a drush script and can be run as many times as desired.

Put it in ~/.drush as ~/.drush/ohai.drush.inc and run drush ohai-convert from your host.

Comment #8

roderik

Dutch

Amsterdam,NL / Budapest,HU

CreditAttribution: roderik commented 9 April 2011 at 17:55

Downloaded the script in #7. Ran it. Like it.

Note to casual readers entering at comment #7:

- you need to make sure that the FileField is already added to your content type (obviously)

- you need to edit the file, to change the field name of your FileField, at the top of the code. (Unless it's "field_attachment").

- if you have multiple content types with different field names set up, that's fine. Change the field name at the top of the script to "field_attachmentname-in-type-1" and run it; part of the attachments will get converted. Then cange the field name to "field_attachmentname-in-type-2" and run it again.

Comment #9

SpriteGF CreditAttribution: SpriteGF commented 1 May 2011 at 16:26

For those searching, there's additional discussion on migrating Upload to FileField here in the Drupal Handbook: http://drupal.org/node/893074

Comment #10

rv0 CreditAttribution: rv0 commented 23 May 2011 at 11:48

great script in #7

one note though, on line 24

  $files = db_query("select * from upload where nid > 0 and vid > 0 order by nid, vid, weight, fid");

change that to

  $files = db_query("select * from {upload} where nid > 0 and vid > 0 order by nid, vid, weight, fid");

Otherwise it wont work with table prefixes..
Other than that, it works perfectly, converted 100s of nodes in no-time.

EDIT:
more comments:
- it doesnt clean out the upload table afterwards.
- it doesnt move the files to the filefields upload path.

Comment #11

Encarte CreditAttribution: Encarte commented 7 October 2011 at 00:12

Subscribing

Comment #12

kmillecam CreditAttribution: kmillecam commented 6 September 2012 at 15:30

Regarding the Drush script provided in comment #7, I'm getting this error:

Drush command terminated abnormally due to an unrecoverable error.                       [error]
Error: Call to undefined function db_fetch_array() in
/home/iade118/.drush/ohai.drush.inc, line 27