Relativity SQL Full Text Index Language Setting

In Relativity under the the Administration tab, and the Workspace details sub-tab, you'll see an option to select the SQL Full Text Language. This setting must be set to the language of the documents loaded into your database. If the documents are in multiple languages in roughly equally amounts you have a challenge. kCura recommends changing the SQL Full Text Language to the language which has the most complex stemming and word breaking rules.

How do we determine which language has the most complex word break rules? While Western languages follow similar word breaking rules, those used for German will be more complex than those used in English or Spanish. German has more compound words. See this reference on a Microsoft page regarding SQL Server. Chinese, Japanese, Korean, and Thai use a more complex word breaking system because text can be broken into individual characters, and even individual characters can be divided.

Relativity - Brief Notes On Working with Load Files

Here are just some brief notes on working with load files in Relativity. Load files use the .dat extension, and are imported with a separate application, the Relativity Desktop Client [RDC].

You begin by setting the column; quote; newline; multi-value; and nested value fields on the 'Load File' tab of the RDC, and then move on to the Field Map tab.

Before actually loading the file, if you must first create new fields in the web based version of Relativity. There doesn't appear to be a way to automatically create new fields - [one could use a 'field load file' in effect]. Relativity apparently considers it best practice to use a fixed length text field of 5 characters for file extension fields; fixed length text fields of 255 characters for the email subject and from fields; but long text fields for email to, CC, and BCC fields.

After adding the new fields in the regular web-based Relativity, you can press F5 in the RDC while on the Field Map tab to display these new fields. RDC includes the ability to overlay data into existing fields.

To ensure the load file brings in the extracted text instead of just the file path, be sure to select the 'Cell contains file location' check box, and set the Extracted Text encoding for undetectable files to Western European (Windows). Relativity apparently prefers load files in this format and Unicode (UTF-8).

As you can see, the RDC works with the standard side by side pick lists to match up the database fields with the fields in the delimited load file. Note that your folder path and file paths don't go in the main pick list - instead refer to the Folder Info and Native File drop down lists below.

You have the option in the import menu to preview the load file first. When you're sure you have things right, you can save import settings with the extension .kwe.

If there are errors in the import process for the load file, after the import finishes you will be prompted to save a separate error file. You can then edit this file and re-import the data that failed to import correctly. The error file will have a .dat extension as well.

Relativity Certification Training Materials

If you have an account for kCura's Relativity, even at the user level, you should be able to access training materials needed for certifications in Relativity on this site. The study materials consist of workbooks, quizzes, webinars, and sample data that you'll need to get certification as an administrator, analytics specialist, infrastructure specialist, processing specialist, review specialist, assisted review specialist, or project management specialist. While the sales professional test is free, and the review specialist exam is $150, all of the other exams cost $250. The exams are give several times each year in Chicago, San Francisco, Los Angeles, Houston/Dallas, New York,Boston, London, Atlanta, and Washington, DC.

Further materials are available at the Relativity Training Center. Free, on-demand videos are available at the beginner, intermediate and advance levels. In person training costs $1000 and is held in the same cities where one can take the exam. Live, free webinars are given in various subject areas each week.

The Exam Workbook for the Relativity Certified Administrator exam is 77 pages long, and includes quizzes at the end of the five chapters on Creation and Data Loading; Setup, Reporting and Searching; Review Management; Production and Export; and Enhancements and Troubleshooting. An Excel spreadsheet outlines a 3 month study plan, showing students how many hours they need to devote to a variety of tasks.

If your firm or business makes use of Relativity, take advantage of these excellent materials tonight!