<?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 Re: Automatically Software Versioning in Archived Groups</title>
    <link>https://community.qlik.com/t5/Archived-Groups/Automatically-Software-Versioning/m-p/1408511#M817</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Brunello,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I make Inline tables that has the comments and then assing verion number for each line. This is an easy way to keep everything in the document, see below.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;As a further improvement to this process we have a script that creates text files with the below tables and a qlikview document that reads this. This way we can see which "changes" are and what phase (Development, Test, Production). Also we use a simple vb-script that copies a file from one environment to the next, Dev -&amp;gt; Test -&amp;gt; Production while making a rotating backup of the files that are in the target environment.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;All working very conviniently. &lt;IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /&gt;. I have attached the scripts for you to have a look at.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;QUALIFY *;&lt;/P&gt;&lt;P&gt;ChangeLog:&lt;/P&gt;&lt;P&gt;LOAD *,&lt;/P&gt;&lt;P&gt;RecNo() as Row;&lt;/P&gt;&lt;P&gt;LOAD * Inline [&lt;/P&gt;&lt;P&gt;Date;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Name;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Change&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;2016-11-21; Johan Lindell, Vimur; Moved Inventory location Id - order head to order head file&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;2016-06-09; Johan Lindell, Vimur; Added data updated functionlity&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;2016-06-09; Johan Lindell, Vimur; Added new changelog&lt;/P&gt;&lt;P&gt;] (delimiter is ';');&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Todo:&lt;/P&gt;&lt;P&gt;LOAD * Inline [&lt;/P&gt;&lt;P&gt;Date;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Name;&amp;nbsp;&amp;nbsp;&amp;nbsp; To do&lt;/P&gt;&lt;P&gt;2017-04-04; Johan Lindell, Vimur; Remove Production value current and Production value history (new fields available / used).&lt;/P&gt;&lt;P&gt;2017-04-04; Johan Lindell, Vimur; Move Season Age History / outlet write off to Season or Article table.&lt;/P&gt;&lt;P&gt;] (delimiter is ';');&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;// 2016-01-20; Johan Lindell, Vimur; Things todo...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Issues:&lt;/P&gt;&lt;P&gt;LOAD * Inline [&lt;/P&gt;&lt;P&gt;Date;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Name;&amp;nbsp;&amp;nbsp;&amp;nbsp; Issue&lt;/P&gt;&lt;P&gt;] (delimiter is ';');&lt;/P&gt;&lt;P&gt;// 2016-01-20; Johan Lindell, Vimur; Issues...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;UNQUALIFY *;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;$(Include=$(vG.SharedCustomPath)11.versioninfo.qvs);&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 09 Nov 2017 09:29:41 GMT</pubDate>
    <dc:creator>johanlindell</dc:creator>
    <dc:date>2017-11-09T09:29:41Z</dc:date>
    <item>
      <title>Automatically Software Versioning</title>
      <link>https://community.qlik.com/t5/Archived-Groups/Automatically-Software-Versioning/m-p/1408510#M816</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello experts,&lt;/P&gt;&lt;P&gt;I'm a management consultant, usually developing applications for my customers in a QDF environment and &lt;SPAN style="font-size: 10pt;"&gt;I'd like to know if there is the chance to automatically give a "version number" to a specific container; as an example, pretend I have the container "CUST1" for a customer and in that one I have the "2.DEV" container with the typical Sense folder structure. Once I'm happy with the integrations made, I'll release it to the customer and I would like to find a way to automatically give it a number (or a reference), as it was a software "build".&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;Do anyone of you have faced and solved such a situation?&lt;/P&gt;&lt;P&gt;Thank you very much!&lt;/P&gt;&lt;P&gt;Brunello&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 22 Jul 2025 17:59:49 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Archived-Groups/Automatically-Software-Versioning/m-p/1408510#M816</guid>
      <dc:creator>bmenicucci</dc:creator>
      <dc:date>2025-07-22T17:59:49Z</dc:date>
    </item>
    <item>
      <title>Re: Automatically Software Versioning</title>
      <link>https://community.qlik.com/t5/Archived-Groups/Automatically-Software-Versioning/m-p/1408511#M817</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Brunello,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I make Inline tables that has the comments and then assing verion number for each line. This is an easy way to keep everything in the document, see below.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;As a further improvement to this process we have a script that creates text files with the below tables and a qlikview document that reads this. This way we can see which "changes" are and what phase (Development, Test, Production). Also we use a simple vb-script that copies a file from one environment to the next, Dev -&amp;gt; Test -&amp;gt; Production while making a rotating backup of the files that are in the target environment.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;All working very conviniently. &lt;IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /&gt;. I have attached the scripts for you to have a look at.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;QUALIFY *;&lt;/P&gt;&lt;P&gt;ChangeLog:&lt;/P&gt;&lt;P&gt;LOAD *,&lt;/P&gt;&lt;P&gt;RecNo() as Row;&lt;/P&gt;&lt;P&gt;LOAD * Inline [&lt;/P&gt;&lt;P&gt;Date;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Name;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Change&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;2016-11-21; Johan Lindell, Vimur; Moved Inventory location Id - order head to order head file&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;2016-06-09; Johan Lindell, Vimur; Added data updated functionlity&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;2016-06-09; Johan Lindell, Vimur; Added new changelog&lt;/P&gt;&lt;P&gt;] (delimiter is ';');&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Todo:&lt;/P&gt;&lt;P&gt;LOAD * Inline [&lt;/P&gt;&lt;P&gt;Date;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Name;&amp;nbsp;&amp;nbsp;&amp;nbsp; To do&lt;/P&gt;&lt;P&gt;2017-04-04; Johan Lindell, Vimur; Remove Production value current and Production value history (new fields available / used).&lt;/P&gt;&lt;P&gt;2017-04-04; Johan Lindell, Vimur; Move Season Age History / outlet write off to Season or Article table.&lt;/P&gt;&lt;P&gt;] (delimiter is ';');&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;// 2016-01-20; Johan Lindell, Vimur; Things todo...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Issues:&lt;/P&gt;&lt;P&gt;LOAD * Inline [&lt;/P&gt;&lt;P&gt;Date;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Name;&amp;nbsp;&amp;nbsp;&amp;nbsp; Issue&lt;/P&gt;&lt;P&gt;] (delimiter is ';');&lt;/P&gt;&lt;P&gt;// 2016-01-20; Johan Lindell, Vimur; Issues...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;UNQUALIFY *;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;$(Include=$(vG.SharedCustomPath)11.versioninfo.qvs);&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 09 Nov 2017 09:29:41 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Archived-Groups/Automatically-Software-Versioning/m-p/1408511#M817</guid>
      <dc:creator>johanlindell</dc:creator>
      <dc:date>2017-11-09T09:29:41Z</dc:date>
    </item>
    <item>
      <title>Re: Automatically Software Versioning</title>
      <link>https://community.qlik.com/t5/Archived-Groups/Automatically-Software-Versioning/m-p/1408512#M818</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello Johan,&lt;/P&gt;&lt;P&gt;thanks for your time and your suggestions: very impressive and helpful! For sure I'll take something from it &lt;IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /&gt;&lt;/P&gt;&lt;P&gt;In the meantime, I set up the following workflow:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1. develop and edit scripts in VSCODE, using QDF environment&lt;/P&gt;&lt;P&gt;2. commit changes toa GIT repository from VSCODE&lt;/P&gt;&lt;P&gt;3. get a version number using git tags&lt;/P&gt;&lt;BLOCKQUOTE&gt;&lt;TABLE border="1"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD&gt;
&lt;P&gt;git describe --tags &lt;SPAN class="p"&gt;&amp;gt;&lt;/SPAN&gt;version.txt&lt;/P&gt;
&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;/BLOCKQUOTE&gt;&lt;P&gt;4. creating the following file:&lt;/P&gt;&lt;BLOCKQUOTE&gt;&lt;TABLE border="1"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD&gt;
&lt;P&gt;&lt;SPAN class="p"&gt;[&lt;/SPAN&gt;&lt;SPAN class="n"&gt;versioninfo&lt;/SPAN&gt;&lt;SPAN class="p"&gt;]&lt;/SPAN&gt;&lt;SPAN class="o"&gt;:&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN class="n"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; LOAD&lt;/SPAN&gt; &lt;SPAN class="mi"&gt;@1&lt;/SPAN&gt; &lt;SPAN class="n"&gt;AS&lt;/SPAN&gt; &lt;SPAN class="n"&gt;Value&lt;/SPAN&gt; &lt;SPAN class="n"&gt;FROM&lt;/SPAN&gt; &lt;SPAN class="p"&gt;[&lt;/SPAN&gt;&lt;SPAN class="nl"&gt;lib&lt;/SPAN&gt;&lt;SPAN class="p"&gt;:&lt;/SPAN&gt;&lt;SPAN class="c1"&gt;//MYFOLDERDEV/3.Include\6.Custom\3.Load\version.txt]&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN class="p"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; (&lt;/SPAN&gt;&lt;SPAN class="n"&gt;txt&lt;/SPAN&gt;&lt;SPAN class="p"&gt;,&lt;/SPAN&gt; &lt;SPAN class="n"&gt;codepage&lt;/SPAN&gt; &lt;SPAN class="n"&gt;is&lt;/SPAN&gt; &lt;SPAN class="mi"&gt;1252&lt;/SPAN&gt;&lt;SPAN class="p"&gt;,&lt;/SPAN&gt; &lt;SPAN class="n"&gt;no&lt;/SPAN&gt; &lt;SPAN class="n"&gt;labels&lt;/SPAN&gt;&lt;SPAN class="p"&gt;,&lt;/SPAN&gt; &lt;SPAN class="n"&gt;delimiter&lt;/SPAN&gt; &lt;SPAN class="n"&gt;is&lt;/SPAN&gt; &lt;SPAN class="sc"&gt;'\t'&lt;/SPAN&gt;&lt;SPAN class="p"&gt;,&lt;/SPAN&gt; &lt;SPAN class="n"&gt;msq&lt;/SPAN&gt;&lt;SPAN class="p"&gt;);&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN class="n"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; LET&lt;/SPAN&gt; &lt;SPAN class="n"&gt;vVersion&lt;/SPAN&gt; &lt;SPAN class="o"&gt;=&lt;/SPAN&gt; &lt;SPAN class="n"&gt;FieldValue&lt;/SPAN&gt;&lt;SPAN class="p"&gt;(&lt;/SPAN&gt;&lt;SPAN class="err"&gt;'&lt;/SPAN&gt;&lt;SPAN class="n"&gt;Value&lt;/SPAN&gt;&lt;SPAN class="err"&gt;'&lt;/SPAN&gt;&lt;SPAN class="p"&gt;,&lt;/SPAN&gt;&lt;SPAN class="mi"&gt;1&lt;/SPAN&gt;&lt;SPAN class="p"&gt;);&lt;/SPAN&gt; &lt;/P&gt;
&lt;P&gt;&lt;SPAN class="n"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; DROP&lt;/SPAN&gt;&lt;SPAN class="n"&gt;TABLE&lt;/SPAN&gt;&lt;SPAN class="p"&gt;[&lt;/SPAN&gt;&lt;SPAN class="n"&gt;versioninfo&lt;/SPAN&gt;&lt;SPAN class="p"&gt;];&lt;/SPAN&gt;&lt;/P&gt;
&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;/BLOCKQUOTE&gt;&lt;P&gt;5. push the committed changes to the PROD folder&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Perhaps not the best, however it seems to work! &lt;IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /&gt;&lt;/P&gt;&lt;P&gt;Have a nice day&lt;/P&gt;&lt;P&gt;Brunello&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 09 Nov 2017 09:49:25 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Archived-Groups/Automatically-Software-Versioning/m-p/1408512#M818</guid>
      <dc:creator>bmenicucci</dc:creator>
      <dc:date>2017-11-09T09:49:25Z</dc:date>
    </item>
  </channel>
</rss>

