XML output issue
Posted: Tue Feb 21, 2006 6:28 am
hi all,
i am stucked with one of requirement ,can any one please helpme on this...
I want to convert .csv(input) file to .xml file(output)
input.csv file format
userid lastname firstname email
jack wilson james JWILSON@XXX.COM
job design :
seqfile------------->transformer------------.>xml out
In Transformer I have some logic
My queries are:
1)while we are working on XML OUTPUT stage,do we need to work with METADATA IMPORTER,i am not using METADATA IMPORTER,i am just writing the xpath xpressions in "Description"field.it is working fine in some scenarios
2)In other scenario..i am not getting output in required format.
Required output file format.......
<AppAttributeName>UserID</AppAttributeName>
<AppAttributeValue>JACK</AppAttributeValue>
<UserName> JACK </UserName>
</ApplicationPrincipalAttributeValues>
- <ApplicationPrincipalAttributeValues>
<AppAttributeName>LastName</AppAttributeName>
<AppAttributeValue>WILSON</AppAttributeValue>
<UserName> JACK </UserName>
</ApplicationPrincipalAttributeValues>
- <ApplicationPrincipalAttributeValues>
<AppAttributeName>FirstName</AppAttributeName>
<AppAttributeValue>JAMES</AppAttributeValue>
<UserName> JACK </UserName>
</ApplicationPrincipalAttributeValues>
- <ApplicationPrincipalAttributeValues>
<AppAttributeName>Email</AppAttributeName>
<AppAttributeValue>JWILSON@XXX.COM</AppAttributeValue>
but i am getting output with my job as below....
<ApplicationPrincipalAttributeValues>
<AppAttributeName>UserID LastName FirstName Email</AppAttributeName>
<AppAttributeValue> JACK WILSON JAMES JWILSON@XXX.COM</AppAttributeValue>
<UserName> JACK </UserName>
</ApplicationPrincipalAttributeValues>ApplicationPrincipalAttributeValues>
Could any one help on this issue
Thanks in Advance
i am stucked with one of requirement ,can any one please helpme on this...
I want to convert .csv(input) file to .xml file(output)
input.csv file format
userid lastname firstname email
jack wilson james JWILSON@XXX.COM
job design :
seqfile------------->transformer------------.>xml out
In Transformer I have some logic
My queries are:
1)while we are working on XML OUTPUT stage,do we need to work with METADATA IMPORTER,i am not using METADATA IMPORTER,i am just writing the xpath xpressions in "Description"field.it is working fine in some scenarios
2)In other scenario..i am not getting output in required format.
Required output file format.......
<AppAttributeName>UserID</AppAttributeName>
<AppAttributeValue>JACK</AppAttributeValue>
<UserName> JACK </UserName>
</ApplicationPrincipalAttributeValues>
- <ApplicationPrincipalAttributeValues>
<AppAttributeName>LastName</AppAttributeName>
<AppAttributeValue>WILSON</AppAttributeValue>
<UserName> JACK </UserName>
</ApplicationPrincipalAttributeValues>
- <ApplicationPrincipalAttributeValues>
<AppAttributeName>FirstName</AppAttributeName>
<AppAttributeValue>JAMES</AppAttributeValue>
<UserName> JACK </UserName>
</ApplicationPrincipalAttributeValues>
- <ApplicationPrincipalAttributeValues>
<AppAttributeName>Email</AppAttributeName>
<AppAttributeValue>JWILSON@XXX.COM</AppAttributeValue>
but i am getting output with my job as below....
<ApplicationPrincipalAttributeValues>
<AppAttributeName>UserID LastName FirstName Email</AppAttributeName>
<AppAttributeValue> JACK WILSON JAMES JWILSON@XXX.COM</AppAttributeValue>
<UserName> JACK </UserName>
</ApplicationPrincipalAttributeValues>ApplicationPrincipalAttributeValues>
Could any one help on this issue
Thanks in Advance