| Author |
Message
|
| taankyu |
 Posted: Tue Nov 18, 2014 7:31 am Post subject: |
 |
|
Novice
Joined: 15 Nov 2014
Posts: 20
|
Have been trying to do that ; but is my approach correct
- Is this feasible what I am trying to do?
- Do I need to loop over an array to get individual body records.
- Do I also need to Test Serialize Model ?
- Any link for working with ESQL using DFDL would be helpful. |
|
| Back to top |
|
 |
| kimbert |
| Posted: Tue Nov 18, 2014 7:45 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
hi taanku,
As I said in my first reply, this is what you should be doing:
1. Create and debug the DFDL model using the Test Parse view. ( already done )
2. Create a flow that consists of an input node and a Trace node. Don't write any transformation logic until the parsing is successful. Debug the parsing using a debug-level user trace. Compare with the DFDL trace in the Test Parse view to diagnose any errors.
3. Add the nodes that perform the transformation/filterning/routing logic. Do this one step at a time, and use the message flow debugger and/or user trace to verify thee behaviour of each stage of the flow
4. Add the output node and check the output of the flow.
Before you do anything else, please answer the following two questions:
a) Did you use the mqsichangetrace command-line tool when you got the user trace ?
b) Which stage are you at in my list of actions above?
You do not need to use the Test Serialize view at all. You do need to get step 2. working before you try to write any ESQL.
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Nov 18, 2014 8:07 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| taankyu wrote: |
| Have been trying to do that ; but is my approach correct |
Yes
| taankyu wrote: |
| - Is this feasible what I am trying to do? |
Yes
| taankyu wrote: |
| - Do I need to loop over an array to get individual body records. |
Possibly
| taankyu wrote: |
| - Do I also need to Test Serialize Model ? |
Only if you're serializing something
| taankyu wrote: |
| - Any link for working with ESQL using DFDL would be helpful. |
That's any link for using ESQL.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| taankyu |
| Posted: Wed Nov 19, 2014 4:27 am Post subject: |
|
|
Novice
Joined: 15 Nov 2014
Posts: 20
|
I am able to parse some fields from file using MRM and message definition file.
One question I have -
If i parse each row individually ,is there a way to merge fields parsed in last row with one parsed after that |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Nov 19, 2014 5:34 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| taankyu wrote: |
| I am able to parse some fields from file using MRM and message definition file. |
I'm sure you are. Do not use MRM for new development. DFDL is the correct tool.
| taankyu wrote: |
| If i parse each row individually ,is there a way to merge fields parsed in last row with one parsed after that |
Yes. There are a number of documented mechanisms for storing data in this manner. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| taankyu |
| Posted: Wed Nov 19, 2014 5:45 am Post subject: |
|
|
Novice
Joined: 15 Nov 2014
Posts: 20
|
Can you provide link to those documented ways you refered ? Thanks in advance
I am still working on dfdl - following the steps suggested.
Considering the deadline i had to look for alternatives |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Nov 19, 2014 5:55 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| taankyu wrote: |
| Can you provide link to those documented ways you refered ? Thanks in advance |
Start here. There's a search facility. Alternatively locate an on site mentor or some training.
| taankyu wrote: |
I am still working on dfdl - following the steps suggested.
Considering the deadline i had to look for alternatives |
Given that you were already parsing with DFDL, it occurs to me that getting parsing working with MRM was a waste of time. Note that you don't generate XML using MRM any more than you generate XML with DFDL.
You'll also need to work on an explaination for whoever gave you the task, when they ask why you've developed a solution using a stabalised modelling tool rather than the preferred one. "So I could hit the deadline" is unlikely to cut it.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| taankyu |
| Posted: Thu Nov 20, 2014 10:08 am Post subject: |
|
|
Novice
Joined: 15 Nov 2014
Posts: 20
|
Thanks in advance for your help.
I have two records shown below - have matching ID = 104940204.
I parse the first row starting with 10 then other row starting with 20.
| Code: |
10 XXXXXX AA04 104940204M 01 20140901
20 AA04 104940204M 01 123 MMMM SS
|
Is there a way to combine both the records as one message or hold back the last record in memory while second is parsed .
End result should be one message from parsing both the rows. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Nov 20, 2014 10:15 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| taankyu wrote: |
| Is there a way to combine both the records as one message |
Yes
| taankyu wrote: |
| or hold back the last record in memory while second is parsed |
Yes.
Read up on the alternatives and decide which is best for you. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| taankyu |
| Posted: Thu Nov 20, 2014 10:22 am Post subject: |
|
|
Novice
Joined: 15 Nov 2014
Posts: 20
|
I am new to parsing - any approach which gives the desired output.
Basically , I am looking for some help on this.
I tried this way in ESQl -
| Code: |
SET Environment.Variables.dataFiles.Rec[] =
(SELECT I FROM InputRoot.MRM.Row[] AS I WHERE I.ID =20 AND I.PID=10494020 );
DECLARE ResultRef REFERENCE TO Environment.Variables.VisionFiles.Rec[1];
|
Need some help on this |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Nov 20, 2014 10:43 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| taankyu wrote: |
| I am new to parsing - any approach which gives the desired output. |
You can't just "plump" for a design. And we can't tell you which is best or which will even work. We don't know the details of your data layout, the details of your environment or the requirements for your output.
We're also not paid to design this solution, nor are we accountable. In the same way you'd need to justify the use of MRM over DFDL, you need to justify using a design suggested by some random strangers on the Internet.
Some of us more random than others. 
| taankyu wrote: |
| Need some help on this |
Yes you do, and this forum is not the place to get it. You need an on-site mentor and/or some training. This should be communicated to whoever gave you this task. IIB is not a simple product.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| taankyu |
| Posted: Thu Nov 20, 2014 10:52 am Post subject: |
|
|
Novice
Joined: 15 Nov 2014
Posts: 20
|
I just asked for any clue or starting point to hold data in memory to start on.
Neither did I start debate on MRM and DFDL or any mentoring.
Just asked for some refence or starting point .
Check your posts - have they any iota of help , moving round and round
Communities are for seeking help, refernce or any link .
I am new to parsing , thats it .... no debates if u cant help  |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Nov 20, 2014 11:09 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| taankyu wrote: |
| I just asked for any clue or starting point to hold data in memory to start on. |
A few moments with a search engine turned up this and this
| taankyu wrote: |
| Just asked for some refence or starting point . |
The InfoCenter. Always start there.
| taankyu wrote: |
| Check your posts - have they any iota of help , moving round and round |
I'm sorry you feel that way.
| taankyu wrote: |
| Communities are for seeking help, refernce or any link . |
This community is for professionals in the field seeking techincal assistance. As policy, we adhere to the "teach a man to fish" principle, and I think you've additionally been given some fish.
| taankyu wrote: |
| I am new to parsing , thats it .... no debates if u cant help |
How can I possibly help when I don't know all of the details of your requirements?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
