All Game Database & Update Database button "quirk&q

2005-09-18, 06:26

Just thought I would share this experience with those who are interested. While updating my rather large database of games(over 700) in the "My Programs" plugin, I decided to delete a ROM in my ROMS directory. I then opened the plugins page and instead of deleting the ROM from the database, I chose update database. Sure, this sounds fine, but it actually lost all of my ROM information data I had stored- like publisher and year created as well as descriptions. When I started mediaportal, the pictures were there, but all game data and descriptions were gone. This is a major pain to redo all of the data. Hopefully someone can benefit from this post. Just remember to remove the rom and remove the database entry manually if you decide to remove a game! I suggest never use the "Update Database" button unless you are creating a new one.

waeberd · 2005-09-18, 09:04

sorry to hear that my plugin swept away your hard work

Yes, the "Update Database" does a complete re-scan of the available roms and rebuilds the database completely. Before that - sadly in your case - all rom entries are erased.

The solution in your case would have been to select the rom and click the DELETE button.

Things I will consider to improve:
1) improve button texts, improve warning text (any suggestions?)
2) do a less aggressive "update database" procedure which conserves the downloaded data.
3) maybe optional: automatically backup the Programdatabase file before deleting many entries.

I need suggestions for 1), I think 2) should be easy to do and I don't really like 3) cause it screams for more follow-up options ("waeberd: please lemme merge data from my last five backup files...."). :-)

Tell me what you think!

Daniel

2005-09-19, 05:00

Well, I love the plugin, dont take this the wrong way. I just wanted to put it in the forum to warn people about a potential loss of data for their games. I dont really think you should put too much time into this. After all, I am the only known person to have the problem. It would be nice to be able to back up the database though. For example, I plan to help build another mediaportal PC for a friend. Is it already possible to export/import the database to a different PC with all of the same ROM files and use it?

As for your reply:
1)Button text and layouts are fine. Maybe a warning text for ROM data in the database will be cleared. 2)Less agressive update would be excellent- though I think I will still use the delete and add buttons from now on- "once bitten twice shy"

. 3)As for backing up the database- that was covered in my text above.
Thanks,
Garret

waeberd · 2005-09-19, 08:40

Garret,

no problem at all with your post, I'm trying to find ways to improve the plugin.

Quote:

Is it already possible to export/import the database to a different PC with all of the same ROM files and use it?

.

... well, almost! :-)
You can copy the ProgramDatabaseV3.db3 file to the new machine.
The problem is that there are absolute paths stored in it (yes, in every ROM-file), so if you use different drives / paths, myPrograms won't find stuff.

Using relative paths / minimising the usage of absolute paths is another one on my ToDo list (not very high prio until now...).

Cheers,

Daniel

Vrokolos · 2005-12-19, 10:43

Quote:

Originally Posted by waeberd

Things I will consider to improve:
1) improve button texts, improve warning text (any suggestions?)
2) do a less aggressive "update database" procedure which conserves the downloaded data.
3) maybe optional: automatically backup the Programdatabase file before deleting many entries.

Any updates on issue no: 2?

Can you make the "Internet Search" function launchable from within MediaPortal like IMDB?

Is the source of the plugin available? Can I have it?

Flop · 2006-01-02, 21:30

Hi- Daniel

I love the way your internet search works......

* - Auto select the games you have not downloaded images / overview
* - Select Best Match
* - Min. Relevance
* - Select what you want to download

BRILLIANT!!!!

Is there any chance you make the same kind of interface for the Movie database?????

It would be a big help for a lot of us!!

To make it even better there should be an export and import option, where the info would be stored in the same folder as the movie is.

All the best Flop

2005-09-18, 06:26	#1 (permalink)
gpeters Guest Posts: n/a	All Game Database & Update Database button "quirk&q Just thought I would share this experience with those who are interested. While updating my rather large database of games(over 700) in the "My Programs" plugin, I decided to delete a ROM in my ROMS directory. I then opened the plugins page and instead of deleting the ROM from the database, I chose update database. Sure, this sounds fine, but it actually lost all of my ROM information data I had stored- like publisher and year created as well as descriptions. When I started mediaportal, the pictures were there, but all game data and descriptions were gone. This is a major pain to redo all of the data. Hopefully someone can benefit from this post. Just remember to remove the rom and remove the database entry manually if you decide to remove a game! I suggest never use the "Update Database" button unless you are creating a new one.

2005-09-18, 09:04	#2 (permalink)
waeberd Portal Member Join Date: Aug 2004 Location: Fribourg (CH) Posts: 314 Thanks: 0 Thanked 1 Time in 1 Post	Re: All Game Database & Update Database button "qui sorry to hear that my plugin swept away your hard work Yes, the "Update Database" does a complete re-scan of the available roms and rebuilds the database completely. Before that - sadly in your case - all rom entries are erased. The solution in your case would have been to select the rom and click the DELETE button. Things I will consider to improve: 1) improve button texts, improve warning text (any suggestions?) 2) do a less aggressive "update database" procedure which conserves the downloaded data. 3) maybe optional: automatically backup the Programdatabase file before deleting many entries. I need suggestions for 1), I think 2) should be easy to do and I don't really like 3) cause it screams for more follow-up options ("waeberd: please lemme merge data from my last five backup files...."). :-) Tell me what you think! Daniel __________________

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
(original thread) US/Canadian/Mexico EPG Zap2it Plugin Released	bradsjm	zap2it (discontinued)	513	2007-02-21 14:07
[BUG] Unable to scan TV chanels and radio	Bram	pre 1.0 RC1	0	2006-11-05 13:45
Technotrend DVB-S no LNB switch	Erbsenkopp	General Support	0	2006-08-03 09:04
Technotrend Budget 1500 CI no LNB switch	Erbsenkopp	General Support	0	2006-08-03 08:46
Issue with My TV, My Videos and Web Browser	Efros	The old Bugreport Forum	15	2006-05-15 21:01

2005-09-19, 05:00	#3 (permalink)
gpeters Guest Posts: n/a	Well, I love the plugin, dont take this the wrong way. I just wanted to put it in the forum to warn people about a potential loss of data for their games. I dont really think you should put too much time into this. After all, I am the only known person to have the problem. It would be nice to be able to back up the database though. For example, I plan to help build another mediaportal PC for a friend. Is it already possible to export/import the database to a different PC with all of the same ROM files and use it? As for your reply: 1)Button text and layouts are fine. Maybe a warning text for ROM data in the database will be cleared. 2)Less agressive update would be excellent- though I think I will still use the delete and add buttons from now on- "once bitten twice shy" . 3)As for backing up the database- that was covered in my text above. Thanks, Garret

2006-01-02, 21:30	#6 (permalink)
Flop Portal User Join Date: Oct 2005 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts	Hi- Daniel I love the way your internet search works...... * - Auto select the games you have not downloaded images / overview * - Select Best Match * - Min. Relevance * - Select what you want to download BRILLIANT!!!! Is there any chance you make the same kind of interface for the Movie database????? It would be a big help for a lot of us!! To make it even better there should be an export and import option, where the info would be stored in the same folder as the movie is. All the best Flop