Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By InterceptPoint on
I need to edit certain CCK fields in a large group of nodes of a certain content type. It would nice to do this by manually changing the values in an editable table environment like you would do with an Excel worksheet or a table in FoxPro or Access. Is there anyway to do that with an existing Drupal module?
Comments
You can probably do something
You can probably do something like that with phpMyAdmin. You could export the tables using phpmyadmin then read that file into a good text editor - I use Text Wrangler on Mac and mass edit them there and then import them back into your database using phpmyadmin.
I think you can use phpmyadmin to edit all fields across records at one time too - I've forgotten if that is possible. If it is there would be no need to export and then import you could do it is situ.
If your database is big, and
If your database is big, and you know your way around a terminal, then you can do large search and replaces on a text file quicker by using the 'sed' command.
THats assuming you're on a linux/OS X based operating system.
--
Ixis (UK): Drupal support, Drupal hosting.