Its there a tool to clean everything?

[ode1979]

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.

[Tom Speirs]

 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.

[ode1979]

Thank you sir, thats what i thouhgt

[Mike_da_Spike]

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

[ode1979]

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

• Hide Mike_da_Spike's signature
• Hide all signatures

 

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. 

[scutters]

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..

[ode1979]

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?

[scutters]

That's strange.. i see it as tab in my output. Not sure why you don't.

Workaround might be to paste the section you're interested in into https://www.browserling.com/tools/spaces-to-tabs ? (i guess the spaces you see are consistently 4). Or in batch look for 4 spaces instead of tab.

 

[Draco1962]

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.

[Mike_da_Spike]

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.

• Hide Draco1962's signature
• Hide all signatures

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 ) 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 !

[ode1979]

12 hours ago, scutters said:

That's strange.. i see it as tab in my output. Not sure why you don't.

Workaround might be to paste the section you're interested in into https://www.browserling.com/tools/spaces-to-tabs ? (i guess the spaces you see are consistently 4). Or in batch look for 4 spaces instead of tab.

 

Thanks , let me try.

[ode1979]

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.

• Hide Draco1962's signature
• Hide all signatures

 

 

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.

[ode1979]

Thanks mike, but dont just make the batch file for me, teach me how is done please. This is what i get. And keep in mind im still making the videos so alot is missing. Thanks in advance.

futurepinball output.txt

[scutters]

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. 

[BrandonLaw]

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.

• Hide Draco1962's signature
• Hide all signatures

 

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.  

[Mike_da_Spike]

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

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

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

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  ) 

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  

[scutters]

12 hours ago, Mike_da_Spike said:

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

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

[ode1979]

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

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

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

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

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  ) 

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  

• Hide Mike_da_Spike's signature
• Hide all signatures

http://http.online.gameex.com/gamecards/pinballx/mike-da-spike___pinball.png 

Also try  PinballX Database manager as an alternative way for gamemanger

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.

[Mike_da_Spike]

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

[ode1979]

14 hours ago, Mike_da_Spike said:

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

• Hide Mike_da_Spike's signature
• Hide all signatures

http://http.online.gameex.com/gamecards/pinballx/mike-da-spike___pinball.png 

Also try  PinballX Database manager as an alternative way for gamemanger

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

[scutters]

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 

[Mike_da_Spike]

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 users

[ode1979]

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.

[Mike_da_Spike]

Your pinball collection is never finished!

For mame games, nothing new will be released. But pimball... every week multiple new or updated tables.