List Picker from csv

481 views
Skip to first unread message

khaled alamer

unread,
Apr 15, 2017, 3:14:28 AM4/15/17
to MIT App Inventor Forum
I am working on listpicker from csv but it is not working there is Error  601:No corresponding
Please I wana help me.

khaled alamer

unread,
Apr 15, 2017, 3:15:11 AM4/15/17
to MIT App Inventor Forum
attached is aia
download.aia

Tim at Loddon

unread,
Apr 15, 2017, 3:58:04 AM4/15/17
to MIT App Inventor Forum
Please posts some blocks and an example of your cab so we can help.

khaled alamer

unread,
Apr 15, 2017, 4:04:01 AM4/15/17
to MIT App Inventor Forum
Hi Tim,
Please open  attached aia.Thank you so much 
download.aia

Taifun

unread,
Apr 15, 2017, 10:31:37 AM4/15/17
to MIT App Inventor Forum
If you are asking for help, I recommend you to make it as easy for others to be able to help you ...
You probably will get more feedback then...

which means in your case post a screenshot of your relevant blocks...

To download the aia file, upload it to  App Inventor, open it, do some bug hunting for you, etc... this takes time, and most people will not do that...
Thank you.

Taifun

Trying to push the limits of App Inventor! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun. 

khaled alamer

unread,
Apr 15, 2017, 10:36:39 AM4/15/17
to MIT App Inventor Forum
Thanx a lot
download_sound.png

Taifun

unread,
Apr 15, 2017, 10:51:49 AM4/15/17
to MIT App Inventor Forum
use Do it to debug your blocks, see also tip 4 here

khaled alamer

unread,
Apr 15, 2017, 11:19:13 AM4/15/17
to MIT App Inventor Forum
It doesn't works. Please help.
Thx a lot
download_sound.png

Taifun

unread,
Apr 15, 2017, 11:36:43 AM4/15/17
to MIT App Inventor Forum
you might want to provide a screenshot including Do it results
Taifun

khaled alamer

unread,
Apr 15, 2017, 11:45:29 AM4/15/17
to MIT App Inventor Forum
There is no result message comes after click download button

Taifun

unread,
Apr 15, 2017, 12:36:09 PM4/15/17
to mitappinv...@googlegroups.com
There is no result message comes after click download button
instead of the download option use a screenshot tool to take a screenshot including Do it results, see also below

Taifun

Capture the blocks on your browser screen as follows:

======================  Screen Capture  +++++++++++++
On Windows  Ctr + PrtScn  keyboard keys pressed at same time copies an image of the screen to the Windows Clipboard.  Open Paint and save the image by placing the contents of the clipboard into Paint. Save the image to your desktop or another folder as a png or jpg file.  On Win 7 and above you can use the Snipping tool (in Accessories) to capture an image of blocks directly from the screen.  Capture what you need and Save the file to a folder on your PC.

On a Mac,  command-shift-3 (whole-screen) or command-shift-4 (drag a rectangle) to take a screenshot. The image file will appear on your desktop. 

Once you have the image of your blocks, you can drag them to MS Word and I think you can drag the image to PowerPoint.



khaled alamer

unread,
Apr 15, 2017, 1:19:58 PM4/15/17
to MIT App Inventor Forum
Hi Taifun, I couldn't understand what you mean.I attached the aia.Please help me as you can
Thx a lot
download.aia

zac

unread,
Apr 15, 2017, 7:03:33 PM4/15/17
to MIT App Inventor Forum
See my attachments, cleaner and it works.
ZAC.aia
Capture1.PNG

khaled alamer

unread,
Apr 15, 2017, 8:23:36 PM4/15/17
to MIT App Inventor Forum
It works very well. But I want to get value from csv because I have a very big list URL

zac

unread,
Apr 15, 2017, 8:57:01 PM4/15/17
to MIT App Inventor Forum
See the attachments. I updated it to get the URL from your CSV.

Capture1.PNG
ZAC2.aia

khaled alamer

unread,
Apr 15, 2017, 10:46:30 PM4/15/17
to MIT App Inventor Forum
Thank you so much for helping me. 

khaled alamer

unread,
Apr 16, 2017, 7:36:12 AM4/16/17
to MIT App Inventor Forum
Hi Zac,
I am trying to use nested picker on this project, but I don't have enough knowledge to complete it.Please help.
Thank you so much.
NestPick.aia

Taifun

unread,
Apr 16, 2017, 10:42:50 AM4/16/17
to MIT App Inventor Forum
How to create a nested listpicker


A very good way to learn App Inventor is to read the free Inventor's Manual here in the AI2 free online eBook   http://www.appinventor.org/book2 ... the links are at the bottom of the Web page.  The book 'teaches' users how to program with AI2 blocks.
There is a free programming course here http://www.appinventor.org/content/CourseInABox/Intro  and the aia files for the projects in the book are here:  http://www.appinventor.org/bookFiles  
How to do a lot of basic things with App Inventor are described here:  http://www.appinventor.org/content/howDoYou/eventHandling  .

Also do the tutorials http://appinventor.mit.edu/explore/ai2/tutorials.html to learn the basics of App Inventor, then try something and follow the
You will not find a tutorial, which does exactly what you are looking for. But doing the tutorials (not only reading a little bit) help you to understand, how things are working. This is important and this is the first step to do.

Taifun

Trying to push the limits of App Inventor! Snippets and Tutorials from Pura Vida Apps by  Taifun.         



khaled alamer

unread,
Apr 16, 2017, 11:19:00 AM4/16/17
to MIT App Inventor Forum
Still I can't complete the nested picker. please help
Ibraham.aia

Taifun

unread,
Apr 16, 2017, 11:40:14 AM4/16/17
to MIT App Inventor Forum
If you are asking for help, I recommend you to make it as easy for others to be able to help you ...
You probably will get more feedback then...

which means in your case post a screenshot of your relevant blocks...

To download the aia file, upload it to  App Inventor, open it, do some bug hunting for you, etc... this takes time, and most people will not do that...
Thank you.

Taifun

Trying to push the limits of App Inventor! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun. 

khaled alamer

unread,
Apr 16, 2017, 12:04:59 PM4/16/17
to MIT App Inventor Forum
Thank you Taifun for help.Please see attached block.
NestedPicker.png

Taifun

unread,
Apr 16, 2017, 12:08:54 PM4/16/17
to MIT App Inventor Forum
so what exactly does not work? what do you get and what do you expect to get instead?
you might want to add relevant Do it results into the screenshot...
Taifun

khaled alamer

unread,
Apr 16, 2017, 12:28:52 PM4/16/17
to MIT App Inventor Forum
When I open the list Picker, there are two Readers and each Reader has many different chapters that is Mp3 sound,  but the problem is that when I click on the list picker it comes the same result.

zac

unread,
Apr 16, 2017, 5:44:42 PM4/16/17
to MIT App Inventor Forum
See my attachment for the update. 
Now you need a new CSV for each "reader" to include his URL.
In my version, when you add a new CSV file, the name of the CSV files must be "xReader_URL", where (x) is the selectionIndex of the reader
ZAC3.aia
Capture1.PNG

khaled alamer

unread,
Apr 17, 2017, 1:21:34 AM4/17/17
to MIT App Inventor Forum
Thank so much Mr.Zaki!
I really appreciate of your helping me to complete the apps in excellent work and easy to use. Is it possible to remove Chapter listPicker and just open Sura ListPicker directly to be easier because I don't need Chapter at all.
Thank you so much!

zac

unread,
Apr 17, 2017, 1:55:27 AM4/17/17
to MIT App Inventor Forum
No problem brother.
Yes, you can. see my example.
I'm waiting to see your finished app, keep building :)

ZAC4.aia
Capture1.PNG

khaled alamer

unread,
Apr 17, 2017, 6:03:33 AM4/17/17
to MIT App Inventor Forum
Thank you again Mr.Zaki.
Would you please help me to add some blocks to be easy for the user to download the sound into SD Card and listen to that again without download it again.
Thank you a lot Mr.Zaki
ZAC4.aia

khaled alamer

unread,
Apr 18, 2017, 1:11:43 AM4/18/17
to MIT App Inventor Forum
Hi Zaki,
Thank you so much for your help.
Now it is working.
Good luck & Best wishes!

khaled alamer

unread,
Apr 18, 2017, 2:58:47 AM4/18/17
to MIT App Inventor Forum
Hi Zaki,
I am really sorry to bother you my brother.
I am still facing the same problem after download sura.
It doesn't read the  selected sura for selected reader as I want.
Please help if you don't mind.
Thank you so much.
Play_csv.aia

zac

unread,
Apr 18, 2017, 4:07:37 AM4/18/17
to MIT App Inventor Forum
Can you please provide a screenshot of your problem. 

khaled alamer

unread,
Apr 18, 2017, 4:47:01 AM4/18/17
to MIT App Inventor Forum
Hi ZAki,
Attached is a screenshot of my block. Please help.
Thank you
PLAY_CSV.jpg

khaled alamer

unread,
Apr 18, 2017, 9:01:15 AM4/18/17
to MIT App Inventor Forum
Hi Zaki,
Finally, it works very well by using this block. but is it possible to use csv instead of using global for two readers?
Thank you a lot for help.
PLAY_CSV.jpg

khaled alamer

unread,
Apr 18, 2017, 3:59:39 PM4/18/17
to MIT App Inventor Forum
Hi Zaki,
Again it doesn't work as I excepted. Please help:)
I want to play the sound after downloaded in SD card.
Thank you 
PLAY_CSV.jpg

zac

unread,
Apr 18, 2017, 8:29:54 PM4/18/17
to mitappinv...@googlegroups.com
Did you specify the correct path of the downloaded file? 
In the "IF" statement, the file will play only if the path is exist. 

In addition, you need to move some blocks as in my attached.

Capture.PNG

khaled alamer

unread,
Apr 18, 2017, 10:45:01 PM4/18/17
to MIT App Inventor Forum
Hi Zaki,
Yes, the path is correct.
play_reader.jpg

zac

unread,
Apr 18, 2017, 11:22:38 PM4/18/17
to MIT App Inventor Forum
After you select, "Do it" to see if the path is correct (exists). 
Capture.PNG
Capture1.PNG

khaled alamer

unread,
Apr 19, 2017, 12:51:26 AM4/19/17
to MIT App Inventor Forum
Hi Zaki,
I do it, but the result is the same.
When I play any reader, I get the same result for both readers although I put the path correct. 
play_reader.png
Play_csv.aia

zac

unread,
Apr 19, 2017, 1:10:41 AM4/19/17
to MIT App Inventor Forum
You need to specify which reader is selected to do it
Capture.PNG

khaled alamer

unread,
Apr 19, 2017, 1:31:15 AM4/19/17
to MIT App Inventor Forum
That is a great!
Thank you so much Mr.Zaki
You are really a very helpful man I have never seen before and you deserve the paradise.
Good luck my brother!

khaled alamer

unread,
Apr 19, 2017, 1:54:46 AM4/19/17
to MIT App Inventor Forum

khaled alamer

unread,
Apr 20, 2017, 2:51:43 AM4/20/17
to MIT App Inventor Forum
Hi Mr Zaki,
Is it possible to build a block in order to download the sound directly without open black sound screen?

Screenshot_٢٠١٧-٠٤-٢٠-٠٩-٤٦-٠٠.png

zac

unread,
Apr 20, 2017, 3:33:23 AM4/20/17
to mitappinv...@googlegroups.com
Upload your files to your own hosting-space OR  to online cloud that support direct link download. 


See if this works:
If you are using Chrome browser do like my attachments and change your CSV to the new links.
Capture.PNG
Capture2.PNG
Capture3.PNG

khaled alamer

unread,
Apr 20, 2017, 3:59:57 AM4/20/17
to MIT App Inventor Forum
Can you please send me any link about online cloud to know more about how to do that?
I am so interested to know more.
Is it free of charge or limited?

khaled alamer

unread,
Apr 20, 2017, 4:17:42 AM4/20/17
to MIT App Inventor Forum
Can you please give me more detail about:
See if this works:
If you are using Chrome browser do like my attachments and change your CSV to the new links.
I am sure I will accept what you are suggesting to me.
Thx

zac

unread,
Apr 20, 2017, 6:36:18 AM4/20/17
to mitappinv...@googlegroups.com






1.




Just follow the steps for each Sura to get its direct download link. These steps are for the chrome browser. 



https://drive.google.com/file/d/0B6tIqrqfHzcnc0hzMFFDU3lfMFE/view?usp=sharing








2. 
















 And then replace the old links with the new ones you obtained.

khaled alamer

unread,
Apr 20, 2017, 7:18:30 AM4/20/17
to MIT App Inventor Forum
Hi Zaki,
I have done all steps but there is a message shown when It starts download sura.
egnor.png

zac

unread,
Apr 20, 2017, 7:27:00 AM4/20/17
to MIT App Inventor Forum

zac

unread,
Apr 20, 2017, 7:39:09 AM4/20/17
to MIT App Inventor Forum
This website will convert your drive link to a direct download link http://gdurl.com/



khaled alamer

unread,
Apr 20, 2017, 9:48:59 AM4/20/17
to MIT App Inventor Forum
I think this link will not download Sura directly there is also the same message shown up.:
Google Drive can't scan this file for viruses.
I think to let it as it is, that is much better than get too much hard work :)
message.png

zac

unread,
Apr 20, 2017, 10:06:46 AM4/20/17
to mitappinv...@googlegroups.com

OK don't use the website. Use the first steps I showed you.
I tested it. It downloads without shown the message on the phone.

khaled alamer

unread,
Apr 20, 2017, 1:29:17 PM4/20/17
to MIT App Inventor Forum
I am sorry to bother you. Actually, I tried but unfortunately it couldn't be loaded directly. 
ZAC4.aia
url.png

khaled alamer

unread,
Apr 20, 2017, 6:26:21 PM4/20/17
to MIT App Inventor Forum
I am trying to pick sura from csv but fortuneteller I can't build that one in correct way. 
Pick_sura_from_csv.aia
pick_sura_from_csv.png

khaled alamer

unread,
Apr 22, 2017, 6:01:46 PM4/22/17
to MIT App Inventor Forum
Hi Zaki, I have done the same way for each reader but after 5 readers,It couldn't compile. There is error. Is it possible to simplify the way in order to repeat for each reader instead of building a very long blocks.
Thank you.
Capture.PNG

khaled alamer

unread,
Apr 22, 2017, 6:06:48 PM4/22/17
to MIT App Inventor Forum
Hi Zaki, I have done the same way for each reader but after 5 readers,It couldn't compile. There is error. Is it possible to simplify the way in order to repeat for each reader instead of building a very long blocks. 
Also,I am trying to pick sura from csv but unfortuneteller I can't build that one in correct way. 


Thank you.

Capture.png
Pick_sura_from_csv.aia
pick_sura_from_csv.png
Reply all
Reply to author
Forward
0 new messages