You have Roma indicating their country:
Addams Family, The (Europe).zip
Addams Family, The (Japan).zip
Aero the Acro-Bat (Europe).zip
Aero the Acro-Bat (USA).zip
...
You want to filter certain countries so as not to scrape the Roma or to delete them for example.
ARRM can filter Roms on certain criteria by applying a filter as a query
Example :
I do not want to display in the database the Roms containing the following countries: (japan), (germany), (italy)
Just create a query like this:
fichier_rom not like '*(japan)*' or fichier_rom not like '*(germany)*' or fichier_rom not like '*(italy)*'
Here the countries must appear between () in the file name. But you might as well remove the parentheses. Only drawback: if the name of the game contains one of these countries, it will also be filtered.
Example: Asterix in italy.zip :)
Let's see how to proceed with two scenarios:
You can apply the queries you want, you just have to respect the name of the fields and the syntax of the queries
You want to scrape ROMs (or do any other processing) that does not contain certain country names in the filename
In the
Query area, enter your query in the combobox. You can know the field names and get syntax help by clicking on the
?. the icon
allows you to see the list of requests you have already made. The combobox can list the old queries you have made, you just have to select them. Here the query will be:
fichier_rom not like '*(japan)*' and fichier_rom not like '*(germany)*' and fichier_rom not like '*(italy)*'**fichier_rom not like '*(japan)*' and fichier_rom not like '*(germany)*' and fichier_rom not like '*(italy)*'
Apply the query by clicking on the Filter button
The filter is applied and the database is updated. You can do the desired processing on this filtered list
To cancel the filters, remember to click on the button No Filter
You want to delete roms (or do any other processing) containing certain country names in the filename
In the
Query area, enter your query in the combobox. You can know the field names and get syntax help by clicking on the
?. the icon
allows you to see the list of requests you have already made. The combobox can list the old queries you have made, you just have to select them. Here the request will be:
fichier_rom like '*(japan)*' or fichier_rom like '*(germany)*' or fichier_rom like '*(italy)*'
Apply the query by clicking on the Filter button
The filter is applied and the database is updated. You can do the desired processing on this filtered list
To cancel the filters, remember to click on the button No Filter