XFlat
-
We currently define the structure of flat file wthiin our organisation using fields stored in a database. However i want to move to an xml file type definition to define file structure, maybe using some sort of schema file. I've seen an article on the use of XFlat. Does anyone know if its any good or any other alternative 'best practice' solutions? Regards
-
We currently define the structure of flat file wthiin our organisation using fields stored in a database. However i want to move to an xml file type definition to define file structure, maybe using some sort of schema file. I've seen an article on the use of XFlat. Does anyone know if its any good or any other alternative 'best practice' solutions? Regards
XFlat is an XML language for defining flat file schemas. link[^] Based on your post it sounds like you want to create XML files from your database so XFlat would be of no value to that effort. What platform and development tools are you using? Have you looked at any database/xml related articles here on code project?
-
XFlat is an XML language for defining flat file schemas. link[^] Based on your post it sounds like you want to create XML files from your database so XFlat would be of no value to that effort. What platform and development tools are you using? Have you looked at any database/xml related articles here on code project?
I'm currently on XP using VB.NET 2005. The organisation uses an older version of SAP which outputs flat files which need processing into other systems. I've looked at xsd validation which is useful for validatiing xml files and will be useful when we eventually upgrade SAP. However i need a generic way (or as much as possible) for reading from and creating flat files. I was wondering if there was a way of specifiying the structure of the flat files using xml files as some sort of schema. If not, is it possible i could de-serialise the flat files, maybe into objects and then later serialise them to (possibly) a different structured files? This is where i was wondering whether an xml type schema could be used. Any help, greatly appreciated.
-
I'm currently on XP using VB.NET 2005. The organisation uses an older version of SAP which outputs flat files which need processing into other systems. I've looked at xsd validation which is useful for validatiing xml files and will be useful when we eventually upgrade SAP. However i need a generic way (or as much as possible) for reading from and creating flat files. I was wondering if there was a way of specifiying the structure of the flat files using xml files as some sort of schema. If not, is it possible i could de-serialise the flat files, maybe into objects and then later serialise them to (possibly) a different structured files? This is where i was wondering whether an xml type schema could be used. Any help, greatly appreciated.
You can use XSLT to transform your flat files to XML.
"We make a living by what we get, we make a life by what we give." --Winston Churchill
-
I'm currently on XP using VB.NET 2005. The organisation uses an older version of SAP which outputs flat files which need processing into other systems. I've looked at xsd validation which is useful for validatiing xml files and will be useful when we eventually upgrade SAP. However i need a generic way (or as much as possible) for reading from and creating flat files. I was wondering if there was a way of specifiying the structure of the flat files using xml files as some sort of schema. If not, is it possible i could de-serialise the flat files, maybe into objects and then later serialise them to (possibly) a different structured files? This is where i was wondering whether an xml type schema could be used. Any help, greatly appreciated.
-
There are many different ways to go from flat file to XML and one is the XmlCsvReader[^]
There you go digging deep in the documentation again!
"We make a living by what we get, we make a life by what we give." --Winston Churchill