| Author |
Message
|
| pradha |
 Posted: Mon May 26, 2008 9:34 pm Post subject: Problem with csv file with JText adapter |
 |
|
Newbie
Joined: 10 Feb 2008
Posts: 7
|
I have an issue regarding passing csv file as input to an adapter. While giving a csv file as input I have found solution to convert it to BO's but in csv file first message will be the field names. I don't want it to be passed.I want the message to be passed from second one ignoring the first message which will be the data. I need to handle this in the message set before it is mapped. Can any one help me on this issue. I'm using TDS format message set.
Thanks in advance.
[admin]edit of subject ... was Hi[/admin] |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Mon May 26, 2008 10:04 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
atleast keep some good subject.....really bad...
not even provided good information too
Which adapter you are using?
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| pradha |
| Posted: Mon May 26, 2008 10:11 pm Post subject: Ignore first message in a csv file |
|
|
Newbie
Joined: 10 Feb 2008
Posts: 7
|
| Thanks for your kind reply. And I'm using JTEXT adapter. I think I'm clear in my subject. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Mon May 26, 2008 10:28 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
you should create a BO,message set and output message set for the same.
later you can map accordingly, its easy to do so.
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| pradha |
| Posted: Mon May 26, 2008 10:39 pm Post subject: Ignoring first message in a csv file |
|
|
Newbie
Joined: 10 Feb 2008
Posts: 7
|
FYI I have a flow, source and target message set. My source is tds and target is xml. I pass csv file as input. I have configured EndBODelimiter as EOL and Data Processingmode as Text which helps me to convert the incoming message to business objects irrespective of their numbers. My sample csv message will look like
Fund ID,Fund Name,Office Loc
o4041, xxxx , yyyyyy
42425,aaaaa,bbbbbbb
Here in the sample my exact message will be from the second one where first clearly tells the field name.Here my adapter converts even the first message as BO and pass it as input to my flow. I think I provided you enough info on my issue to help me better. |
|
| Back to top |
|
|
| kimbert |
| Posted: Tue May 27, 2008 4:47 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| Quote: |
| I think I'm clear in my subject. |
We don't. 'Hi' is not a very useful subject line!
| Quote: |
| I want the message to be passed from second one ignoring the first message which will be the data |
Should be simple enough. Just add a structure 'FieldNames' at the start of your message definition to consume the first line.
If you want more help than that, you will need to describe your message definition, and include details of all TDS properties. |
|
| Back to top |
|
|
|
|
