<?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: Problem executing a powershell script on the talend administration center in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/Problem-executing-a-powershell-script-on-the-talend/m-p/2318638#M143759</link>
    <description>&lt;P&gt;Hello &lt;/P&gt;&lt;P&gt;The job execution successfully finished? Open the execution log and check the status, if fails, check any useful information on there. The user who launches the Job Server should the rights to access network drive and the excel files. &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards&lt;/P&gt;&lt;P&gt;Shong&lt;/P&gt;</description>
    <pubDate>Fri, 13 May 2022 03:37:30 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2022-05-13T03:37:30Z</dc:date>
    <item>
      <title>Problem executing a powershell script on the talend administration center</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Problem-executing-a-powershell-script-on-the-talend/m-p/2318637#M143758</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I need help on a issue with the talend administration center.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I created a powershell script that updates excel files on a network drive. Updates are mainly conditional formatting and header formatting.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;In my Job Talend, I just have a TSystem with the command : "powershell ////server//script/script.ps1".&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I deployed the Job on the Talend administration center and i execute it.&lt;/P&gt;&lt;P&gt;The script starts, opens the excel files but does nothing and the excel files are not modified. In the Task Manager, i see the excel files open and close very quickly.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If i start the job from IDE Talend or even just by double clicking on the powershell script, the excel files are modified and saved.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The user who launch the powershell script on the talend administration center has all rights on the network drive.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thank you beforehand for your answers.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;</description>
      <pubDate>Fri, 15 Nov 2024 22:55:33 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Problem-executing-a-powershell-script-on-the-talend/m-p/2318637#M143758</guid>
      <dc:creator>CGUERIF1652348112</dc:creator>
      <dc:date>2024-11-15T22:55:33Z</dc:date>
    </item>
    <item>
      <title>Re: Problem executing a powershell script on the talend administration center</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Problem-executing-a-powershell-script-on-the-talend/m-p/2318638#M143759</link>
      <description>&lt;P&gt;Hello &lt;/P&gt;&lt;P&gt;The job execution successfully finished? Open the execution log and check the status, if fails, check any useful information on there. The user who launches the Job Server should the rights to access network drive and the excel files. &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards&lt;/P&gt;&lt;P&gt;Shong&lt;/P&gt;</description>
      <pubDate>Fri, 13 May 2022 03:37:30 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Problem-executing-a-powershell-script-on-the-talend/m-p/2318638#M143759</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2022-05-13T03:37:30Z</dc:date>
    </item>
  </channel>
</rss>

