Go to Post Ohhh Chiefdelphi how I love you and your 700 posts about a picture of a fish. - Boydean [more]
Home
Go Back   Chief Delphi > CD-Media > White Papers
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

photos

papers

everything



Android Scouting App for Arial Assist

tr6scott

By: tr6scott
New: 21-02-2014 06:28
Updated: 11-03-2014 12:17
Total downloads: 685 times


Scouting app for Android Phones, using SMS to populate a central Google Sheet for a team. Uses App Inventor for application, Twilio for SMS message data communication to the sheet.

To use this system, one will need to be technical savvy with the technologies used. It has been a long learning process for the team this year, and is working, but there is not an easy one click, everything works setup button.

The app is created in App Inventor ( Google account). The app collects data into variables, then creates a comma separated text string from the variables. Next, when the submit button is pressed, the text is sent to the Twilio number, which then calls the script that separates the string into values that are entered into the spreadsheet. There are three different sheets. The first sheet shows autonomous data, the second shows teleop data and third is descriptive data. This app uses SMS (phone texting on Android phone) to enter data. This was done due to lack of wifi or data signals at venues, and the rules restricting Bluetooth or other such signals to be utilized.

I am not the programmer for this app, but our team will be happy to answer questions, and take feedback.

Attached Files

  • ocx Instructions

    InstructionsforTORCAerialAssistScoutApp.docx

    downloaddownload file

    uploaded: 21-02-2014 06:28
    filetype: ocx
    filesize: 281.54kb
    downloads: 195


  • aia Aerial_Assist_Scout_v6.aia

    Aerial_Assist_Scout_v6.aia

    downloaddownload file

    uploaded: 11-03-2014 12:17
    filetype: aia
    filesize: 48.39kb
    downloads: 149


  • txt Aerial Scout Script version 6.txt

    Aerial Scout Script version 6.txt

    downloaddownload file

    uploaded: 11-03-2014 12:17
    filetype: txt
    filesize: 5.46kb
    downloads: 130


  • txt Aerial Assist Scout version 6 changes.txt

    Aerial Assist Scout version 6 changes.txt

    downloaddownload file

    uploaded: 11-03-2014 12:17
    filetype: txt
    filesize: 1.53kb
    downloads: 99


  • lsx Aerial Assist Scout v6 Data.xlsx

    Aerial Assist Scout v6 Data.xlsx

    downloaddownload file

    uploaded: 11-03-2014 12:17
    filetype: lsx
    filesize: 10.61kb
    downloads: 110



Recent Downloaders

  • Guest

Discussion

view entire thread

Reply

23-02-2014 13:55

jawebste


Unread Re: paper: Android Scouting App for Arial Assist

When I run the google script I receive the following error:
TypeError: Cannot read property "parameter" from undefined. (line 5, file "Code")Dismiss

I think I am following the directions. This occurs during Step 3 at the top of page 3 of the instructions. My cell is dead a reply here is probably best. Thanks



24-02-2014 10:16

MasterEric


Unread Re: paper: Android Scouting App for Arial Assist

Quote:
Originally Posted by jawebste View Post
When I run the google script I receive the following error:
TypeError: Cannot read property "parameter" from undefined. (line 5, file "Code")Dismiss

I think I am following the directions. This occurs during Step 3 at the top of page 3 of the instructions. My cell is dead a reply here is probably best. Thanks
That is an error that is expected. Since you don't have a text coming through, there is no "parameter". The won't actually run until a text comes through, but you have to try to run so that you can go through the Google permissions. The permissions allow the script to access the Google Spreadsheet.

I will add that to the instructions. Let me know if you have any other questions, it will help me to write more complete instructions.



24-02-2014 12:17

MasterEric


Unread Re: paper: Android Scouting App for Arial Assist

Please note the following:

*All buttons use a “long-click” to subtract, that way if a button is pressed accidentally it can be subtracted. The Assist button is a toggle.

*Data is submitted every time a goal is scored , the end cycle button is pressed or the submit button is pressed. When you view the data in the spreadsheet, there WILL BE duplicates. The “remove duplicate rows” Google script can be used in the autonomous data (sheet 1) and the robot description sheet(sheet 3). In the teleop data sheet that script will not work because of the timestamp. In that case, rows can be sorted by robot number, then cycle number. If there is multiple rows for one cycle then those extra rows can be removed. We may create a script for just removing rows where data is duplicated just in certain rows, but we have not done that yet.



26-02-2014 10:31

MasterEric


Unread Re: paper: Android Scouting App for Arial Assist

Go to TORC website to download latest version of this app and the new and improved script file that will prevent duplicate data from being entered into the spreadsheet.



26-02-2014 12:30

tr6scott


Unread Re: paper: Android Scouting App for Arial Assist

Updated files are now posted here, please update if you have downloaded prior to 2014-02-26.



27-02-2014 08:14

MasterEric


Unread Re: paper: Android Scouting App for Arial Assist

Quote:
Originally Posted by MasterEric View Post
Please note the following:

*All buttons use a “long-click” to subtract, that way if a button is pressed accidentally it can be subtracted. The Assist button is a toggle.

*Data is submitted every time a goal is scored , the end cycle button is pressed or the submit button is pressed. When you view the data in the spreadsheet, there WILL BE duplicates. The “remove duplicate rows” Google script can be used in the autonomous data (sheet 1) and the robot description sheet(sheet 3). In the teleop data sheet that script will not work because of the timestamp. In that case, rows can be sorted by robot number, then cycle number. If there is multiple rows for one cycle then those extra rows can be removed. We may create a script for just removing rows where data is duplicated just in certain rows, but we have not done that yet.
The row duplication issue has been fixed by the new script. Use script_v5.



27-02-2014 09:47

MasterEric


Unread Re: paper: Android Scouting App for Arial Assist

Users of this app will need to go in and change the events list to their own team's events. The "Choose Event" button is a list picker. Go to the properties and in the "ElementsFromString" property, type in events separated by a comma.



27-02-2014 09:59

MasterEric


Unread Re: paper: Android Scouting App for Arial Assist

Up to version 5, this app separates the string by commas. We will fix this in the future but in the meantime don't use comma's in your comments or team number or match number. If you do, your data will not go into the expected places on the spreadsheet.



27-02-2014 15:02

Anthony4004


Unread Re: paper: Android Scouting App for Arial Assist

Just installed v5 however the duplicates are still there, as well as differing duplicates.

https://docs.google.com/spreadsheet/...rive_web#gid=0


I believe that a tutorial video would be very helpful.



27-02-2014 15:24

MasterEric


Unread Re: paper: Android Scouting App for Arial Assist

Quote:
Originally Posted by Anthony4004 View Post
Just installed v5 however the duplicates are still there, as well as differing duplicates.

https://docs.google.com/spreadsheet/...rive_web#gid=0


I believe that a tutorial video would be very helpful.
Did you use the v5 script (as well as app inventor v5 .aia file)?



27-02-2014 15:32

MasterEric


Unread Re: paper: Android Scouting App for Arial Assist

Quote:
Originally Posted by Anthony4004 View Post
Just installed v5 however the duplicates are still there, as well as differing duplicates.

https://docs.google.com/spreadsheet/...rive_web#gid=0


I believe that a tutorial video would be very helpful.
Did you use the v5 script (as well as app inventor v5 .aia file)?

Just as a side, it looks like you pressed the submit button without entering any data for the tele cycle. The way it's set up, it will enter the auto data when the End Cycle button is pressed, or a goal button is pressed in tele (either high or low), so you don't have to scroll down and enter the auto data at all.

Regarding a tutorial video, yes we probably should put out a tutorial. This app is really meant as a jumping off point for programmers on other teams to use, and build on. It's definitely not a perfect end product.



27-02-2014 15:43

Anthony4004


Unread Re: paper: Android Scouting App for Arial Assist

Yes, I used all the new updates



27-02-2014 15:59

MasterEric


Unread Re: paper: Android Scouting App for Arial Assist

Quote:
Originally Posted by Anthony4004 View Post
Yes, I used all the new updates
You need to press the "start cycle" button. The cycle number in your tele data was 0, which is one of the parameters that the script checks.
Also the data was different in each row of the data on the third sheet because the telepoints changed.
...still not quite sure why it entered another row in autonomous that was identical. I'm trying to duplicate it and it doesn't happen.



27-02-2014 22:01

MrRiedemanJACC


Unread Re: paper: Android Scouting App for Arial Assist

One of my students downloaded and set it up today. Looks pretty awesome! Thanks for sharing!!!!



28-02-2014 07:44

eddie12390


Unread Re: paper: Android Scouting App for Arial Assist

It looks good, thanks for sharing



28-02-2014 08:00

MasterEric


Unread Re: paper: Android Scouting App for Arial Assist

Quote:
Originally Posted by MrRiedemanJACC View Post
One of my students downloaded and set it up today. Looks pretty awesome! Thanks for sharing!!!!
TORC is happy to share!



01-03-2014 16:11

Hazmat2145


Unread Re: paper: Android Scouting App for Arial Assist

Great work being done here.
I have the newest script.
I get a error on the phone.
'IO Error : unable to create GvHelper'
Any help would be greatly appropriated.

Thanks
Hazmat 2145



01-03-2014 16:48

MasterEric


Unread Re: paper: Android Scouting App for Arial Assist

Quote:
Originally Posted by Hazmat2145 View Post
Great work being done here.
I have the newest script.
I get a error on the phone.
'IO Error : unable to create GvHelper'
Any help would be greatly appropriated.

Thanks
Hazmat 2145
I have never seen that error, but found this on a App Inventor discussion, you might check (you will have to go into App Inventor and check the text1 object properties.
* The Texting component has to have its GoogleVoiceEnabled property set to true.
* The app has to be packaged and downloaded to the phone -- it won't run from the blocks editor.



01-03-2014 17:13

Hazmat2145


Unread Re: paper: Android Scouting App for Arial Assist

Wow fast response. I did the compile again and get no error now.
The next issue i have is when i submit i get a text message on my phone but no update on Google drive. I know i am close.
Thanks for the help
Hazmat 2145



02-03-2014 09:25

MasterEric


Unread Re: paper: Android Scouting App for Arial Assist

Quote:
Originally Posted by Hazmat2145 View Post
Wow fast response. I did the compile again and get no error now.
The next issue i have is when i submit i get a text message on my phone but no update on Google drive. I know i am close.
Thanks for the help
Hazmat 2145
the things that need to be correct for the text to get to the spreadsheet are:
1. The spreadsheet ID in the script, check that that correct
2. The Twilio phone number in the App Inventor file needs to be the Twilio phone number
3. The script was run and permissions were allowed for the spreadsheet.

In Twilio, there is a text message log. There, you can tell if your message got to Twilio from the app. If it did, you can see what the message is. It should be all your data separated by commas. If that is correct then it's an issue with the script not sending it to the spreadsheet properly. You need to figure out which part isn't working.



03-03-2014 16:51

Hazmat2145


Unread Re: paper: Android Scouting App for Arial Assist

Quote:
Originally Posted by MasterEric View Post
the things that need to be correct for the text to get to the spreadsheet are:
1. The spreadsheet ID in the script, check that that correct
2. The Twilio phone number in the App Inventor file needs to be the Twilio phone number
3. The script was run and permissions were allowed for the spreadsheet.

In Twilio, there is a text message log. There, you can tell if your message got to Twilio from the app. If it did, you can see what the message is. It should be all your data separated by commas. If that is correct then it's an issue with the script not sending it to the spreadsheet properly. You need to figure
out which part isn't working.
The log Twillo for text messages is empty. Do i need to upgrade the Twillo account?
The spread sheet ID in the script is correct according to the number on my spread sheet
The Twillo # in the app is changed to match the number i got.
The script was run to give permission.

I do get a message on my phone from Verizon every time i hit the send key in the app
"5555555555 is a land-line# Reply Y to send all TXT messages to this # as voice messages for 0.25/msg"

Thanks for the help.
Hazmat 2145



04-03-2014 08:12

MasterEric


Unread Re: paper: Android Scouting App for Arial Assist

Quote:
Originally Posted by Hazmat2145 View Post
The log Twillo for text messages is empty. Do i need to upgrade the Twillo account?
The spread sheet ID in the script is correct according to the number on my spread sheet
The Twillo # in the app is changed to match the number i got.
The script was run to give permission.

I do get a message on my phone from Verizon every time i hit the send key in the app
"5555555555 is a land-line# Reply Y to send all TXT messages to this # as voice messages for 0.25/msg"

Thanks for the help.
Hazmat 2145
"The Twillo # in the app is changed to match the number i got." For some reason it didn't save it. It must be dialing the default number, because 555-5555 was the dummy number I put in. I didn't upgrade our Twilio account, so I don't think that's the issue. If you have an older version of the app the phone number is in the Submit button as well as the global variable phoneNumber. (that was fixed in version 5)

p.s. I have fixed a few other problems and after some more testing I'm going to be sharing a new version, hopefully later this week. It fixes some glitches with the timer and data entry on the spreadsheet, much smoother.



08-03-2014 08:49

Hazmat2145


Unread Re: paper: Android Scouting App for Arial Assist

Great news I no longer get the text message sent back to my phone. After changing the variable "initialize global phonenumber" to the correct Twillo # Twillo now gets the message. Now I have a Twillo message log but for ever message i get a error "Error: 11200 - HTTP retrieval failure" in Twillo.

Thanks,
Hazmat 2145



10-03-2014 21:24

MasterEric


Unread Re: paper: Android Scouting App for Arial Assist

Quote:
Originally Posted by Hazmat2145 View Post
Great news I no longer get the text message sent back to my phone. After changing the variable "initialize global phonenumber" to the correct Twillo # Twillo now gets the message. Now I have a Twillo message log but for ever message i get a error "Error: 11200 - HTTP retrieval failure" in Twillo.

Thanks,
Hazmat 2145
I have never seen that, but look it up gave me "An 11200 error is an indicator of a connection failure between Twilio and your service. When Twilio requests a page from your server, we wait a maximum of 15 seconds for a response. A connection failure will occur if no response is returned in that time."
I would double check the url for the Google spreadsheet in the script and make sure that you run the script to get that authorization. Just a guess.



11-03-2014 11:26

eli2410


Unread Re: paper: Android Scouting App for Arial Assist

I don't think anyone has asked this yet, but if they have, sorry for the repeat.

I know that with Google Forums, every time you submit an answer, it creates a new line. This messes up any formulas you have in the document. Does this happen here or not?



11-03-2014 12:19

tr6scott


Unread Re: paper: Android Scouting App for Arial Assist

Version 6 is posted.

Thanks to all the teams that have tried this, and given feedback, it is making it better!



Changes:
-moved the foul and technical foul buttons to the description area. During the match it's too hard to keep track of fouls (ref) and the bot. After the match when they are announced it can be tallied or entered into the comments area.can be added along with the other robot descriptive data in the checkboxes.
-the previous version used commas to separate the data into the columns of the spreadsheet. This version uses '~' (tilde) since it's too easy to enter a comma in the comments section, and end up with the data going into multiple columns.
-added an "End Match" button. This stops the clock, and sends the final match data to the spreadsheet
-timer glitch was fixed (timer was continuing until the start cycle was pressed again. It's easy to forget to start the cycle, so now it's done automatically). The timer RESETS and a new cycle is started as soon as a high or low goal is scored or the End Cycle button is pressed. The timer STOPS when the End Match button is pressed.
-when submit data is pressed, data is entered into the descriptive data spreadsheet sheet 3, and the comments data sheet 4
-if End match, goals and end cycle buttons nothing happens unless a cycle has been started.If the match is going, and those buttons are pressed it sends the cycle data to sheet 2 and starts a new cycle. End cycle also sends the data and starts a new match. End match sends the data but does not start a new match.
also
-fixed foul reset (was not resetting to 0), reset start position
-events are general (wk#, championship)
-changed "match time" label to "cycle time"



11-03-2014 16:49

MasterEric


Unread Re: paper: Android Scouting App for Arial Assist

please note: When setting up a new version of the script, you need to create a new project. Once you run, authorize and publish the script, you need to make a new app in Twilio with the url of the new script. Twilio caches the script url so this is the only way to get around Twilio using the old script.



11-03-2014 16:55

MasterEric


Unread Re: paper: Android Scouting App for Arial Assist

Quote:
Originally Posted by eli2410 View Post
I don't think anyone has asked this yet, but if they have, sorry for the repeat.

I know that with Google Forums, every time you submit an answer, it creates a new line. This messes up any formulas you have in the document. Does this happen here or not?
This app simply adds a line of data to the spreadsheet. It does not have any formulas in the spreadsheet. This app is for collection of data. You could download the data into an excel spreadsheet for analysis.
Does this answer your question?

Please note the version 6 is available on our website or here on Chief Delphi.



view entire thread

Reply

Tags

loading ...



All times are GMT -5. The time now is 23:45.

The Chief Delphi Forums are sponsored by Innovation First International, Inc.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi