CPL Library Administration Depositions Editing Import/Export Miscellaneous Opticon Printing Searching 3rd Party CPL FAQs		Btree.zip Salvages corrupt b+tree files (dictionary, tag, data entry list, and other files used by Concordance). Use bTree.EXE to dump the contents of these files to plain ASCII, then use Concordance's "List File Management" feature ("Tools | List File Management") to reload into bTree format. Bulk-Convert-Databases.cpl Automatically converts all v7 databases in a user-specified folder to v8 databases. compare_fields.cpl Compares two fields for identical contents, and tags any which match. Set up to compare STARTBATES and ENDBATES, and create the tag "Same start and end bates". Can be modified to compare any two fields, and tag any tagname. Create-Hyperlinks.cpl Creates a Concordance "Attachment" link or hyperlnk from the full path and filename of the external document. The full path and filename of the external file should be in a field called "ATTACHMENT"; that fieldname can be modified in the CPL using Concordance's CPL editor. Supports multiple attachments, separated by carriage returns in the field. Daemon.cpl Daemon.cpl has been superceded by reindexing_daemon.cpl. This program will reindex all databases in the specified folder. DateValidation.cpl This program checks the current query for valid dates. (Dates with all zeros for either the year, month, or day are considered valid.) Any invalid dates, such as February 30th, are tagged with the phrase "Invalid date in FIELD". Endnumber.cpl Calculates ending document numbers in databases with beginning document numbers only. Requires contiguous documents, with no gaps in the beginning numbers. Error.cpl Used to isolate physically corrupted records in a database which produce an "Error on Text File" message when attempting to read the record via Browse, Unload, Pack, or other operations. Error.CPL sequentially Browses all documents in a database. If an "Error on Text File" message is provoked, the document is tagged. User can then use the Search/List_Tagging/Tag List Management dialog box to "Create Query from..." only the corrupted documents, which can then be reviewed/abandoned. For more information on the EOTF problem, click here. Note: One of the best solutions is to create a replica of the database, excluding the tagged problem records from the replication. Error.CPL is used for after-the-fact collection of corrupted documents. This program DOES NOT repair or recover corrupted data. It merely tells you where those records are located. Also, in some severe cases of corruption, Error.CPL will crash/GPF Concordance the same as a Browse operation would. In these cases, the document is not tagged. 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. Field2Tag.cpl Creates tag from the entries in a user-selectable field. Multiple values are supported. This CPL must be manually edited to specify the field name and the delimiter. Gapcheck.cpl Checks for gaps, overlaps and "Same begin as end" conditions in production numbers between documents. Gapcheck writes findings to a log file. ImageCheck.cpl Checks for inconsitencies between database imagekeys and entries in the Opticon DIR file. Reports any errors to a log file. imagepath.cpl Writes an image path to the Opticon ini file. Opticon then prepends this typed in image path to every image location stored in the imagebase. Duplicates "Imagebase Management | Path" function found in Opticon 2.0 and higher. 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. Indxpack.cpl Automatically Indexes a database, then Packs it. Many administrative functions can be scripted to run overnight, etc. Use this program as a template. Issue2Field.cpl Writes issue tag names to a user-selectable field in the database. Multiple issue tags are supported. issue2tag.cpl Converts issue tags to document level tags. Helpful when users have attempted to add document tags while text was highlighted in "Browse" mode. List.cpl Handy bTree manager. Import/Export LST files to plain ASCII, display entry counts, merge LST files. This functionality has been built-in to versions v6.2 and later ("Tools | List File Management"). Listtags.cpl Displays all tags in the database in a gray pop-up box. See "PrintTags.cpl" to print them to the default printer. Maketagsreplicate.cpl V6 to v7 tag update utility. Allows tags that were applied to version 6 databases to properly replicate after the database has been converted to v7. Pagecnt.cpl Displays the total page count of the current query. User selects a begin document number and end document number fields to calculate number of pages. Pages_per_doc.CPL Writes the number of pages to a text field in every record in the current query. User selects the begin document number and end document number fields. Phrases.cpl Creates a phrase dictionary database, listing all unique phrases with hit counts and a document count for each phrase. The phrases are stored in a Concordance database for ease of use. If you are reporting on the Author field of the PRODUCTION database, the phrase database will be called "Production-Phrases for Author.dcb." Purge.cpl Deletes all Paragraph field data in the current record. Used as a last resort for repairing records with "Error on Text File" corruption. THIS PROGRAM IS DESTRUCTIVE and there is no UNDO. Please back up your database before use. Purgeqry.cpl Deletes all paragraph field data from all records in the current query. Used as a last resort for repairing records with "Error on Text File" corruption. It is assumed that you have already isolated all corrupted records which produce the "Error on Text File" message into a single query. Searching for all EOTF records may be done manually by browsing, or automatically with the "Error.CPL" utility. THIS PROGRAM IS DESTRUCTIVE and there is no UNDO. Please back up your database before use. ReAccess.zip This program scans V6 and later databases to identify, and optionally correct, accession number problems. Accession number problems are typically indicated by a record which appear as blank and locked ('L' on the status line). This program preserves records and tags, unlike the previous CPL utilities used to check accession numbers. Reaccess.exe superannuates both reaccess.cpl and locked.cpl. Reindexing Daemon (Recursive).cpl Same as above, but this version starts reindexing in a specified master folder, and automatically opens and reindexes all databases in every subfolder. reindexing_daemon (infinite).cpl Same as above, but this version runs continually. Some sites doing heavy editing leave a dedicated workstation running this program throughout the workday, providing constant (but not "instant") updates. Reindexing_daemon.cpl This Reindexing "daemon" cycles through a user-specified directory (or multiple directories), reindexing all resident Concordance databases until stopped by the user. This CPL can easily be modified to also pack databases. Renumber.cpl Handy renumbering utility. Assigns sequential alphanumeric serial numbers in user-specified field, in current query. This CPL lets the user specify the alpha-prefix and starting number of the serial number. replicate_daemon.cpl This script is designed to replicate and reindex databases found in a .txt file. The program will evaluate one line at a time. The format of each line of the file should be: "full\path\to\publisher_database.dcb", "full\path\to\subscriber_database.dcb" ShowSystemFields.CPL Displays and hides System fields in current database. System field display is only temporary, will reset when database is closed. Tag-History.cpl Displays a dated history of all tag additions and deletions for a record. Tag2Field.cpl Writes tag names to a user-selectable field in the database. Multiple tags are supported. Tagsaver.cpl Tag backup/restore utility for Concordance versions v6.0 and later. This utility saves tags and restores them. Requires a field with unique values on all documents (such as Begin Bates) to properly save and restore tags. Textchek.cpl Reads Paragraph fields for "weird" ASCII characters that fall outside of "normal" English range (a-z, A-Z, 0-9, and normal punctuation like !#$?.,/, etc.). Affected records are tagged, so they can be collected through Tag List Manager for later review. Userid.cpl Displays the current network login ID. Validate Key File.cpl Key file checking utility. Wordcnt.cpl Tallies total count of all words for all Paragraph fields in the database.