<?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 Utility - File Management - Get Files in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Utility-File-Management-Get-Files/m-p/79219#M31127</link>
    <description>When I use the subject object to get a list of files, it is capturing a temp file in the folder.&amp;nbsp; How do I stop this?&amp;nbsp; When the process runs, I'm getting the error "Excel cannot open the file '~$2018-04 44310000.xlsx' because the file format or file extension is not valid".&amp;nbsp; I am running the process for May, so it is opening April, updating, and saving as new month.&amp;nbsp; Many steps later (plenty of time for temp of 04 to go away), the file list is being retrieved with the utility.&amp;nbsp; When I do it manually, the temp file disappears immediately after the "save as" new month file.</description>
    <pubDate>Wed, 27 Jun 2018 21:53:00 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2018-06-27T21:53:00Z</dc:date>
    <item>
      <title>Utility - File Management - Get Files</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Utility-File-Management-Get-Files/m-p/79219#M31127</link>
      <description>When I use the subject object to get a list of files, it is capturing a temp file in the folder.&amp;nbsp; How do I stop this?&amp;nbsp; When the process runs, I'm getting the error "Excel cannot open the file '~$2018-04 44310000.xlsx' because the file format or file extension is not valid".&amp;nbsp; I am running the process for May, so it is opening April, updating, and saving as new month.&amp;nbsp; Many steps later (plenty of time for temp of 04 to go away), the file list is being retrieved with the utility.&amp;nbsp; When I do it manually, the temp file disappears immediately after the "save as" new month file.</description>
      <pubDate>Wed, 27 Jun 2018 21:53:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Utility-File-Management-Get-Files/m-p/79219#M31127</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-06-27T21:53:00Z</dc:date>
    </item>
    <item>
      <title>Hello, kimlundquist
There…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Utility-File-Management-Get-Files/m-p/79220#M31128</link>
      <description>Hello, kimlundquist
There are 2 things that I think would be useful for you.&amp;nbsp;
1) If no one else is operating in the same folder as your robot, try close all the excel first before you use the get files utility.
&amp;nbsp;&amp;nbsp;&amp;nbsp; This should&amp;nbsp;eliminate the risk of&amp;nbsp;getting&amp;nbsp;the temp files.
2) If the temp file was created because someone else is updating it,&amp;nbsp;then you could&amp;nbsp;add a decision&amp;nbsp;stage to avoid opening file with&amp;nbsp;""~$"" in it or use loop to eliminate files name that&amp;nbsp;have&amp;nbsp; ""~$"" in it first then use the file collection.
I hope this work for you.
&amp;nbsp;
Regards,
Met Vonghiran</description>
      <pubDate>Thu, 28 Jun 2018 05:26:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Utility-File-Management-Get-Files/m-p/79220#M31128</guid>
      <dc:creator>MetVonghiran</dc:creator>
      <dc:date>2018-06-28T05:26:00Z</dc:date>
    </item>
  </channel>
</rss>

