<?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: import-csv in VMware PowerCLI Discussions</title>
    <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309580#M82687</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I'm pretty sure you fixed the issue in the CSV by adding the useless comma.&lt;/P&gt;&lt;P&gt;As a test, remove the comma and test again.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 29 Oct 2020 12:04:34 GMT</pubDate>
    <dc:creator>LucD</dc:creator>
    <dc:date>2020-10-29T12:04:34Z</dc:date>
    <item>
      <title>import-csv</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309567#M82674</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Luc,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;i am getting very weird error .following code works fine till orange&lt;/P&gt;&lt;P&gt;however when i m trying to get vmhost to do further activities it throws error .&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;esxi1.localhost.com &lt;/P&gt;&lt;P&gt;get-vmhost : 28/10/2020 14:45:32 Get-VMHost VMHost with name &lt;/P&gt;&lt;P&gt;'esxi1.localhost.com ' was not found using the specified filter(s).&lt;/P&gt;&lt;P&gt;At line:6 char:1&lt;/P&gt;&lt;P&gt;+ get-vmhost -Name $v&lt;/P&gt;&lt;P&gt;+ ~~~~~~~~~~~~~~~~~~~&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; + CategoryInfo&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; : ObjectNotFound: (:) [Get-VMHost], VimException&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; + FullyQualifiedErrorId : Core_OutputHelper_WriteNotFoundError,VMware.VimA &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp; utomation.ViCore.Cmdlets.Commands.GetVMHost&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;SPAN style="color: #eb7a3d;"&gt;$esxis=import-csv "C:\Users\jvmishra\Desktop\fileroot.csv"&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #eb7a3d;"&gt;foreach($e in $esxis)&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #eb7a3d;"&gt;{&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #eb7a3d;"&gt;$v=$e.esxiname&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #eb7a3d;"&gt;$v&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #3a0699;"&gt;get-vmhost -Name $v&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;}&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 28 Oct 2020 14:58:45 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309567#M82674</guid>
      <dc:creator>jvm2016</dc:creator>
      <dc:date>2020-10-28T14:58:45Z</dc:date>
    </item>
    <item>
      <title>Re: import-csv</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309568#M82675</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Is there a space character after .com in your csv file? There is in the error you posted:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="Screenshot 2020-10-28 at 15.03.06.png"&gt;&lt;img src="https://communities.vmware.com/t5/image/serverpage/image-id/24149i5E22E4A2A7C338CA/image-size/large?v=v2&amp;amp;px=999" role="button" title="Screenshot 2020-10-28 at 15.03.06.png" alt="Screenshot 2020-10-28 at 15.03.06.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 28 Oct 2020 15:04:42 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309568#M82675</guid>
      <dc:creator>scott28tt</dc:creator>
      <dc:date>2020-10-28T15:04:42Z</dc:date>
    </item>
    <item>
      <title>Re: import-csv</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309569#M82676</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;There seems to be an extra space at the end of '&lt;SPAN style="color: #666666; font-family: proxima-nova, Arial, sans-serif;"&gt;esxi1.localhost.com '&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 28 Oct 2020 15:05:52 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309569#M82676</guid>
      <dc:creator>LucD</dc:creator>
      <dc:date>2020-10-28T15:05:52Z</dc:date>
    </item>
    <item>
      <title>Re: import-csv</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309570#M82677</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;not sure how it appeared .its fine if i m printing $v&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 28 Oct 2020 15:29:07 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309570#M82677</guid>
      <dc:creator>jvm2016</dc:creator>
      <dc:date>2020-10-28T15:29:07Z</dc:date>
    </item>
    <item>
      <title>Re: import-csv</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309571#M82678</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I suspect it already is there in the CSV&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 28 Oct 2020 15:31:51 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309571#M82678</guid>
      <dc:creator>LucD</dc:creator>
      <dc:date>2020-10-28T15:31:51Z</dc:date>
    </item>
    <item>
      <title>Re: import-csv</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309572#M82679</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;i dont see any space in the file .i tested one of them with get-vmhost command and it worked fine ..&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 28 Oct 2020 16:01:34 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309572#M82679</guid>
      <dc:creator>jvm2016</dc:creator>
      <dc:date>2020-10-28T16:01:34Z</dc:date>
    </item>
    <item>
      <title>Re: import-csv</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309573#M82680</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Check with the Length property if the extra blank is in there.&lt;BR /&gt;&lt;SPAN style="color: #eb7a3d; font-family: proxima-nova, Arial, sans-serif;"&gt;&lt;BR /&gt;$v.Length&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 28 Oct 2020 16:06:56 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309573#M82680</guid>
      <dc:creator>LucD</dc:creator>
      <dc:date>2020-10-28T16:06:56Z</dc:date>
    </item>
    <item>
      <title>Re: import-csv</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309574#M82681</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;its not there as i m able to use get-vmhost $v when i run individually .&lt;/P&gt;&lt;P&gt;moreover the space seems to come at the end of the fqdn dont know how it happened .&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 28 Oct 2020 16:52:14 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309574#M82681</guid>
      <dc:creator>jvm2016</dc:creator>
      <dc:date>2020-10-28T16:52:14Z</dc:date>
    </item>
    <item>
      <title>Re: import-csv</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309575#M82682</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;$v.length issame as sum of individual charecters.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 28 Oct 2020 17:02:06 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309575#M82682</guid>
      <dc:creator>jvm2016</dc:creator>
      <dc:date>2020-10-28T17:02:06Z</dc:date>
    </item>
    <item>
      <title>Re: import-csv</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309576#M82683</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I would need to see your CSV and script file (as attachments) to further analyse.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I tested this, and indeed an extra space at the end of the ESXi node name produces the same error.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 28 Oct 2020 17:04:29 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309576#M82683</guid>
      <dc:creator>LucD</dc:creator>
      <dc:date>2020-10-28T17:04:29Z</dc:date>
    </item>
    <item>
      <title>Re: import-csv</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309577#M82684</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;i put comma after each esxi name .it is working now .however i did this multiple times in past and for a single column i did not use coma and it used to work...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;esxiname&lt;/P&gt;&lt;P&gt;esxi1.script-infra.local,&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;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/P&gt;&lt;P&gt;esxi2.script-infra.local,&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;&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; &lt;/P&gt;&lt;P&gt;esxi3.script--infra.local,&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;&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; &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 28 Oct 2020 17:32:06 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309577#M82684</guid>
      <dc:creator>jvm2016</dc:creator>
      <dc:date>2020-10-28T17:32:06Z</dc:date>
    </item>
    <item>
      <title>Re: import-csv</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309578#M82685</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I'm still pretty sure there was some sort of whitespace (blank, tab ...) at the end of one or more lines in your CSV.&lt;/P&gt;&lt;P&gt;By placing the comma at the end, you have a visual confirmation that there is no trailing blank on a row.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 28 Oct 2020 17:50:19 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309578#M82685</guid>
      <dc:creator>LucD</dc:creator>
      <dc:date>2020-10-28T17:50:19Z</dc:date>
    </item>
    <item>
      <title>Re: import-csv</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309579#M82686</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;well its working now with comma ...&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 29 Oct 2020 11:35:50 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309579#M82686</guid>
      <dc:creator>jvm2016</dc:creator>
      <dc:date>2020-10-29T11:35:50Z</dc:date>
    </item>
    <item>
      <title>Re: import-csv</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309580#M82687</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I'm pretty sure you fixed the issue in the CSV by adding the useless comma.&lt;/P&gt;&lt;P&gt;As a test, remove the comma and test again.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 29 Oct 2020 12:04:34 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309580#M82687</guid>
      <dc:creator>LucD</dc:creator>
      <dc:date>2020-10-29T12:04:34Z</dc:date>
    </item>
    <item>
      <title>Re: import-csv</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309581#M82688</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;without comma i cant get the proper output .i m unable to send the .csv file due to security reasons.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 29 Oct 2020 15:03:00 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/import-csv/m-p/2309581#M82688</guid>
      <dc:creator>jvm2016</dc:creator>
      <dc:date>2020-10-29T15:03:00Z</dc:date>
    </item>
  </channel>
</rss>

