Home Concordance-U

Concordance®/Opticon HELP!


CPL FAQs CPL Admin CPL Editing CPL Searching CPL Import Export CPL Printing CPL Opticon CPL Depositions CPL 3rd Party CPL Misc Master CPL List


Follow concordancehelp on Twitter

CPL Import/Export Programs


Update: As of Concordance 2007, and especially Concordance 10, some CPLs listed here may not work correctly. Especially any CPLs involving working with Tags. Also, please be aware LexisNexis Concordance has released a new set of CPLs specifically geared towards working with Concordance 10. I hope to get those posted soon. - 05/31/2009 Bob Meyers


ATMSLOAD.CPL Loads an ATMS data set from IBM's STAIRS mainframe full-text database, into a Concordance database.

BRS.CPL Import utility for BRS "print-to-file" output. See also BRSPrep.CPL.

BRSPREP.CPL Prepares BRS print-to-file output for loading into Concordance. See also BRS.CPL.

Dialog.cpl Import utility for mainframe DIALOG data sets which have been exported to plain ASCII.

E-mail.cpl Loads plain text e-mail that has been exported from an e-mail application. Looks for text files in C:\temp and deletes them when finshed. Does not handle attachments or inline UUEncoded data.

Export-Bates-Page-Numbers.cpl Exports bates numbers from the database to a text file, interpolating numbers between the Begin document number and End document number. Used to cross-check bates numbers and imagekeys.

Export-PTF.cpl Export transcripts and depositions to LiveNote's portable transcript file, .ptf, format.

Export.cpl Exports data in a plain ASCII format suitable for later re-import with the Concordance Convert.EXE utility. For more detail, see the Concordance user's manual.

Export_ocr.cpl Exports OCR field, creating new text files named the same as the begin document number. Essentially the reverse of ReadOCR.cpl.

Export_ocr_append.cpl Same as above, but if duplicate bates numbers are found, appends data to previously created text files.

Import-Move_File_Name.cpl This CPL moves the fieldnames from imported text files when "Filenames are kept" option is turned on. After import with "Import Full Text" using the "Filenames are kept" option, Concordance adds the source filename within parentheses at the top of the field. This script moves that filename string to a new field in the database, normalizing the imported text.

Import-V6-Depositions.CPL Converts and imports depositions and transcripts from V6 format databases to the V7 transcript format.

LF2crlf.cpl In preparation for Import, this program globally replaces soft-return line-feeds found in UNIX files with hard-return carriage-return + line-feeds expected in DOS files.

Load64k.cpl Utility for managing Import (Load) of delimited ASCII files in which field data exceeds Concordance V6's Paragraph-type field limit of 65,000 characters. (Delimited ASCII data of this size has usually been exported from a mainframe application) Note: This program is not needed with Concordance V7 or above. Use Documents/Import/Delimited text.

Loadsom2.cpl Same as Loadsome.cpl, except matches on two target fields instead of one.

Loadsome.cpl Targeted delimited ASCII Overlay for updating field data between identical database structures. Based on a target field match (e.g., BEGBATES) between the two databases, user-specified fields are Overlayed from one database to another. Note: This program is not needed with Concordance V7. Use "Documents | Import | Concordance database". Exception: Loadsome.cpl allows source data to append to target database fields, rather than overwrite the field as does "Documents | Import | Concordance database".

load_opticon_notes.cpl Loads notes from Opticon's "sticky notes" feature into the matching documents in the database.

Readocr.cpl OCR import program to overlay OCR text into existing database records. The program assumes that for a Bates number ABC123, the related OCR file is named ABC123.TXT. User is prompted for the "key" field (e.g., BEGBATES) and DOS path to the OCR files.

ReadOCR1.cpl Same as ReadOCR.CPL, but modified to retrieve/import OCR files from full drive/path/filename stored in the "key" field.

Send-to-Excel.cpl Sends the contents of the current query to Excel. Carriage returns are removed from the text before it is sent as Excel cannot handle text formatted with carriage returns.

Stairs.cpl Produces "Editable Condensed Text" output for IBM STAIRS mainframe text-retrieval system.

Stairs72.cpl Loads a STAIRS 72C format input file into a Concordance database. The 72C file has been converted to ASCII and downloaded from the mainframe to a PC.

Txt-Bulk-Load.cpl Allows bulk-loading of TXT or RTF file types into Concordance. Recursively "drills down" through a folder and its subfolders. Using "Documents | Import | Full text" only allows a maximum of 200-300 files at one time, limited by a Windows filename length limit in the "Open File" dialog box. This CPL bypasses that dialog box, and imports all TXT or RTF files from a specified folder and all of its sub-folders.

Copyright © 2010 Bob Meyers

Any questions on anything at all, please feel free to contact me directly: bobmeyers@concordancehelp.com

Or give me a call: +1 (424) 35-HELPU (424-354-3578)

Back Home Up Next