Barcode and Database

Marketplace Request
, , , , ,
#21

Airtable is also a good choice. Try this free extension:
http://www.kevinkun.cn/airtable.html.

#22

Yes, Indeed
But he hs a data of 1000 + row so that becomes eligible for paid plan, thats the reason i didnt recommend it yet to him

#23

Thanks for your reminder to know the airtable free plan only allow 1200 records per base.
maybe airtable not suitable for this project.

1 Like
#24

Hey everybody

I sent again. But i sent like a txt file. It mean .csv .

data.txt (206.6 KB)

Also i want to make the app with local database. I can convert every file to my file.
Or i can use google sheets. Because its free everytime :slight_smile:

Thanks for all supports.

#25

Try this one BarcodeDatabase.aia (68.4 KB)

#26

Thanks Boban.
Its looking very good :slight_smile:
But i have a problem. I didnt work. When i select the data.csv i see that

1
11593×848 120 KB

Label to Text for Barcode
#27

Ahh sorry, try this one BarcodeDatabase.aia (97.3 KB)

1 Like
#28

Thanks Boban for all.

Can u try for me that app with this barcode. It is first row barcode. I tried a lot of time but it didnt work.

indir

#29

I don’t have that number…

bild

you want 1234567 but in excel is 1235467

1 Like
#30

Yeah sorry i wanted to send 123456 :slight_smile:

indir (1)

#31

Works as it should

Screenshot_20210115-201550
Screenshot_20210115-2015501440×2960 143 KB

1 Like
#32

Thanks Boban for all supports.

I see now.
I didnt found my android phone. So i used emulator. It is not working good at emulator. Because camera working like a mirror. Its working all then.

Thanks again :slight_smile:

1 Like
#33

I want to thank all the helpers. :slight_smile:
I will improve myself about Kodular.io after that.

1 Like
#34

Hey again Boban.

I want to ask a thing too :slight_smile:

My DB will be more than 5000.It will be almost 100.000. When i 100.000 rows an csv app is closed.
How can i change with big DB?

#35

Sorry for the sincerity. Use Relational databases / Database Manager.

Real databases are not spreadsheets.

#36

Thanks Rogerio.
im trying new things. I want to do that double database it mean local and with firebase. If i dont connect internet i will continue to use app with local database. So i need to do this firstly. It wont basic i know. But im working :slight_smile:

1 Like
#37

This post was flagged by the community and is temporarily hidden.

#38

English , Please. :+1:t2:

1 Like
#39

Hey again everyone
Sorry for this.

I have some problem with the project. Can u help me ?

-In this project can read just 5000 row but i have 100.000 row. So its not working. I didnt find anything about rows size.

-Also my .csv file is seperate with semicolon(; ) Because my database have comma(,) so i need to seperate with semicolon(; ) How can i do i dont know its not basically.

-Also first label is scanned barcode. I want to change with textbox. When it is textbox. If i write in textbox any barcode i want to find without scanner. I didnt find when i write anything in textbox how can i take this text for add to code.

Can u help me about these?
Thanks for your supports.

1 Like
#40

Well, If you had mentioned this from the beginning that it will be 25000, 50000, 100000 then I would advise you to do it in a different way…

Perhaps using SQLite component, you might want to search the community about SQLite

P.S. Putting 100.000 rows instantly in list/db might overwhelm any device, thereby either read mutiple files or from the big file read 5000 lines at a time…