Replacements

View video

In the replacement fields, if you wish to refer to a database field, it is imperative to surround it with a double %
exemple

%%adult_rom%%
%%annee_rom%%
%%arcadesystemname_rom%%
%%boxart_rom%%
%%boxback_rom%%
%%cache_rom%%
%%cartridge_rom%%
%%description_rom%%
%%developer_rom%%
%%fanart_rom%%
%%favoris_rom%%
%%fichier_rom%%
%%gameid_rom%%
%%gametime_rom%%
%%genre_rom%%
%%genreid_rom%%
%%image_rom%%
%%kid_rom%%
%%lang_rom%%
%%lastplayed_rom%%
%%manual_rom%%
%%maps_rom%%
%%marquee_rom%%
%%mix_rom%%
%%nomjeu_rom%%
%%playcount_rom%%
%%players_rom%%
%%publisher_rom%%
%%rating_rom%%
%%region_rom%%
%%screenshot_rom%%
%%temporary_rom%%
%%thumbnail_rom%%
%%titleshot_rom%%
%%video_rom%%
%%wheel_rom%%

Never change the names of the files (artworks/images/roms) in the replacement module, because they will not be applied to the files.

Query (combobox): Allows you to compose your own conditions/filters (MS ACCESS SQL syntax). (It is OPTIONAL )

The searched strings must be surrounded by single quote (') and not by double quotes (“) If a searched string contains a single quote ('), you must put two single quotes in the query

fichier_rom like '%(USA)%'
nomjeu_rom not like '%[%' and region_rom is not null
boxart_rom<>'' and favoris_rom=true and rating_rom > 0.2
nomjeu_rom like '*zelda*' and map_rom is null
favoris_rom=true and (image_rom is null and manual_rom<>'')
len(description_rom) < 10
substring(nomjeu_rom,1,2) = '19'

The fields available for the conditions are:

adult_rom
annee_rom
arcadesystemname_rom
boxart_rom
boxback_rom
cache_rom
cartridge_rom
core_rom
description_rom
developer_rom
emulator_rom
fanart_rom
favoris_rom
fichier_rom
gameid_rom
gametime_rom
genre_rom
genreid_rom
hash_rom
image_rom
kid_rom
lang_rom
lastplayed_rom
manual_rom
map_rom
marquee_rom
md5_rom
mix_rom
nomjeu_rom
numauto_rom
playcount_rom
players_rom
publisher_rom
rating_rom
region_rom
screenshot_rom
temporary_rom
thumbnail_rom
titleshot_rom
video_rom
wheel_rom

Each condition/filter validated via the button is stored in the ' Query ' combobox and saved in the file located under %appdata%\Nexouille Soft\arrm\database\query_sql2.txt (you can edit it and add any conditions you want) You will then be able to select an already archived condition/filter.

The filter is applied to the Database

EXAMPLES :

Apply a modification of the value of a field

In the example above, we apply the Query:

nomjeu_rom not like '%[%' and region_rom is not null

which means that we want to display only the games which do not contain '[' and whose region field is not empty.

In the next combobox we indicate the new value. It can also be a field name from the database, it must then be surrounded by double % exemple :

%%nomjeu_rom%% [%%region_rom%%]

Select the field on which you want to apply modifications, here it will be the field Game Title (nomjeu_rom)

Select (highlight) the games you want to apply the changes to, then click the button to apply the change.

This will change the DB Fields Game Title (nomjeu_rom) so that it becomes nomjeu_rom [region_rom]

On the game ' Ballbllazer ' whose field region_rom = 'us' this will give: Ballblazer [us]

Note that on the replacement field, references to a database field are surrounded by a double %

EXAMPLES :

Apply a value replacement on a field

In the example above, we apply the Query (It is OPTIONAL ):

fichier_rom like '%(USA)%'

which means that we want to display only the games whose fichier_rom (file name) contains '(USA)'.

Select the field on which you want to apply modifications, here it will be the field Genre (genre_rom)

Select (highlight) the games you want to apply the changes to, then click the button to apply the change.

This will replace in the DB Fields Genre (genre_rom) the string 'Tir' by 'Shoot'

Note that on the replacement field ('With'), references to a database field are surrounded by a double %
exemple :

%%nomjeu_rom%%

Remember to remove the filter by clicking on 'No filter' after use.