on 06-30-2016 12:59 AM
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='atom1']"></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
Could you please inform us if this issue is resolved? we are using b1if v2.
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
8 | |
6 | |
6 | |
5 | |
4 | |
2 | |
2 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.