Barcode and Database

[Boban (Boban Stojmenovic)]

I don’t have that number…

you want 1234567 but in excel is 1235467

[esad18 (m.esad)]

Yeah sorry i wanted to send 123456

[Boban (Boban Stojmenovic)]

Works as it should

[esad18 (m.esad)]

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

[esad18 (m.esad)]

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

[esad18 (m.esad)]

Hey again Boban.

I want to ask a thing too

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?

[Rogerio_Rios (Professional Support)]

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

Real databases are not spreadsheets.

[esad18 (m.esad)]

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

[esad18 (m.esad)]

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

[Rogerio_Rios (Professional Support)]

@esad18

Bu projede sadece 5000 satır okuyabilirim ama 100.000 satırım var. Yani çalışmıyor. Satır boyutu hakkında hiçbir şey bulamadım.

English , Please.

[esad18 (m.esad)]

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.

[Boban (Boban Stojmenovic)]

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…

[esad18 (m.esad)]

@Boban

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…

I didnt know about this anything sorry @Boban So i cant change this DB when i use like that. So i need to add other rows with that.

@Boban

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

Most of the people advice to me. So i will try with that. But i need to use that app with like that database now. So i need to increase DB size. Can u help me about it.

@Boban

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…

@esad18

-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.

Can u help me about these? I didnt find anything.

[Rogerio_Rios (Professional Support)]

You need to export your data to an SQL database.

[esad18 (m.esad)]

I will do it still. I need to time for doing SQL. How can i integrate SQL to the project? Because The project is very usefull.

[Rogerio_Rios (Professional Support)]

SQL is the language. Sqlite and Mysql are Relational databases that use SQL. Locally you will use Sqlite. On the web you will use MySQL. In the community there are 2 examples without extension. These examples use PHP Scripts + Kodular Blocks.

MySQLi. PHP. GET. POST. Insert. Update. Delete. Segur SQL Inject

Hello friends, I have published a basic tutorial on MySQLi and PHP in the App Inventor Community, I think it is better to put a link in this forum so as not to repeat the same thing. The tutorial deals with 3 examples: 1.- MySQLi + PHP + GET 2.- MySQLi + PHP + POST 3.- MySQLi + PHP + Web page In these examples I use the 000webhost server. The forum link is: I have also put it in Spanish: App inventor. App inventor y MySQLi. PHP. GET. POST. Página web. Base de datos [mysqlwebhost9] …

https://puravidaapps.com/mysql.php

And there is a paid extension.

MySQL Extension - Call Sql Operations Without Script [PAID]

MySQL Extension This extension allows you to call Sql operations without using any script. This can connect to the MySQL Database with it’s url,username and password. It would connect to the server directly with JDBC, there won’t be any kind of third party interfering in the connection, the connection is directly between Your Application And The MySQL Server. [jdbc] Image From : JDBC Tutorial There is one more specialty of this extension, It supports prepared statement block to prevent Sql …

[esad18 (m.esad)]

Thanks @Rogerio_Rios

I created my .db file. I learn something. I need to how to import and read this without any price So can you help me for this. I didnt understand nothing at the forum topics.

Can someone say me this;
If u have a .db file how can u import this file in kodular and how can u read, search with id this data.

[esad18 (m.esad)]

Hey @Boban when i try to make new app can u help me for ur created project with .csv
I just want to ask that; If my file like that

barcode | text1 | text2 | number1 | number2 | number3
987654321987 | first text | second text | 25,88 | 25,21 | 23,65
987654321986 | first text1 | second text1 | 55,54 | 65,47 | 73,77
987654321985 | first text | second text | 25,32 | 25,61 | 63,25
123456 | first text1 | second text1 | 55,45 | 75,96 | 63,33
…
.
.

How can i seperate csv commas and commas of my file?
I save .csv with ;

Also Can you say me how to increase 5000 rows than more.
Can you help me for this?

[esad18 (m.esad)]

Hey @Boban

First of all thanks for your all supports. I have really good project thanks to you.
But i have some problems. Also u know im new here.
I’m really waiting a reply from you. If you dont want to continue to help please say me this.
I wont wait anymore.
I’m looking here everyday almost 10 times or more. If i can do it. I didnt say these to you. But i didnt anything the problems.
Please say me.

Thanks for all.