Import CSV into DataBase using UniGUI-based Program

[jemmyhatta]

Hi,

 

I have some need to take some data from the CSV format. Is it able in UniGUI? To read /importing some CSV files to UniGUI based program? What third party components I have to have to do that? To import that CSV files into the database. Thanks.

[ldb68]

Hi,

 

I have some need to take some data from the CSV format. Is it able in UniGUI? To read /importing some CSV files to UniGUI based program? What third party components I have to have to do that? To import that CSV files into the database. Thanks.

This work has nothing to do with unigui.

A CSV is a text file. Each row contains data separated by ",".

You have to read the file (with a TStringList) line by line and split the line in the destination fields.

Then you have to save each field in the target table ...

 

PS: 

see http://stackoverflow.com/questions/4854310/how-can-i-read-and-write-csv-in-a-way-similar-to-net-filehelpers

for a JvCsvDataSet  (Jedi project) --> a dataset to import csv data

So you don't need to write the parsing code ...

[adragan]

First you have to upload the csv to the server in a folder that is accessible by the application. ( See upload demo )

After that you can import it ( write the respective code yourself !) to where ever you like.

[jemmyhatta]

Ok. Thanks.