• Script access to MS OneDrive

    From Grimble@2:250/1 to All on Sat Oct 5 17:29:03 2019
    As part of my activities for my charity (National Coastwatch Lyme Bay - contributions welcome!) I am required by GDPR to keep sensitive files in Microsoft's Cloud, but prefer to manipulate them (Word and Excel)
    locally because the web versions of these are not as powerful as their
    local equivalents, to which I have access.
    I want to write a couple of scripts to download certain files from
    OneDrive then move them back after processing. Can anyone recommend an
    add-in to do this? - clearly I don't want a sync-ing solution.
    TIA
    --
    Grimble
    Registered Linux User #450547
    Machine 'Handel' running Plasma 5.15.4 on 5.2.16-desktop-2.mga7 kernel.
    Mageia release 7 (Official) for x86_64

    --- MBSE BBS v1.0.7.12A (GNU/Linux-x86_64)
    * Origin: A noiseless patient Spider (2:250/1@fidonet)
  • From William Unruh@2:250/1 to All on Sun Oct 6 01:29:11 2019
    On 2019-10-05, Grimble <grimble@nomail.afraid.org> wrote:
    As part of my activities for my charity (National Coastwatch Lyme Bay - contributions welcome!) I am required by GDPR to keep sensitive files in Microsoft's Cloud, but prefer to manipulate them (Word and Excel)

    Why this requirement? So that any hacker can download and read the
    filesi:-? Or what is the rational?

    locally because the web versions of these are not as powerful as their
    local equivalents, to which I have access.
    I want to write a couple of scripts to download certain files from
    OneDrive then move them back after processing. Can anyone recommend an add-in to do this? - clearly I don't want a sync-ing solution.
    TIA

    --- MBSE BBS v1.0.7.12A (GNU/Linux-x86_64)
    * Origin: A noiseless patient Spider (2:250/1@fidonet)
  • From Doug Laidlaw@2:250/1 to All on Sun Oct 6 09:44:30 2019
    On 6/10/19 11:29 am, William Unruh wrote:
    On 2019-10-05, Grimble <grimble@nomail.afraid.org> wrote:
    As part of my activities for my charity (National Coastwatch Lyme Bay -
    contributions welcome!) I am required by GDPR to keep sensitive files in
    Microsoft's Cloud, but prefer to manipulate them (Word and Excel)

    Why this requirement? So that any hacker can download and read the
    filesi:-? Or what is the rationale?

    locally because the web versions of these are not as powerful as their
    local equivalents, to which I have access.
    I want to write a couple of scripts to download certain files from
    OneDrive then move them back after processing. Can anyone recommend an
    add-in to do this? - clearly I don't want a sync-ing solution.
    TIA

    Can you put them in Google Drive, then use Google Docs to edit them?

    Probably, you need to ask this on a Windows forum, write a script that
    Windows understands, and make its target your Linux copy. Any app such
    as wget can download the files. You will need to deal with the
    different permissions, and presumably the format will have to suit other members who don't have Linux. Windows offered me to put my files in One Drive. When I did that, the files were unwritable, and any local copies
    were unwritable as well.

    For something this complicated, I would do everything in one OS, which
    would have to be Windows, maybe running in Virtualbox.

    HTH,

    Doug.

    --- MBSE BBS v1.0.7.12A (GNU/Linux-x86_64)
    * Origin: Aioe.org NNTP Server (2:250/1@fidonet)
  • From Grimble@2:250/1 to All on Sun Oct 6 15:42:09 2019
    On 05/10/2019 17:29, Grimble wrote:
    As part of my activities for my charity (National Coastwatch Lyme Bay - contributions welcome!) I am required by GDPR to keep sensitive files in Microsoft's Cloud, but prefer to manipulate them (Word and Excel)
    locally because the web versions of these are not as powerful as their
    local equivalents, to which I have access.
    I want to write a couple of scripts to download certain files from
    OneDrive then move them back after processing. Can anyone recommend an add-in to do this? - clearly I don't want a sync-ing solution.
    TIA
    A bit more background: National Coastwatch Institution is a national
    charity with a headquarters, 54 operations stations and other
    hierarchical groups. HQ has decided to use Office 365 accross the patch
    and adminstrators like me are not (supposed/allowed) to keep personnel/financial details on our private PCs. If I can mount the
    OneCloud top level directory in my file system, I can use scripts to
    download specific files as temporary copies, manipulate them and
    upload/move them back.

    --
    Grimble
    Registered Linux User #450547
    Machine 'Handel' running Plasma 5.15.4 on 5.2.16-desktop-2.mga7 kernel.
    Mageia release 7 (Official) for x86_64

    --- MBSE BBS v1.0.7.12A (GNU/Linux-x86_64)
    * Origin: A noiseless patient Spider (2:250/1@fidonet)
  • From Doug Laidlaw@2:250/1 to All on Mon Oct 7 09:03:58 2019
    On 6/10/19 7:44 pm, Doug Laidlaw wrote:
    On 6/10/19 11:29 am, William Unruh wrote:
    On 2019-10-05, Grimble <grimble@nomail.afraid.org> wrote:
    As part of my activities for my charity (National Coastwatch Lyme Bay -
    contributions welcome!) I am required by GDPR to keep sensitive files in >>> Microsoft's Cloud, but prefer to manipulate them (Word and Excel)

    Why this requirement? So that any hacker can download and read the
    filesi:-? Or what is the rationale?

    locally because the web versions of these are not as powerful as their
    local equivalents, to which I have access.
    I want to write a couple of scripts to download certain files from
    OneDrive then move them back after processing. Can anyone recommend an
    add-in to do this? - clearly I don't want a sync-ing solution.
    TIA

    Can you put them in Google Drive, then use Google Docs to edit them?

    Probably, you need to ask this on a Windows forum, write a script that Windows understands, and make its target your Linux copy.  Any app such
    as wget can download the files.  You will need to deal with the
    different permissions, and presumably the format will have to suit other members who don't have Linux.  Windows offered me to put my files in One Drive.  When I did that, the files were unwritable, and any local copies were unwritable as well.

    For something this complicated, I would do everything in one OS, which
    would have to be  Windows, maybe running in Virtualbox.

    HTH,

    Doug.

    [OT]
    Under the heading, "Windows 10 Just Screwed the Pooch (Again)" dated Oct
    7, LifeHacker reports that the latest updates to Win10 breaks the OS in several ways, including "boot-up, printing, Windows Search and even the
    Start Menu."

    [We don't use that metaphor in Oz.]

    I use Windows only when there is no alternative. Some people still run Windows 7. I run Windows 8.1. In Grimble's case, I recommended using
    Windows because everybody else will be. When Pinnerite wanted to
    interface an Android phone to his daughter's iPad, I replied in the same
    vein: his objections to an iPhone were based on philosophy only.

    I keep telling Microsoft that making their product saleable is a far
    better approach than locking the alternatives out. Now Windows has full support for Linux, but advertise that Linux is a "cancer." They simply
    refuse to listen.

    Doug.

    --- MBSE BBS v1.0.7.12A (GNU/Linux-x86_64)
    * Origin: Aioe.org NNTP Server (2:250/1@fidonet)
  • From Doug Laidlaw@2:250/1 to All on Tue Oct 8 11:49:29 2019
    On 7/10/19 7:03 pm, Doug Laidlaw wrote:
    Under the heading, "Windows 10 Just Screwed the Pooch (Again)" dated Oct
    7, LifeHacker reports that the latest updates to Win10 breaks the OS in several ways, including "boot-up, printing, Windows Search and even the Start Menu."

    But when Mageia can't provide a working C++ or an RPMdrake that doesn't
    crash, I start to have doubts about which is better.

    --- MBSE BBS v1.0.7.12A (GNU/Linux-x86_64)
    * Origin: Aioe.org NNTP Server (2:250/1@fidonet)
  • From Doug Laidlaw@2:250/1 to All on Tue Oct 8 12:09:05 2019
    On 8/10/19 9:49 pm, Doug Laidlaw wrote:
    But when Mageia can't provide a working C++ or an RPMdrake that doesn't crash, I start to have doubts about which is better.

    I am in the middle of a download of over 1K packages in Cauldron. They
    must have adopted KDE's approach, and be downloading the whole shebang.

    --- MBSE BBS v1.0.7.12A (GNU/Linux-x86_64)
    * Origin: Aioe.org NNTP Server (2:250/1@fidonet)
  • From Bit Twister@2:250/1 to All on Tue Oct 8 14:12:13 2019
    On Tue, 8 Oct 2019 22:09:05 +1100, Doug Laidlaw wrote:

    I am in the middle of a download of over 1K packages in Cauldron. They
    must have adopted KDE's approach, and be downloading the whole shebang.

    How unfortunate, had you kept an eye on the dev mail list, you would
    know there is mass rebuild in the near future.

    --- MBSE BBS v1.0.7.12A (GNU/Linux-x86_64)
    * Origin: A noiseless patient Spider (2:250/1@fidonet)