Exporting data to csv or txt Files in Sage Enterprise ManagementV9

Exporting data to csv or txt Files in Sage Enterprise ManagementV9

Posted by

Exporting data to csv or txt Files in Sage Enterprise ManagementV9

Sometimes we want to export the data to CSV or TXT file when customers have multiple ERP systems interface. For instance, whenever we want to import the data from Sage Enterprise Management V9 system to any other ERP system like SAP or PeopleSoft etc. then it is necessary to export the data from Sage Enterprise Management V9 system to CSV or TXT. If there is requirement of fetching the data from multiple tables, there is no standard export template. We will have to do this process using the code.

There two ways to export data from Sage Enterprise Management V9 to CSV or TXT:

  1. By using import/export Templates
  2. Using Code

Following procedure describes how to export the data from Sage Enterprise Management V9 to csv file:

Given example shows that how to export sales data in Sage Enterprise Management:

The following screenshot shows a code which is used to export the data to csv and a method to create csv file at particular location for example creating CSV in TEM folder in SEED folder in Sage Enterprise Management.

image001Note: It is possible to assign any extension in place of csv like .txt or .dat etc. as per customer requirement.

Once above code has been written then click on create button which gives us message “File has been created successfully” if there are no errors.

image003Then check path where file has been created as per path given in code.

It is possible to see new csv file in temp folder with given name during the coding.

image005image007 It is possible to see the data in csv file as shown below:

This method is helpful in creating all type of files in Sage Enterprise Management V9.

The following two tabs change content below.
Panni

Panni

Panni is an Alberta based technology consulting firm offering consulting services in Sage ERP X3, business intelligence, business collaboration, invoice automation to medium and large enterprises. Leveraging our deep industry knowledge and technical expertise, we help companies improve and optimize their business processes by creating technology-enabled business solutions.

Leave a Reply