I'm new to WF and need to know the best way to import or load an XML file into a FOCUS table or to convert the XML into a usable format like a fix or flat file. Thanks. joe

DevStudio 7.6.2
WF Suze Linux

This message has been edited. Last edited by: Kerry,

Hi Joe,

Check with IBI. They do have an XML adaptor that can be configured to read these files.

Rich

While Rich's suggestion is the most straightforward, it will also cost $$ for the additional XML adapter. If you open the XML file in Excel, does it appear correctly in columns? You could then save as flat file or comma-delimited, move it to your WF server, create a Master File to describe it, and you've got what you need.

You would need to follow these steps for every XML file that you want to access.

What is the intended use of your XML file?

If purely to display the entire contents then look at using an XSL file to display it.

If you need to select only certain records then, as Darin says, open the file in Excel which has the ability to convert XML files, even creating it's own schema if you do not have the reference to one in the XML file itself.

T

Thanks for the replies. I will need to build an automated process that pulls in XML files and loads them to table(s). I read that Maintain does not support XML directly, so, I will need to get them into native Focus or some other maintain addressable format. Any thoughts or best practices? .. thanks

Hey Joe, Did you get the XML Adaptor working OK ? Or did you go down another route ? I am hoping to use this myself so keen to hear of others experiences. Cheers....

No, I am only able to do it manually with the create synonym tool. I'd bet there is a way to issue a CREATE SYNONYM command and then dump the data into a hold file for further processing. I just can't find it anywhere. j

Additional info: We already purchased the XML adapter. I can create the synonym manually however I need a way to do it programatically i.e. in a FEX.