Thank you both. It's given me an idea.
Wow! Great extension!!! I will buy it soon
I'm using mysql, but I want only one data to be entered into mysql database and use the UPDATE code block to change that data automatically with location change.
how do?
Your blocks look fine...
As test you can use the web component to find out, if your update statement works fine
Also you might want to use Do it to debug your query to find out, if the number is correct...
And while using the extension it helps to use the ErrorOccurred event to display any errors in a label just in case
Taifun
The previous project was buildable, but after I added the extension location service an error occurred.
Please help me
The location service test project builds fine, which means, it is something else in your project...
Send me your previously working project file by email or PM and I will check
Taifun
PS: as you know, posting a project in the community which includes paid extensions is not allowed....
The project contains 10 screens and 25 extensions
This was the result
@Taifun, I checked the extensions one by one, I found the extension phase.
after I upgraded the extension phase to version 2.2.2, the project can be built.Thanks for taking the time to check out my project.
Best regards
Thank you @Ayun_Challymalang
Taifun
Please help me.
- Which MySQL and Spreadsheet are recommended?
- The data stored in MySLQ/Spreadsheed is latitude and longitude data, if you use DistanceInterval = 1 and TimeInterval = 1000, a lot of data will be stored.
Can only the Trip1 Tag be stored? to save storage capacity.
I hope there is a solution.
MySQL on your own web server, see for example App Inventor Tutorials and Examples: MySQL | Pura Vida Apps or Google Spreadsheet using the web component following this tutorial METRIC RAT AI2 - Google Sheets - Simple POST and GET Data
You might want to read again the documentation here App Inventor Extensions: Location Service | Pura Vida Apps
Before starting the service use an if statement to decide, if you want to use the background web feature or not, see also the example project
Taifun
The update query does not convert magically into an insert query somehow. .
Follow my previous suggestions
Taifun
4 posts were split to a new topic: How to display all the data in the first row taken from a MySQL database
I have 2 questions
-
I attached taifun location extension blocks into project built in location sensor then this happened. coordinate and other numbers attached in list. what numbers are those and how can i remove those numbers except coordinates.
-
Can options like ProviderLocked to true, ProviderName to "gps" in LocationSensor also possible in TaifunLocationService? location accuracy weirdly lower so I have to try any optional test to improve accuracy. Or any other suggest options to higher accuracy rate?
I couldn't attached my project file as it include paid extension in it.
thanks in advance.
See the documentation at App Inventor Extensions: Location Service | Pura Vida Apps
Optional location data to be stored in TinyDB
As the collected data can be extensive, the following properties can be used to decide, if a specific location information should be stored in TinyDB or not.
So if you like only the coordinates stored in TinyDB, then only set the property Coordinates to true and the other properties mentioned there to false
Unfortunately not... please see the documentation about the available features. Did you enable GPS and allow location access all the time? Did you also grant location background permission? Which Android version are you using for your tests?
Thank you for respecting my t&c.. In case there are still questions you also can provide a screenshot of your relevant blocks...
Taifun
1 Like
See Taifuns advice. The following might help with respect to question #1
You should be able to post ONLY the latitude and longitude by only requesting the latitude and longitude.
fused indicates you are using the new 'feature' provider on Android 11+ devices intended to improve coordinate accuracy (it often does not). The other numbers are probably altitude in meters and perhaps the Accuracy
Hola, tengo una app que enviar datos en segundo plano con esta extension, funciona muy bien en dispositivos con android 11 o menor, pero en dispositivos con android 12 o 13 al presionar el boton para iniciar los servicios me bota de la aplicacion, alguien ha tenido algun problema similar que me pueda ayudar, Gracias.
(Hello, I have an app that sends data in the background with this extension, it works very well on devices with android 11 or lower, but on devices with android 12 or 13 when pressing the button to start the services, the application kicks me out, someone has I had a similar problem that you can help me, Thank you)
Please try the example projects on your Android 12 or 13 device and let us know, if these work for you...
Also nake sure to grant location permission always, not only while using the app...
Taifun