This is an old revision of the document!
As well as the main database, all users of Mystic also have an allocated area of the cloud server in which other files are stored.
Under normal circumstances, these files are directly maintained by the functional areas of Mystic (such as loading CSV and Excel files for BISON to import into the database). As well as loading them, these functional areas can be used to remove them when no longer in use.
The Mystic [File & Attachment Manager] however, is provided to also perform direct management of these files, as well as perform one or two further operations which can only be be performed here in the manager.
On initial display, the main part of the [File & Attachment Manager] displays a typical tree-view listing similar in nature to a conventional folder (directory) browser. It lists the six different sub-directories that are automatically created within your file storage area:
Clicking a Folder opens the folder and displays the files stored within.
Clicking a File displays details of the file on the right hand side of the dialog.
In order to refresh the display of files, click the [Refresh] toolbar button. Unlike other areas of Mystic however, the stored files rarely change at a fast pace and it is unlikely that a refresh will typically be required.
In order to remove a file, select the file in the display and then click the [Remove] toolbar button in the [Attachments] toolbar group.
Note that removing a file here bypasses the normal functionality of Mystic, and it may be that records to which the file is attached will be out of synchronisation. While this will not cause errors, it will mean that files which are initially indicated as being available to end readers (e.g. a book cover) can not be displayed.
It is typically better to remove files which are technically 'attachments' to Mystic records only using the functionality provided by the various specialised functional areas.
In order to make a file copy of the current Mystic database for your account, click the [Archive] button in the [Database] toolbar group.
This function makes a server based copy of the secure database in the Database Archive folder of your account. The file server and the database server are located on different physical hosts, maintained by different providers and in different physical locations, and this process therefore provides a good physical backup option.
Note that this file is intended only for disaster recovery purposes (Esferico and the database server hosting provider also make their own secure backups of all data) and remains in a heavily encrypted state, accessible only by Mystic tools. It cannot be opened using typical end-user database query tools.
If you also wish to make a local copy of the database file, see the download functionality below.
All files that are managed by the [File & Attachment Manager] dialog reside on the cloud server that you are connected to. This means that if you need to be able to transfer files between your local workstation and the file storage area of the server.
In order to upload a file, select the Folder that you want to place the file in then select [Upload]. This will trigger the standard…