| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| URGENT: Empty CSV field disappear during parsing |
« View previous topic :: View next topic » |
| Author |
Message
|
| yaakovd |
 Posted: Fri Jan 23, 2009 4:05 am Post subject: URGENT: Empty CSV field disappear during parsing |
 |
|
Partisan
Joined: 20 Jan 2003
Posts: 319
Location: Israel
|
Hi 
I have very simple CSV message set:
CSV_Message (sequence closed, all elements delimited with <LF>)
---> CSV_Line (sequence closed, all elements delimited with comma)
--------> CSV_Element (not nillable)
When parsing file by RCD node for line
ADL,215812,MO-HOME,,22,99.000000,1525,MO_I2I
I'm getting only
ADL,215812,MO-HOME,22,99.000000,1525,MO_I2I 
Means, empty fields disapear from parsed tree.
Tried different flags in MRM settings without any success.
Will appreciate any advise
_________________
Best regards.
Yaakov
SWG, IBM Commerce, Israel
Last edited by yaakovd on Fri Jan 23, 2009 6:44 am; edited 1 time in total |
|
| Back to top |
|
 |
| yaakovd |
| Posted: Fri Jan 23, 2009 4:20 am Post subject: |
|
|
Partisan
Joined: 20 Jan 2003
Posts: 319
Location: Israel
|
I'm working with WMB 6.1 and use 'Suppress Absent Element Delimiters' value "Never"
_________________
Best regards.
Yaakov
SWG, IBM Commerce, Israel |
|
| Back to top |
|
|
| kimbert |
| Posted: Fri Jan 23, 2009 5:37 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
You need to tell the MRM TDS parser that the empty string should be interpreted as a NULL value. You do this as follows:
In the logical properties of the empty element
- set 'Nillable' to true ( tick the box )
In the TDS physical format properties for the empty element:
- Set 'Encoding Null' to 'NullLiteralValue'
- Set 'Encoding Null Value' to the empty string
It works - I've tried it. |
|
| Back to top |
|
|
| yaakovd |
| Posted: Fri Jan 23, 2009 6:40 am Post subject: Solved |
|
|
Partisan
Joined: 20 Jan 2003
Posts: 319
Location: Israel
|
kimbert 
it works!!!
thanks a lot!
_________________
Best regards.
Yaakov
SWG, IBM Commerce, Israel |
|
| Back to top |
|
|
| pcelari |
| Posted: Tue May 26, 2009 7:53 am Post subject: |
|
|
Chevalier
Joined: 31 Mar 2006
Posts: 411
Location: New York
|
| kimbert wrote: |
You need to tell the MRM TDS parser that the empty string should be interpreted as a NULL value. You do this as follows:
In the logical properties of the empty element
- set 'Nillable' to true ( tick the box )
In the TDS physical format properties for the empty element:
- Set 'Encoding Null' to 'NullLiteralValue'
- Set 'Encoding Null Value' to the empty string
It works - I've tried it. |
Hi Kimbert,
I have the same problem, yet only with elements at the end. My output with empty end elements should look like:
112334,blue,,aberdeen,,,
yet, I got the tail element completely cut off:
112334,bule,,aberdeen
I did as you recommended, but still the same. What could I be missing?
_________________
pcelari
-----------------------------------------
- a master of always being a newbie |
|
| Back to top |
|
|
| kimbert |
| Posted: Tue May 26, 2009 8:03 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| "Suppress Absent Element Delimiters" set to the wrong value? |
|
| Back to top |
|
|
| pcelari |
| Posted: Tue May 26, 2009 9:42 am Post subject: |
|
|
Chevalier
Joined: 31 Mar 2006
Posts: 411
Location: New York
|
many thanks Kimbert, that did the trick!
under Supress Absent Element Delimiteres, I was "End of Type", not sure what that really means.
_________________
pcelari
-----------------------------------------
- a master of always being a newbie |
|
| Back to top |
|
|
| MQEnthu |
| Posted: Tue May 26, 2009 8:46 pm Post subject: |
|
|
Partisan
Joined: 06 Oct 2008
Posts: 329
Location: India
|
| pcelari wrote: |
| under Supress Absent Element Delimiteres, I was "End of Type", not sure what that really means |
If required it is possible to suppress the delimiters at the end of a record(complex type) for absent elements. The Suppress Absent Element Delimiter property can be set to "End of Type" to achive this.If it is set to never, delimiter suppresession will never be done.
_________________
-----------------------------------------------
It is good to remember the past,
but don't let past capture your future |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
