File Types

1.On the File menu click Import and then click Electronic Discovery.

2.Click the Settings tab and then click File Types. The File Types options display.

3.The file type management database is selected in the LAW Configuration Utility.

4.Configure options for file types as needed:

•Enable File Filtering - If this option is disabled, all files will be imported. If enabled, the files imported will depend on the selected scope.

Active List (Scope) - Specifies a list that identifies files to import. You can identify a list as an Include list or as an Exclude list.

If filetype is not marked 'Include' then (Action): Options include:

Include - This option will copy the native file and log a record in the database.

Partially Exclude - This option will not copy the native file but will log a record in the database.

Exclude - This option will not copy the native file or log a record in the database.

Note the following facts about using these kinds of lists:

•If the Include list is selected, file types marked as Include in the File Type Manager's Include list will be imported. Files that are not checked in the Include list will be excluded.

•If the Exclude list is selected, file types marked as Exclude in the list are excluded from import. File types that are not marked as Exclude in the list will be imported.

•Lists are evaluated independently of each other. If the Include list is selected as the active list, or scope, the Exclude list is not considered during the import and vice versa.

•Auto-assign suspect extensions - assigns inferred extensions to files identified with suspect extensions.

5.Click Edit. The Manage File Types dialog box opens.

6.Configure file inclusion and exclusion lists, and other options:

•Inc. Files marked as Include will be imported if the active list is set to the Include list.

•Exc. If Exclude is set as the active list, then anything not marked as Exclude will be imported.

•Multiple file type databases can be created. This feature can be useful when establishing procedures on specific files to exclude from processing. The File menu in the File Type Manager is used to create new file type databases, open existing databases, and save changes to the current database.

•Assign default source applications for each file type.

•Select whether or not to extract text from each file type.

•Auto Assign Suspect Extensions - Performs maintenance actions if a file extension does not  match the actual file type. When enabled, if the extension of the incoming file does not match any extensions in the Extensions field in the File Type Manager for the assigned file ID, LAW assigns a new extension from the Active Ext. field to the DocExt field, and records the original extension in the OrigExt field.

Prior to version 6.18, the File Type Management database was only available in Access.  Version 6.18 allows the opportunity to transfer the database into SQL.  SQL allows a central location for FTM database storage that all work stations can use.  You can also create Case specific databases.

Creating a SQL based File Type Management database as the default

Creating a case Specific File Type Management database

After installing LAW version 6.18+, you will have the opportunity to transfer the Access File Type Management database to a SQL server. 1. On the File menu, select Import and then select Electronic Discovery. 2. The LAW Electronic Discovery Loader will open in a new window.       3.  Select the Settings tab, then select File Types.       4.  Select the ellipses. 5.  The Select Database Type window will open.       6.   Choose the database type that you would like to use then select OK.       Access Database a.Select File Type Database window will open.     b.Browse to a previously stored EDLoader.ftm.mdb. c.Enter a new File name for the database. d.Click Edit. The Manage File Types dialog box opens.     e. Configure file inclusion and exclusion lists, and other options: •Inc. Files marked as Include will be imported if the active list is set to the Include list. •Exc. If Exclude is set as the active list, then anything not marked as Exclude will be imported. •Multiple file type databases can be created. This feature can be useful when establishing procedures on specific files to exclude from processing. The File menu in the File Type Manager is used to create new file type databases, open existing databases, and save changes to the current database. •Assign default source applications for each file type. •Select whether or not to extract text from each file type. •Auto Assign Suspect Extensions - Performs maintenance actions if a file extension does not  match the actual file type. When enabled, if the extension of the incoming file does not match any extensions in the Extensions field in the File Type Manager for the assigned file ID, LAW assigns a new extension from the Active Ext. field to the DocExt field, and records the original extension in the OrigExt field.         SQL Server a. Server Connection Information will open to provide the option for configuring use in SQL.       b. Configure options for the File Type Manager Connection. Field Possible Values Description Server Name Computer Name\SQL Express This is the name of the SQL Instance of which you will store the file type management database. Use Windows Authentication   Enable if you use Windows Authentication for the SQL instance's login security. User Name Law_User The default login for the SQL instance is law_user. Password ************* The default password for the law_user is stored. (Contact technical support for assistance.) Database LAW5_Management The default name is LAW5_Management. * *LAW5_Management is the default.  If not using the default, then it is recommended to start each file type management database with (FTM) followed by the same naming sequence for example: FTM no MOV files or FTM exclude excels.  This helps to distinguish the file type management databases in your SQL server from other databases. c. After completing Configure the SQL Server Connection, select OK. •If the SQL Instance's name is entered correctly then Server Connection Information will disappear. •If the SQL Instance's name is entered incorrectly, then it will open "File Type Manager Validation Error" select OK.  Then go to  steps 4, after confirming SQL Instance name. d. Click Edit. The Manage File Types dialog box opens.     e. Configure file inclusion and exclusion lists, and other options: •Inc. Files marked as Include will be imported if the active list is set to the Include list. •Exc. If Exclude is set as the active list, then anything not marked as Exclude will be imported. •Multiple file type databases can be created. This feature can be useful when establishing procedures on specific files to exclude from processing. The File menu in the File Type Manager is used to create new file type databases, open existing databases, and save changes to the current database. •Assign default source applications for each file type. •Select whether or not to extract text from each file type. •Auto Assign Suspect Extensions - Performs maintenance actions if a file extension does not  match the actual file type. When enabled, if the extension of the incoming file does not match any extensions in the Extensions field in the File Type Manager for the assigned file ID, LAW assigns a new extension from the Active Ext. field to the DocExt field, and records the original extension in the OrigExt field.