<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Bloomberg Request File in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/Bloomberg-Request-File/m-p/2229151#M20185</link>
    <description>Hi - I wonder if someone can help me... 
&lt;BR /&gt;I'm trying to create a text file that is used to request data from Bloomberg's per-security product. The file is a simple text file with a number of sections: 
&lt;BR /&gt;There are 3 sections - like this: 
&lt;BR /&gt;START-OF-FILE 
&lt;BR /&gt;&amp;lt;File Header&amp;gt; 
&lt;BR /&gt;&amp;lt;List of Fields&amp;gt; 
&lt;BR /&gt;&amp;lt;List of Securities&amp;gt; 
&lt;BR /&gt;END-OF-FILE 
&lt;BR /&gt;each section has a number of rows: 
&lt;BR /&gt;The &amp;lt;File Header&amp;gt; contains specific keys &amp;amp; values - mostly to be read from contrexts or alternatively hard-coded 
&lt;BR /&gt;The &amp;lt;List of Fields&amp;gt; and &amp;lt;List of Securities&amp;gt; can fairly simply be read from a file 
&lt;BR /&gt;I think I need to use tFileOutputMSDelimited but there is no example in the help file of the version of TOS. 
&lt;BR /&gt;Is tFileOutputMSDelimited the best component? 
&lt;BR /&gt;And if so, does someone have an example? 
&lt;BR /&gt;Any help would be much appreciated 
&lt;BR /&gt;Many thanks 
&lt;BR /&gt;Max 
&lt;BR /&gt;This is a sample file from the user manual 
&lt;BR /&gt;START-OF-FILE 
&lt;BR /&gt;SYSTEM=DATA 
&lt;BR /&gt;LOGIN=JDOE 
&lt;BR /&gt;USERNUMBER=111111 
&lt;BR /&gt;REPLYFILENAME=Sample3.txt 
&lt;BR /&gt;PROGRAMNAME=getdata 
&lt;BR /&gt;PROGRAMFLAG =oneshot 
&lt;BR /&gt;SECMASTER=yes 
&lt;BR /&gt;SN=777777 
&lt;BR /&gt;WS=0 
&lt;BR /&gt;LAUNCH=YES 
&lt;BR /&gt;OUTPUTFORMAT=fixed 
&lt;BR /&gt;SECDESLENGTH=12 
&lt;BR /&gt;DELIMITER=; 
&lt;BR /&gt;START-OF-FIELDS 
&lt;BR /&gt;NAME 
&lt;BR /&gt;NAME|16 
&lt;BR /&gt;PX_LAST 
&lt;BR /&gt;PX_LAST|14|4|c 
&lt;BR /&gt;PX_LAST||8 
&lt;BR /&gt;PX_LAST|||c 
&lt;BR /&gt;END-OF-FIELDS 
&lt;BR /&gt;START-OF-DATA 
&lt;BR /&gt;IBM US Equity|| 
&lt;BR /&gt;END-OF-DATA 
&lt;BR /&gt;END-OF-FILE</description>
    <pubDate>Sat, 16 Nov 2024 13:18:24 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2024-11-16T13:18:24Z</dc:date>
    <item>
      <title>Bloomberg Request File</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Bloomberg-Request-File/m-p/2229151#M20185</link>
      <description>Hi - I wonder if someone can help me... 
&lt;BR /&gt;I'm trying to create a text file that is used to request data from Bloomberg's per-security product. The file is a simple text file with a number of sections: 
&lt;BR /&gt;There are 3 sections - like this: 
&lt;BR /&gt;START-OF-FILE 
&lt;BR /&gt;&amp;lt;File Header&amp;gt; 
&lt;BR /&gt;&amp;lt;List of Fields&amp;gt; 
&lt;BR /&gt;&amp;lt;List of Securities&amp;gt; 
&lt;BR /&gt;END-OF-FILE 
&lt;BR /&gt;each section has a number of rows: 
&lt;BR /&gt;The &amp;lt;File Header&amp;gt; contains specific keys &amp;amp; values - mostly to be read from contrexts or alternatively hard-coded 
&lt;BR /&gt;The &amp;lt;List of Fields&amp;gt; and &amp;lt;List of Securities&amp;gt; can fairly simply be read from a file 
&lt;BR /&gt;I think I need to use tFileOutputMSDelimited but there is no example in the help file of the version of TOS. 
&lt;BR /&gt;Is tFileOutputMSDelimited the best component? 
&lt;BR /&gt;And if so, does someone have an example? 
&lt;BR /&gt;Any help would be much appreciated 
&lt;BR /&gt;Many thanks 
&lt;BR /&gt;Max 
&lt;BR /&gt;This is a sample file from the user manual 
&lt;BR /&gt;START-OF-FILE 
&lt;BR /&gt;SYSTEM=DATA 
&lt;BR /&gt;LOGIN=JDOE 
&lt;BR /&gt;USERNUMBER=111111 
&lt;BR /&gt;REPLYFILENAME=Sample3.txt 
&lt;BR /&gt;PROGRAMNAME=getdata 
&lt;BR /&gt;PROGRAMFLAG =oneshot 
&lt;BR /&gt;SECMASTER=yes 
&lt;BR /&gt;SN=777777 
&lt;BR /&gt;WS=0 
&lt;BR /&gt;LAUNCH=YES 
&lt;BR /&gt;OUTPUTFORMAT=fixed 
&lt;BR /&gt;SECDESLENGTH=12 
&lt;BR /&gt;DELIMITER=; 
&lt;BR /&gt;START-OF-FIELDS 
&lt;BR /&gt;NAME 
&lt;BR /&gt;NAME|16 
&lt;BR /&gt;PX_LAST 
&lt;BR /&gt;PX_LAST|14|4|c 
&lt;BR /&gt;PX_LAST||8 
&lt;BR /&gt;PX_LAST|||c 
&lt;BR /&gt;END-OF-FIELDS 
&lt;BR /&gt;START-OF-DATA 
&lt;BR /&gt;IBM US Equity|| 
&lt;BR /&gt;END-OF-DATA 
&lt;BR /&gt;END-OF-FILE</description>
      <pubDate>Sat, 16 Nov 2024 13:18:24 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Bloomberg-Request-File/m-p/2229151#M20185</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2024-11-16T13:18:24Z</dc:date>
    </item>
  </channel>
</rss>

