CREPORTUPLOAD

Allows for the uploading of files, into CALUMO, for any custom purposes.

CReportUpload files are saved to a dedicated database table ie not uploaded to the CALUMO tree.

CReportUpload functions only in web reports. In Excel, a simple textual confirmation of the existence of the formula is displayed

A stored procedure (proc) can be run after the file is uploaded (if configured) and is passed various arguments from the formula - the purpose of the proc is to allow the report author to do something with the uploaded file

Only one file can be uploaded per formula. If more than one is selected by the report user, only the first is uploaded

Storage

The parameters loginID, fileKey, fileID (DB ID of the record) and jobID (a GUID for this event in the format “jobid-{GUID}”) are always passed to the proc, and custom parameters (specified in the ProcArgs argument of the formula) are then appended

The data table (ReportUploadFile) stores the DateUploaded, FileByteCount, FileBytes, FileName and LoginID of user uploading the file and the file Key

Syntax

CREPORTUPLOAD (ButtonText, Key, ProcDataSource, ProcName, ProcArgs, ResultCell, AutoCalc, Enabled, ImageUrl)

Arguments

ButtonText

(Required)

Text to appear on the upload button

Key

(Required)

A key (presumably unique) passed to the proc, to enable the report author to identify this upload event

ProcDataSource

Datasource for a proc to run, once the file is uploaded

ProcName

Name of a proc to run

ProcArgs

Arguments to be passed to the proc - uses a special format, identical to CEXECSTOREDPROC, eg “@param1=’Hello’,@param2=’world’, @ID=22”

ResultCell

(Required)

The cell in which to put the jobID (a GUID) if the file is successfully uploaded. This cell needs to be a visible cell if you want to use the jobID

AutoCalc

Whether to automatically calculate after the file upload is complete

Default value: true

Enabled

Enable or disable this formula (this just provides a way of disabling the formula without having to remove it)

Default value: true

ImageUrl

Image URL to display on this cell

Examples

=CREPORTUPLOAD("Upload","unique-1","datasource1","myproc","@param1='Hello',@param2='world'",B9,FALSE,TRUE)