Edit MovingPictures.db3 (1 Viewer)

[alexeiei]

Hi.

I would like to know if is there any (easy) way of editing the database. I want to change the "genres" cell, once the movie is added to the DB, in order to eliminate duplicated genres (action=accion=acción= etc...)

Thanks.

 

[lillis_55]

You can edit movie details in movingpictures configuration window, movie manager tab. Don't know any other way.

 

[RoChess]

Hi.

I would like to know if is there any (easy) way of editing the database. I want to change the "genres" cell, once the movie is added to the DB, in order to eliminate duplicated genres (action=accion=acción= etc...)

Thanks.

You can edit the database direct with any SQLite tool, and then you can use SQL queries to do a mass update.

The table you are after is `movie_info` and the column is `genres`. So you can do something like:

• UPDATE `movie_info` SET genres = REPLACE(genres, '|Accion|', '|Action|');

Which will mass-replace any Genre called 'Accion' with 'Action'.

 

[SilentException]

or, sqllite database browser is what does the job for me...