View Single Post
Old 09-28-2019, 12:17 PM   #2
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,098
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by Rellwood View Post
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.
You can change the visible name without a major restructure. Just don't change the #name or type
AFAIK the gui.json will be updated if you have used the columns tool.

It might be faster/easier to create a new library and tick the 'copy structure', then use the Copy To Library, delete after tool (a move) Anything left over WAS a problem, then the old, now empty Library can be deleted
theducks is online now   Reply With Quote