AI2 Inventor Forum News: Error messages in fusion tables

2017년 7월 22일 토요일

Error messages in fusion tables

I'm studying in class 7 and learning fusion tables. I created a table with a single column called "Text" to accept text. In app inventor I have done the following steps.

1. Created a service account key.

2. Copied and pasted the service account in the share option in Fusion tables and shared it.

3. In fusion table I got table Id from File - About this table - Id (copied without any spaces)

4. In app inventor a screen with a label, a button and Fusion table control 1 (Invisible component) .(see pic1)

5. program (see pic2)

I have not used API but have used service account method

I have also downloaded and uploaded the *.pk2 file in appinventor

But still it gives this error (see pic 4 and its continuation)

Show us the Designer attributes of the Fusion Table Control, like attached ...

If that doesn't help, post the .aia expert file here.

I have sent the .aia file and the Image of properties of fusion tables from app inventor.

test.aia

I opened your test.aia in AI2, and looked at your Fusion Table Control in the Designer. (See attached).

You have to empty out that API Key field,

other wise the Service Account Method won't work.

As per your instructions I deleted the API key in fusion tables property but I'm still getting the same error message.

Please can you help me.

After you clear the field, you have to click on a blank spot in that area outside the text box to make the change stick.

To test that, clear the field, then switch to the label or button, then switch back to the Fusion Control to see if it is still cleared.

I tested your app after clearing the field, and it worked for me.

I did as you have said the API field is now cleared but sir the app is still giving me the error message.

When I created the service account . I created the account without the Role. Has this got to do anything with the error message.

I have also attached the new .aia file

test.aia

I am from Indian time. Its pretty late now. Thank you sir for your suggestions.

I tested from your new test.aia and it worked (see attached).

Maybe you are testing using an old built .apk and not from the emulator?

I would like to run this program on the mobile and not on emulator , and the pro gram is still not working.

My mobile is:

MotoG4+

android version 7.0

Maybe you are running an old version of the program on your mobile.

Try doing a Project->Save As ->TESTV02 to give it a new name, build TESV02, and load TESTV02.apk onto your phone, after removing the old test app from your phone.

This will avoid any confusion between old and new versions of the app.

I see no reason why this should work for me but not for you.

I did as you had advised , but unfortunate its not working on my mobile. : - (

Thanks for your suggestions and time , sir.

Could you export the new .aia file and post it here?

ALso, if you can supply a screen shot of the error message on your mobile?

Maybe some one else on this board will have new ideas.

From the AI2 Help on Fusion Tables:

Using the FusiontablesControl Component Creating Fusion Tables

You will probably want to create your own Fusion Tables to experiment with as you are developing your apps. This is as easy as creating a Google document, if you are familiar with that process. Here are the steps:

1. On the web, login to your Gmail account or any other Google service (e.g., Drive, YouTube). Navigate to Google Drive.

2. Click the New button and navigate to More. If you do not see a Google Fusion Tables option, select Connect more apps and scroll through the page of Google services to find the Fusion Tables service and connect it to your Google Drive.

3. You may want to view some of the examples and work through a tutorial (e.g. Pizza Party Tutorial) to learn the basics.

4. Click the See my tables button (top right of the page). This will bring you to your own page.

5. You should see a list of your own tables or tables that have been shared with you (possibly none).

6. Use the Create button to create a new table. Give it some column names and save it.

7. Click on the Share button (top right) to modify the table's permissions.

Did you skip step 7?

Also compare your table permissions with the sample in this doc ...

Pizza Party Table Permissions

I had already done the share settings (as seen in "share" picture) before . I am getting the same error message (as seen in pic4) . I have also sent the new .aia file.