Previous Topic

Next Topic

Book Contents

Book Index

Command Line Index Rebuilder

VSys can be told to run the index rebuild tool directly from the command line, rather than using the visual user interface. These are handy for scheduled runs without having to involve user intervention.

Run the command-line index rebuild tool by launching VSys with the ixrebuild: parameter, followed by any options. For example,

VSys.exe ixrebuild
or,
VSys.exe ixrebuild:purexml,transitions,optionunique

Rebuild codes

Meaning

all

Runs all known rebuilders

shortnames

Sound-alike names, statuses and dates for people

address

Lookup values (phone, e-mail) for all addresses

people

Personal data for all people (wheelchair, inactive, deceased, languages)

banned

Banned list attributes

jobs

Job and slot specifications

listunique

"Unique" values on lists

hours

Descriptions in hours records

addrvalues

Various address table issues

purexml

XML <-> compatibility field updates

nulldates

Zero but non-NULL date fields

attachments

Remove attached files no longer in use

training

Various training course values

availability

Availability detail records

entries

Lookup values (checked-in, alternate) for entries

transitions

Transitions values from old format to new

optionunique

Populate "Code" field in options values

optionbogus

Remove orphaned options values records

assslotmatch

Automatically match assignments to open job slots

assignremlost

Delete future assignments for non-existent people

VSys must be configured to automatically start with a database for these to work. If VSys prompts you for a database to use when it's run, the automated index rebuilder cannot work.

See Also

Command Line Tools

Command Line Backups

Command Line Datapump

Command Line Assignment Reminders

Command Line VSys Web Synchronization

Command Line Reports

Command Line SMS Results Retrieval