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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.