[AccessD] OT: Interfacing => Datamodel

You may want to investigate BizTalk to assist you in this.

> -----Original Message-----
> From: S D [mailto:accessd667 at yahoo.com]
> Sent: Tuesday, March 16, 2004 10:51 PM
> To: accessd
> Subject: [AccessD] OT: Interfacing => Datamodel
> 
> 
> Hi group,
>  
> I need some info regarding interfacing (messages between 2 
> parties) not interfaces in VB , C++, etc.!! Could you please 
> comment on this:
>  
> Process:
> We receive and send interfaces (textfiles) with a specific 
> layout. There are about 100 types of different messages. 
> About 50 incoming and 50 outgoing.
>  
> I've build a datamodel like this:
> Importing files:
> 1 table stores the data of the incoming file: (tblRawData)
> Fields:
> ID
> FileName
> MessageID (wich type of message is it?)
> MessageData
> Date
> Time
>  
> 1 table has lay-out information regarding all messages: 
> (tblMessageLayout) 
> MessageID (Message Type)
> FieldName (different data fields)
> StartPosition (at what position is the data for the field stored)
> EndPosition (at what position is the data for the field stored)
> Mandatory (Is this a mandatory field?)
>  
> 1 table with the layout as stored in the table above for 
> every Message Type. (tblMessageX)
> To store the data of the interface file. I would have 100 of 
> these tables
>  
> Example:
> MessageType 10 has the following fields:
> Field    StartPosition  EndPosition  Mandatory  | Example data
> ID        1                   8                  YES          
> | 12345678
> CustID  9                  15                 YES          | 100235
> Street   16                 35                 NO           | 
> KennedyLane 
> Housenr 36                38                 NO           | 15
> etc
> etc
>  
> The interface could look like this:
> 12345678100235KennedyLane15
> 12345677100266St.Anna        6
> 12345645100322blablabla       10
>  
> I want to store every line in the table tblRawData. After 
> that I use the tblMessageLayout to export the data in 
> tblRawData to tblMessage10
> The table tblMessageLayout has (for Message 10) the following data:
>  
> MessageID FieldName    StartPosition  EndPosition  Mandatory 
> 10              ID                1                   8       
>            Y
> 10              CustID         9                   15         
>         Y
> 10              Street          16                 35         
>         N
> etc
>  
>  
> Could this approach work? What didn't I think of? What are 
> known traps for interfacing?
>  
> TIA
> 
> Sander
> 
> Do you Yahoo!?
> Yahoo! Mail - More reliable, more storage, less spam
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 





***********************************************************************************
17/3/2004
This transmittal may contain confidential information intended solely for
the addressee. If you are not the intended recipient, you are hereby
notified that you have received this transmittal in error; any review,
dissemination, distribution or copying of this transmittal is strictly
prohibited. If you have received this communication in error, please notify
us immediately by reply or by telephone (collect at 907-564-1000) and ask to
speak with the message sender. In addition, please immediately delete this
message and all attachments. Thank you. ACS