{"id":2124,"date":"2024-05-24T11:01:56","date_gmt":"2024-05-24T11:01:56","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/acumatica\/?p=2124"},"modified":"2024-12-12T10:12:26","modified_gmt":"2024-12-12T10:12:26","slug":"enable-upload-action-for-grid-in-acumatica","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/","title":{"rendered":"Enable Upload Action for Grid in Acumatica"},"content":{"rendered":"\n<p>Acumatica&#8217;s powerful ERP platform offers a wide range of tools to help businesses manage and analyze their data effectively. One such tool is the ability to import records using Excel files, facilitated by the &#8220;Upload&#8221; action feature. While importing records via import scenarios is a known process, it requires mapping fields to Acumatica fields and implementing logic for handling multiple records. However, another useful feature is the &#8220;Upload&#8221; option at the grid level, which enhances usability and efficiency. In this blog post, we&#8217;ll explore how to enable this functionality on screens where it may be missing, empowering users to seamlessly import data directly into their Acumatica grids.<\/p>\n\n\n\n<p>In this blog post, we will add the Upload action on the Equipment tab of the Projects (PM301000) screen. However, you can use the methods described below for any grid in Acumatica.<\/p>\n\n\n\n<p><strong>Step-by-Step Guide to Using the Upload Action:<\/strong><\/p>\n\n\n\n<p>Let&#8217;s walk through the process of configuring and using the Upload Action in Acumatica:<\/p>\n\n\n\n<p>1. Navigate to the Equipment tab of the Project Screen:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Inspect the grid to get the view name.<\/li>\n\n\n\n<li>Notice that there is no upload action currently present.<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-24-105233.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; \nalign: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-24-105233.png\" alt=\"Screenshot 2024-05-24 105233\"><\/a><\/center>\n\n\n\n<p>2. Go to the Customization Project Editor Screen:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create a new project.<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-24-105638.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; \nalign: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-24-105638.png\" alt=\"Screenshot 2024-05-24 105638\"><\/a><\/center>\n\n\n\n<p>3. Navigate to the Equipment Rates Tab:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>On the Customization Project Editor, click on the grid of the EquipmentRates grid.<\/li>\n\n\n\n<li>Under the Layout Properties section, navigate to Mode.<\/li>\n\n\n\n<li>Expand Mode and set the `AllowUpload` and `InitNewRow` properties to True (refer to the attached screenshot).<\/li>\n\n\n\n<li>Publish the customization project. You will see the Upload Action on the Equipment tab grid, but it is disabled.<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-24-110253.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; \nalign: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-24-110253.png\" alt=\"Screenshot 2024-05-24 110253\"><\/a><\/center>\n\n\n\n<p>4. Enable the Upload Action:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Check whether the view used on the graph has a `[PXImport]` attribute.<\/li>\n\n\n\n<li>&nbsp;If not, add the attribute to the view by creating an extension of the current graph.<\/li>\n\n\n\n<li>&nbsp;Search for the view definition in the base graph, copy, and paste it into the extension code file.<\/li>\n\n\n\n<li>Add the `[PXImport(typeof(EPEquipmentRate))]` attribute above the view (refer to the attached screenshot).<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-24-112045.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; \nalign: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-24-112045.png\" alt=\"Screenshot 2024-05-24 112045\"><\/a><\/center>\n\n\n\n<p>5. Publish the Customization Package: &nbsp;&nbsp; <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>After publishing, you will see the Upload action enabled on the Equipment tab.<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-24-112339.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; \nalign: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-24-112339.png\" alt=\"Screenshot 2024-05-24 112339\"><\/a><\/center>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Acumatica&#8217;s powerful ERP platform offers a wide range of tools to help businesses manage and analyze their data effectively. One such tool is the ability to import records using Excel files, facilitated by the &#8220;Upload&#8221; action feature. While importing records via import scenarios is a known process, it requires mapping fields to Acumatica fields and\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":2380,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[146,15,3,130,14],"tags":[4,108,252,248],"class_list":["post-2124","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-acumatica","category-acumatica-customization","category-acumatica-erp","category-acumatica-product","category-acumatica-services","tag-acumatica","tag-customization-project","tag-data-import","tag-erp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Enable Upload Action for Grid in Acumatica<\/title>\n<meta name=\"description\" content=\"By following these steps, you can enable the Upload action for grids in Acumatica, allowing for seamless data import directly into your system. This feature enhances the user experience by simplifying the data import process, making it more efficient and user-friendly. Implementing this functionality can save time and reduce errors associated with manual data entry, contributing to a more streamlined workflow in your Acumatica environment.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Enable Upload Action for Grid in Acumatica\" \/>\n<meta property=\"og:description\" content=\"By following these steps, you can enable the Upload action for grids in Acumatica, allowing for seamless data import directly into your system. This feature enhances the user experience by simplifying the data import process, making it more efficient and user-friendly. Implementing this functionality can save time and reduce errors associated with manual data entry, contributing to a more streamlined workflow in your Acumatica environment.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/\" \/>\n<meta property=\"og:site_name\" content=\"Acumatica \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-24T11:01:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-12T10:12:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-24-105233-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1098\" \/>\n\t<meta property=\"og:image:height\" content=\"329\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"greytrix\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greytrix\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/\",\"name\":\"Enable Upload Action for Grid in Acumatica\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-24-105233-1.png\",\"datePublished\":\"2024-05-24T11:01:56+00:00\",\"dateModified\":\"2024-12-12T10:12:26+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec\"},\"description\":\"By following these steps, you can enable the Upload action for grids in Acumatica, allowing for seamless data import directly into your system. This feature enhances the user experience by simplifying the data import process, making it more efficient and user-friendly. Implementing this functionality can save time and reduce errors associated with manual data entry, contributing to a more streamlined workflow in your Acumatica environment.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-24-105233-1.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-24-105233-1.png\",\"width\":1098,\"height\":329,\"caption\":\"Action For Grid - Acumatica\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Enable Upload Action for Grid in Acumatica\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/\",\"name\":\"Acumatica \u2013 Tips, Tricks and Components\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec\",\"name\":\"greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"caption\":\"greytrix\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/author\/greytrix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Enable Upload Action for Grid in Acumatica","description":"By following these steps, you can enable the Upload action for grids in Acumatica, allowing for seamless data import directly into your system. This feature enhances the user experience by simplifying the data import process, making it more efficient and user-friendly. Implementing this functionality can save time and reduce errors associated with manual data entry, contributing to a more streamlined workflow in your Acumatica environment.","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:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/","og_locale":"en_US","og_type":"article","og_title":"Enable Upload Action for Grid in Acumatica","og_description":"By following these steps, you can enable the Upload action for grids in Acumatica, allowing for seamless data import directly into your system. This feature enhances the user experience by simplifying the data import process, making it more efficient and user-friendly. Implementing this functionality can save time and reduce errors associated with manual data entry, contributing to a more streamlined workflow in your Acumatica environment.","og_url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/","og_site_name":"Acumatica \u2013 Tips, Tricks and Components","article_published_time":"2024-05-24T11:01:56+00:00","article_modified_time":"2024-12-12T10:12:26+00:00","og_image":[{"width":1098,"height":329,"url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-24-105233-1.png","type":"image\/png"}],"author":"greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greytrix","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/","name":"Enable Upload Action for Grid in Acumatica","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-24-105233-1.png","datePublished":"2024-05-24T11:01:56+00:00","dateModified":"2024-12-12T10:12:26+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec"},"description":"By following these steps, you can enable the Upload action for grids in Acumatica, allowing for seamless data import directly into your system. This feature enhances the user experience by simplifying the data import process, making it more efficient and user-friendly. Implementing this functionality can save time and reduce errors associated with manual data entry, contributing to a more streamlined workflow in your Acumatica environment.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-24-105233-1.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2024\/05\/Screenshot-2024-05-24-105233-1.png","width":1098,"height":329,"caption":"Action For Grid - Acumatica"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2024\/05\/24\/enable-upload-action-for-grid-in-acumatica\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/acumatica\/"},{"@type":"ListItem","position":2,"name":"Enable Upload Action for Grid in Acumatica"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/","name":"Acumatica \u2013 Tips, Tricks and Components","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/acumatica\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec","name":"greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","caption":"greytrix"},"url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/author\/greytrix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/2124","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/comments?post=2124"}],"version-history":[{"count":4,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/2124\/revisions"}],"predecessor-version":[{"id":2381,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/2124\/revisions\/2381"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/media\/2380"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/media?parent=2124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/categories?post=2124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/tags?post=2124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}