Load a text file into SQLlite or MySQL - Delphi Application
$30-250 USD
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
Project ID: #25757824
About the project
Awarded to:
Hi, I can make delphi app which parses txt files according to separators you have discribed. And loads it into MySQL table.
14 freelancers are bidding on average $169 for this job
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.
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
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...
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
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
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.
I already made a demo app for reading and parsing the file. Please contact me so I can show it to you.
Exe app to mysql, but I will code it in python. Let me know if you're interested. Hablo español.
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