Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

You can't push on a string.

aus+uk / uk.comp.homebuilt / Re: Pi has a CSV file, and updates it every 30 minutes, how to access that *.csv file on Excel running on a win 10 box?

SubjectAuthor
* Pi has a CSV file, and updates it every 30 minutes, how to accessSH
`* Re: Pi has a CSV file, and updates it every 30 minutes, how toJim Jackson
 +- Re: Pi has a CSV file, and updates it every 30 minutes, how to accessAbandoned_Trolley
 `- Re: Pi has a CSV file, and updates it every 30 minutes, how to accessSH

1
Pi has a CSV file, and updates it every 30 minutes, how to access that *.csv file on Excel running on a win 10 box?

<tiscak$1l96$1@gioia.aioe.org>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=2630&group=uk.comp.homebuilt#2630

  copy link   Newsgroups: uk.comp.homebuilt
Path: i2pn2.org!i2pn.org!aioe.org!ok3HMNHmsIv5MlSBB73KNg.user.46.165.242.75.POSTED!not-for-mail
From: i.love.s...@spam.com (SH)
Newsgroups: uk.comp.homebuilt
Subject: Pi has a CSV file, and updates it every 30 minutes, how to access
that *.csv file on Excel running on a win 10 box?
Date: Thu, 20 Oct 2022 21:50:28 +0100
Organization: Aioe.org NNTP Server
Message-ID: <tiscak$1l96$1@gioia.aioe.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="54566"; posting-host="ok3HMNHmsIv5MlSBB73KNg.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101
Thunderbird/102.3.3
X-Notice: Filtered by postfilter v. 0.9.2
 by: SH - Thu, 20 Oct 2022 20:50 UTC

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?

Re: Pi has a CSV file, and updates it every 30 minutes, how to access that *.csv file on Excel running on a win 10 box?

<slrntl3e75.gr1.jj@iridium.wf32df>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=2631&group=uk.comp.homebuilt#2631

  copy link   Newsgroups: uk.comp.homebuilt
Path: i2pn2.org!i2pn.org!paganini.bofh.team!eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: jj...@franjam.org.uk (Jim Jackson)
Newsgroups: uk.comp.homebuilt
Subject: Re: Pi has a CSV file, and updates it every 30 minutes, how to
access that *.csv file on Excel running on a win 10 box?
Date: Thu, 20 Oct 2022 21:08:53 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 22
Message-ID: <slrntl3e75.gr1.jj@iridium.wf32df>
References: <tiscak$1l96$1@gioia.aioe.org>
Injection-Date: Thu, 20 Oct 2022 21:08:53 -0000 (UTC)
Injection-Info: reader01.eternal-september.org; posting-host="285a00a2a5e16b80bca4e1b891f09958";
logging-data="450150"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+noDESvOZZM9ta5GBjHIdXPpf+vKvBfGI="
User-Agent: slrn/1.0.3 (Linux)
Cancel-Lock: sha1:geiT2vFQoS0yFzLrMk2CeCuTdVI=
 by: Jim Jackson - Thu, 20 Oct 2022 21:08 UTC

On 2022-10-20, SH <i.love.spam@spam.com> 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

Re: Pi has a CSV file, and updates it every 30 minutes, how to access that *.csv file on Excel running on a win 10 box?

<titjmh$ja3n$1@dont-email.me>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=2632&group=uk.comp.homebuilt#2632

  copy link   Newsgroups: uk.comp.homebuilt
Path: i2pn2.org!i2pn.org!aioe.org!eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: fre...@fred-smith.co.uk (Abandoned_Trolley)
Newsgroups: uk.comp.homebuilt
Subject: Re: Pi has a CSV file, and updates it every 30 minutes, how to access
that *.csv file on Excel running on a win 10 box?
Date: Fri, 21 Oct 2022 09:02:26 +0100
Organization: A noiseless patient Spider
Lines: 36
Message-ID: <titjmh$ja3n$1@dont-email.me>
References: <tiscak$1l96$1@gioia.aioe.org> <slrntl3e75.gr1.jj@iridium.wf32df>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Fri, 21 Oct 2022 08:02:25 -0000 (UTC)
Injection-Info: reader01.eternal-september.org; posting-host="cf588a4c4c6db6e90bc4c62c96b059bd";
logging-data="632951"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/Rm+gOwZ6ISK+EQ4LBpT2cuL+/bGVVyioA4/PTSZ6O1w=="
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101
Thunderbird/102.4.0
Cancel-Lock: sha1:6zyaXQblq2Q9Y5mBda7k7xzyUZw=
In-Reply-To: <slrntl3e75.gr1.jj@iridium.wf32df>
 by: Abandoned_Trolley - Fri, 21 Oct 2022 08:02 UTC

On 20/10/2022 22:08, Jim Jackson wrote:
> On 2022-10-20, SH <i.love.spam@spam.com> 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

Re: Pi has a CSV file, and updates it every 30 minutes, how to access that *.csv file on Excel running on a win 10 box?

<titkej$v2s$1@gioia.aioe.org>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=2633&group=uk.comp.homebuilt#2633

  copy link   Newsgroups: uk.comp.homebuilt
Path: i2pn2.org!i2pn.org!aioe.org!ok3HMNHmsIv5MlSBB73KNg.user.46.165.242.75.POSTED!not-for-mail
From: i.love.s...@spam.com (SH)
Newsgroups: uk.comp.homebuilt
Subject: Re: Pi has a CSV file, and updates it every 30 minutes, how to access
that *.csv file on Excel running on a win 10 box?
Date: Fri, 21 Oct 2022 09:15:15 +0100
Organization: Aioe.org NNTP Server
Message-ID: <titkej$v2s$1@gioia.aioe.org>
References: <tiscak$1l96$1@gioia.aioe.org> <slrntl3e75.gr1.jj@iridium.wf32df>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="31836"; posting-host="ok3HMNHmsIv5MlSBB73KNg.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101
Thunderbird/102.3.3
X-Notice: Filtered by postfilter v. 0.9.2
 by: SH - Fri, 21 Oct 2022 08:15 UTC

On 20/10/2022 22:08, Jim Jackson wrote:
> On 2022-10-20, SH <i.love.spam@spam.com> 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.

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor