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.
⚠️ Note: Any fields without a corresponding Logikcull field can be imported into Logikcull by selecting "Import as new" from the drop down menu or the bulk select tool.
Video Walkthrough
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.
💡 For any metadata present in your load file that does not directly correspond to an available Logikcull Field, you may set that field to Do Not Import or Import As New.
Common Load File Field Names | Logikcull Field |
BegBates BEGDOC BeginBates BEGDOC# FIRSTBATES Begno BATES START BEGINDOC | Begin Bates |
EndBates ENDDOC ENDDOC# LASTBATES Endno BATES END | End Bates |
BegAttach BEGATT BeginAttachmentBates ATTACH_START | Begin Family |
EndAttach ENDATT EndAttachmentBates ATTACH_END | End Family |
PAGES PageCount NUMPAGES PGCOUNT PAGECNT | Page Count |
FILEPATH OriginalFilepath PATH FPATHNAME | File Path (the original document file path) |
NativeLink ORIGINALSPATH NativePath LINK NativeFile NATIVE_DIR FILELINK XSPATHNAME FILE_PATH | Native File Link (the relative file path to the uploaded volume) |
TEXTPATH OCRPath TEXT_DIR TEXT PRECEDENCE | Text File Link |
Custodian Custodians | Custodian |
Available Mapping Fields in Logikcull
Map the metadata fields available in your load file to the corresponding available Logikcull fields.
💡 Once you map custom fields from your load file into Logikcull, they will appear in the Logikcull Field drop-down on subsequent Database Uploads within the same Project.
LOGIKCULL FIELD | DEFINITION |
Control Number Fields |
|
Beg Bates | The beginning control number of a document, i.e., the Bates number of the first page. |
End Bates | The ending control number of a document, i.e., the Bates number of the last page. |
Family ID | The control number that identifies members of a document family. This is the Begin Bates of the family's parent document. |
Begin Family | The beginning control number of a document family, i.e., the Bates number of the first page of the first document in the family. |
End 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. |
Begin Attach | 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. |
End Attach | 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. |
Special Fields |
|
Custodian | 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. |
Email Metadata |
|
Email From | The original author of the email. |
Email To | The intended recipients of the email. |
Email CC | The carbon copied recipients of the email. |
Email BCC | The blind carbon copied recipients of the email. |
Email Subject | 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. |
File Metadata |
|
File Name | The document's original name in the file system. |
File Path | The document's original location in the file system; a bread-crumb. |
Full Text | The full extracted text or OCR of the document. |
Document Date | The date of the individual document. |
File Size | The original file size, in bytes, of the document. |
File Author | 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. |
File Company | An Office metadata tag, shows company name. |
File Keywords | An Office metadata tag, shows various keywords applied to document. Not from search. |
File Title | An Office metadata tag, shows the title name of the document. |
File Comments | An Office metadata tag, shows comments in the document. |
File Subject | 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.
