{"id":5552,"date":"2014-09-23T07:22:04","date_gmt":"2014-09-23T07:22:04","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=5552"},"modified":"2018-11-19T10:51:19","modified_gmt":"2018-11-19T10:51:19","slug":"how-to-execute-import-utility-using-code-2","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2014\/09\/23\/how-to-execute-import-utility-using-code-2\/","title":{"rendered":"How to execute import utility using code"},"content":{"rendered":"

Sage ERP X3 has a functionality of creating Import\/Export template which works quite efficiently. The only thing that has to be done manually through export utility under Usage is :<\/p>\n

Imports\/Exports->Exports, (GEXPOBJ).<\/p>\n

\"How<\/a><\/strong><\/em><\/span>However, Sage ERP X3 has a functionality of creating Import\/Export template in XML format which can be done manually after following some simple navigation. However, if you need a duplicate XML tag in the export template, Sage ERP X3 doesn\u2019t allow this using standard template.<\/p>\n

However, this can be easily done using code.<\/p>\n

Step1.<\/strong> First of all, you need to declare Clbfile variable. This declaration is important for storing data in variable.<\/p>\n

\"How<\/a><\/strong><\/em><\/span><\/p>\n

CLBFILE : Clbfile function is used to declare the variables of the type clob. The clob type is used to store the text with variable length.<\/p>\n

Step2.<\/strong> Create file using \u201cfilepath\u201d function.<\/p>\n

First parameter: Pass the directory name for export file location.<\/p>\n

Second parameter: Pass the file name to function without extension.<\/p>\n

Third parameter: Pass the type of file you want to generate. To generate XML file, Pass \u201cXML\u201d.\"How<\/a><\/p>\n

Step3.<\/strong> Tag declaration – Here you can declare same tag multiple times which is not possible using standard template.<\/p>\n

Below, we have given an example of Trading partners<\/strong> tag. Once you intiate trading partner tag, you can start writing data inside the tags in xml format. Data should be in XML tags format.<\/p>\n

\"How<\/a><\/p>\n

About Us<\/strong><\/span>
\nGreytrix<\/a> \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

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 Sage Enterprise Management (Sage X3) for Sage CRM<\/a>,\u00a0Salesforce.com<\/a> and\u00a0Magento eCommerce<\/a>\u00a0along with Implementation and Technical Support worldwide for Sage Enterprise Management (Sage X3)<\/a>. Currently we are Sage Enterprise Management Implementation Partner<\/a> in East Africa, Middles East, Australia, Asia.\u00a0We also offer best-in-class\u00a0Sage X3 customization and development services<\/a>,\u00a0integrated applications such as POS<\/a> | WMS<\/a> | Payment Gateway<\/a> | Shipping System<\/a> | Business Intelligence<\/a> | eCommerce<\/a> and have developed add-ons such as Catch \u2013 Weight <\/a>\u00a0and Letter of Credit<\/a> for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.<\/p>\n

Greytrix is a recognized Sage Rockstar ISV Partner<\/a> for GUMU™ Sage Enterprise Management \u2013 Sage CRM integration also listed on Sage Marketplace<\/a>; GUMU™ integration for Sage Enterprise Management \u2013 Salesforce is a 5-star app listed on Salesforce 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":"

Sage ERP X3 has a functionality of creating Import\/Export template which works quite efficiently. The only thing that has to be done manually through export utility under Usage is : Imports\/Exports->Exports, (GEXPOBJ). However, Sage ERP X3 has a functionality of creating Import\/Export template in XML format which can be done manually after following some simple\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":[1],"tags":[765,810,2324,2450],"class_list":["post-5552","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-export","tag-filpath","tag-usage","tag-xml"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/5552","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=5552"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/5552\/revisions"}],"predecessor-version":[{"id":16394,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/5552\/revisions\/16394"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=5552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=5552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=5552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}