Skip to Content
0
Jun 29, 2016 at 11:59 PM

Define Delimiter for FTP Upload in CSV

121 Views

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

Attachments

screen1.png (46.3 kB)