Vendor-Agnostic Load Template

X DLC-M03-001 · Vendor-Agnostic Load Template.xlsx — Excel

FileHomeInsertPage LayoutFormulasDataReviewView

A1 ƒ_x Delphoria Vendor-Agnostic Load Template — v3.1 · works with Relativity, Reveal, Everlaw, Nuix Discover

DLC-M03-001 · Load-File Spec

Vendor-Agnostic Load Template

Matter:

Target Tool:

Delphoria required field Standard field Optional / conditional Delimiter: ¶ (0xB6) · Text qualifier: þ (0xFE) · Encoding: UTF-8 with BOM · Newline: CRLF

	A	B	C	D	E	F	G
1	.DAT — Metadata Load File (Fields, in order)
2	Ord	Field Name	Type	Max Len	Nullable	Required	Notes
3	1	DLPUniqueID	String	40	No	Delphoria	Primary key. Format defined in DLC-M01-002.
4	2	DocID	String	40	No	Standard	Vendor-assigned sequential ID (e.g. VND000001).
5	3	BeginBates	String	20	Yes	If Produced	Populated at production, not at initial load.
6	4	EndBates	String	20	Yes	If Produced	Populated at production.
7	5	BeginAttach	String	20	Yes	Standard	Family group anchor.
8	6	EndAttach	String	20	Yes	Standard	Family group end.
9	7	Custodian	String	80	No	Delphoria	"Last, First" — display name.
10	8	CustodianCode	String	6	No	Delphoria	2–4 letter code.
11	9	SourceCode	String	6	No	Delphoria	M365, LAP, MOB, WA, SLK, etc.
12	10	FileName	String	255	No	Standard	Original filename with extension.
13	11	FilePath	String	1024	Yes	Standard	Original path (or mailbox folder path).
14	12	FileSize	Int	—	No	Standard	Bytes.
15	13	FileExtension	String	10	Yes	Standard	Extension only, lowercased, no dot.
16	14	FileType	String	40	Yes	Standard	Content-derived type.
17	15	MD5Hash	String	32	No	Standard	Hex, lowercase.
18	16	SHA256Hash	String	64	No	Standard	Hex, lowercase. Required for chain of custody.
19	17	Author	String	255	Yes	Standard	From metadata; may be blank.
20	18	DateCreated	DateTime	—	Yes	Standard	ISO 8601, UTC.
21	19	DateModified	DateTime	—	Yes	Standard	ISO 8601, UTC.
22	20	DateSent	DateTime	—	Yes	If Email	Emails only.
23	21	DateReceived	DateTime	—	Yes	If Email	Emails only.
24	22	From	String	500	Yes	If Email	Display Name <smtp@…>
25	23	To	String	4000	Yes	If Email	Semicolon-separated.
26	24	Cc	String	4000	Yes	If Email	Semicolon-separated.
27	25	Bcc	String	4000	Yes	If Email	Semicolon-separated.
28	26	Subject	String	500	Yes	If Email	Verbatim.
29	27	ConversationID	String	128	Yes	If Email	Feeds threading.
30	28	ThreadingID	String	40	Yes	Standard	Processing-tool assigned.
31	29	AllCustodians	String	4000	Yes	Standard	Semicolon-separated list of custodians who had a copy (dedup attribution).
32	30	NativeFilePath	String	1024	No	Standard	Path within the .OPT-referenced native folder.
33	31	TextPath	String	1024	Yes	Standard	Path to extracted text file.
34	32	OCRPath	String	1024	Yes	If OCR'd	Path to OCR-generated text; separate from TextPath.
35	33	ProtocolVersion	String	10	No	Delphoria	Version of DLC-M01-002 in effect at collection.
36	34	CollectionDate	DateTime	—	No	Delphoria	When the item was collected, UTC.

Companion files. This template pairs with .OPT (image manifest, one row per page image) and .LFP (Concordance-legacy image manifest, provided as alternate). Native files ship in a folder tree rooted at NATIVES\; text files at TEXT\; images at IMAGES\. Path fields above must be relative to the load-file root.

.DAT Spec .OPT Spec Overlay Rules Encoding Notes Change Log Ready · 100%