Re: Need help creating a xsd schema from a flat text file

Hi Geir

I suggest you check out Liquid XML Studio, its a great way to build up
XSD's and learn the standard.

A free community version can be downloaded from

http://www.liquid-technologies.com/Product_XmlStudio.aspx

There is also a tutorial on the site that takes you through the basics

http://www.liquid-technologies.com/XsdTutorial_01.aspx

Hope this helps

Regards
Simon


On 23 Jul, 13:50, g-for...@xxxxxxxxxxx wrote:
Hi!

I hope some of you have experience with creating a xsd schema from a
text file. I have tried using flat file wizard but I am not sure if I
got it right. I am putting the text file below. It is a text file
fixed text lines 121 character long including line feed.

If you study the text file you see that each line starts with 501,
503, and so on.

The 501 line is appearing only once (it is a company identifier)
The 503 line is apperaring more than once(employer identifier), but it
is always followed by a 504 lines (sometime a 506 line is also there,
but basically 504 lines)
The 504 line is mentioned, it is detail info about the employer.

Then a new 503 line comes up, and the followed by 504 lines and so on.

Finally, we have sum line which is the last line and starts with 508.
Well here you see the pattern. I don't expect you to understand every
part of the lines in the file below. but I need some tip how to
arrange the xsd file to support the content from the text file.
Something like this is the content

Schema
  -tag501
     -tag503
        -tag504
        -tag504
     -tag503
       -tag504
       -tag506
       -tag504
       -tag504
   -tag508

I really like some tips about how to use the flat file wizard. You can
see that when going through the file with the wizard 501 is a record,
503 is maybe a repeating record, but I don't know how to build it up
so I dont have to create many 503 records, it should only be one that
accepts 504 and 506 lines.

Please help

regards

geir F

.