During Step 3 of the Database Upload 🔗 process, you will be asked to map the fields in your load file to existing Logikcull fields. Logikcull will attempt mapping suggestions based on the import field name, but it isn't always accurate - we recommend double-checking the mapping before proceeding.
How to Navigate the Mapping Screen
When fields are mapped, that row in the table will turn green. Unmapped rows will show as white.
You can also opt to use the bulk select tool to map all fields, all unmapped fields, or all mapped fields as "import as new," "do not import," or "reset to Logikcull suggestions."
Once you've mapped all of your fields, simply click on "Next: Validate Data" to process the mappings.
Minimum load file requirements
Here are the recommended minimum load file field requirements in order to validate a set of load files successfully:
Begin Doc/Begin Bates - Beginning bates/document identifier number for each record
Begin Family/End Family or Begin Attachment/End Attachment - If linking families (i.e. emails and their associated attachments). The family fields cannot be overlaid, so we recommend requesting these in the original load file.
File Name - File name that includes the file extension (i.e. document.msg)
Native File Link - If importing native records
Text File Link - If importing OCR text/text files
TIME FIELDS: If you have a time field in your load file, a corresponding date field is required. For example, for "File Time Created" to be mapped, there must be a corresponding field available for "File Date Created".
Custodian field - lists who is associated with with the document. The custodian field cannot be overlaid so we recommend requesting this field in the original load file.
Field Mapping Guide
The table below provides guidance for mapping some of the less intuitive field names so that metadata and file locations can be correctly communicated to Logikcull.
Common Load File Field Names
(the original document file path)
Native File Link
(the relative file path to the uploaded volume)
Text File Link
Available Mapping Fields in Logikcull
Map the metadata fields available in your load file to the corresponding available Logikcull fields.
Control Number Fields
The beginning control number of a document, i.e., the Bates number of the first page.
The ending control number of a document, i.e., the Bates number of the last page.
The control number that identifies members of a document family. This is the Begin Bates of the family's parent document.
The beginning control number of a document family, i.e., the Bates number of the first page of the first document in the family.
The ending control number of a document family, i.e., the Bates number of the last page of the last document in the family.
The beginning control number of a document's attachments, i.e., the Bates number of the first page of the first attachment in the family.
The ending control number of a document's attachments, i.e., the Bates number of the last page of the last attachment in the family.
The document's custodian.
Native File Link
A link to a copy of the original file.
Text File Link
A link to the extracted text file.
The original author of the email.
The intended recipients of the email.
The carbon copied recipients of the email.
The blind carbon copied recipients of the email.
The email subject line.
Email Date Sent
The date the email was sent.
Email Time Sent
The time the email was sent.
Email Date Received
The date the email was received.
Email Time Received
The time the email was received.
The document's original name in the file system.
The document's original location in the file system; a bread-crumb.
The full extracted text or OCR of the document.
The date of the individual document.
The original file size, in bytes, of the document.
An Office metadata tag, shows the name of the author for the document.
File Last Saved By
An Office metadata tag, shows person name that last saved the document.
An Office metadata tag, shows company name.
An Office metadata tag, shows various keywords applied to document. Not from search.
An Office metadata tag, shows the title name of the document.
An Office metadata tag, shows comments in the document.
An Office metadata tag, shows the subject of the document.
File Revision Number
An Office metadata tag, shows number of revisions in document.
File Date Created
An Office metadata tag, shows the date the document was created.
File Time Created
An Office metadata tag, shows the time the document was created.
File Date Last Modified
An Office metadata tag, shows the date the document was last modified.
File Time Last Modified
An Office metadata tag, shows the time the document was last modified.
Using and Saving Mapping Templates
Once you have mapped all your fields on the mapping step, you can save your selected mapping choices for future uploads.
You can load your saved mapping template on the mapping screen using the mapping template drop down.