Exporting data from sage x3 from Application level

SUGGESTED






Am interested in writing / developing an application that will export data from Sage x3.

I want to do it from the application level not from the database level.

Would really like help in getting the solution.

Possibly if i can get documentation to read.

I do need help please.

Thank you.

Parents
  • 0
    SUGGESTED

    There are several ways you can do this. 

    1) The easiest way would be to utilize the import/export templates, and export the data to a delimited text file. 

    2) Utilize the X3 objects, and publish them as web services, and read the objects using a query to get the left list, and a read to get all of the object details.  This method doesn't offer as many options for filtering the data you are pulling.

    3) Create a custom sub-program using the X3 4GL, and publish it as a web service.  This provides more flexibility on filtering the data you want to extract, and also on the fields that are returned. 

    I often do options #2 and #3, and consume the web services from a .net application, then push the data to an external/3rd party application.

    The method you do really depends upon how often you want to do this.  If it's a one-time thing, I would do option 1.  If you intend on setting up an ongoing process to pull data, I would do option 2 or 3.

Reply
  • 0
    SUGGESTED

    There are several ways you can do this. 

    1) The easiest way would be to utilize the import/export templates, and export the data to a delimited text file. 

    2) Utilize the X3 objects, and publish them as web services, and read the objects using a query to get the left list, and a read to get all of the object details.  This method doesn't offer as many options for filtering the data you are pulling.

    3) Create a custom sub-program using the X3 4GL, and publish it as a web service.  This provides more flexibility on filtering the data you want to extract, and also on the fields that are returned. 

    I often do options #2 and #3, and consume the web services from a .net application, then push the data to an external/3rd party application.

    The method you do really depends upon how often you want to do this.  If it's a one-time thing, I would do option 1.  If you intend on setting up an ongoing process to pull data, I would do option 2 or 3.

Children
No Data