...
Code Block | ||
---|---|---|
| ||
{ "Defines":[ { "__type":"Geodi.Database.Meta.DBSubContent, Geodi.Database", "TableFilter":"TQA", "IDColumnMacro":"[OBJECTID]_1", "FileNameColumnMacro":"[file1]", "FileMemoColumn":"file2" }, { "__type":"Geodi.Database.Meta.DBSubContent, Geodi.Database", "TableFilter":"TQA", "IDColumnMacro":"[OBJECTID]_2", "FileNameColumnMacro":"[dosya1]", "FileMemoColumn":"dosya2" } ] } |
Indexing an Embedded File Without a Filename in a Table
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 file extension. Meta can be modified as desired.
FileMemoColumn
in VT must have a file extension in the given column.If there is no extension in the column value and all files are of 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":"Documents", "IDColumnMacro":"[DocumentsID]", "FileNameColumnMacro":'=string.Concat(d["EAID"],"-",d["CretaDate"],string.IsNullOrEmpty(d["DF"])?".pdf":d["DF"])', "FileMemoColumn":"File" } ] }
Indexing what is given with File Path in Table
...