Flat file schema problem

, ,
21

Do they have record identifiers for rec1,2,3 in your batch file?If so this should help in parsing the file.

create a Schema with record definition (rec1) and followed by fields(fixed length)
under this same rec1 hierarchy create record definition (rec2) followed by fields,another record definition (rec3) followed by fields.

ex:rec1 (max repeat=unlimited)
----rec2
----rec3

test the schema with one set of recr1,2,3 and later with multiples.

If this doesnt work,some one will assist you.

HTH,
RMG

22

thank you rmg,
awsome ,it worked just perfect and more over i need to loop only once on that doc list.
cool
thank you
regards
srikanth

23

Glad to know it worked.

HTH,
RMG.

24

hi rmg,
i am struck at a small problem ,actually i am entring date into the database,and i am getting the error. the column type in database is smalldatetime ,and the input i am providing it is MM/dd/yyyy, but it says need format MM-dd-yyyy mm hh etc…
and i have just input for the date .
thanks
srikanth

25

So build the date with dateFormat(Pattern MM-dd-yyyy HH:mm:ss) service accordingly and insert it,also there are few threads discussed on the problem.

For these type of problems,please do search this site it saves your time.

HTH,
RMG

26

hi rmg,
i am struck at a step.
where in i am populating an array in a loop with values ,
input output
string string list
and when i check the values in string list outside the loop i am getting just the last value entered inside the string list.
do u have any idea why its happening.
thanks
sri

27

Sri,

For this kind use appendToStringList service inside the loop,this should build you the stringlist output.See BuiltInServices userguide for more inputs information.

But a trick when using this service basically in the pipeline out drop the toList,fromItem.

HTH,
RMG

28

Sri,

Make sure you are mapping a string list to “toList” and a string to “fromItem” in “Service In” of pub.list:appendToStringList. Please step through the flow and see the stringList after each iteration.

HTH.

-Pauly

29

hi rmg,
thank you
i have one more quesiton idk if i am doing it properly.
when i get the string list out of loop,actually i got 2 string lists.
and i need to put the values in the database ,so what i am doing is
loop over stringlist1
loop over stringlist2
string1 ,string2 map to insertadapter
exit loop (if success)
its working fine but duplicate values are getting into database ,do u think exit has something to do with it.logically it seems to be right but idk its not working.
thanks sri

30

duplicate values getting into database?Debugging helps for looping problem.So step thru the loops and see the pipeline what values being passed to insertAdapter service and how is ur exit loop working.

Basically you will need to step thru the flows for this kind of problem,since we dont have clear picture what you are doing in mapping,drop variables,loop iterations,pipeline behaviour etc…

HTH,
RMG

31

check whether your are dropping the unnecessary values or not before entering the loop again and again.

32

I seem to be having the same problem here. Any resolution tips for the same. Only difference is that my data looks like

aawew=paramater1?
sadadas=paramater2?

nightfox.