Convert XML to a flat file on unix

, ,
1

Imported from previous forum

2

I have an XML file that needs to be converted into a UNIX flat file. Does anyone know of a specific tool that can accomplish this. I am writing the c code to do this but surely a tool must exist that can do this. Any help would be greatly appreciated. thanks

3

I have an XML file that needs to be converted into a UNIX flat file. Does anyone know of a specific tool that can accomplish this. I am writing the c code to do this but surely a tool must exist that can do this. Any help would be greatly appreciated. thanks

Robert - presume you mean tab delimited file as TEXT.

Yes - just use XSLT!!! Set the output mode to text/txt mimetype.

Thanks, DW

4

I have an XML file that needs to be converted into a UNIX flat file. Does anyone know of a specific tool that can accomplish this. I am writing the c code to do this but surely a tool must exist that can do this. Any help would be greatly appreciated. thanks

XLST can do this for you, i.e. you can select out what you want from the XML into whatever data / file structure you need. There’s plenty of generic stuff on the web to show you how to do this on the web. Google XSLT to flat file.

5

I have an XML file that needs to be converted into a UNIX flat file. Does anyone know of a specific tool that can accomplish this. I am writing the c code to do this but surely a tool must exist that can do this. Any help would be greatly appreciated. thanks

XLST can do this for you, i.e. you can select out what you want from the XML into whatever data / file structure you need. There’s plenty of generic stuff on the web to show you how to do this on the web. Google XSLT to flat file.

Thanks for the response but is there a tool/process to convert XML file to text file using C. I’m not well versed in Java but might be my opportunity to start learning.

6

I have an XML file that needs to be converted into a UNIX flat file. Does anyone know of a specific tool that can accomplish this. I am writing the c code to do this but surely a tool must exist that can do this. Any help would be greatly appreciated. thanks

XLST can do this for you, i.e. you can select out what you want from the XML into whatever data / file structure you need. There’s plenty of generic stuff on the web to show you how to do this on the web. Google XSLT to flat file.

Thanks for the response but is there a tool/process to convert XML file to text file using C. I’m not well versed in Java but might be my opportunity to start learning.

You should just call the XSLT transformation, by passing in your data and the XSLT to apply to it, this you can do under programmatic control using C. i.e. pick up the FIXML message, grab the XSLT, pass both to processor, get back the processor output, save processor output to file.

Most operating systems will have a default XSLT / Xquery processors e.g. SAXON , MSXML, XALAN. - you’d invoke this from your program. I’d explain the XSLT template as a document [itself in XML format] which describes the output you want from your source data together with instructions on how to read the source data. You’ll be able to get examples to covert XML to flat files through google.

Check out XSLT on wiki which describes this for you. A good tool to get to grips with this is ‘oxygen xml’ – google for a free trial download, and the w3c schools for basic info on XSLT.

If you add XSLT into your solution, you’ll have all the flexibility you need for this and many other similar tasks. (Your source data doesn’t even have to be XML – but that’s another story)

You may even be able to find a pre-built tool for you that does the job already.

Good luck.

7

I have an XML file that needs to be converted into a UNIX flat file. Does anyone know of a specific tool that can accomplish this. I am writing the c code to do this but surely a tool must exist that can do this. Any help would be greatly appreciated. thanks

XLST can do this for you, i.e. you can select out what you want from the XML into whatever data / file structure you need. There’s plenty of generic stuff on the web to show you how to do this on the web. Google XSLT to flat file.

Thanks for the response but is there a tool/process to convert XML file to text file using C. I’m not well versed in Java but might be my opportunity to start learning.

You should just call the XSLT transformation, by passing in your data and the XSLT to apply to it, this you can do under programmatic control using C. i.e. pick up the FIXML message, grab the XSLT, pass both to processor, get back the processor output, save processor output to file.

Most operating systems will have a default XSLT / Xquery processors e.g. SAXON , MSXML, XALAN. - you’d invoke this from your program. I’d explain the XSLT template as a document [itself in XML format] which describes the output you want from your source data together with instructions on how to read the source data. You’ll be able to get examples to covert XML to flat files through google.

Check out XSLT on wiki which describes this for you. A good tool to get to grips with this is ‘oxygen xml’ – google for a free trial download, and the w3c schools for basic info on XSLT.

If you add XSLT into your solution, you’ll have all the flexibility you need for this and many other similar tasks. (Your source data doesn’t even have to be XML – but that’s another story)

You may even be able to find a pre-built tool for you that does the job already.

Good luck.

thank you so much for this information.

8

I have an XML file that needs to be converted into a UNIX flat file. Does anyone know of a specific tool that can accomplish this. I am writing the c code to do this but surely a tool must exist that can do this. Any help would be greatly appreciated. thanks

XLST can do this for you, i.e. you can select out what you want from the XML into whatever data / file structure you need. There’s plenty of generic stuff on the web to show you how to do this on the web. Google XSLT to flat file.

Thanks for the response but is there a tool/process to convert XML file to text file using C. I’m not well versed in Java but might be my opportunity to start learning.

You should just call the XSLT transformation, by passing in your data and the XSLT to apply to it, this you can do under programmatic control using C. i.e. pick up the FIXML message, grab the XSLT, pass both to processor, get back the processor output, save processor output to file.

Most operating systems will have a default XSLT / Xquery processors e.g. SAXON , MSXML, XALAN. - you’d invoke this from your program. I’d explain the XSLT template as a document [itself in XML format] which describes the output you want from your source data together with instructions on how to read the source data. You’ll be able to get examples to covert XML to flat files through google.

Check out XSLT on wiki which describes this for you. A good tool to get to grips with this is ‘oxygen xml’ – google for a free trial download, and the w3c schools for basic info on XSLT.

If you add XSLT into your solution, you’ll have all the flexibility you need for this and many other similar tasks. (Your source data doesn’t even have to be XML – but that’s another story)

You may even be able to find a pre-built tool for you that does the job already.

Good luck.

thank you so much for this information.

I stumbled upon Altova Mapforce, a product from XMLSpy developers, that will do exactly what you are looking for:

9

I have an XML file that needs to be converted into a UNIX flat file. Does anyone know of a specific tool that can accomplish this. I am writing the c code to do this but surely a tool must exist that can do this. Any help would be greatly appreciated. thanks

XLST can do this for you, i.e. you can select out what you want from the XML into whatever data / file structure you need. There’s plenty of generic stuff on the web to show you how to do this on the web. Google XSLT to flat file.

Thanks for the response but is there a tool/process to convert XML file to text file using C. I’m not well versed in Java but might be my opportunity to start learning.

Hi,
Xerces-C++ XML Parser might be handy if you want to carry on using C, of course, AWK or Perl could also do it.

10

[ original email was from Dave Arter - dave.arter@eds.com ]
> > > > I have an XML file that needs to be converted into a UNIX flat file. Does anyone know of a specific tool that can accomplish this. I am writing the c code to do this but surely a tool must exist that can do this. Any help would be greatly appreciated. thanks

XLST can do this for you, i.e. you can select out what you want from the XML into whatever data / file structure you need. There’s plenty of generic stuff on the web to show you how to do this on the web. Google XSLT to flat file.

Thanks for the response but is there a tool/process to convert XML file to text file using C. I’m not well versed in Java but might be my opportunity to start learning.

Hi,
Xerces-C++ XML Parser might be handy if you want to carry on using C, of course, AWK or Perl could also do it.

Have you pulled down a simple tool like XMLSpy and tried converting the source to flat file? Creating a C parser for XML redaction to text form seems to be a bit overkill.

11

I have an XML file that needs to be converted into a UNIX flat file. Does anyone know of a specific tool that can accomplish this. I am writing the c code to do this but surely a tool must exist that can do this. Any help would be greatly appreciated. thanks

XLST can do this for you, i.e. you can select out what you want from the XML into whatever data / file structure you need. There’s plenty of generic stuff on the web to show you how to do this on the web. Google XSLT to flat file.

Thanks for the response but is there a tool/process to convert XML file to text file using C. I’m not well versed in Java but might be my opportunity to start learning.

Hi,
Xerces-C++ XML Parser might be handy if you want to carry on using C, of course, AWK or Perl could also do it.

Have you pulled down a simple tool like XMLSpy and tried converting the source to flat file? Creating a C parser for XML redaction to text form seems to be a bit overkill.

i agree about overkill and also seems like i would be reinventing the wheel so i’ll look into this XMLSpy. Thank you so much