The 'System' section deals with system-wide settings and processes.
You can influence resources and security for your 1202 system with the settings in the 'General' pane. These are:
- Language: sets the system language. Currently available are English and Dutch. Defaults to 'English'.
- Timezone: sets the system timezone. Dates and times in your system will be shown and used according to the timezone set, except when 'UTC' is explicitly stated. Defaults to 'UTC'.
- Title: system title, visible on the login screen and, when logged in, at the top right corner. The system title also appears on the print version of overviews.
- Allowed remote addresses: if you want to remotely get data from your 1202 system, you need to allow the remote IP addresses. You can use only IP addresses, separated by semicolons.
- Allow public access for: ignores above setting for the selected remote requests ('File', 'Image' or 'Model block'), serving to all. This may be useful when serving files or images on a website, which are in effect requested by the user's computer. Defaults to all 'off' (unchecked).
- Extra secure login: checks whether a user has actually (and correctly) typed his credentials when logging in or unlocking. This provides superior security, but prohibits users from logging in by copy-pasting their credentials. Defaults to 'off' (unchecked).
- Cookie validity time in sec.: when a user logs in, a cookie is created with a limited lifetime, the 'cookie validity time'. The cookie is refreshed when interacting with the system. Defaults to '3600' (seconds, or one hour).
- Overview max. rows: the number of rows shown in an overview is either 20, 50 or the value set with 'Overview max. rows'. Defaults to '100'.
- Trash max. items: deleted items are collected as trash. The 'Trash max. items' setting limits the number of trashed items. When reaching this threshold, the oldest item will be deleted. Defaults to '100'.
- Import max. items: your 1202 system can receive import data from a remote host. The 'Import max. items' setting prevents excessive amounts of stored imports. Defaults to '100'.
- Image cache max. items: retrieved images are cached to speed up retrieval. If you have a lot of images, you can consider setting a higher value. However, this will take up more space. Defaults to '500'.
- System max. logs: every session is logged. The 'System max. logs' setting limits the number of log items. When reaching this threshold, the oldest item will be deleted. Defaults to '1000'.
The 'Info' pane (bottom right of the 'General' pane) shows system size and expiration date. This relates to your My 1202 account.
There are two actions for the 'General' pane:
- Save settings: saves the settings in the 'General' pane and applies them.
- Create new container: creates a new, empty container with only an id field and default properties.
Deleted items are collected as trash. You can review and recover trashed items in the 'Trash' pane.
The overview of trashed items shows for each item:
- Recoverable: indicates if a trashed item can be recovered. 'Thumbs up' icon means you can try to recover an item, 'thumbs down' icon means a recovery attempt was made but failed.
- Date & time: date and time the item was deleted.
- Container: title of the container from which the trashed item originates.
- Title: title of the trashed item.
By default, the overview lists all items currently in trash. You can limit this to show only trash items from a particular container by selecting the desired container from the 'Container' select menu (top right).
Hover over or tap on an item and click the 'Delete' button to permanently delete an item, or the 'Recover' button to attempt a recovery.
Info: recovering an item will recover the complete item, including all links (as far as the linked items still exist).
Background processes are handled by the 1202 daemon. The daemon starts and stops automatically. Its main task is synchronizing the views.
You can track daemon actions and progress in the 'Daemon' pane. This pane contains an overview which shows all current views, and for each view:
- View: title of the view.
- Items: number of items in the parent container.
- Items built: number of (complete) items currently present in the view. When this matches the number of items in the parent container, it simply states 'All'. If the daemon is building or rebuilding a particular view, it updates the 'Items built' value during building. This allows you to track build progress.
- Rebuild initiated: either the system or a user can issue a rebuild of a view. The value is 'Yes' when true, 'No' if false.
- Daemon active: indicates if the daemon is working on this view.
- Last activity: shows time and date of the last action the daemon has performed on this view.
Info: Daemon tasks are queued to ensure consistency of the views. However, queues will only be of any concern when working with very large amounts of data with a high degree of complexity. Even then, views are still accessible and thanks to the loose coupling of containers and views, users can still create and edit items.
The 'Daemon' pane has one action:
- Restart daemon: if the daemon does not make progress while it should, you can reset it. This kills the daemon process and tries to repair and rebuild views that could be responsible for the problem.
Note: Restarting the daemon can take quite some time, depending on the size and complexity of the views. It should be used as a last resort, as the daemon already has a mechanism to restart itself.
A very powerful asset of your 1202 system is the ability to import practically anything. In the 'Import' pane you can either import items by copying and pasting tabulated or semicolon/comma-separated data, using an uploaded CSV file, or inserting remotely submitted data.
Remotely submitted data can either be directly imported or saved. Saving submitted data allows for review and is recommended for data that needs to be validated. The saved imports are presented in an overview in the 'Import' pane.
For each submitted import it shows:
- User: submitted data will only be stored when valid credentials of a user that has the proper permissions accompany it. The user's (login) name is shown.
- IP address: the server from where the data was submitted is logged.
- Date & time: date and time the data was submitted.
- Content: the first part of the submitted data.
You can choose to either import or delete saved imports. Hover over or tap on an import and click the 'Insert' button to insert the data in the text box below, or click the 'Delete' button to permanently delete it.
In the 'Direct input' text box you can either insert, paste or type source data for the import. Inserting can be done with saved imports from the overview (above the text box). Alternatively, you can copy and paste data from a spreadsheet application like Microsoft Excel or Apple Numbers. The last option is simply typing data into the text box.
It is also possible to upload a CSV file and import it. This is described under New/edit item.
Your source data has to be in CSV file format. This means that commas, semicolons or tabs should delimit the fields.
Info: Copy-pasting from Microsoft Excel typically results in tab-separated source data. This resembles the CSV format and is therefore perfectly useable.
The first line of your source data has to list the field names. The correct format is:
Container title: Field name
In CSV, with two fields (both 'Title' and 'Text' from the 'Text' container):
Text: Title,Text: Text some title,some text
Use container 'paths' for linked items. For instance, adding the 'Title' field for a linked image:
Text: Title,Text: Text,Text: Image: Title some title,some text,some image title
You can mark fields that your 1202 system should try to match with square brackets:
Text: Title,Text: Text,[Text: Image: Title] some title,some text,some image title
Before validating the data, set the 'Delimiter' option to 'Tab', 'Semicolon' or 'Comma'.
Tip: If you have colons in your container or field names, surround them with double quotes to avoid misinterpretation. For example, if your container is named 'Text: Private' you'd use
"Text: Private": Field.
Before validating, the only action for the 'Import' pane is 'Validate this data'. After you click this button, your 1202 system will try to sort out and match the data from the text box.
An important part of the validation process is determining the 'parent' container, since you always import data into one container. The basic assumption is that each row of the import is a new item in the parent container.
After the validation process has finished, the result will be presented. At the top, a small pane 'Look for match' shows the fields that were positively matched to existing fields. Fields that are not from the parent container are listed under 'Include', because these are fields from linked items. Fields from the parent container are listed under 'Exclude' by default.
The 'included' fields are the ones with which your 1202 system tries to match data from the import to existing data.
To move fields from the 'Exclude' list to the 'Include' list and vice versa, click the green/red 'arrow' icon next to the field. For the changes to take effect, click 'Revalidate source' (top right).
A table below the 'Look for match' pane shows the predicted import result. It has a legend at the bottom:
- Cells marked with a green edge: 'Will be added or updated'. No attempt was made to look for a match using this field. A new item will be created if no other field for the same container was matched. Otherwise, it will update the item with this value.
- Cells marked with a green edge and blue background: 'No exact match found. Click to find matches.' There was an attempt made to look for a match using this field. However, no match was found. This will result in a new item for this container or an update of an existing item (when a match was found for another field from the same container). It is possible there is no exact match but there is a close match. Click the cell to look for close matches. A small pane at the bottom will appear from which you can select a close match or view it more closely.
- Cells marked with a striped background: 'Matched. Will be linked if required.' An existing item was matched based on this field. If the field is from the parent container, the item will get updated, if not, it will be linked.
- Cells marked with a red background: 'Invalid. Excluded from export.' The field was not matched, you do not have sufficient permissions for the field or the field value proves invalid.
Note: Matches made are exact matches. Even uppercase letters and spaces can prevent an exact match.
Tip: The best way to match to existing items, is by using their 'id' value. All items in your 1202 system have an 'id' value.
After validation, you have three main actions to choose from:
- Import this data: imports the data as shown, creating and updating items and adding links where necessary. Shows a 'score card' when done. Any real errors will be logged in the system log.
- Edit source data: switches to the pre-validation state of the 'Import' pane, where you can edit the source data in the 'Direct input' text box.
- Revalidate source: validates the source data again. This is especially useful when you have changed the included/excluded fields.
Note: You cannot 'undo' an import. Also, imports can never delete items.