Download, Read and Search csv file

MIT App Inventor Help
#1

Hi at all!
I am creating a project to scan the warehouse codes.
I would like to create an application that allows me to read barcodes and find the result in a csv file.
I had thought of such a thing:

  • download the updated CSV file from GDrive
  • scan the barcode
  • I look for the correspondence of the scan code in the downloaded csv file
  • have the second or third line of the csv as an answer

Can help me?
Thanks

#2

Perhaps something like this:

  • Fetch File by File - #14 by TIMAI2
  • Search community for QRcodes. Use the advice to scan the code and retrieve a bar code value.
  • convert csv to a List, then search the List for the bar code

What have you tried? What you need to do depends on your familiarity with App Inventor.

Here are some resources to help you learn to use the AI2 tools. A very good way to learn App Inventor is to read the free Inventor's Manual here in the AI2 free online eBook App Inventor 2 Book: Create Your Own Android Apps ... 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 Course In A Box and the aia files for the projects in the book are here: App Inventor 2 Book: Create Your Own Android Apps

How to do a lot of basic things with App Inventor are described here: How do you...? .

Also look here App inventor español. Offline. Tutorial. Ejemplos. Instalación. Códigos. Juegos. Curso gratis de App inventor. and here Tutorial Index | Imagnity for more tutorials.

Learn about components Component Reference
and visit the Library The MIT App Inventor Library: Documentation & Support Help>Library on the MENU

1 Like
#3

I've already built a few apps with AI2 so I'm a bit familiar with programming.
For now I have created these blocks:

blocks (9)
blocks (9)1021×442 73.2 KB

The first problem I encountered is downloading the GDrive file, AI2 downloads me a file with .tmp extension and I don't understand where the error is.
I have already created the method of reading with barcode and I can get the result of the reading carried out.

#4

Try to use as url https://drive.google.com/uc?export=download&id=your_spredsheetID_here and see if it works for you

#5

Not work, the file downloed is ".html". :thinking:

#6

grafik
grafik1130×161 18.6 KB

grafik
grafik947×66 4.46 KB

#7

Btw, this should work without storage permissions (WRITE) on API ≥ 19 (KitKat, Android 4.4+) .

#8

With this method the file is downloaded successfully.
Now the problem is in the read and write permissions which are not allowed. I try with "android.permission.READ_EXTERNAL_STORAGE" and "READ_EXTERNAL_STORAGE"

blocks (11)
blocks (11)980×1075 134 KB

How should I do?

#9

Set DefaultFileScope to Legacy in the Designer.

grafik

#10

grafik
grafik800×451 90.4 KB

#11

The file not found, but in the folder exist.

blocks (12)
blocks (12)874×1074 116 KB

WhatsApp Image 2022-01-14 at 11.32.42
WhatsApp Image 2022-01-14 at 11.32.42970×2048 88.4 KB

#12

The file open correctly.

blocks (13)
blocks (13)873×877 105 KB

Now I would like to create a list view with the data inside the csv file.
Then, with the barcode scanner, enter the scanned text in the search bar of the listview.
How do i do it?

#13

I was able to read the csv file and put it in a listview. I enclose the blocks in case someone might need them.

blocks (16)
blocks (16)779×1568 193 KB

#14

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.