Bulk Edits
Bulk Edits
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
Re: Bulk Edits
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.
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.