{"id":30141,"date":"2024-10-29T10:26:31","date_gmt":"2024-10-29T10:26:31","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=30141"},"modified":"2024-10-29T10:26:31","modified_gmt":"2024-10-29T10:26:31","slug":"how-to-store-images-using-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2024\/10\/29\/how-to-store-images-using-sage-x3\/","title":{"rendered":"How to Store Images Using Sage X3"},"content":{"rendered":"\n

Before learning how to store images, it’s important to understand the AB0 and ABB data types.<\/p>\n\n\n\n

Understanding AB0 and ABB Data Types<\/p>\n\n\n\n

Both AB0 and ABB are BLOB (Binary Large Object) fields used to store binary data, such as images, directly in the database. The length of BLOB fields is expressed in powers of 2. For example, if you select a length of 6, the field can store files up to 64 KB (6 length : 2^6 = 64kb).<\/p>\n\n\n\n

Steps to Store Images in Sage X3<\/a><\/p>\n\n\n\n

To store images in Sage X3, follow these steps:<\/p>\n\n\n\n

    \n
  1. Add a Field to Store the Image<\/li>\n<\/ol>\n\n\n\n

    \uf0b7Begin by adding a new Column in the table where you want to store your image. Select the data type AB0 or ABB for the field (as shown in the screenshot below).<\/p>\n\n\n\n

    New Stuff:-<\/strong> Running Total Fields Feature in Crystal report<\/a><\/p>\n\n\n\n

    \"Fig1:Development<\/a><\/center>\n
    Fig1:Development Table Details<\/center><\/font>\n\n\n\n
      \n
    1. Select the Appropriate Length<\/li>\n<\/ol>\n\n\n\n

      \uf0b7Choose the length of the BLOB field based on your expected file size. This length is crucial because it defines the maximum size of the image you can store. For example, choosing a length of 6 allows you to store up to 64 KB.<\/p>\n\n\n\n

        \n
      1. Save and Validate the Table
        \uf0b7After setting the field and length, save your changes and validate the table to apply the modifications.<\/li>\n\n\n\n
      2. Add the Field to the Corresponding Screen
        Navigate to the screen associated with your table, and add the same field you just created. Ensure the field length matches the one you set in the table.<\/li>\n<\/ol>\n\n\n\n
        \"Fig2:Development<\/a><\/center>\n
        Fig2:Development Screen Details<\/center><\/font>\n\n\n\n
          \n
        1. Configure the Graphic Object<\/li>\n<\/ol>\n\n\n\n

          After adding the field to the screen, you need to configure it as a graphic object to handle images. Select Photo as the graphic object type. When configuring the graphic object, you\u2019ll encounter the following parameters:<\/p>\n\n\n\n

          oNumber of Lines (Height): Determines the height of the image box.
          oPhysical Columns (Width): Defines the width of the image box.
          oPhoto Type: Choose between:
          \uf0a7Normal: Displays the image as is.
          \uf0a7Stretched: Stretches the image to fit the box.
          \uf0a7Proportional: Adjusts the image proportionally to fit the box (as shown in the screenshot below).<\/p>\n\n\n\n

          \"Fig3:Development<\/a><\/center>\n
          Fig3:Development Screen Details – Graphic Object<\/center><\/font>\n\n\n\n
          \"Fig4:Graphical<\/a><\/center>\n
          Fig4:Graphical Parameters<\/center><\/font>\n\n\n\n

          Configure these parameters according to your needs and design preferences.<\/p>\n\n\n\n

            \n
          1. Save and Validate the Screen<\/li>\n<\/ol>\n\n\n\n

            \uf0b7Once the graphic object is configured, save and validate the screen to apply the changes.<\/p>\n\n\n\n

              \n
            1. Upload the Image<\/li>\n<\/ol>\n\n\n\n

              \uf0b7Now, when you navigate to the screen, you\u2019ll see the option to upload an image file (as shown in the screenshot below). Select your image file, and the system will display a preview in the designated field.<\/p>\n\n\n\n

              \"Fig5:Screen<\/a><\/center>\n
              Fig5:Screen Before Selecting Image<\/center><\/font>\n\n\n\n
              \"Fig6:Screen<\/a><\/center>\n
              Fig6:Screen After Selecting Image<\/center><\/font>\n\n\n\n
                \n
              1. Save the Image<\/li>\n<\/ol>\n\n\n\n

                \uf0b7After previewing the image, hit the Save button to store the image in the database.<\/p>\n\n\n\n

                Following these steps will allow you to successfully store images in Sage X3 using AB0 or ABB fields. Be sure to select the appropriate length and configuration to meet your requirements.<\/p>\n\n\n[about_us_blog_common]\n","protected":false},"excerpt":{"rendered":"

                Before learning how to store images, it’s important to understand the AB0 and ABB data types. Understanding AB0 and ABB Data Types Both AB0 and ABB are BLOB (Binary Large Object) fields used to store binary data, such as images, directly in the database. The length of BLOB fields is expressed in powers of 2.\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,8],"tags":[4313,4314,4309,4312,1822,4311],"class_list":["post-30141","post","type-post","status-publish","format-standard","hentry","category-integration","category-sage-erp-x3","tag-ab0","tag-abb","tag-binary-data","tag-blob","tag-sage-x3","tag-store-binary-data"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/30141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=30141"}],"version-history":[{"count":9,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/30141\/revisions"}],"predecessor-version":[{"id":30154,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/30141\/revisions\/30154"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=30141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=30141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=30141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}