Introducing ReadySuite, Part 6 – Delimited Text

Posted Nov 20, 2009 in Features

We’re about ready to wind down our Introduction to ReadySuite series with discussions geared towards enhancements to some of the core functionality. This post will focus on changes made to the import and export of delimited text.

First up, we’ll highlight how we’ve improved the import of delimited text files. One of most requested changes by our users was to allow new records to be created by this process. Previously, you had to link the delimited text import with an existing record (i.e. native and/or image based document). The benefit here was we could tell you which documents were “un-linked” or not found. Now you can add the record as a new document if it can’t be linked. If you don’t need to add these as new records, the option to generate a warning is still there.

Unlinked Document & Update Mode

We’ve also implemented an update-mode if the record already exists. You can choose to replace an existing field value or append the new value to the existing record. For example, if you had a field named PRODRANGES with the value “ABC001-ABC002” and a delimited text file with a PRODRANGES field having the value of “DEF001-DEF002”, the append mode would combine the values to be “ABC001-ABC002 DEF001-DEF002”.

Additionally, you can now choose to repeat the value of a field during the import delimited text process. If a field is marked to have its values repeated, any empty values will be replaced with the previous non-empty value. If you’re importing a FOLDER field whose value is only entered for the first document inside that folder, but you need it repeated for each document inside that folder, then mark the field to be repeated. The folder information will be re-used for each document until a new folder is encountered.

Repeat Column

Moving on to exporting delimited text files, we’ve added the ability to export page records. When setting up the delimited text export, you can simply check a box to export all the pages or images in a document. Page level fields, such as filename, page number, folder and color status will be available. Document level fields will simply be repeated for each page in the document.

Page Level

Group fields are now available to the delimited text export in addition to the EDRM and DII exports. This feature allows you to specify two or more fields to be “merged” on export in the event that one field does not have a value. This is useful if you have three fields called Author, From, and Creator but you only need one export field called Author. Based on the order you add the fields to the new group field, the first non-empty item will be used in the export field.

For those users who want to merge two or more fields together regardless of any existing data, we’ve added that ability to the Batch Update dialog. For example, if you want to merge BEGPROD1, BEGPROD2, and BEGPROD3 into a BEGPRODS field, you would use the following syntax:

${META:BEGPROD1}; ${META: BEGPROD2}; ${META: BEGPROD3}

Don’t worry if the above is confusing: we have an easy-to-use field picker to help in the process.

Batch Update

The changes highlighted in this post are also being provided to our ReadyConvert users, among other bug fixes, free of charge. ReadyConvert is our free load file verification and conversion tool used by many litigation professionals.

Our next blog post will focus on overall stability improvements and important changes to the document grid.