Managing Historic Data for Records in Quanta

Quanta allows you to store historic data for records.  You are able to record a value and a time that relates to the value.  For example, you might be recording blood pressure or blood sugar levels for a group of people suffering from diabetes (where each person being monitored has a record for blood pressure and for blood sugar).

History List

Select Components ->Quanta from the Joomla Administrator Menubar.

Select Histories from the Sub-menu.  This will show you a list of the historic data you have defined for use in the Quanta component.

Click on any of the linked column headings to sort by that column.

Click the linked date or value to edit the history.

Click the icon in the published column to toggle the published state to either published or unpublished.

The following Toolbar actions are available:

• Publish - Published the selected values in the list.
• Unpublished - Unpublished the selected values in the list.
• Trash - Send the selected values in the list to the trash.
• Delete - Permanently delete the selected values. Note that this only displays when the Published State filter is set to Trash.
• Edit - Edit the selected value in the list.
• New - Create new value.
• Import - Import data from a CSV

The following list filters are available:

• Search - This filter allows you to search for a string or a sub-string in the record name or alias.
• Record Filter - This allows you to filter the list for historic data attached to an individual record.
• Category Filter - This allows you to filter the list for historic data assigned to a category.
• Published State - This filter allows you to display various published states.  The default setting shows published and unpublished categories.

Create a New Historic Value

To create a new value, click the New icon in the Toolbar of the histories list.

The following Toolbar actions are available:

• Save and New - This button allows you to save the current value and then create a new one without having to go back to the records list.
• Save - Allows you to save the value and returns you to the records list.
• Apply - Allows you to save the value and returns you to the edit screen of that value.
• Cancel - Returns you to the histories list without saving.

Enter data in the following fields:

• For Record - The record that the value relates to.
• Time - The date and time that relates to the value.
• Record Value - The value.
• Record Value 2 - Currently not in use.
• User ID - Currently not in use.
• Published - This is the published state of the record

Edit an Existing Historic Value

To edit an existing record, click the linked date or value in the list.

Import Data from a CSV

The Histories view allows you to import data from an external CSV source.  Click Import in the Toolbar.  A popup window will display:

Enter data in the following fields:

• CSV File - Click Browse to select the CSV file that contains your data (see additional notes below).
• Date Column - This is either the name of the column (in the first row of the data) or the column number (starting at 1) that contains the date.
• Value Column - This is either the name of the column (in the first row of the data) or the column number (starting at 1) that contains the value.
• Import into Record - This is the record that the historic data will be imported into.

Click Upload to import the data.  Depending on the size of the file, the import could take a while.  When it is complete, the popup window will automatically close and the history list will automatically refresh.

The following image shows an example of the data that might be contained within the CSV file.

Using this example to upload, the Date Column would be 1.  The data column must be in MySQL data format (YYYY-MM-DD HH:MM:SS).

The values columns would range from 2 to 5 depending on the record that the data is to be imported against.  The value must be numeric (and whole or decimal number).