File Download

HTML enabled
(v8+)

• Collection: With this option selected, you can specify the name of a collection that contains the list of files for download. Each item in the collection should have the following fields:
  • filepath: This is the physical location of the file.
  • caption: This is the caption that the system should display on the list. But also the caption will be the name of the downloaded file.
  • filetype: This is the type of the file.
  • time_stamp [optional]: This is the time stamp (last modified date) of the file.
  • content [optional]: It is possible to directly set the content of the file in this field
  • encoding [optional]: If the content of the file is encoded as base64, you can set the encoding to 'base64'.
    
    Example collection:
    - my_collection.filepath = “C:\new_file4.html”
    - my_collection.caption = “myfile”
    - my_collection.filetype = “txt”
    
    Note: If you point the download part to a file location containing too many files, the application may stop responding and will display a blank page. If that happens, reduce the amount of files located in the folder and try again. There is not an exact number of files that can be located in the file folder, as it can vary based on the capacity of each device.
• Directory: You can specify a path to a storage location on the server from which the files can be downloaded. If you click 'with subfolders' option, the system also lists the files in the subfolders.
• File: You can specify a filename that is made available to download. The downloaded filename can be different to the source file (e.g. add $(now) to the filename for it to be timestamped at the time of download, filename = download_YYYYMMDD.HHMMSS.abc)
• Data Object: You can specify a data object that contains text or base64-encoded data to be downloaded. Enter the data object name in the source (data object) field.
• Datasource: You can specify the name of the data source (database and table) that contains the downloadable content. If you leave the database field empty the system assumes the table is within the package itself.
  
  The table should have the following columns:
  • caption: This is the caption the system will display on the list.
  • content: This is the content of the file.
  • filetype: This is the type of the file.
  • encoding: base64 or empty.
    
    You can create a table in the workspace in the resources\data folder or in an external database using SQL. An example SQL statement is CREATE TABLE [NAME OF THE TABLE] (id Integer PRIMARY KEY AUTOINCREMENT UNIQUE NOT NULL, caption Text, content BLOB, filetype Text, encoding TEXT);. If you create a table in an external database, you must import the table definition into the workspace using the Import definition from existing table function in the resources\data folder of your project.

This option becomes available when the storage location is set to '(local) \appdata' or '(local) \temp'. It allows you to specify the subfolder within the given directory to which the file(s) must be uploaded.

If the sub folder was specified in the File Upload part, then match the parameter here to be able to see uploaded files.

• (local) \appdata: This is the \appdata folder in the company-dat folder of your LogicNets installation.
• (local) \temp: This is the \temp folder in your company-dat folder of your LogicNets installation. Note: The \temp folder will be cleared at set intervals so this location should be considered temporary storage.
• External directory: This is a custom location outside the standard \appdata and \temp folders.

• Download: The item can be downloaded.
• Open: The item can only be opened in a new browser tab.
• Download and Open: The item can both be downloaded or opened in a new browser tab.

• filepath: This is the physical location of the file.
• filename: This is the caption that the system displayed on the list.
• filetype: This is the file type.
• delete_at: This is the time stamp of the deletion.