Last updated: 17.04.2023
Applies from: 2020.08.00 and later
Setting the way attachments are stored
The files can be stored in the system in three different ways:
- File: The files are saved in a folder on the Opter server or a file server.
- Database: The files are saved in the database (SQL Server).
- Cloud (blob storage): The files are stored in the Microsoft Azure Blob Storage cloud service.
You specify where attachments are to be stored in the system settings. Remember that the disk space may run out if the files are stored in a folder on a computer/file server or in the database, especially if running the free version of SQL Server, which has a limit of 10 GB.
Step 1: Choose how to store the files in the system
Click on Settings > System settings and choose how to store the files under Storage of attachments.
- Manually attached files: Here it is possible to choose how files that are added to the PC client, Opter Driver, Opter Terminal and the webs are saved. These could be, for example, customs documents that are added in order reception or images from Opter Driver.
- EDI logs: Here it is possible to choose how EDI logs are saved. The EDI logs are used for troubleshooting EDI integrations.
- Imported attachments: Here it is possible to choose how files that are automatically imported are saved. The files are imported into Opter via an import service. For more information about how to import files automatically, see Importing files from a folder automatically and Import of attachments, window.
Step 2: Enter paths and credentials
Depending on the choice of how files are to be saved in step 1 above, it may be necessary to specify either a path to a storage location and/or credentials.
If the Database option has been selected for any of the sources above
It is not necessary to provide any additional information. The files are saved in the existing SQL database.
If the File option has been selected for any of the sources aboveEnter the path to the storage location in the File storage path field. When a file, such as a customs document, is added the file is saved in a subfolder with the date on that day (EDI logs are saved under \EDI\YYYY-MM-DD).
If the Cloud (blob storage) option has been selected for any of the sources aboveEnter the connection string to Microsoft Azure Blob Storage in the Cload storage (blob storage connection string) field. The connection string consists of a URL and an access key.
If the files cannot be uploaded to the cloud, for example if the connection string specified here is incorrect, the files are saved in the database instead.
If you are running Opter CloudThe file import service is installed by a deployment consultant on the computers on which folders are to be monitored. Contact for more information.