MFExportFileHistory¶
Columns¶
- ID int (primarykey, not null)
SQL primary key
- FileExportRoot nvarchar(100)
Rootfolder is automatically set to C:MFSQLFileExport and can be changed in MFSettings
Rootfolder + FileExportFolder
The FileExportFolder is class specific and is set in the MFClass table by class. It defaults to NULL.
The FileExportFolder will separate the files for different classes in the folder system.
- SubFolder_1 nvarchar(100)
This parameter is set in the spMFExportFiles procedure
- SubFolder_2 nvarchar(100)
This parameter is set in the spMFExportFiles procedure
- SubFolder_3 nvarchar(100)
This parameter is set in the spMFExportFiles procedure
- MultiDocFolder nvarchar(100)
Name or title of metadata
- FileName nvarchar(256)
M-Files filename of the file
- ClassID int
M-Files class ID of the related class table
- ObjID int
M-Files ObjID for the metadata object
- ObjType int
M-Files ObjectType for the class
- Version int
Version number of the object that contained the exported file
- FileCheckSum nvarchar(100)
Calculated checksum for the exported file
- FileCount int
The count of the files in the object
- Created datetime
The date and time of the export of the file
- FileObjectID int
ID of the file
- FileExtension nvarchar(10)
Extension of the file
- FileSize int
Size of file
Used By¶
spMFExportFiles
Changelog¶
Date |
Author |
Description |
2021-01-04 |
LC |
Add file size and file ext to table |
2019-09-07 |
JC |
Added documentation |
2018-06-29 |
LC |
Add Column for MultiDocFolder |
2018-09-27 |
LC |
Add script to alter column if missing |
2019-02-22 |
LC |
Increase size of column for filename |
2017-06-15 |
LC |
Created table |