I am new to using TOS and one of the things I am looking at doing is reading a flat file with multiple formats in the same file.
I have tried creating a job with the example shown in Use Case 15, and have run into two issues and I have unsuccessfully looked in the user documentation to resolve this.
1) I get an error on the context variables defined in the tJavaRow component:
Error in the component's properties:context.customerNum cannot be resolved or is not a field
row2.customerNum cannot be resolved or is not a field
context.customerName cannot be resolved or is not a field
row2.customerName cannot be resolved or is not a field
How do I resolve this? This was not clear in the Use Case where or how the context variables are defined.
2) If I do not add the context variable in the tJavaRow component, I get the following error message for all the rows in my test file:
Line doesn't match: C;1;Mr. Smith
Line doesn't match: O;1;My first order
Line doesn't match: I;Potatoes:5:brown
Line doesn't match: I;Turkey:1:frozen
Line doesn't match: O;2;Mr. Smith's second order
Line doesn't match: I;Anythng:1
nly one
Line doesn't match: C;2;Mr. Jones
Line doesn't match: O;3;Mr Jones's first order
Line doesn't match: I;Fruits:50:fresh
Line doesn't match: I;Cake:2:Large
Line doesn't match: I;Tea:10:with fruit
Line doesn't match: O;4;Mr. Jones's second order
Line doesn't match: I;Book:1:Easy Cook Book
Line doesn't match: I;Knife:1
harp
Line doesn't match: O;5;Another order for Mr. Jones
Line doesn't match: I;Book:1:Cooking made Easy
Line doesn't match: C;3;Mrs. Apple
Line doesn't match: C;4;Mrs. Frey
Line doesn't match: O;6;Only order for Mrs. Frey
Line doesn't match: I;Banana:2:Ripe and Yellow - No Brown spots!
Line doesn't match: I;Apple:5:Golden Delicious
Line doesn't match: I;Chocolate Bar:2:With Almonds
I have followed the example in Use Case 15 exactly, with no success and there is not much documentation regarding multiple formats in the same file
.
I'd appreciate any help with this.
Thanks
Debbie