Delete Database item

[lar282]

I want to be able to delete a database item from within XL. Or even better, when I delete a movie from the hardrive the item in the datasbe should be deleted.


//Lasse

[m_ski]

Lasse, there is a built in command to delete a database item. Steven uses it in the default skin on the musicviewer overlay.

[lar282]

thanks for the tip
I must be blind cause I couldn't find it. Can u give me a hint where the command is?
categorie
xlobby??


regards

//Lasse

[tswhite70]

I think it's OS:Delete which physically deletes the item based on Parameter value from the hard drive. There's an optional Category for the command. I've never used the command though so I'm not sure if you have to do a category refresh to see the change.

good luck,
tsw

[Atlas]

I use this function for my HD recordings. You are correct in using OS:Delete and put in the category name. It will delete the database item and the file. Since you are wanting to delete the movie you will need a script to "clean up" the rest. If you have IFO files it will only delete your video_ts.ifo file. If it is .iso then you are probably fine with just the OS:delete.

In my event I use the OS:delete then OS:execute to execute a batch file. I pass in info from the category for it to clean up the rest of the directory(ies).

[lar282]

I use this function for my HD recordings. You are correct in using OS:Delete and put in the category name. It will delete the database item and the file. Since you are wanting to delete the movie you will need a script to "clean up" the rest. If you have IFO files it will only delete your video_ts.ifo file. If it is .iso then you are probably fine with just the OS:delete.

In my event I use the OS:delete then OS:execute to execute a batch file. I pass in info from the category for it to clean up the rest of the directory(ies).

thanks u all.
Atlas:
U willing to share the script that cleans up folder an files?


//Lasse

[lar282]

I looked at my command and I actually had a categorie set already. In my case it is movies2. Still the categorie entry does not get deleted.
Are u sure your still works with the latest EXE




//Lasse

[lar282]

bump

[Atlas]

Haven't been around the forum for awhile.

I took a closer look and I too have a problem deleting w/o a refresh for a single item. I use it on tv shows and my directory looks like

show1/episode1.tp
/episode2.tp
/episode3.tp
show2/episode1.tp
etc.


Now when I delete an episode it disappears from the database (I only see remaining entries) but when I delete the last episode the "show" level stays in the db. It will only disappear when I do 'refresh'. This is probably how your movies are behaving.

My order for the event is

OS::execute file-- File: delrec.bat Arguments "%myHDcat>name%" "%myHDcat>episode%" Window Type: hidden
OS::delete -- Category: myHDcat

Then my bat file is straight forward

del D:\pvr\%1\%2_*.tp

Note that I just do a _* since the OS::delete took care of deleting the main file that is recognized as a db item (determined by my metamasks).

You could just have an event for delete that executes a batch file to delete the directory and then a refresh. This might not be good based on how big your movie collection is.