To begin, please refer to the source database's procedures on how to export documents into a format that meets Logikcull’s database import requirements. You can refer to the following links below for specific platform export directions. If needed, it might make sense to reach out to the other platform’s support team:
The following load files should be included: .log, .lfp, .dat
Before exporting, please review the following information to make sure your export meets Logikcull's database import requirements linked below.
The Database Uploads feature has been designed to take the pain out of loading outside data into Logikcull as much as possible. This process has many, many variables to take into account, but automated systems check nearly every aspect of your import from start to finish, in order to ensure a seamless process.
Even with the smart technology that goes into Database Uploads, questions can arise. This document contains details on all of the important facets of Database Uploads so that you can ensure the right choices are made when outside data is being imported.
Contents and Structure
A Database Upload currently requires that you have, at a minimum, a metadata DAT load file, an image load file (opt or lfp), and a set of images. You may optionally include native (original format) files or text files.
Your document database volume should be arranged with a top-level folder named for the volume. Inside of this folder should be folders named DATA, IMAGES, NATIVES, TEXT, each containing their respective file-types. The DATA folder should contain your metadata load file and image load file.
Things to note:
- The uncompressed archive needs to have a complete folder structure, not broken into smaller zips within the uploaded zip.
- Once the folder structure meets the requirement, zip up production volume for database upload.
The following image file formats are supported:
- single page black and white TIFF and color JPEG
- multi-page black and white TIFF
- multi-page PDF (black and white or color)
A metadata load file makes use of three main delimiters:
- Column/Field delimiter - denotes the separation between column/fields
- Quote/Text Qualifier - used to separate actual field data from the delimiters around it (especially useful when your field delimiter is a common character such as a comma)
- Newline - code to denote a newline within the data encompassed by your quote delimiter (most often seen in extracted text fields or other long text fields)
Your metadata load file must be in a delimited text format, but the specific delimiters you use are up to you. Logikcull will attempt to detect your delimiters automatically in any case. If you're not sure which delimiters to use in your load file, we recommend these character values by default:
- Column - ASCII 020
- Quote - ASCII 254
- Newline - ASCII 174
Your metadata load file is required to have a header row. Your header field names must be unique, and for your benefit, should be meaningful or descriptive in order to make choosing the correct fields to import/map easier.
There is no limit to the number of fields that you may include in your Database Upload, but you are required to have at least the Begin Doc field. For all other fields, you may:
- choose to import them into a new custom field
- choose to not import them
- choose to import them into an existing Logikcull Document field.
The Logikcull document fields which you can import into are listed below:
- Begin Doc End Doc
- Begin Family
- End Family
- File Name
- File Path
- Native Link
- Text Link
- Full Text
- Document Date
- File Size
- Email From
- Email To
- Email CC
- Email BCC
- Email Subject
- Email Sent Date
- Email Sent Time
- Email Received Date
- Email Received Time
- File Author
- Last Saved By
- File Company
- File Keywords
- File Title
- File Comments
- File Subject
- File Revision Number
- File Created Date
- File Created Time
- File Modified Date
- File Modified Time
Time & Date Formats
Logikcull's Time and Date fields should be formatted as follows:
- Dates: mm/dd/yyyy
- Time: hh:mm:ss [AM|PM]
Months(mm), days(dd), and hours (hh) may all be denoted by a single digit. You may also use military notation for the time and can exclude the AM/PM designation if you do.
Concordance delimited DAT
Things to note:
- Path to native and text files need to be a single field each with a relative path to the file instead of two separate fields (i.e. NATIVEDIR and NATIVEFILE)
- Paths to native and text files needs to start from volume folder
- Order of documents from DAT file should be the same order with OPT image load file.
OPT Image Load File
Things to note:
File needs to have relative paths and can start from volume or IMAGES folder
Create a new database upload
Once your production set is good, you're now ready to upload your production.