Newbie need help with csv template for recordWithNoID

, ,
1

I can’t seem to get the template correct for a csv file without segment identifiers. I don’t need first line of data, only 2nd thru last line. Input looks like this:

“PersonID”,“ResourceID”,“Status”,“CompletionDate”,“Total”
109013,00HRDBUSQK3,“Complete”,“02/19/2003”,51
109013,00HRDCOMQK1,“Complete”,“02/19/2003”,51
105280,00HRDSUPQK8,“Complete”,“02/20/2003”,48
105537,00HRDBUSQK5,“Incomplete”,“02/20/2003”,0
116472,00HRDPRI016,“Incomplete”,“02/20/2003”,0

I copied the flow from WmEDIsamples parseCsvInput and modified template to look like this:

<?xml version="1.0"?> 10 44 AAA AAA2

When I run my test flow, I get null pointer exception at wm.b2b.edi.EDIConverter.getSegment(EDIConverter.java:553). Any help would be greatly appreciated.

Thanks,

GME

2

When using recordWithNoID, there are no need for dummy segments and loops.

changed template:

<?xml>
<csvtemplate>
<segment-delimiter>
<keyword></keyword>
<offset></offset>
<fixed>10</fixed>
</segment-delimiter>
<field-delimiter>
<keyword></keyword>
<offset></offset>
<fixed>44</fixed>
</field-delimiter>
<sub-field-delimiter>
<keyword></keyword>
<offset></offset>
<fixed></fixed>
</sub-field-delimiter>

<segment>
<field>
<field>
<field>
<field>
<field>
</segment>

<loop>
<seg-id>recordWithNoID</seg-id>
</loop>

</csvtemplate>

3

Hi,

I get a CSV with values such as OrderNo, LineNo, ItemNo, Qty, etc… I am able to get the values using a flatfile Template with “recordWithNoID”.

I need data extracted by OrderNos. Can this be done with flatfile template? do i need to create any other loop segments as well?

I use webMethods 4.6.

4

Not sure I understand your question.
If you have the values then you should be able to manipulate the data by writing services using the idata object generated by the template.