paper: Android Scouting App for Arial Assist
 

Thread created automatically to discuss a document in CD-Media.

Android Scouting App for Arial Assist by tr6scott

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

Re: paper: Android Scouting App for Arial Assist
 

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.

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.

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.

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.

Re: paper: Android Scouting App for Arial Assist
 

The row duplication issue has been fixed by the new script. Use script_v5.

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.

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.

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.

Re: paper: Android Scouting App for Arial Assist
 

Did you use the v5 script (as well as app inventor v5 .aia file)?

Re: paper: Android Scouting App for Arial Assist
 

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.

Re: paper: Android Scouting App for Arial Assist
 

Yes, I used all the new updates

Re: paper: Android Scouting App for Arial Assist
 

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.

Re: paper: Android Scouting App for Arial Assist
 

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

Re: paper: Android Scouting App for Arial Assist
 

It looks good, thanks for sharing

Re: paper: Android Scouting App for Arial Assist
 

TORC is happy to share!

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

Re: paper: Android Scouting App for Arial Assist
 

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.

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

Re: paper: Android Scouting App for Arial Assist
 

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.

Re: paper: Android Scouting App for Arial Assist
 

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

Re: paper: Android Scouting App for Arial Assist
 

"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.

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

Re: paper: Android Scouting App for Arial Assist
 

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.

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?

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"

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.

Re: paper: Android Scouting App for Arial Assist
 

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.