Load a text file into SQLlite or MySQL - Delphi Application

Completed Posted 3 years ago Paid on delivery
Completed Paid on delivery

Hello

We need an Delphi app whose function will be load a text file into SQLlite and MySQL Database (Both)

The main exe is a simple form with two buttons (Button 1 -> load txt and build a SQLite DB file), (Button 2 -> load the txt, connect to MySQL and fill the table)

Fort he second exe there are two options:

Option 1: Run a web-service with modern UI to show the SQLite Data

Option 2: A form with a nice interface capable to show large amount of data without lag

Notes:

1. Separators are not the same for each column in the txt file

Example:

03/05/2020$H14:17:57$Vexcel$T--$EPC$Ujmospina$R[login to view URL]$[login to view URL]

These Will be the columns at the Table:

FECHA -> The value before $H separator

HORA -> The value after $H separator

TIPO -> The value after time column, txt file contains $V or $I, the value to be stored is V or I (without $)

DESCRIPCION -> The value before $T separator

TITULO -> The value before $E separator

EQUIPO -> The value before $U separator

USUARIO -> The value before $R separator

DIR_IP -> The value before $X separator

EJECUTABLE -> The value after $X separator

2. The developer Will provide a compiled exe with the instructions to configure the database (as a Demo, Developer can choose DB Name, DB User…)

4. For SQLite a second exe is needed as a web interface or web service showing the data stored at SQLite, developer could use Html5 for the interface (suggest), we want a modern UI. For MySQL a second exe is not required

5. The developer Will choose the best Delphi versión for this Project accordint to previous experience

6. Both solutions has to be capable to process txt files bigger than 150MB

Delphi Software Architecture SQL MySQL Software Development

Project ID: #25757824

About the project

14 proposals Remote project Active 3 years ago

Awarded to:

Vladius85

Hi, I can make delphi app which parses txt files according to separators you have discribed. And loads it into MySQL table.

$80 USD in 2 days
(13 Reviews)
4.3

14 freelancers are bidding on average $169 for this job

vano101

Hello I have several years of experience with Delphi and both SQLite and MySQL About SQLite - there is free SQLIteAdmin app that can open SQLite data file and show tables.

$137 USD in 2 days
(1027 Reviews)
7.6
expertcoder1vw

Hi, I'm a Delphi developer, using the latest Delphi 10.4 Sydney, and can develop this app with MySQL as the back-end database. Estimate delivery in: 4 days or less Good quality work done. Thanks for considering my bi More

$350 USD in 4 days
(102 Reviews)
6.5
BestDevGod

I have more than 20 years experience of Delphi, C,C++ Developer. I have experience in Windows API, Network API,System programming,... I can do it very fast and reliable. Please contact me...

$250 USD in 1 day
(13 Reviews)
5.5
Shendiqerimi

Hello, I have read your description carefully & I believe I got what you want. I'm fluent in c#/VB.NET/DELPHI with more than 7 years of experience. I can give you satisfy result within 12 hours. Please send me a messag More

$140 USD in 1 day
(17 Reviews)
5.4
WilliamArispe

Why Delphi? You can get this quickly by MySQL stuff and create a Log to see the results. Contact me and we will talk about. Porqué el Delphi? Esto lo puedes hacer con sólo MySQL y generar unos Logs para ver el resultad More

$150 USD in 1 day
(15 Reviews)
4.9
l060448

Hi, I have 6+ years of application development experience. I have developed several windows desktop, web and windows service apps in C#. Delphi is also not a problem. I have understood most of the requirements, few not More

$190 USD in 7 days
(4 Reviews)
4.6
alexandersapov

Hello! I can do it with mysql and latest delphi. Thanks

$140 USD in 7 days
(12 Reviews)
4.5
igorchrepanovdev

hi, nice to meet you. i have read your details carefully. i have rich experience in delphi i have ever done like this project . i can give you good result in short time. please contact me.

$140 USD in 7 days
(3 Reviews)
3.7
vw7105461vw

I already made a demo app for reading and parsing the file. Please contact me so I can show it to you.

$300 USD in 3 days
(2 Reviews)
3.3
zotil

Exe app to mysql, but I will code it in python. Let me know if you're interested. Hablo español.

$200 USD in 3 days
(2 Reviews)
3.1
kuetedonald

Ready to work

$60 USD in 7 days
(0 Reviews)
0.0
ajay25027

I will provide best service to execute your data file withouth any problem and guarratied solution. Thanks & Regards Relevant Skills and Experience I am Working From 10 years in Sap and Erp service for copanies

$156 USD in 3 days
(0 Reviews)
0.0