Jump to content

All my products and services are free. All my costs are met by donations I receive from my users. If you enjoy using any of my products, please donate to support me. Thank you for your support. Tom Speirs

Patreon

Its there a tool to clean everything?


ode1979

Recommended Posts

Hey thanks for reading, i continue on my pinball set up, as just found a torrent with lots of games and systems, i have most systems set'up, but i was wondering, is there a tool that cleans everything up? i have lots of media thats not used by PBX , i would like to get rid off all that. Thanks for any help.

Link to comment
Share on other sites

 I'm not aware of anything current. It tends to be a manual process. The normal thing people do is do one item at a time and cherry pick individual tables. PinballX was designed from the get go for just the best of the best games rather than absolutely everything. Hopefully that answers the question for you and everyone else.

Link to comment
Share on other sites

In Database manager, we have an Audit Media option.

It will check your media files against your tables .

This will generate a list with potential files that can be deleted.

Create a batch file and move the files to another folder, before you delete them

Database manager can be downloaded in the download section

Link to comment
Share on other sites

On 10/20/2020 at 8:38 PM, Mike_da_Spike said:

In Database manager, we have an Audit Media option.

It will check your media files against your tables .

This will generate a list with potential files that can be deleted.

Create a batch file and move the files to another folder, before you delete them

Database manager can be downloaded in the download section

 

Also try  PinballX Database manager as an alternative way for gamemanger

So i just tried it, and it looks that the missing media, and the media that its not needed and more, gets copied to the clipboard, if i paste it on a regular notepad to create  a batch file, the info has the size of the image file at the end, example "C:\PinballX\Media\Future Pinball\Wheel Images\Tomb Raider (Original) (0.9).png    1,331.0 KB" making it hard to create a batch file, and if i paste it to an exel document i just get the names of the files without and extention , again making it har to create a batch file, maybe im missing something, let me look further. 

Link to comment
Share on other sites

38 minutes ago, ode1979 said:

So i just tried it, and it looks that the missing media, and the media that its not needed and more, gets copied to the clipboard, if i paste it on a regular notepad to create  a batch file, the info has the size of the image file at the end, example "C:\PinballX\Media\Future Pinball\Wheel Images\Tomb Raider (Original) (0.9).png    1,331.0 KB" making it hard to create a batch file, and if i paste it to an exel document i just get the names of the files without and extention , again making it har to create a batch file, maybe im missing something, let me look further. 

The output has tab separated values, so you should be able to split on the tab character to read the file names only.  Note that you still need to verify the file names manually, it was written deliberately not to automatically delete unused media it finds (which it could do) as the program uses exact matching only (so results may be wrong if you toggle File Matching in PinballX) and you may wish to use images rather than videos in the front end etc.   Hope that helps..

Link to comment
Share on other sites

Well in notepad i get this:

C:\PinballX\Media\Future Pinball\Wheel Images\Tomb Raider (Original) (0.9).png    1,331.0 KB

so i dont see a tab.

In exel, i get :

Tomb Raider (Original) (0.9)      tab    wheel image

Non of them seem to be usefull to create a batch  file.

Should i use some othe software  to make the batch file?

Link to comment
Share on other sites

A word of caution as I've seen many posts on Facebook where someone has downloaded a torrent or Megaupload full of tables, media, etc.  They run into problems because some of these ready-made collections are often incomplete or not properly configured. 

Slow as it is, unless I know the source personally, I download and install one table at a time, including related media. A smaller Charlie-Foxtrot is easier to diagnose and fix than a large one.

  • Like 1
Link to comment
Share on other sites

11 hours ago, ode1979 said:

In exel, i get :

Tomb Raider (Original) (0.9)      tab    wheel image

The tab is in excel ? So you are able to split it on tab ?

Otherwise paste the output to a text file and attach it. I will check to create a nice batch file for you

 

7 hours ago, Draco1962 said:

A word of caution as I've seen many posts on Facebook where someone has downloaded a torrent or Megaupload full of tables, media, etc.  They run into problems because some of these ready-made collections are often incomplete or not properly configured. 

Slow as it is, unless I know the source personally, I download and install one table at a time, including related media. A smaller Charlie-Foxtrot is easier to diagnose and fix than a large one.

Totally agree with you Draco.

The beauty of pinball, is to get the vpx file, search for a nice backglass, get the rom, add it to pinballx (with database manager of course :P) search for all the media, flyers and instruction cards

Than create the playfield and backglass video and finally make a nice video for the realdmd.

Thats the way I like it !

  • Like 1
Link to comment
Share on other sites

10 hours ago, Draco1962 said:

A word of caution as I've seen many posts on Facebook where someone has downloaded a torrent or Megaupload full of tables, media, etc.  They run into problems because some of these ready-made collections are often incomplete or not properly configured. 

Slow as it is, unless I know the source personally, I download and install one table at a time, including related media. A smaller Charlie-Foxtrot is easier to diagnose and fix than a large one.

Well, i ran into the same problem. But little by little im fixing all of the games i have. I enjoy it. As for playing, most of the games i have played seem to work just fine.

  • Like 1
Link to comment
Share on other sites

I have to re-learn batch files every time i make one so i'll leave that in Mikes capable hands, but from a quick look i'm guessing you're running a two screen setup so unless you plan to add a real or lcd DMD screen later on you should be safe to lose all the DMD Images/DMD Videos/Real DMD Color Videos media. That should reduce the output a bit. 

Link to comment
Share on other sites

22 hours ago, Draco1962 said:

A word of caution as I've seen many posts on Facebook where someone has downloaded a torrent or Megaupload full of tables, media, etc.  They run into problems because some of these ready-made collections are often incomplete or not properly configured. 

Slow as it is, unless I know the source personally, I download and install one table at a time, including related media. A smaller Charlie-Foxtrot is easier to diagnose and fix than a large one.

The journey is the fun of cab ownership!  I truly think of it as getting a new Pinball Table.  I try to learn some of the rules and making it nice, fitting, and personal adjustments is the fun.  Hell, I already have a hard time playing tables more than once or twice...I can't imagine getting dumped on with tables.  Not sure I'd value the hobby as much.  

  • Like 3
Link to comment
Share on other sites

What I did :
I copied only the lines from "Unused media" :

image.png.cbc9c2613a701154d667b00763a2f1a1.png

And paste it to Excel :
It directly put it in the correct format :

image.png.37b991bc6446d0b3a2a3edd01daca870.png

In column C, I made a small function ="del """&A1&""""" :

image.png.bf972b23da95fcab66479270d253ac78.png

And copied that to the end if the last entry , I copied it to a text files and renamed it for you :
DeleteFiles.cmd

Within 1 minute I was finished (and 3 minutes to capture to get the screenshots :P ) 

Be aware as on top of the block is stated:

*********************************************************************************************************
UNUSED MEDIA - Not used by current system (enabled & disabled tables). Does not include 'global' media (Flyers, Instructions and Loading files).
Please verify before actioning. Duplicate file names of different types (e.g. .mp4 and .flv) will be listed once, verify the file to keep.
*********************************************************************************************************

A delete is a delete :) 

  • Like 1
Link to comment
Share on other sites

12 hours ago, Mike_da_Spike said:

Within 1 minute I was finished (and 3 minutes to capture to get the screenshots :P ) 

And there i was thinking about a batch file to parse through a text file :lol:.  I guess you found the easy way! good job Mike.

Link to comment
Share on other sites

On 10/23/2020 at 3:21 AM, Mike_da_Spike said:

What I did :
I copied only the lines from "Unused media" :

image.png.cbc9c2613a701154d667b00763a2f1a1.png

And paste it to Excel :
It directly put it in the correct format :

image.png.37b991bc6446d0b3a2a3edd01daca870.png

In column C, I made a small function ="del """&A1&""""" :

image.png.bf972b23da95fcab66479270d253ac78.png

And copied that to the end if the last entry , I copied it to a text files and renamed it for you :
DeleteFiles.cmd

Within 1 minute I was finished (and 3 minutes to capture to get the screenshots :P ) 

Be aware as on top of the block is stated:


*********************************************************************************************************
UNUSED MEDIA - Not used by current system (enabled & disabled tables). Does not include 'global' media (Flyers, Instructions and Loading files).
Please verify before actioning. Duplicate file names of different types (e.g. .mp4 and .flv) will be listed once, verify the file to keep.
*********************************************************************************************************

A delete is a delete :) 

Thanks for the update, you know , when i paste the info into exell, i get just the name of tthe tables, perhaps theres an automatization setting on my exel , let me try on google docs , thanks alot.

Link to comment
Share on other sites

14 hours ago, Mike_da_Spike said:

Maybe we can make an easier way for media audit in a future release

maybe just remove the extra not needed info,like image size.

Link to comment
Share on other sites

On 10/27/2020 at 5:47 PM, ode1979 said:

maybe just remove the extra not needed info,like image size.

The original version didn't have file size data, that was added as extra info later. I guess we might struggle to please everyone!.

Hope you got your media cleaned up anyway :)

Link to comment
Share on other sites

16 minutes ago, scutters said:

The original version didn't have file size data, that was added as extra info later. I guess we might struggle to please everyone!.

Hope you got your media cleaned up anyway :)

Maybe we can have an internall discusion. To please all our usersB)

Link to comment
Share on other sites

Well, the database manager its a great tool indeed, im pretty much new here, so i really dont know its history, to be hnest im not gonna be using it too much, once i clean the media thats not need, ill probably have my games collection ready. I really apreciate all of the developers hard work here and the fact that you guys made all this available for free. Without yu guys we wouldnt have all this fun, thanks again.

  • Thanks 2
Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...