[Servingxml-help] What about this file format?

[Brian R. <bri...@al...>]

I've spent far too long trying to match up my flat file format with  
similar examples, and have not been able to get a successful result.   
Here is my flat file format:

254844~123456789~SMITH~PAULA~FOLDER~001~04/09/2007
@E:\PENSIONS MEMBERS\001\00000\00000001.TIF
@E:\PENSIONS MEMBERS\001\00000\00000002.TIF
@E:\PENSIONS MEMBERS\001\00000\00000003.TIF
@E:\PENSIONS MEMBERS\001\00000\00000004.TIF
@E:\PENSIONS MEMBERS\001\00000\00000005.TIF
250233~123456789~SMITH~PERRIE~FOLDER~001~04/09/2007
@E:\PENSIONS MEMBERS\001\00000\00000006.TIF
@E:\PENSIONS MEMBERS\001\00000\00000007.TIF
@E:\PENSIONS MEMBERS\001\00000\00000008.TIF
@E:\PENSIONS MEMBERS\001\00000\00000009.TIF
@E:\PENSIONS MEMBERS\001\00000\00000010.TIF
@E:\PENSIONS MEMBERS\001\00000\00000011.TIF
@E:\PENSIONS MEMBERS\001\00000\00000012.TIF
@E:\PENSIONS MEMBERS\001\00000\00000013.TIF
@E:\PENSIONS MEMBERS\001\00000\00000014.TIF
@E:\PENSIONS MEMBERS\001\00000\00000015.TIF
@E:\PENSIONS MEMBERS\001\00000\00000016.TIF
@E:\PENSIONS MEMBERS\001\00000\00000017.TIF
@E:\PENSIONS MEMBERS\001\00000\00000018.TIF
@E:\PENSIONS MEMBERS\001\00000\00000019.TIF
@E:\PENSIONS MEMBERS\001\00000\00000020.TIF
@E:\PENSIONS MEMBERS\001\00000\00000021.TIF
@E:\PENSIONS MEMBERS\001\00000\00000022.TIF
@E:\PENSIONS MEMBERS\001\00000\00000023.TIF
...

I'd like to generate XML that looks like this:
<PensionMember>
	<PayrollNumber>254844</PayrollNumber>
	<SSN>123456789</SSN>
	<LastName>Smith</LastName>
	<FirstName>Paula</FirstName>
	<DocType>Folder</DocType>
	<RollNumber>001</RollNumber>
	<ScanDate>2007-04-09</ScanDate>
	<Files>
		<File>0000\00000001.TIF</File>
		<File>0000\00000002.TIF</File>
		<File>0000\00000003.TIF</File>
		<File>0000\00000004.TIF</File>
		<File>0000\00000005.TIF</File>
	</Files>
</PensionMember>

I think I need help with the concepts; for example, do I have one  
record type or two?  Do I have a repeating group or not?  I've tried  
several different things, but I can't figure out how to get files to  
be recognized as something other than a <PensionMember>.  Any help  
would be greatly appreciated!

Thanks,
-Brian

Brian R. Robinson  |  Director, Services                              
|  Alfresco
m. (609) 870-4724  |  e. bri...@al...  |  skype.  
brian.robinson

Introducing Alfresco Community 3.2 - E-Mail, Mobile, CMIS: Download &  
More Details