Forum Discussion

Joe Fischer's avatar
Joe Fischer
Brass Contributor
Jul 17, 2018
Solved

copy an mhtml document from a local share to a SharePoint Online document library on a schedule

Hi All, I have a reporting services report that places an mhtml file on a local share.  I would like to display this on the home page of one of my sites using a web part.  Is there a way for me to ...
Document Library
files
SharePoint Online
  • spucelik's avatar
    spucelik
    Jul 17, 2018

    Joe...you're best option would be to use PowerShell and add the file to the library.  Here is a script that will help.

spucelik's avatar
spucelik
Icon for Microsoft rankMicrosoft
Jul 17, 2018

Joe...you're best option would be to use PowerShell and add the file to the library.  Here is a script that will help.

Joe Fischer's avatar
Joe Fischer
Brass Contributor
Jul 17, 2018

Thanks Steve,

This looks too easy :)

Is there a way to automate that? 

It looks like it will prompt for a password.

 

Thanks Again,

joe

  • spucelik's avatar
    spucelik
    Icon for Microsoft rankMicrosoft
    Jul 17, 2018

    Joe...use this variable to "hard" code the password to avoid the prompt:

    $Password = ConvertTo-SecureString –String "<PASSWORD>" –AsPlainText -Force

     

    You can also use the task scheduler to run the script.  here are the actions you should use when configuring the task.

     

    Program/Script:  C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe

     

    Add Arguments:  -psconsolefile "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\CONFIG\POWERSHELL\Registration\psconsole.psc1" -command "[FullPathToScript]"

    • Joe Fischer's avatar
      Joe Fischer
      Brass Contributor
      Jul 17, 2018

      Thanks Again,

      I will le you know how it goes..

       

      Joe

      • Joe Fischer's avatar
        Joe Fischer
        Brass Contributor
        Jul 18, 2018

        Thanks again Steve,

        works like a charm :)

         

        Joe

Resources