Sage 100

Anyone had experience creating XML files from SAGE? Any recommendations where to start?

The only luck I've had is ""faking it"" - manually putting in the ""<>"" stuff required for someone who needed to export PO information.

Connect to Sage with Microsoft Access. Access can export in XML format. Jackie in our office can assist/advise as needed.

If it needs to be recurring or automatic, I like to use PowerShell to connect to Sage via ODBC (with a silent login), and then you can export-clixml to a file. That also gives you a chance to validate or cleanse the output.

All good ideas. Access may be the answer.

Haven't tried it, but from Crystal Help: You can create XML data from your Crystal reports using Crystal Reports XML export. With this data, you can apply a style sheet or import it into another application. Because you can import your own schemas, you can specify any XML, HTML or other file format you need. If you do not have a specific XML schema you want to use to format your report, or if you want to perform transformations after exporting the report, you can use the built in Crystal Reports XML schema, then transform the exported file. You can customize the structure of your XML data when exporting a report. For information on how to do this, see Customizing XML report definitions.

I was going to say something along the lines of what Mark posted. Jim whatever source app you use to create the XML send a sample to the people who will import it into their app to verify compatibility. E.g. Your XML may include CR and LFs (traditional schema) but they are expecting that to be stripped, or vice-versa. Or yours doesn't include tags they are expecting or vice-versa. If you're dealing with a web app the very best and flexible format today is JSON.

Thanks all for your suggestions. I am investigating pulling the data into SQL and using SQL tools to create a XML files. I will update once I make some progress.