B1IF FileWatcher ?

[Former Member]

Hi All,

I want to make a filewatcher with B1IF can someone give me some tips how to do this. The generate of a file out of SAP B1 is easy but how do I read the file from a local folder (C:\TEMP\In\) transform it (convert to the correct format) and push it into a B1Object atom  to create a new business partner ?

Please help ?

Regards Brenden.

[Former Member · Accepted solution]

Hi All,

I finally found a solution....

The code to use in your XSL Transformation is supposed to look like this

<xsl:for-each select="/vpf:Msg/vpf:Body/vpf:Payload[./@id='atom6']/bfa:io/bfa:row">

<xsl:value-of select="./bfa:col[1]"/>

</xsl:for-each>

atom6 is my GetFile atom.

Regards, Brenden

[former_member201110]

Hi Brenden,

You've posted this query on the SDK development forum. B1if is not really part of the SDK and you should have better luck getting a response from someone familiar with B1if on the integration forum:

http://scn.sap.com/community/business-one-integration-technology

I remember seeing a video where someone was demonstrating how to import data from a flat file to SBO using B1if. You could also try searching YouTube for B1if videos as a lot of the demos and training material can be found there.

Sorry I couldn't be more help.

Kind Regards,

Owen

[Former Member]

Hi Owen,

Thank you very much for your input I will try You Tube thanks.

Regards Brenden.

[Former Member]

Hi All,

How do I get the Value in the stored text file to my B1Object

See attached image, it is the unbranch returned xml.

Regards, Brenden

[Former Member]

Hi All,

I managed to pick up the file and read/store the data, but now I have to use a XSL transformation atom to pass the correct values from the file to the B1Object.

Has anyone tried this before ?