Skip to Content
0

integration framework attachment replication

Mar 26 at 08:31 PM

41

avatar image

Dear Team,

Kindly I have a question on integration framework, I made and scenario when create an item master data in database A it will be replicated automatically to database B, and when updating this item master in database A, it will be updated to database B as well,


My question is about attachment, if I put three lines attachment in item master data in database A, in the sender message shows only the first line ID "5" of this attachment only and the two other lines don't show up,

the second problem that, let's suppose the first attachment line in the database A send to database B is "5" then 5 will be replicated to DataBase B but 5 in database B in related to another attachment line in the table ATC1,


so do you have an idea how to replicate all lines of attachment?
and I just want to replicate the exact path and file not the AbsEntry in ATC1 Table.

Regards,
Mohsen

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Nicolas Fuchs
Mar 27 at 12:47 PM
0

Hi Mohsen,

in the Item Master Object you only have the reference to the object stored in "Attachments2". You need to enhance the item master sceanrio with additional data coming from "Attachements2" (Object ID=221) which contain the detailed lines of the reference code. When transfering to another DB this refrence number (=AbsoluteEntry) gets created automatically by the DI-API.

Regards, Nicolas

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Nicolas,

But can you help me please with some details for how many atoms will be added, the order of the atoms and configuration and xlst of the attachment because I got the idea but I am a little bit confused?

Regards,
Mohsen

0
Mohsen Sameh Mar 31 at 12:22 AM
0

Dear Nicolas,

I got the idea but I didn't succeed to make the schema in the transformation atom previous to b1 object atom that will insert the attachment into the receiver system, this is my XSLT i wrote but i don't know what is the problem in it Please help,
<xsl:template name="transform"></xsl:template> <xsl:template name="B1if.object.schema.">
<Attachments2
> <row>
<AbsEntry>
<xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@id='atom3']/BOM/BO/OATC/row"></xsl:value-of> </AbsEntry> </row> </Attachments2>
<Attachments2_Lines>
<xsl:for-each select="/vpf:Msg/vpf:Body/vpf:Payload[./@id='atom3']/BOM/BO/ATC1/row">
<row>
<SourcePath>
<xsl:value-of select="SourcePath"></xsl:value-of>
</SourcePath>
<FileName>
<xsl:value-of select="FileName"></xsl:value-of>
</FileName>
<FileExtension>
<xsl:value-of select="FileExtension"></xsl:value-of>
</FileExtension>
<Override>
<xsl:value-of select="Override"></xsl:value-of> </Override> </row> </xsl:for-each> </Attachments2_Lines>
</xsl:template>

Share
10 |10000 characters needed characters left characters exceeded