cancel
Showing results for 
Search instead for 
Did you mean: 

Define Delimiter for FTP Upload in CSV

mike_taylor3
Contributor
0 Kudos

Hello,

I've successfully run an SQL query and output it to a local CSV file and it works perfectly.

I now want to upload the same file in the exact same format to an FTP location.  I have the FTP location working fine, it creates the file with the same data and format EXCEPT it switches the delimiter to a semi-colon.  I have read this is the default of the system but I don't know how to change it.

My FTP atom setup:

You can see it's set to .CSV and my output file is .CSV.  My original code for the source atom is:


    <xsl:template name="transformDSV">

        <xsl:attribute name="deli">,</xsl:attribute>

        <xsl:variable name="sqlResults" select="/vpf:Msg/vpf:Body/vpf:Payload[./@id=&apos;atom1&apos;]"></xsl:variable>

        <bfa:io>

            <bfa:row>

                <bfa:col>Supplier ID</bfa:col>

                <bfa:col>Item Number</bfa:col>

                <bfa:col>Qty On Hand</bfa:col>

                <bfa:col>Qty Backordered</bfa:col>

                <bfa:col>Qty On Order</bfa:col>

                <bfa:col>Item Next Availability</bfa:col>

                <bfa:col>Item Discontinued</bfa:col>

                <bfa:col>Item Description</bfa:col>

            </bfa:row>

            <xsl:for-each select="$sqlResults/jdbc:ResultSet/jdbc:Row">

                <bfa:row>

                    <bfa:col>

                        <xsl:value-of select="jdbc:SuppID"></xsl:value-of>

                    </bfa:col>

                    <bfa:col>

                        <xsl:value-of select="jdbc:ItemCode"></xsl:value-of>

                    </bfa:col>

                    <bfa:col>

                        <xsl:value-of select="jdbc:QtyOnHand"></xsl:value-of>

                    </bfa:col>

                    <bfa:col>

                        <xsl:value-of select="jdbc:QtyBackordered"></xsl:value-of>

                    </bfa:col>

                    <bfa:col>

                        <xsl:value-of select="jdbc:QtyOnOrder"></xsl:value-of>

                    </bfa:col>

                    <bfa:col>

                        <xsl:value-of select="jdbc:ItemNextAvail"></xsl:value-of>

                    </bfa:col>

                    <bfa:col>

                        <xsl:value-of select="jdbc:ItemDisc"></xsl:value-of>

                    </bfa:col>

                    <bfa:col>

                        <xsl:value-of select="jdbc:ItemName"></xsl:value-of>

                    </bfa:col>

                </bfa:row>

            </xsl:for-each>

        </bfa:io>

    </xsl:template>

You can see my delimiter set at the top.  Is there somewhere else I need to set the delimiter?

I can't see much documentation in the B1i help about the bfa structure.

Thanks for your help!

Mike

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member797538
Discoverer
0 Kudos

Could you please inform us if this issue is resolved? we are using b1if v2.

thanks

bastian_schaefer
Active Contributor
0 Kudos

Hi Mike,

FTP Out  atom does not support an attribute for delimiter at the moment (framework version 1.22.5).

Therefore it's not documented, there is no way to set a delimiter using the FTP atom at the moment.

Please use a workaround and generate your file with delimiters using the storefile atom and upload it via a ftp tool.

best regards

Bastian

P.S.: SAP is planning to introduce the attribute for delimiter in FTP out atom in in of the following patches.