1. Forum
  2. Usenet
  3. UK.COMP.HOMEBUILT

  • Re: Pi has a CSV file, and updates it every 30 minutes, how to access t

    From Jim Jackson@21:1/5 to [email protected] on Thu Oct 20 21:08:53 2022
    On 2022-10-20, SH <[email protected]> wrote:
    Right, I have a Pi that is measuring something every 30 minutes and
    appending the new measurement to the end of a CSV file that is stored on
    the Pi.

    I want to run excel on my win 10 box and access that csv file without
    having to use WinSCP to copy the most recent file across.

    I presume I could share a file directory on the pi onto the network, so
    How do I do this please?

    you need to install samba if its not already installed, and then
    configure it to allow access.

    A google for "samba on the raspberry pi" throws up quite a few tutorials.

    This one for instance ...

    https://pimylifeup.com/raspberry-pi-samba/

    good luck

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Abandoned_Trolley@21:1/5 to Jim Jackson on Fri Oct 21 09:02:26 2022
    On 20/10/2022 22:08, Jim Jackson wrote:
    On 2022-10-20, SH <[email protected]> wrote:
    Right, I have a Pi that is measuring something every 30 minutes and
    appending the new measurement to the end of a CSV file that is stored on
    the Pi.

    I want to run excel on my win 10 box and access that csv file without
    having to use WinSCP to copy the most recent file across.

    I presume I could share a file directory on the pi onto the network, so
    How do I do this please?

    you need to install samba if its not already installed, and then
    configure it to allow access.

    A google for "samba on the raspberry pi" throws up quite a few tutorials.

    This one for instance ...

    https://pimylifeup.com/raspberry-pi-samba/

    good luck




    alternatively, there may be a way to make a ftp connection to it
    directly from Excel ?

    I hasten to add that I don't own a Pi or know much about them.

    AT

    --
    random signature text inserted here

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From SH@21:1/5 to Jim Jackson on Fri Oct 21 09:15:15 2022
    On 20/10/2022 22:08, Jim Jackson wrote:
    On 2022-10-20, SH <[email protected]> wrote:
    Right, I have a Pi that is measuring something every 30 minutes and
    appending the new measurement to the end of a CSV file that is stored on
    the Pi.

    I want to run excel on my win 10 box and access that csv file without
    having to use WinSCP to copy the most recent file across.

    I presume I could share a file directory on the pi onto the network, so
    How do I do this please?

    you need to install samba if its not already installed, and then
    configure it to allow access.

    A google for "samba on the raspberry pi" throws up quite a few tutorials.

    This one for instance ...

    https://pimylifeup.com/raspberry-pi-samba/

    good luck



    well that worked, but I had to be patient while Win 10 sorted its stuff out...... it came up with a lot of Not reeponding windows!

    I just shared the directory that the CSV file is located at.

    FYI, I have a cron job on the Pi that does a CLI speedtest every 30 mins
    and there is a noticeable drop from 500 Mbit to less than 100 Mbit every evening from about 7.00 pm to 10.00 pm. The upload of 500 Mbit is
    unaffected. Ping is OK but Jitter is poor in the evenings.

    So at least I have evidence when I raise a support ticket with my fibre provider regarding the poor download speed and poor jitter.

    The Pi is suprisingly useful, I also have Pi Hole and Ubiquiti network controller AND Wireguard all running on the same physical Pi 4.

    S.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)