将Flatfile处理为xml文件 [英] Processing flatfile into xml file

问题描述

我有一个平面文件，其中包含约90行输入数据.创建的inpu xsd文件包含appid，forename，dob，surname，ENAME等元素.因此，我的平面文件如下所示.

Hi,

I have a flat file with around 90 lines of input data. the inpu xsd file created has elements like appid, forename,dob,surname, ENAME etc. So my flatfile would look like as below.

1 abc 10/11/2007 xyz
1 qbc 10/11/2007 xyz, HP
1 dbc 10/11/2007 xyz
2 hbc 10/11/2007 xyz
3 afc 10/11/2007 xyz
4 gbc 10/11/2007 xyz
4 wbc 10/11/2007 xyz

这里大约有3行具有相同的authid，因此这3条记录需要在生成的单个输出xml中作为单个记录进行分配.输出xml如下所示.

输出XML文件

here the there are around 3 lines having same authid, so these 3 records need to be dispalyed as a single record in the single output xml generated.the output xml looks as below.

OUTPUT XML FILE

<BATCH>
<HEADER>
<COUNT>1<COUNT>
</HEADER>
<CUSTOMERS>
<CUSTOMER>
<AUTHID>1</AUTHID>
<FORENAME>ABC</FORENAME>
<DOB>10/11/2007</DOB>
<LASTNAME>XYZ<LASTNAME>
<CUST_EMP>
<ENAME>HP</ENAME>
</CUST_EMP>
</CUSTOMER>
</CUSTOMERS>
</BATCH>

因此，如客户"下所示，我需要获取所有与authid 1相关的详细信息.因此，就像是主要客户一样，该客户具有工作详细信息，地址详细信息，联合客户详细信息等，这些都将基于authid进行链接.要为每个认证生成，因此它将是4个客户记录.

注意:需要检查使用/地址详细信息等，并使用源模式中的类型"字段将其映射到映射文件中的目标模式.

那么如何在biztalk服务器2004中实现呢?任何人都可以在这个问题上提供帮助/建议.

SO as shown under CUSTOMER i need to get all details displayed related to authid 1. so it is like theer is main customer who has employment details,address details,joint customer details etc which all will be linked based on the authid.CUSTOMER RECORD NEED TO BE GENERATED FOR EVERY AUTHID, SO IN THIS THEER WILL BE 4 CUSTOMER RECORDS.

Note: the employement/address details etc need to be checked and mapped to destination schema in map files using a Type field in the source schema.

So how to achieve this in biztalk server 2004? Can anyone please help/suggest on this issue.

推荐答案

1)创建平面文件架构
2)创建平面文件管道

请点击链接以了解如何设置哪些属性

http://msdn.microsoft.com/en-us/library/aa578441.aspx [ ^ ]

1) create a flatfile schema
2) Create a flatfile pipeline

Follow the link for to know exaclty what are the properties to set

http://msdn.microsoft.com/en-us/library/aa578441.aspx[^]

这篇关于将Flatfile处理为xml文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！