| Author |
Message
|
| sivakumar_patni |
 Posted: Tue Jan 11, 2011 12:56 am Post subject: Please IDentify the message format |
 |
|
Newbie
Joined: 11 Jan 2011
Posts: 6
|
Field Logical Name Starting Position Length Value Mandatory
Header
Record Type n/a 1 5 1HDR: Y
Header Filler 1 n/a 6 1 space Y
Header Date n/a 7 8 System date, in mm/dd/yy format Y
Header Filler 2 n/a 15 1 space Y
Header Time n/a 16 10 System time, in hh:mm:ssnn format Y
Header Filler 2 n/a 26 378 spaces Y
Detail
Record Type n/a 1 1 2 Y
Customer Name 2 60 Y
Headquarters Address Line 1 62 60 Y
Headquarters City 122 20 Y
Headquarters State 142 2 Y
Headquarters Zip 144 11 Y
Executive Correspondent Name 155 60 Y
Experience Number 215 7 Y
Customer Number 222 10 Y
Division Filler 232 4 Y
CDF Coverage ID 236 8 Y
CDF Coverage Name 244 60 Y
Coverage Effective Date 304 10 Y
Tracking Number Filler 314 30 Y
Date Mailed Filler 344 10 Y
Date Acknowledged Filler 354 10 Y
Disclosure Status 364 2 Y
Detail Filler n/a 366 35 spaces Y
Footer
Record Type n/a 1 5 3TLR: Y
Trailer Filler 1 n/a 6 1 space Y
Trailer Date n/a 7 8 System date, in mm/dd/yy format Y
Trailer Filler 2 n/a 15 1 space Y
Trailer Time n/a 16 10 System time, in hh:mm:ssnn format Y
Trailer Filler 3 n/a 26 1 space Y
Record Count n/a 27 9 Total number of Detail records. Y
[/img][/list][/list] |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Tue Jan 11, 2011 2:00 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
What do you think it is and why?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Jan 11, 2011 2:45 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| What's my prize if I guess right? |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue Jan 11, 2011 3:00 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| mqjeff wrote: |
| What's my prize if I guess right? |
To stand on the 'naughty step' for an hour? 
I was really asking the OP as you no doubt guessed.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Jan 11, 2011 3:19 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| smdavies99 wrote: |
| I was really asking the OP as you no doubt guessed. |
So was I.  |
|
| Back to top |
|
|
| sivakumar_patni |
| Posted: Tue Jan 11, 2011 11:19 pm Post subject: I am giving a sample also.please see it and atleast guide me |
|
|
Newbie
Joined: 11 Jan 2011
Posts: 6
|
1HDR: 05/06/10 10:09:5000
2Accenture LLP 233 N. Michigan Ave Suite 1100 Chicago IL60601 Peter Zackrison 143438 105819 24 CRITICAL ILLNESS 09/01/201071179898648840217455 05/03/201005/05/201001
2Accenture LLP 233 N. Michigan Ave Suite 1100 Chicago IL60601 Peter Zackrison 143444 105819 24 CRITICAL ILLNESS 09/01/201071179898648840217455 05/03/201005/05/201001
2Eye Surgeons of Richmond, Inc. d/b/ 400 Westham Station Road Richmond VA23226-332 Chris Turpin 145017 145017 2 BASIC LIFE 06/01/201071179898648840217479 05/03/201005/05/201001
3TLR: 05/06/10 10:09:5000 000000021 |
|
| Back to top |
|
|
| sivakumar_patni |
| Posted: Tue Jan 11, 2011 11:21 pm Post subject: hi |
|
|
Newbie
Joined: 11 Jan 2011
Posts: 6
|
| in the above one only one header and 4messages and one footer.i dont know how to convert this into CDF. if anyone do have idea on this please assist me. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Wed Jan 12, 2011 12:13 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Please use code tags for things like this. It really does make it a lot easier to read.
| Code: |
1HDR: 05/06/10 10:09:5000
2Accenture LLP 233 N. Michigan Ave Suite 1100 Chicago IL60601 Peter Zackrison 143438 105819 24 CRITICAL ILLNESS 09/01/201071179898648840217455 05/03/201005/05/201001
2Accenture LLP 233 N. Michigan Ave Suite 1100 Chicago IL60601 Peter Zackrison 143444 105819 24 CRITICAL ILLNESS 09/01/201071179898648840217455 05/03/201005/05/201001
2Eye Surgeons of Richmond, Inc. d/b/ 400 Westham Station Road Richmond VA23226-332 Chris Turpin 145017 145017 2 BASIC LIFE 06/01/201071179898648840217479 05/03/201005/05/201001
3TLR: 05/06/10 10:09:5000 000000021
|
CDF? What do you mean by CDF?
PDF, CWF or what?
As I see it, you have a flat file that has no readily identifiable delimiters. How was this data produced?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| fatherjack |
| Posted: Wed Jan 12, 2011 1:01 am Post subject: Re: Please IDentify the message format |
|
|
Knight
Joined: 14 Apr 2010
Posts: 522
Location: Craggy Island
|
And the sample file you've provided doesn't match the record layout in your original post.
_________________
Never let the facts get in the way of a good theory. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jan 12, 2011 1:29 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
|
| Back to top |
|
|
| sivakumar_patni |
| Posted: Wed Jan 12, 2011 2:03 am Post subject: hi |
|
|
Newbie
Joined: 11 Jan 2011
Posts: 6
|
ok. I have given the sample which relates to that main structure.it is a fixed length format.
CDF Format:
Self-describing data format for the storage and manipulation of scalar and multidimensional data in a platform- and discipline-independent fashion
Scientific data management package (known as the "CDF Library") which allows programmers and application developers to manage and manipulate scalar, vector, and multi-dimensional data arrays |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jan 12, 2011 2:15 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| That's a very odd definition of "self-describing" where you have a separate document that tells you how to interpret the fields in the actual data. |
|
| Back to top |
|
|
| sivakumar_patni |
| Posted: Wed Jan 12, 2011 2:22 am Post subject: hi |
|
|
Newbie
Joined: 11 Jan 2011
Posts: 6
|
Field LogicalName Starting Position Length Value Mandatory
Record Type n/a 1 5 1HDR: Y
THink the above are in table and the field are given below but |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jan 12, 2011 2:29 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Sure.
But it's not in the actual DATA you receive, is it?
It's not like it lists the table and then lists the data?
XML is self-describing, in that every single piece of data is marked with a name - and you can parse it without knowing anything at all about the contents.
This appears to require that you create a model of what the data is expected to be, and then use the model to parse the document.
Welcome to Broker. This is day 2 of the training class. Good luck, happy reading, and please remember to READ, THINK, TRY, READ, THINK, TRY and *then* Post here for help. |
|
| Back to top |
|
|
| fatherjack |
| Posted: Wed Jan 12, 2011 2:40 am Post subject: Re: hi |
|
|
Knight
Joined: 14 Apr 2010
Posts: 522
Location: Craggy Island
|
| sivakumar_patni wrote: |
| i dont know how to convert this into CDF. if anyone do have idea on this please assist me. |
http://cdf.gsfc.contact admin.gov
_________________
Never let the facts get in the way of a good theory. |
|
| Back to top |
|
|
|
|
