ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » how to create message set for .dat file?

Post new topic  Reply to topic
 how to create message set for .dat file? « View previous topic :: View next topic » 
Author Message
siva.kasetty
PostPosted: Mon May 26, 2008 10:02 pm    Post subject: how to create message set for .dat file? Reply with quote

Apprentice

Joined: 17 Mar 2008
Posts: 45

Hi,
i am having .dat (PS.dat) file and i have to create a messageset for that ,
how can i do it in broker.

need help.
Back to top
View user's profile Send private message
Gaya3
PostPosted: Mon May 26, 2008 10:15 pm    Post subject: Reply with quote

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US

create message set by pulling down the project menu and go ahead and do it.

There is no short cut to do so like for Cobol copy book, mxsd, c headers, WSDL, XML DTD,

Regards
gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
Back to top
View user's profile Send private message
siva.kasetty
PostPosted: Mon May 26, 2008 10:31 pm    Post subject: Reply with quote

Apprentice

Joined: 17 Mar 2008
Posts: 45

hi,
thanks for replay.

while creating messageset i am select text and created messageset but hwo to created messgedefenition file from this.
i need help on this
Back to top
View user's profile Send private message
Gaya3
PostPosted: Mon May 26, 2008 10:34 pm    Post subject: Reply with quote

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US

in message definition file, you have to specifically mention about
message structure or schema,
like message element, message type, message attributes and properties too

Get in to info center or Message model PDF for further guidence

Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
Back to top
View user's profile Send private message
kimbert
PostPosted: Tue May 27, 2008 4:25 am    Post subject: Reply with quote

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

You need to model this yourself. If you want help, you will need to post an example of the .dat file format.
Back to top
View user's profile Send private message
siva.kasetty
PostPosted: Wed May 28, 2008 4:45 am    Post subject: Reply with quote

Apprentice

Joined: 17 Mar 2008
Posts: 45

Hi,

i am copying my >dat file which is coming from peoplesoft.

TRANSACTION_CODE,SHORTNAME,EMPLID,DERIVED_EMPL_STATUS,DERIVED_EMPL_STATUS_DESCR,EFFDT,EMPL_STATUS,EMPL_STATUS_DESCR,FIRST_NAME,MIDDLE_NAME,LAST_NAME,NAME_SUFFIX,NAME_TITLE,BIRTHDATE,JOBCODE,JOBCODE_DESCR,FLSA_STATUS,LOCATION,LOCATION_DESCR,ADDRESS1,ADDRESS2,ADDRESS3,CITY,STATE,COUNTY,POSTAL,COUNTRY,DEPTID,DEPTID_DESCR,COMPANY,BUSINESS_UNIT,POSITION_NBR,POSITION_NBR_DESCR,GL_PAY_TYPE,EMPL_TYPE,SHIFT,SUPERVISORID,SUPERVISOR_SHORTNAME,UNION_SENIORITY_DT,HIRE_DT,REHIRE_DT,TERMINATION_DT,BUSINESS_PHONE,BUS_PHONE_PREF,CELL_PHONE,CELL_PHONE_PREF,FAX_PHONE,FAX_PHONE_PREF,PAGER_PHONE,PAGER_PHONE_PREF,PAGER_PIN,MAIN_PHONE,MAIN_PHONE_PREF,NETWORK_ID,BUS_EMAIL_ADDRESS,BUS_EMAIL_ADDRESS_PREF,HOME_EMAIL_ADDRESS,HOME_EMAIL_ADDRESS_PREF,HRS_CARRYOVER,HRS_EARNED_YTD
C,,123456,,,,A,,prakash,chandra,khajurgi,,Mr,06/01/1981,111111,,,855,,Citywest end,,,Newyork,NA,,01581-5039,USA,,,,,,,S,1,222222,,,,,,,,,,,,,,,,1,,,,,,,,,


how create a messageset?[/img]
Back to top
View user's profile Send private message
Gaya3
PostPosted: Wed May 28, 2008 4:57 am    Post subject: Reply with quote

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US

Which version of Broker are you using?

if it is V6.1 where you will get peoplesoft node too.

the data looks like CSV format, you can create a message set for this.

Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
Back to top
View user's profile Send private message
siva.kasetty
PostPosted: Wed May 28, 2008 5:09 am    Post subject: Reply with quote

Apprentice

Joined: 17 Mar 2008
Posts: 45

hi,
i am using MessageBrokerV6.0.
if it looks like CSV format. i need to rename file with .csv .
Back to top
View user's profile Send private message
Gaya3
PostPosted: Wed May 28, 2008 5:12 am    Post subject: Reply with quote

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US

as the data is comma separated, thats the reason i told you like that..

hope all the contents would be comma separated

Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
Back to top
View user's profile Send private message
siva.kasetty
PostPosted: Wed May 28, 2008 5:14 am    Post subject: Reply with quote

Apprentice

Joined: 17 Mar 2008
Posts: 45

ok.i will change my file .csv. and try to create the messageset and let u
know about the result.
Back to top
View user's profile Send private message
siva.kasetty
PostPosted: Wed May 28, 2008 5:33 am    Post subject: Reply with quote

Apprentice

Joined: 17 Mar 2008
Posts: 45

i changend the file to .csv , while creating message definition which one i need to select,there no option for .csv file in "messagedefination file from"

can u please help on this.
Back to top
View user's profile Send private message
Gaya3
PostPosted: Wed May 28, 2008 5:40 am    Post subject: Reply with quote

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US

use TDS format to do so. it support comma separated

Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
Back to top
View user's profile Send private message
siva.kasetty
PostPosted: Wed May 28, 2008 5:45 am    Post subject: Reply with quote

Apprentice

Joined: 17 Mar 2008
Posts: 45

yes, i am using TDS format only while creating messageset.
after that we will do message defination file from,there which one i need to select to use the .csv file
Back to top
View user's profile Send private message
yaakovd
PostPosted: Wed May 28, 2008 6:11 am    Post subject: Reply with quote

Partisan

Joined: 20 Jan 2003
Posts: 319
Location: Israel

"create from" options means using data model (xsd, cobol, c). Rename .dat to .csv will not help you at all. You cannot create message set by sample file.

You need create in manualy: Use TDS with all elements delimited.
I suggest you ask Peoplesoft team to provide xsd (otherwise you need to define all field name manually).
_________________
Best regards.
Yaakov
SWG, IBM Commerce, Israel
Back to top
View user's profile Send private message Send e-mail
kimbert
PostPosted: Wed May 28, 2008 6:56 am    Post subject: Reply with quote

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

Have you tried searching for 'CSV' in the product documentation? There is an entire sample project in the Samples Gallery dedicated to this subject.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » how to create message set for .dat file?
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.