Search found 62 matches

by viktor_au
Fri Sep 11, 2026 12:21 am
Forum: General
Topic: rtc DD-MM-YY to mysql YYYY-MM-DD-HH-MM
Replies: 3
Views: 803

Re: rtc DD-MM-YY to mysql YYYY-MM-DD-HH-MM

Thanks.
I think it is easy to re-format the rtc datetime format into a mysql friendly string.
Would be great if you can insert this function into a component.
by viktor_au
Thu Sep 10, 2026 7:05 am
Forum: General
Topic: rtc DD-MM-YY to mysql YYYY-MM-DD-HH-MM
Replies: 3
Views: 803

rtc DD-MM-YY to mysql YYYY-MM-DD-HH-MM

Hi all
The mysql table requires the datetime format as: YYYY-MM-DD HH:MM:SS
Flowcode RTC component gives me a choice of:
0= DD:MM:YY
1= MM:DD:YY

Looks like I have to read and save the values separately as:
YY, MM, HR, MIN (set Secs as 00)
And reformat it to:
YYYY-MM-DD-HH-MM-00 ...
by viktor_au
Mon Nov 17, 2025 12:03 am
Forum: General
Topic: Haversine formula
Replies: 8
Views: 4946

Re: Haversine formula

Hi
All good. Thank you.
by viktor_au
Sat Nov 15, 2025 5:57 am
Forum: General
Topic: Haversine formula
Replies: 8
Views: 4946

Re: Haversine formula

Hi Iain.
You are a good man.
I see the difference between the:
-------------------------------------------------------------------------
a = (sin (((lat_diff / 2) * sin (lat_diff / 2))) + cos (Lat1) * cos (Lat2) * (sin (lon_diff / 2) * sin (lon_diff / 2)))
And:
a = ((sin(dlat / 2) * sin(dlat / 2 ...
by viktor_au
Fri Nov 14, 2025 8:34 pm
Forum: General
Topic: Haversine formula
Replies: 8
Views: 4946

Re: Haversine formula

Hi again.
Haversine
Did not work for me.

a = sin² (Δlat / 2) + cos(lat1) × cos(lat2) × sin²(Δlong / 2)

Flowcode:
a = (sin (((lat_diff / 2) * sin (lat_diff / 2))) + cos (Lat1) * cos (Lat2) * (sin (lon_diff / 2) * sin (lon_diff / 2)))
c = 2 * atan2 (sqrt (a),sqrt (1 - a))
d = 6371.0 * c

Example1 ...
by viktor_au
Tue Nov 11, 2025 6:15 pm
Forum: Feature Requests
Topic: Component for GNSS / GPS Modules
Replies: 5
Views: 4161

Re: Component for GNSS / GPS Modules

I can only suggest to try to filter out the UTC time without even using the gps module.
If you use the string manipulations to get the 151227 out of ($GNRMC,151227.3997,) and convert it to local time, you can do the major part.
by viktor_au
Tue Nov 11, 2025 6:12 pm
Forum: General
Topic: Haversine formula
Replies: 8
Views: 4946

Re: Haversine formula

Thank you guys for the help.
Will try to implement.
I thought I have to find the difference between the (for example) lat2-lat1 before the radian conversion.
by viktor_au
Tue Nov 11, 2025 5:16 am
Forum: General
Topic: Haversine formula
Replies: 8
Views: 4946

Haversine formula

Hi
Wonder if anybody work with the gps distance calculation.
Any suggestions how to implement the Haversine formula?
Thanks.
by viktor_au
Mon Nov 10, 2025 9:28 pm
Forum: Feature Requests
Topic: Component for GNSS / GPS Modules
Replies: 5
Views: 4161

Re: Component for GNSS / GPS Modules

HI. Only a time?
Why don't you use the cheap Neo 6x module?
Neo gives user a free software (u-centre).
Easy to test the module without the flowcode engine.
I do not think you need to use the flowcode component.
Neo module can receive the
$GNRMC,151227.3997,A,4723.5403567,N,00826.8867153,E,0.00000,81 ...
by viktor_au
Wed Nov 05, 2025 10:56 pm
Forum: Feature Requests
Topic: Component for GNSS / GPS Modules
Replies: 5
Views: 4161

Re: Component for GNSS / GPS Modules

Hi Stefan
I am working with Neo8N right now.
What is the benefit of GPS SMA (instead of high speed) ?
Does it have a high precision?
Thanks