BizTalk Server General - Flat files mapping problem

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > November 2004 > Flat files mapping problem





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Flat files mapping problem
morgana@nospam.amerinetcentral.org

2004-11-05, 5:48 pm

I'm convering maps from biztalk 2002 to biztalk 2004.

These maps convert a flat positional file into an xml file, among
other things. Some fields in the flat file ar filled with spaces. BT
2002 handled these fields by mapping them to a blank attribute, but
the attribute was there. In BT2004 It does nothing, and that records
is missing the attribute completly.


This example is just an small sample of the flat file, and the xml
record.

Input file
41254 1

the format is
areacode 3 charaters
county 2 characters
state 2 characters
amd type 1 character

This is what I would get in BT2002:
AREA_CODE="412" ORG_CNTY="54" STATE="" AMD_TYPE="1"

In BT2004:
AREA_CODE="412" ORG_CNTY="54" AMD_TYPE="1"

if you notice the state field is missing in the BT2004 record

Has anybody run into this, and is there a way around it, besides
putting funtoids everywhere.

Thanks
Tan Bao Nguyen

2004-11-09, 8:46 pm

My understanding is you will need to add some functoids to deal with the
spaces for the STATE field. Use a combination of logical functoids and a
value mapping functoids.

Could you send your BTS2002 map?

Regards,
Tan Nguyen
Microsoft BizTalk Server

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------[vbcol=seagreen]
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08
phx.gbl!TK2MSFTNGP11.phx.gbl[vbcol=seagreen]

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com