README

Find records

Find all records (of a given table, type and subtype) within the pagetree of a given root uid:

bin/typo3 toolbox:find [table] [type] [subtype]

# Find all powermail plugins (old) globally
bin/typo3 toolbox:find tt_content list 'powermail%' --root=0

# Find all powermail plugins (new) starting in node 123
bin/typo3 toolbox:find tt_content 'powermail%' --root=123

# Global search for powermail fields of type 'captcha'
bin/typo3 toolbox:find tx_powermail_domain_model_field captcha

Other parameters:

• --root, root node (recursively resolved!)`
• --columns, comma separated list of field names, default: uid,pid,,<title>
• --enable-columns/-e, append enable fields to columns
• --url, to render URLs as separate columns
• --extract, to use ExtractValue to extract fields from a XML fields (such as pi\_flexform)
• --online-only, to respect record (and parent page) enable fields
• --group-by, comma separated list of field names
• --order-by, comma separated list of field names
• --count, perform a COUNT instead of a SELECT
• --limit

Pagetree

Determine uids of all children in the pagetree of a given root uid:

bin/typo3 toolbox:tree 123 [--table=pages] [--depth=10] [--separator=,] [--languages=0]

A site identifier can be used instead of the root uid:

bin/typo3 toolbox:tree my-site-identifier

Categorytree

Determine uids of all children in the categorytree of a given root uid:

bin/typo3 toolbox:tree 321 --table=sys_category

Recursive delete

(!) Use with caution and backup!

bin/typo3 toolbox:delete --source=123 [--table=pages] [--memory-limit=512M]

Copy/move records

See TYPO3 datahandler for details on behaviour of positive/negative --target parameter

# Copy tt_content:123 to page:234
bin/typo3 toolbox:copy --table=tt_content --source=123 --target=234 [--be-user=1] [--memory-limit=512M]

# Copy tt_content:123 right behind tt_content:-234
bin/typo3 toolbox:copy --table=tt_content --source=123 --target=-234

# Move pages:123 to page:234
bin/typo3 toolbox:move --source=123 --target=234

Move FAL folders across storages

To move a folder from one storage (fileadmin) to another you can use this command to

• Move all files within the given "source" to the given "target" folder
• Recalculate the file hashes

bin/typo3 toolbox:move-fal-folder 1:/folder/subfolder/ 2:/different-folder/subfolder