To update a field having more than one dimension you need to specify its dimension using brackets (). Please refer below example.<\/p>\n
Below is the import template which is use to import the customer records in X3. Here the field BPRNAME is two dimensional field and can be added as BPRNAM(0) and BPRNAM(1) if we need to update both dimension.<\/p>\n
Hope this helps!<\/p>\n About Us<\/strong><\/span> Greytrix<\/a>\u00a0caters to a wide range of Sage Enterprise Management (Sage X3) offerings \u2013 a Sage Business Cloud Solution. Our\u00a0unique GUMU™ integrations include\u00a0Sage Enterprise Management (Sage X3) for Sage CRM<\/a>,\u00a0Salesforce.com<\/a>\u00a0and\u00a0Magento eCommerce<\/a>\u00a0along with Implementation and Technical Support worldwide for\u00a0Sage Enterprise Management (Sage X3)<\/a>. Currently we are\u00a0Sage Enterprise Management Implementation Partner<\/a>\u00a0in East Africa, Middles East, Australia, Asia.\u00a0We also offer best-in-class\u00a0Sage X3 customization and development services<\/a>,\u00a0integrated applications such as\u00a0POS<\/a>\u00a0|\u00a0WMS<\/a>\u00a0|\u00a0Payment Gateway<\/a>\u00a0|\u00a0Shipping System<\/a>\u00a0|\u00a0Business Intelligence<\/a>\u00a0|\u00a0eCommerce<\/a>\u00a0and have developed add-ons such as\u00a0Catch \u2013 Weight\u00a0<\/a>\u00a0and\u00a0Letter of Credit<\/a>\u00a0for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.<\/p>\n Greytrix is a recognized\u00a0Sage Rockstar ISV Partner<\/a>\u00a0for GUMU™ Sage Enterprise Management \u2013 Sage CRM integration also listed on\u00a0Sage Marketplace<\/a>; GUMU™ integration for Sage Enterprise Management \u2013 Salesforce is a 5-star app listed on\u00a0Salesforce AppExchange<\/a>.<\/p>\n For more information on Sage X3 Integration and Services, please contact us at\u00a0x3@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":" There can be occasions when you want to create and\/or update multi-dimensional attribute of an object in X3 via import template. Here we are describing\u00a0how to achieve it using import template. New Stuff:\u00a0Restrict to create the direct supplier return. To update a field having more than one dimension you need to specify its dimension using\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[1039,1050,1312,1313],"class_list":["post-7734","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","tag-import-data-and-csv-file","tag-import-template-in-x3","tag-multi-dimensional-values","tag-multi-dimensional-values-via-import-template"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/7734","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=7734"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/7734\/revisions"}],"predecessor-version":[{"id":16856,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/7734\/revisions\/16856"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=7734"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=7734"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=7734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"o7\"](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2015\/10\/o7.png\")
<\/a>Now we can treate this BPRNAM(0) and BPRNAM(1) as two different fields and can pass two values seperated by field seperator of import template.
\nPlease note if you don\u2019t specify the dimension for multi dimensional fields then by defaut X3 will update the value in dimension zero (0).<\/p>\n
\nGreytrix<\/a>\u00a0\u2013 a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.<\/p>\n