2017 R1 Update Rollup 1

The Fabasoft Folio/COLD File System ImportPermanent link for this heading

Using the datasource type “File System” directory structures and files from the file system can be read and used to generate Fabasoft Folio objects.

The Fabasoft Folio/COLD File System Import makes available file names associated with directories and their sub-folders in a table.

The table is structured as follows:

  • ParentName
    Contains the name of the parent folder (e.g. “import“).
  • ParentPath
    Contains the path of the parent folder (e.g. “e:\import“).
  • ParentKey
    Contains a combination of the import address and the relative path to the parent folder.
  • <ext>Name
    You have to specify all file extensions that occure among the files that should be imported. For each extension, a column of the form "<ext>Name" is produced, e.g. for the extension “docx”, a “docxName” column is produced and all DOCX files are entered in this column, e.g. “Document1.docx”.
  • <ext>Path
    For each specified extension, a column of the form “<ext>Path“ is produced, e.g. for the extension “docx”, a “docxPath” column is produced and the path of each DOCX file is entered in this column, e.g. “e:\import\Document1.docx“.
  • <ext>Key
    For each specified extension, a column of the form “<ext>Key“ is produced, e.g. for the extension “docx”, a “docxKey” column is produced and a combination of the import address and the relative path of each DOCX file is entered in this column. This column can be used as key in the Fabasoft Folio/COLD import.
  • Extension
    Contains the file extension of the file.

Note:

  • “Folder” is a known extension which can be used to import folders.
  • “*” can be used as extension which means that all other file formats of the source directory are contained in columns with the * extension.
  • Using Fabasoft Folio/COLD File System Import it is possible to import from both directories and ZIP files. Using the import via a ZIP file the content can assigned via the property “Data Source Object” (FSCCOLD@1.1001:datimpobjdatasource).