Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagejson
{
   "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
      languagejson
      {
         "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

...