Re: Data mapper

[Jim Langston <jimlangston@xxxxxxxxxxxxxxxx>]

An example of input would help.  Are you getting fixed length text files?
comma separated variable (CSV), tab delimited, or...

Each one requires a little different parser.  For a parser is what you are
going to have to write if you are going to do this yourself.  And since you
don't have a definite standard (since they're not doing the same thing) you'll
have to expect the unexpected.  A number they could send as;
'     12345'
'0000012345'
'12345     '
'12345'

So, your program is going to have to interpret those to a valid number.  I 
believe
the C call CTOI (Character to Integer) would handle all of those with no 
problems.
CTOF (Character to Float) would handle decimal data.

Without any more info to go on, not much I can answer.

Regards,

Jim Langston

Me transmitte sursum, Caledoni!


"Bartell, Aaron L. (TC)" wrote:
> 
> I have a project staring me down that requires me to send and receive
> documents (PO's, Shipping Acknowledgements, Order Status) from multiple
> companies.  My company currently reserves the right to have a standard for
> sending as receiving documents but I don't think that will fly.
> 
> We are using our own proprietary format to transfer the data which all of
> the companies playing adhere to, but everybody has their own idea of how and
> where the data should be put within this format.
> 
> So I need to create a data mapper of sorts that would be similar to
> Harbinger or any other EDI X.12 data mapper.  I need to do it in RPG because
> that is what I know.  Java is also another possible solution but I have only
> dabbled in java.  I am guessing that I will also need to do it in SQL so I
> don't have to hard code file and field names into my programs.
> 
> Does anyone have ideas or examples of how I could accomplish this?
> 
> Aaron Bartell
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---