iLets

Check Attachment Field's File Paths
Returns a list of records that contain an invalid attachment path (for each record that contains an invalid path, returns an ID field - e.g., Bates number - and the invalid file path).

Export Oracle Object IDs
Exports Oracle Object IDs for all clients, cases, databases, and users to a text file.

Get Password Expiry Info
For user accounts with expired passwords, returns when the password expired, when it was last changed, and how long it has been expired.

Add Unique ID
Adds a unique ID (with a user-assigned prefix) to each record in a specified existing field. Any existing content in the specified field is overwritten.

Auto Number
Adds a unique number to each record in the database. Increments by "1" per record. Padding length can be set.

Clear Field
Clears all contents of a selected field. The field becomes an empty field throughout the database.

E-Mail Database Cleanup
Removes e-mail addresses by searching a specified field and removing any content that includes the @ symbol found between angle brackets "<>" so that the person's name will show but not the e-mail address. E.g., Kevin Harvey would change to just Kevin Harvey.

Field to Lowercase
Changes field contents to all lowercase for a specified Limited Text field.

Field to Uppercase
Changes field contents to all uppercase for a specified Limited Text field.

Field to Uppercase (All Fields)
Changes field contents to all uppercase for all Limited Text fields.

Text Data to Date Field
Move properly formatted dates (e.g., mm/dd/yyyy) from a text field in the database into a Date field.

Trim Path 
Trims all pathing information from a UNC or Drive letter path. Remaining info will be the file name only.

Trim Spaces
Removes leading and trailing spaces from data in a specified Limited Text field.

Batch Search to Folder
Runs searches using queries specified in a text file, and places the results in the specified folder. If the folder does not exist, a new folder is created. Format must be "query,foldername" (e.g., "bill WITHIN Author, Jim to Review").

Copy Folder Contents
Copies document-folder associations from a specified "copy from" folder to a "copy to" folder. E.g., all documents that were added to folder ABC are also added to folder DEF.

Field to Folder
Recreates folders and document-to-folder assignments by performing the opposing action of the Folder to Field iLET. For example, run Folder to Field to record document-to-folder assignments, export that data to another database, and run Field to Folder to recreate the folders and document-to-folder assignments.

Field to Root Folders
For each document in a database, adds the document to folder(s) based on a specified field’s contents. Example: You specify the Author field, it contains "jsmith;sjones", and the semicolon is specified as the delimiter. The result is two root folders named "jsmith" and "sjones", and the document is added to both folders. Note: Newline characters and review folders are not supported by this iLET. In addition, if the folders already exist, they are not created; the document is just added to the existing folder.

Folder to Field
For each document, writes the name of all folders that a document has been added to (including review folders) to a specified field. Use in conjunction with the iLET "Field to Folder" to recreate folders and document-to-folder assignments in a different database. Run this script from the command prompt using the command cscript followed by the path to the script file.

Image Count in Folder
Returns the number of images in a folder, and the number of invalid image links.

Check Image Paths in Opticon File
Returns a list of invalid image paths found in the Opticon load file.

Check Imagelink Field for Valid Link
Returns the image IDs that are missing from the imagelink table for a specified database.

Page Count in Imagelink Table
Returns the number of documents and pages in an imagelink table.

OCR or Full Text Export
Exports a specified OCR or Full Text field to a text file for each document in a specified folder. Use this output with Equivio technology to identify near-duplicate documents in your iCONECT databases.

Pages per Document
Calculates the number of pages (TIFF images) in a record by cross-referencing the beginning Bates field and the end Bates field. Writes the resulting number back to the database into a specified field.