Versions Compared

Key

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

...

  • 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.

      • 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"
            }
      
         ]
      }
    • Code Block
      languagejson
      {
         "Defines":[
            {
               "__type":"Geodi.Database.Meta.DBSubContent, Geodi.Database",
               "TableFilter":"CMS.FileContentCore",
               "IDColumnMacro":"[FieldId][VersionNumber][MinorVersionNumber]",
               "FileNameColumnMacro":"[Internalid][Extension]",
               "FileMemoColumn":"FileContent"
            }
         ]
      }

Indexing what is given with File Path in Table

...