ode1979 Posted October 20, 2020 Share Posted October 20, 2020 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 More sharing options...
Tom Speirs Posted October 20, 2020 Share Posted October 20, 2020 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 More sharing options...
ode1979 Posted October 20, 2020 Author Share Posted October 20, 2020 Thank you sir, thats what i thouhgt Link to comment Share on other sites More sharing options...
Mike_da_Spike Posted October 21, 2020 Share Posted October 21, 2020 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 More sharing options...
ode1979 Posted October 22, 2020 Author Share Posted October 22, 2020 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. Link to comment Share on other sites More sharing options...
scutters Posted October 22, 2020 Share Posted October 22, 2020 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 More sharing options...
ode1979 Posted October 22, 2020 Author Share Posted October 22, 2020 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 More sharing options...
scutters Posted October 22, 2020 Share Posted October 22, 2020 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. Link to comment Share on other sites More sharing options...
Draco1962 Posted October 22, 2020 Share Posted October 22, 2020 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. 1 Link to comment Share on other sites More sharing options...
Mike_da_Spike Posted October 22, 2020 Share Posted October 22, 2020 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 ! 1 Link to comment Share on other sites More sharing options...
ode1979 Posted October 22, 2020 Author Share Posted October 22, 2020 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. Link to comment Share on other sites More sharing options...
ode1979 Posted October 22, 2020 Author Share Posted October 22, 2020 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. 1 Link to comment Share on other sites More sharing options...
ode1979 Posted October 22, 2020 Author Share Posted October 22, 2020 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 Link to comment Share on other sites More sharing options...
scutters Posted October 22, 2020 Share Posted October 22, 2020 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 More sharing options...
BrandonLaw Posted October 23, 2020 Share Posted October 23, 2020 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. 3 Link to comment Share on other sites More sharing options...
Mike_da_Spike Posted October 23, 2020 Share Posted October 23, 2020 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 1 Link to comment Share on other sites More sharing options...
scutters Posted October 23, 2020 Share Posted October 23, 2020 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. Link to comment Share on other sites More sharing options...
ode1979 Posted October 27, 2020 Author Share Posted October 27, 2020 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. Link to comment Share on other sites More sharing options...
Mike_da_Spike Posted October 27, 2020 Share Posted October 27, 2020 Maybe we can make an easier way for media audit in a future release Link to comment Share on other sites More sharing options...
ode1979 Posted October 27, 2020 Author Share Posted October 27, 2020 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. Link to comment Share on other sites More sharing options...
scutters Posted October 29, 2020 Share Posted October 29, 2020 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 More sharing options...
Mike_da_Spike Posted October 29, 2020 Share Posted October 29, 2020 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 Link to comment Share on other sites More sharing options...
ode1979 Posted October 29, 2020 Author Share Posted October 29, 2020 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. 2 Link to comment Share on other sites More sharing options...
Mike_da_Spike Posted October 30, 2020 Share Posted October 30, 2020 Your pinball collection is never finished! For mame games, nothing new will be released. But pimball... every week multiple new or updated tables. Link to comment Share on other sites More sharing options...
Recommended Posts