Same blocks, two different length csv files, but one of them can't run correctly

[cc1608x]

I have a csv file that includes name, gender, class, account, password and course fields. First, read the csv file, then turn it to a list, and store data to TinyWebDB. If you click the button "Read WebDB and Display", it will read TinyWebDb and display the value. I use 2 csv files to test the app. The test_10.csv file has 10 items, and it runs totally correctly, the label3.text shows all items. The test_full.csv file has about 900 items, after clicking the button "Read WebDB and Display", the label3.txt shows nothing. What is the probable problem? video

Screen Initialize:

Turn csv file to list, delete the first and last brackets

Clicking  btnInitialize "Set Data Format":

Clicking "Read WebDB and Display"

But when I just change file test_10.csv to test_full, the last step cannot fulfill, the label3.txt shows nothing.

Here is a video: https://drive.google.com/open?id=0B8J1AltYGH0MdnlMQnc4dWdwOHc       to show the app running.

I have also upload the .aia file.

[Tim Carter]

Why do you need to use the TinyWebDB? Looks like static data to me?

[Abraham Getzler]

This should be a Fusion Tables app.

See this sample for how to do multiple INSERTs from a csv table ...

https://docs.google.com/document/d/12g_66X0xoXrbfCHFOo838umQC8vE7lwhpxGQLsZQl9A/edit?usp=sharing

Also, when you build your list of pairs from the split line,

you fail to guard against short (< 6 items) lines before

you go selecting items from the split result.

Edit your .csv file with the free NotePad++ program to

clean it up.

Watch for short line(s) at the end.

ABG

[cc1608x]

Thanks for your reply!

We can't use fusion table as well as MIT TinyWedDB in China. So we use our local TinyWebDB instead. In order to shorten the length of the list, I modify my progrem, don't use pair value at last. Finally I figure out what the problem is. I think it is because of the length limit of TineWebDB. When I seperate the total long list into 21 short lists, each list only include not more than 60 items, and then it can fetch value from TinyWebDB.

[Abraham Getzler]

Thanks for the length limit alert.

Added to TinyWebDB section of FAQ

https://groups.google.com/forum/?utm_medium=email&utm_source=footer#!msg/mitappinventortest/2cd6Uz__xA0/cPQSiZpcDAAJ

ABG

[Juliet]

That's so appreicate of you! The power users FAQ is very helpful!