howto_filter_roms_en

How to filter ROMS according to their country contained in the file name

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:

  • Filter Roms not containing certain country names
  • Filter Roms containing certain country names
You can apply the queries you want, you just have to respect the name of the fields and the syntax of the queries

Filter Roms not containing certain country names

You want to scrape ROMs (or do any other processing) that does not contain certain country names in the filename

  1. 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)*'
  2. Apply the query by clicking on the Filter button
  3. The filter is applied and the database is updated. You can do the desired processing on this filtered list
  4. To cancel the filters, remember to click on the button No Filter

Filter Roms containing certain country names

You want to delete roms (or do any other processing) containing certain country names in the filename

  1. 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)*'
  2. Apply the query by clicking on the Filter button
  3. The filter is applied and the database is updated. You can do the desired processing on this filtered list
  4. To cancel the filters, remember to click on the button No Filter
howto_filter_roms_en.txt · Dernière modification : 2022/03/19 11:54 de nexusone13