Bulk Edits

Any trouble you encounter with the Pedias, here's the place to ask for help.
Post Reply
wanaka3
Bruji Friend
Bruji Friend
Posts: 15
Joined: Tue Aug 25, 2009 9:53 pm

Bulk Edits

Post by wanaka3 »

Hey there, Using CDPEDIA: I am wanting to move all info from a custom field into a standard field (somewhere along the line I started using a custom field for entering Catalogue info when I should have been using the standard Catalog # ). Is there a script or functionality that i am not aware of do help me with this. Thanks Chris
User avatar
Nora
Site Admin
Posts: 2155
Joined: Sun Jul 04, 2004 5:03 am
Contact:

Re: Bulk Edits

Post by Nora »

There is no internal function, but you can do so directly in the database that is open SQL. To do so, first make a backup (Copy) of your data file in ~/Library/Application Support/CDpedia/Database.cdpd.

To move the info copy paste these three commands into the program called "Terminal" in /Applications/Utilities folder while CDpedia is not running.

sqlite3 ~/Library/Application\ Support/CDpedia/Database.cdpd
update zEntry set zCatalogNumber = zCustom1 where zCatalogNumber is not null;
.exit

You need to update "zCustom1" to match the number of the custom field that you used original, hovering with the mouse over the custom field in "CDpedia -> Preferences -> Fields" will display the custom number of the field.
Post Reply