The File Repository in SystemWeaver is used for file attachment functionality. When configured for use, it allows users to add attachment files to items and issues. Currently, the repository storage solution can be in one of two possible formats - database or file-based.  


Database File Repository

Using the database format, the repository is stored in one big file. The advantage of this format is that repository consists of only one file - an sqlite database file - which makes it easy to handle. With regards to back-ups, because is it one database file, the entire file gets backed up each time which can become considerably large.  


File-Based File Repository

This is the format that we generally recommend. Using the file-based format, the repository is stored using a file system in a custom file structure. Using whichever back-up process you chose, this format is efficient in that it identifies files that have been changed and only copies those, along with the index file, to the back-up repository.


To change the file repository format, there is a conversion tool available. 


Prerequisites


Note: The swDatabaseManager application is not for general distribution and should only be used by an authorized system administrator.


  1. Navigate out to the SystemWeaver installation and open the swDatabaseManager application.

  2. Navigate to the File Repository tab.


Database File Repository

  1. For a database type repository, click on Create file repository (database)
  2. Name the database in which the file repository will be stored and click Save. The default extension is .sqlite.

File-Based File Repository

  1. For a file-based type repository, click on Create File Repository (file-based)
  2. Select the folder location that will contain the file repository structure. We advise that you select a new directory and not an existing one. A data directory will be created and an initial structure.

You must never manually edit this structure or it's files. This may corrupt the file store. You can move the file store to another location by copying the entire directory including all it's subdirectories and files.

What's Next?

Once the file repository is created, you are ready to configure its use by the swDBServer so that users can upload attachments to items and issues. You can also learn about repository back-ups.