I’m currently at a customer site, and I found that a lot of documents had data in the wrong field („IPTC02015“ instead of „Category“). An excellent opportunity to play with the DC-X command line tools:
php /opt/dcx/bin/dcx_textquery.php –app default ‚+IPTC02015:[* TO *]‘ -m 1000 | php /opt/dcx/bin/dcx_export.php –app default -t document – | sed ’s/IPTC02015>/Category>/g‘ | php /opt/dcx/bin/dcx_update.php –app default –
This invocation performs a fulltext search for all documents which have the field „IPTC02015“ set, feeds the document IDs into a script that exports these documents as XML, runs „sed“ to change the field name, and uses the modified XML to update the document in the DC-X database. (The fulltext index is automatically updated.) Marvellous!