Ignore my comment about the multiple edit, you're correct that this would not work for your case. Do see below that you can use multiple edit to delete the values of a field.
What I want to do is for every record, move the contents of the field "Summary" to the field "Custom Text 1".
That's exactly what's described
in this thread, as linked in my previous post. In that particular thread the user is changing the path of his links so maybe that was not the ideal example but take a look at
this thread or
this one instead. (All of these threads refer to version 4 so you'd have to adjust the name of the database file which has changed with version 5 from Database.pediadata to Database.dvdpd.)
The following would be what you'd have to run in Terminal to move information from Summary into Custom Text 1:
- Code: Select all
sqlite3 ~/Library/Application\ Support/DVDpedia/Database.dvdpd
update zEntry set zCustomText1 = zSummary;
.exit
Then in DVDpedia use the multiple edit to delete the value of the Summary field for all entries before updating it from whatever source you want. This can be done in the SQL with the command line but we recommend doing it in DVDpedia since it is more obvious what information you're deleting. However if you want to do it all together in SQL, it would then look like this:
- Code: Select all
sqlite3 ~/Library/Application\ Support/DVDpedia/Database.dvdpd
update zEntry set zCustomText1 = zSummary;
update zEntry set zSummary = NULL;
.exit