...
When there is no file name in the table in the database, you can name your files with the help of a macro.
*.pdf extension is added by default for records without the file extension. Meta can be modified as desired.
FileMemoColumnin VT must have a file extension in the given column.If there is no extension in the column value and all files are the same type, an extension can be added to the macro value.
Code Block language json { "Defines":[ { "__type":"Geodi.Database.Meta.DBSubContent, Geodi.Database", "TableFilter":"DocumentsCMS.FileContentCore", "IDColumnMacro":"[DocumentsID[FieldId][VersionNumber][MinorVersionNumber]", "FileNameColumnMacro":'=string.Concat(d["EAID"],"-",d["CretaDate"],string.IsNullOrEmpty(d["DF"])?".pdf":d["DF"])', "FileMemoColumn":"File" } "[Internalid][Extension]", "FileMemoColumn":"FileContent" } ] }
Code Block language json In the following example, the
Extensioncolumn is assumed to have the file extension. Some rows may have empty values. We assumed that the file is PDF if no extension. The macro might have returned an empty string to skip the files.Code Block language json { "Defines":[ { "__type":"Geodi.Database.Meta.DBSubContent, Geodi.Database", "TableFilter":"CMS.FileContentCoreDocuments", "IDColumnMacro":"[FieldId][VersionNumber][MinorVersionNumber]DocumentsID]", "FileNameColumnMacro":"[Internalid][Extension]",'=string.Concat(d["Internalid"],"-",d["CreateDate"],string.IsNullOrEmpty(d["Extension"])?".pdf":d["Extension"])', "FileMemoColumn":"FileContentFile" } ] }
| language | json |
|---|
build one using the FileNameColumnMacro value. There are two examples below. The first example is a simple one. the second one assumes that some rows do not have an extension value. FileMemoColumn is the file stream.
Indexing what is given with File Path in Table
You can also index files specified by file links in a record. (CSV files are not supported).
Key | Description |
|---|---|
| A macro that calculates the directories where files are located. This macro can be the value directly in a field (e.g. PATH), or it can be a path calculated in combination with other fields of the record.( Example: column name PATH on VT) |
| If there is more than one file in the file path, you can give the bracket character this way. |
| Code Block | ||
|---|---|---|
| ||
{
"Defines":[
{
"__type":"Geodi.Database.Meta.DBSubContent, Geodi.Database",
"FileFullPathColumnMacro":"[PATH]",
"FileFullPathColumnSplitter":"|"
}
]
} |
For Excel source with more than one "PATH" in a column, you can index it using the metafile.
...
name PATH on VT) | |
| If there is more than one file in the file path, you can give the bracket character this way. |
| Code Block | ||
|---|---|---|
| ||
{ "Defines":[ { "__type":"Geodi.Database.Meta.DBSubContent, Geodi.Database", "FileFullPathColumnMacro":"[PATH]", "FileFullPathColumnSplitter":",|" } ] } |
...
Specifying a Primary Key Column
...