All Collections
Upload
Common Upload Questions
Mapping Load File Fields to Logikcull
Mapping Load File Fields to Logikcull

Link metadata in your load file to searchable fields in Logikcull with our field mapping tool.

Kate avatar
Written by Kate
Updated over a week ago

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.

Did this answer your question?