Subject:custom xml conversion Author:Ron Zimmerman Date:19 Jun 2008 03:29 PM
What are the steps one should use to create an xml conversion adapter when your input *.txt file has 3 different record types with different numbers of fields and field sizes for each? Attached is an example of what my issue is. It would be greatly appreciated if you could outline the normal procedure for handling these kinds.
Thanks,
Ron Zimmerman
Subject:custom xml conversion Author:Tony Lavinio Date:20 Jun 2008 01:57 PM
You actually want just one fixed-width region for the whole file.
A fixed-width region can have the lines separated by CR,LF - that's
what you want.
Then to start a new field, put the cursor on the first character of
that field, right-click, and choose 'begin field here'. You can
drag the field lines once drawn, and remove them just by clicking on
the first character and unchecking the 'begin here' item.
Subject:custom xml conversion Author:Ron Zimmerman Date:01 Jul 2008 09:29 AM
new question: The input file I'm working with is tab delimited. Sometimes not all the fields are present. How do you get the adapter to recognize this?
Subject:custom xml conversion Author:Tony Lavinio Date:01 Jul 2008 10:57 AM
Can you give an example?
I'm assuming you're using the TAB converter.
You might note that the 'Collapse consecutive separators' is
set to 'yes' by default, so TAB-TAB-TAB for example would be
treated as just TAB.
If you are using the Custom XML Converter that creates a .conv
file, could you let us know what the definitions are, and maybe
give us a peek at a small sample file?