Wm601 Flat File Schemas recordWithNoID

yes we are able to create recordWithNoID record definition in FF Schema in IS6.01 SP2 with out having any problems.

Thanks,

Hi Chris,

Opening this old thread again…

We have an issue for parsing Inbound flatfile Schema using (recordWithNoID)option and getting this error
“com.wm.ui.UiException: com.wm.ff.parse.ParseException: [FFP.0012.0004] Found no valid records”.
We have Record Delimiter (newline) and field Delimiter (~)and it is the Nth Field.

For outbound convertToString (recordWithNoID)working fine with no problems.

My question is will WMFlatFile support recordWithNoID when parsing flatfile.

Here is the sample package i am attaching and a sample flatfile.

TIA,
RMG

TestSchemaPackage
TestSchema.zip (4.0 k)

sampleFF
SampleFF.txt (18.2 k)

RMG

Didn’t run the package but I still have an open case with Tech support on this.
Somewhere in version 6.0.1 recordWithNoID became no longer supported.
The only way that I can now get it to work is using the method Mark mentioned above. Tech support insist that it is not supported.
The problem is I have schemas that run in production fine but if I take the output and use it as a test file in developer against the schema I get the no valid records.
Something has definitely changed but according to the docs it’s not supported as it is not mentioned any where.
The argument I have with tech support is that I have a case where Tech support showed me how to do it in 6.0.1 but this no longer works for some reason.

HTH

Chris,

Thanks for your response.

I don’t understand why the recordWithNoID option is working for convertToString but not for using for convertToValues.So 6.01 partly supporting the recordWithNoID definition.

I too opened an SR with tech support.let see what they will say on this issue.

Regards,

Chris,

Followed Mark method and successfull in parsing the inbound FlatFile and parsed the file which gave us recordWithNoID in the results.

Amd unpdated techsupport to close my SR.

Thanks mark,for your elaborate procedure.

Regards,

I just parsed a flat fixed width file with no record identifiers in the file. When webMethods parses it it gives me a recordWithNoID record array even though I created my own record name in the schema (normally has to match exactly when the file contains record identifiers) and did the set thing as mentioned above. So in order to have this map properly I created a record in the schema called recordWithNoID so that the generated document type would match what I get passed at runtime. It’s all working now (although not ideal - I would like it to use my record name), however in the generated doc type I get 3 nearly identical recordWithNoID arrays under the root node for some reason although this doesn’t appear at runtime.

Will

hey .
just got a same problem with FlatFile structure is there any one who can create a Flat File schema for this kind of record , this faltfile is also uses "recordWithNoId " and “recod Identifier “ both I need to have record Identifier in the middle of the record (R1,R2,R3)
the example goes here …

0000000000010000000002R11SMTAOVA USA 040499999999YYNCON
0000000000010000000002R2TAOVAUK 040499999999YYNCON
0000000000010000000002R353261GGTAOBIG RAIN 04049999YYNCON

this particular sample uses “recordWithNOID” for this first part
“0000000000010000000002” then from R1 (R11SMTAOVA USA….)
i need record Identifier for example “R1” “R2” “R3” like that
because each R has different Structure (Fixed length)and it need to be identified first to get processed .
If you need any more information i will glad to tell you. i will appreciate your responses.

Thank you

KK,

I believe it is not possible,only recordWithNoId is the option and so after parsing the flatfile you have to loop on the records and map the R1,R2,R3 details to a new record create which has R1,R2,R3 structures and do the mapping.But this process is tedious for this kind of file and requirement.

HTH,
RMG>

Why not just specify your record identifier at the position of R1, position 23. It doesn’t have to be at the beginning of the record.

Just a thought.

Thanks RMG and Chris,

RMG:-
If I use recordwithNoID then I will get the whole record set
but this R1 R2 R3 is like a set and this set is repeating like this

0000000000010000000002R11SMTAOVA USA 040499999999YYNCON
0000000000010000000003R2TAOVAUK 040499999999YYNCON
0000000000010000000004R353261GGTAOBIG RAIN 04049999YYNCON

0000000000020000000001R11SMTAOVA USA 040499999999YYNCON
0000000000020000000002R4TAOVAUK 0404GGASVCDYYNCON
0000000000020000000003R753261GG

more over the R1 R2 are not consistent meaning
i may come like R1 R2 R3 R3 one time and next time it may come
R1 R4 R7 RA…(but the header will be present every time 0000000000020000000001)
Each R’s has it own structure defined.

Chris:-

I did tryed that !!
keep record Identifier at 22 (23-1) Position, I created the “RecordIdenifier” and “recordWithNoID” both
and i was able to get R1 record But the record “recordWithNOID” didn’t show up (exp:0000000000010000000002 was missing ).
But If I Just keep record Identifier at 0 Position I was just getting Header not R’s Segment . Its like vice versa… that funny

I was wondering is there any other way to figure this out ?

If you have the record identifier then you don’t need the recordWithNoID. Then name of your record in the schema has to match the value in the record identifier position. Your record names therefore has to be R1, R2…
Define the first fields in each record to handle 000000000010000000002.
In other words treat them as any other field not a separate record.

Thanks,
but the purpose of doing that is to identify the different set of data there are 2 sets of data in this example .

0000000000010000000002R11SMTAOVA USA 040499999999YYNCON
0000000000010000000003R2TAOVAUK 040499999999YYNCON
0000000000010000000004R353261GGTAOBIG RAIN 04049999YYNCON

0000000000020000000001R11SMTAOVA USA 040499999999YYNCON
0000000000020000000002R4TAOVAUK 0404GGASVCDYYNCON
0000000000020000000003R753261GG

my requirement is getting a list of (2 document in this case)

Can we do that with your logic?

No but neither can your data the way it’s structured.
Use the method I mention to get your data into an idata record.
Then you can write whatever logic you like to process the first 2 fields including creating a second idata record object just for those fields.

thanks Chris,
I used your logic to create the Schema and tested it It works fine for
Single record but I found some errors while parsing multiple records.
I will try to give you example :-

001R1000A
001R200B
002R1000A
002R200B

I created the schema and make it multiple occurrences of that
R1 and R2 record But then I testing the schema I am getting

1 occurrences of R1 record (expected is 2 records)
2 occurrences of R2 record

And one error message: [FFP.0011.0011] Unrecognized element

do you have any idea about this error.
Thank you so much for replying.

Try testing with just one record.
001R1000A
001R200B
001R35326

See if your schema works.
If it does, chances are your error has to do with the fact that your file contains more than one record. In that case you’ll have to play around with what’s repeatable and what’s not. At least you’ll know your structure is correct.

I am able to Create Schema for that Flat file.
What I did is, Just define the Dictionary for all R’s and when we create the Flatfile Schema and I just used arrows |->(left arrow) and <-|(right arrow ) ( in the schema )
to insert all variables inside the only one record (R1 has all the R2 ,R3… and soo on )
It took some time to figure out the schema.

Thanks Chris and RMG .

Glad it worked.

Can any one give a sample Fixed length record Flat file.

I need to see how the flat file is looking like.

I have one with me which i created: please see this and correct me if any thing wrong.

Record length: 21
Field delimiter: *
File content :

SampleRecSiva12345

Is this a valid record as per the settings?

Siva,

Don’t cross post.

Siva,

The example shown above is correct…So there will be RecordDefinition set?If no recordfintion in the flatfile then use recordWithNoID this makes parse the flatfile.

HTH,
RMG