moodle-tool_advancedreplace

This is a Moodle plugin that allows administrators to search and replace strings in the Moodle database.

Administrators can search and replace strings in tables and columns of the Moodle database. They can use simple text search or regular expressions.

GDPR

The plugin does not store any personal data.

Branches

Installation

1. Install the plugin the same as any standard Moodle plugin, you can use git to clone it into your source:

   ```sh git clone git@github.com:catalyst/moodle-tool_advancedreplace.git admin/tool/advancedreplace

Examples

Find all occurrences of "http://example.com/" followed by any number of digits on tables:

cd admin/tool/advancedreplace/cli/
php find.php --regex-match="http://example.com/\d+" --output=result.csv

Find all occurrences of "http://example.com/" in a table:

php find.php --regex-match="http://example.com/\d+" --tables=page --output=result.csv

Find all occurrences of "http://example.com/" in multiple tables:

php find.php --regex-match="http://example.com/\d+" --tables=page,forum --output=result.csv

Find all occurrences of "http://example.com/" in different tables and columns:

php find.php --regex-match="http://example.com/\d+" --tables=page:content,forum:message --output=result.csv

Find all occurrences of "http://example.com/" in all tables except the ones specified:

php find.php --regex-match="http://example.com/\d+" --skip-tables=page,forum --output=result.csv

Find all occurrences of "http://example.com/" in all columns except the ones specified:

php find.php --regex-match="http://example.com/\d+" --tables=page --skip-columns=intro,display --output=result.csv

Support

If you have issues please log them in GitHub.

Please note our time is limited, so if you need urgent support or want to sponsor a new feature then please contact Catalyst IT Australia.

This plugin was developed by Catalyst IT Australia.