[Dobbin]

Hi.
Is there a easy to use GUI tool to enable me to see and change the XBMC database.
This is so that I can amend or expand on certain entries (e.g. expand the synopsis).
Thanks

[drpizznock]

http://wiki.xbmc.org/index.php?title=Add-on:XWMM

[un1versal]

Perhaps http://forum.xbmc.org/showthread.php?tid=113136

I dont use it or know anything about it.

uNi

[Dobbin]

Thanks to both of you.
I am finding XWMM a bit flakey. The full list of Movies does not always show up?

Is there a simple editor something like access or excel using a simple columns and rows spreadsheet like display?

[Martijn]

Sql browser

[Dobbin]

Sql browser

Thanks.
I've had a look at SQL Browser and it doesn't seem to give me a row and columns type format in order to add/edit the movie etc. entries in the .db file.
It still looks very command line driven.
Am I missing something?

[un1versal]

http://portableapps.com/apps/development...r_portable

uNi

[Robotica]

maybe try navicat..

[Dobbin]

Thanks to both of you.
I have had a quick try and found Navicat to be pretty good.
However I didn't fancy paying the $79 for it.

DatabaseBrowserPortable seems pretty good However I keep getting a "Database Browser" error whenever I try to amend the fields.
The error says

near "WHERE": syntax error

Ah well.........maybe you get what you pay for?

[un1versal]

look at http://sourceforge.net/projects/sqlitebrowser/

or perhaps at a non portable version of database browser http://www.etl-tools.com/database-editor...rview.html

I'm sure there's tons of other options that are gpl and "free" as in free beer.

uNi

[Dobbin]

uNi

Thanks.
I've had a quick try of both and found SQLite Database Browser works very well.
It's DESCRIPTION says

SQLite Database browser is a light GUI editor for SQLite databases, built on top of Qt. The main goal of the project is to allow non-technical users to create, modify and edit SQLite databases using a set of wizards and a spreadsheet-like interface.

It makes it very easy to use and change fields in my databases.

Thanks again.

[un1versal]

Fantastic glad it was helpful

+1

You can mark the topic as SOLVED for future reference, if anyone happens to read it or find it.

uNi

[scott967]

I use sqlite-manager extension in Firefox on Windows, though mainly for browsing the db, I haven't done a lot of heavy editing.

scott s.
.

[Dobbin]

I use sqlite-manager extension in Firefox on Windows, though mainly for browsing the db, I haven't done a lot of heavy editing.

scott s.
.

Scott

I gave that a try and found it to be very good and again easy to use.

Thanks

Peter