Quote:
Originally Posted by Rellwood
I have a lot of libraries with different variations of the same column. It's taking forever to standaradize all the columns.
Can I just go into the .db file and change the column names?
If I do, will this be a problem with the metadata_db_backup.json?
Is there an easier way to do this than going into each library and manually changing the columns. Making sure each column matches up gets tedious.
I have the list of all the columns in all the libraries, it's just a pain to match up all the libraries that need editing, going into them, changing the columns, and hoping I didn't miss one or get it wrong.
|
I wouldn't even contemplate changing my library databases directly. So, I'm not going to speculate what the consequences would be of you changing your library databases directly.
AFAIK the only place you can
change Custom column attributes is
Preferences->Add Your Own Columns->Edit Settings of user defined columns -- you can't change the Column Type attribute. The calibredb command has
add_custom_column and
remove_custom_column sub-commands.
Or do something along the lines as that suggested by theducks.
BR