Get Uploaded Data
This layer loads a frameset from a CSV file that the user uploads.
Adding this layer to an analytic will make the 'Upload Measurement(s)' button appear in the list of captures.
Parameters
Name | Default | Meaning |
---|---|---|
columns | A list of required column names | |
length | 30 | Length of the event (in seconds) if no end given |
offset | 0 | Amount of offset (in seconds) to subtract from the given time(s) |
Description
This function loads a set of frames based on either a fixed time, or a start and end time.
These frames may (and usually will) also contain other information, such as manual measurements, inspection results or descriptions of that particular point of time.
This data is often used to convert manual measurements into AIs that provide virtual sensors.
Required Columns
At the very least, the file must have a column named 'Time' or 'Date' (the case doesn't matter).
Alternatively, it could have 'Start' and 'End', 'StartTime' and 'EndTime' or 'StartDate' and 'EndDate' to provide variable time ranges.
Example
Using a layer like this…
{ "type": "get_upload", "length": 60 }
…and uploading a file like this…
Time,Vibration,Temperature 2025-08-02 10:00,0.22,15 2025-08-03 14:44,4,40 2025-08-04 12:31,4,34
Will load in 3x 60-second timeframes, each with a 'Vibration' and a 'Temperature' amount.
You could then capture other process details around that time (ie. the AIPOINTS function in AQL would let you capture the current, voltage & mode of the machine, status of the process, ambient temperature conditions at that point in time etc.) to build an AI model.