{"id":95,"date":"2014-05-08T10:00:24","date_gmt":"2014-05-08T10:00:24","guid":{"rendered":"https:\/\/quickthinkcloud.com\/?p=95"},"modified":"2019-02-28T16:38:06","modified_gmt":"2019-02-28T16:38:06","slug":"agresso-document-archive-part-2-storing-images-on-the-file-system","status":"publish","type":"post","link":"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/","title":{"rendered":"Agresso Document Archive \u2013 Part 2: Storing Images on the File System"},"content":{"rendered":"

Document Archive<\/h3>\n

Document Archive was introduced in Agresso 5.5 to replace the document store in Agresso 5.4 which was handled by Compello. It was a great improvement over the 5.4 version because it was far more robust, feature rich and gave users options around where to store their documents. In this article we are going to concentrate on the storage of the documents in the database or outside of the database on shared storage.<\/p>\n

Document Archive \u2013 File Storage<\/h3>\n

With the release of Agresso 5.6.3 (M3) there was distinct improvement in the File Storage method of storing images. The improvements included better data control on images within Agresso, however a much more relevant improvement to the purpose of this blog post was regarding storage of images and how they could be secured on the file system.<\/p>\n

Previous to Agresso 5.6.3 you could had to either give users read access to the actual share hosting the images or you could proxy the connection with substitute credentials held as parameters and these were held in plain text.<\/p>\n

In Agresso 5.6.3 this issue was removed with the introduction of a new service that runs under an Windows account that has access to the images. This means that you can remove all rights to the image share from everyone except the user (and admins) that runs the service. This means that when you ask for an image in Agresso, a request is placed with the service that retrieves it and passes the image back to Agresso for viewing.<\/p>\n

Therefore our advice is to only use File Storage from Agresso 5.6.3 onwards, below you will find the advantages and disadvantages of this method.<\/p>\n

The Advantages:<\/h4>\n
    \n
  1. Disk Space<\/strong> \u2013 You can now store your images on cheaper, higher capacity disks. Only your technical team will thank you for this unless you get cross charged for disk space but it can extend the life of storage drastically.<\/li>\n
  2. Local and Off Site Backups<\/strong> \u2013 These will benefit hugely, reducing the time your database takes to backup and the cost of storing these backups. SQL Server can compress data between 70-90% and images (BLOBS) by 0-1%, so with no images a 100 GB database can take up as little space at 10-25 GB, if you have 100 GB of data and 100 GB of images then your backups will be around 115 GB, a big difference!<\/li>\n
  3. Restores<\/strong> \u2013 Restores to test systems will take a lot less time when storing images outside the database and if you have a DR event drastically reduces recovery time.<\/li>\n
  4. Security<\/strong> \u2013 In previous versions to Agresso 5.6.3 this may have been a disadvantage over database storage but with the latest version of Agresso access can be locked down very tightly and is now an advantage.<\/li>\n
  5. Portability<\/strong> \u2013 If you need to move your image store for any reason then you just copy and paste them to the new location and point the Document Archive service at the new location. There are other ways to achieve this via DNS rather than re-pointing the service but it does add an extra step that is not self contained within the Agresso application stack.<\/li>\n<\/ol>\n

    The Disadvantages:<\/h4>\n

    The disadvantages of File Storage over Database Storage are:<\/p>\n

      \n
    1. Configuration<\/strong> \u2013 The configuration of the newly released File Storage mechanism is quite simple to set up technically but you will need to read the Tech Guidelines in your Agresso installation directory in order to do so. Once the service is configured correctly there is an extra step required in the Agresso Smart Client\/Desktop which involves you changing or setting up a new Document System and setting a dll against it. Once this is completed the you either need to set up new Document Types or change existing ones to use the new Document System.<\/li>\n
    2. Backup<\/strong> \u2013 A new backup source needs to be configured to backup the production image file location, this is not a big task however it is another step.
      \nWhat happens if I want to move from database storage to file storage?<\/li>\n<\/ol>\n

      The short answer is that it is simply complicated. To clarify, the process appears straight forward however the transfer does not remove any images from the database so these need to be manually removed directly via the database. We will look into this in the next Spring Cleaning post.<\/p>\n

      Summary<\/h3>\n

      Hopefully this has blog post has given you some insight into the Pro and Cons of storing images on the file system. Storing images on the file system is suitable for all customers regardless of size with the disadvantages usually being one time considerations to negate.<\/p>\n","protected":false},"excerpt":{"rendered":"

      Document Archive Document Archive was introduced in Agresso 5.5 to […]<\/p>\n","protected":false},"author":1,"featured_media":131,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"yoast_head":"\nAgresso Document Archive \u2013 Part 2: Storing Images on the File System - QuickThink Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Agresso Document Archive \u2013 Part 2: Storing Images on the File System - QuickThink Cloud\" \/>\n<meta property=\"og:description\" content=\"Document Archive Document Archive was introduced in Agresso 5.5 to […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/\" \/>\n<meta property=\"og:site_name\" content=\"QuickThink Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2014-05-08T10:00:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-02-28T16:38:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/quickthinkcloud.com\/wp-content\/uploads\/Storing-Data-Part-2-Blog-Image.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1414\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nick\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nick\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/\"},\"author\":{\"name\":\"Nick\",\"@id\":\"https:\/\/quickthinkcloud.com\/#\/schema\/person\/baee40715d0049fa3d96ed00eef60b3b\"},\"headline\":\"Agresso Document Archive \u2013 Part 2: Storing Images on the File System\",\"datePublished\":\"2014-05-08T10:00:24+00:00\",\"dateModified\":\"2019-02-28T16:38:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/\"},\"wordCount\":761,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/quickthinkcloud.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/quickthinkcloud.com\/wp-content\/uploads\/Storing-Data-Part-2-Blog-Image.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/\",\"url\":\"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/\",\"name\":\"Agresso Document Archive \u2013 Part 2: Storing Images on the File System - QuickThink Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/quickthinkcloud.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/quickthinkcloud.com\/wp-content\/uploads\/Storing-Data-Part-2-Blog-Image.jpg\",\"datePublished\":\"2014-05-08T10:00:24+00:00\",\"dateModified\":\"2019-02-28T16:38:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/#primaryimage\",\"url\":\"https:\/\/quickthinkcloud.com\/wp-content\/uploads\/Storing-Data-Part-2-Blog-Image.jpg\",\"contentUrl\":\"https:\/\/quickthinkcloud.com\/wp-content\/uploads\/Storing-Data-Part-2-Blog-Image.jpg\",\"width\":2560,\"height\":1414,\"caption\":\"Storing Data Part 2 Blog Image\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/quickthinkcloud.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Agresso Document Archive \u2013 Part 2: Storing Images on the File System\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/quickthinkcloud.com\/#website\",\"url\":\"https:\/\/quickthinkcloud.com\/\",\"name\":\"QuickThink Cloud\",\"description\":\"Experts in Unit4 Business World Cloud Hosting, Agresso Managed Services and Agresso Technical Consultancy\",\"publisher\":{\"@id\":\"https:\/\/quickthinkcloud.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/quickthinkcloud.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/quickthinkcloud.com\/#organization\",\"name\":\"QuickThink Cloud Limited\",\"url\":\"https:\/\/quickthinkcloud.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/quickthinkcloud.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/quickthinkcloud.com\/wp-content\/uploads\/2019\/02\/QuickThink-Cloud-Retina-Mobile-Logo.png\",\"contentUrl\":\"https:\/\/quickthinkcloud.com\/wp-content\/uploads\/2019\/02\/QuickThink-Cloud-Retina-Mobile-Logo.png\",\"width\":201,\"height\":137,\"caption\":\"QuickThink Cloud Limited\"},\"image\":{\"@id\":\"https:\/\/quickthinkcloud.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/quickthinkcloud.com\/#\/schema\/person\/baee40715d0049fa3d96ed00eef60b3b\",\"name\":\"Nick\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/quickthinkcloud.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/52bcbce9d2ad057e87a6140e76c10c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/52bcbce9d2ad057e87a6140e76c10c6f?s=96&d=mm&r=g\",\"caption\":\"Nick\"},\"url\":\"https:\/\/quickthinkcloud.com\/author\/nick\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Agresso Document Archive \u2013 Part 2: Storing Images on the File System - QuickThink Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/","og_locale":"en_US","og_type":"article","og_title":"Agresso Document Archive \u2013 Part 2: Storing Images on the File System - QuickThink Cloud","og_description":"Document Archive Document Archive was introduced in Agresso 5.5 to […]","og_url":"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/","og_site_name":"QuickThink Cloud","article_published_time":"2014-05-08T10:00:24+00:00","article_modified_time":"2019-02-28T16:38:06+00:00","og_image":[{"width":2560,"height":1414,"url":"https:\/\/quickthinkcloud.com\/wp-content\/uploads\/Storing-Data-Part-2-Blog-Image.jpg","type":"image\/jpeg"}],"author":"Nick","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nick","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/#article","isPartOf":{"@id":"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/"},"author":{"name":"Nick","@id":"https:\/\/quickthinkcloud.com\/#\/schema\/person\/baee40715d0049fa3d96ed00eef60b3b"},"headline":"Agresso Document Archive \u2013 Part 2: Storing Images on the File System","datePublished":"2014-05-08T10:00:24+00:00","dateModified":"2019-02-28T16:38:06+00:00","mainEntityOfPage":{"@id":"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/"},"wordCount":761,"commentCount":0,"publisher":{"@id":"https:\/\/quickthinkcloud.com\/#organization"},"image":{"@id":"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/#primaryimage"},"thumbnailUrl":"https:\/\/quickthinkcloud.com\/wp-content\/uploads\/Storing-Data-Part-2-Blog-Image.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/","url":"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/","name":"Agresso Document Archive \u2013 Part 2: Storing Images on the File System - QuickThink Cloud","isPartOf":{"@id":"https:\/\/quickthinkcloud.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/#primaryimage"},"image":{"@id":"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/#primaryimage"},"thumbnailUrl":"https:\/\/quickthinkcloud.com\/wp-content\/uploads\/Storing-Data-Part-2-Blog-Image.jpg","datePublished":"2014-05-08T10:00:24+00:00","dateModified":"2019-02-28T16:38:06+00:00","breadcrumb":{"@id":"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/#primaryimage","url":"https:\/\/quickthinkcloud.com\/wp-content\/uploads\/Storing-Data-Part-2-Blog-Image.jpg","contentUrl":"https:\/\/quickthinkcloud.com\/wp-content\/uploads\/Storing-Data-Part-2-Blog-Image.jpg","width":2560,"height":1414,"caption":"Storing Data Part 2 Blog Image"},{"@type":"BreadcrumbList","@id":"https:\/\/quickthinkcloud.com\/agresso-document-archive-part-2-storing-images-on-the-file-system\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quickthinkcloud.com\/"},{"@type":"ListItem","position":2,"name":"Agresso Document Archive \u2013 Part 2: Storing Images on the File System"}]},{"@type":"WebSite","@id":"https:\/\/quickthinkcloud.com\/#website","url":"https:\/\/quickthinkcloud.com\/","name":"QuickThink Cloud","description":"Experts in Unit4 Business World Cloud Hosting, Agresso Managed Services and Agresso Technical Consultancy","publisher":{"@id":"https:\/\/quickthinkcloud.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quickthinkcloud.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/quickthinkcloud.com\/#organization","name":"QuickThink Cloud Limited","url":"https:\/\/quickthinkcloud.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quickthinkcloud.com\/#\/schema\/logo\/image\/","url":"https:\/\/quickthinkcloud.com\/wp-content\/uploads\/2019\/02\/QuickThink-Cloud-Retina-Mobile-Logo.png","contentUrl":"https:\/\/quickthinkcloud.com\/wp-content\/uploads\/2019\/02\/QuickThink-Cloud-Retina-Mobile-Logo.png","width":201,"height":137,"caption":"QuickThink Cloud Limited"},"image":{"@id":"https:\/\/quickthinkcloud.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/quickthinkcloud.com\/#\/schema\/person\/baee40715d0049fa3d96ed00eef60b3b","name":"Nick","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quickthinkcloud.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/52bcbce9d2ad057e87a6140e76c10c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/52bcbce9d2ad057e87a6140e76c10c6f?s=96&d=mm&r=g","caption":"Nick"},"url":"https:\/\/quickthinkcloud.com\/author\/nick\/"}]}},"_links":{"self":[{"href":"https:\/\/quickthinkcloud.com\/wp-json\/wp\/v2\/posts\/95"}],"collection":[{"href":"https:\/\/quickthinkcloud.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quickthinkcloud.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quickthinkcloud.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quickthinkcloud.com\/wp-json\/wp\/v2\/comments?post=95"}],"version-history":[{"count":0,"href":"https:\/\/quickthinkcloud.com\/wp-json\/wp\/v2\/posts\/95\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/quickthinkcloud.com\/wp-json\/wp\/v2\/media\/131"}],"wp:attachment":[{"href":"https:\/\/quickthinkcloud.com\/wp-json\/wp\/v2\/media?parent=95"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quickthinkcloud.com\/wp-json\/wp\/v2\/categories?post=95"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quickthinkcloud.com\/wp-json\/wp\/v2\/tags?post=95"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}