Page 1 of 5

DBF<-->SQLite Exporter

Posted: Tue Oct 11, 2011 3:49 pm
by Rathinagiri
Hi all,

Here is a small utility to export one or more dbf table(s) to SQLite database. You can either create a SQLite DB or select an existing DB.

This utility requires hmgsqlite library which is already available with HMG 3.0.39


dbf2sqlite01.jpg
dbf2sqlite01.jpg (14.01 KiB) Viewed 6121 times
dbf2sqlite02.jpg
dbf2sqlite02.jpg (42.08 KiB) Viewed 6121 times
dbf2sqlite03.jpg
dbf2sqlite03.jpg (15.01 KiB) Viewed 6121 times
dbf2sqlite04.jpg
dbf2sqlite04.jpg (18.94 KiB) Viewed 6121 times
dbf2sqlite05.jpg
dbf2sqlite05.jpg (18.08 KiB) Viewed 6121 times
dbf2sqlite06.jpg
dbf2sqlite06.jpg (14.98 KiB) Viewed 6121 times
dbf2sqlite07.jpg
dbf2sqlite07.jpg (14.91 KiB) Viewed 6121 times
dbf2sqlite08.jpg
dbf2sqlite08.jpg (4.76 KiB) Viewed 6121 times

Re: DBF->SQLite Exporter

Posted: Tue Oct 11, 2011 4:01 pm
by esgici
rathinagiri wrote:...utility to export one or more dbf table(s) to SQLite database
Nice utility, thank you so much, Rathi :)

Could you allow me using it in my applications ?

Best regards

--

Esgici

Re: DBF->SQLite Exporter

Posted: Tue Oct 11, 2011 4:13 pm
by Rathinagiri
Hi Esgici,

How can you ask such type of questions?!

The answer is, 'Yes, with pleasure'. :)

Re: DBF->SQLite Exporter

Posted: Tue Oct 11, 2011 4:33 pm
by esgici
rathinagiri wrote: How can you ask such type of questions?!
Sorry :(
The answer is, 'Yes, with pleasure'. :)
Thanks you very much, again :)

Best regards

--

Esgici

Re: DBF->SQLite Exporter

Posted: Tue Oct 11, 2011 4:45 pm
by Rathinagiri
esgici wrote: Sorry :(
Nothing to worry Esgici. :) You need not ask this question. That is what I tried to express.

Re: DBF->SQLite Exporter

Posted: Tue Oct 11, 2011 5:14 pm
by esgici
Hi Rathi

Yes, you are right.

Two year ago this SQLite subject discussed in a thread introduced by our friend Sudip with title of My First SQLite Project and noticed there automatically adding records from dbf to SQLite db. This was good news. Bad news was non-existence of some field types of DBF systems in the SQLite. Frankly speaking, I was afraid and don't look closely this subject.

Now, I'm thinking re-discover.

And my "newbie" question is : is it possible reverse of your last util, that is SQLite to DBF ?

I guess this isn't necessary for majority, but who know, it will be a day.

Best regards

--

Esgici

Re: DBF->SQLite Exporter

Posted: Tue Oct 11, 2011 7:03 pm
by Rathinagiri
Esgici,

Yes, it is very much possible at least for the tables created using this utility. Let me try and do it.

Re: DBF->SQLite Exporter

Posted: Tue Oct 11, 2011 7:41 pm
by esgici
Thanks :)

I will wait.

Best regards

--

Esgici

Re: DBF->SQLite Exporter

Posted: Wed Oct 12, 2011 4:31 am
by bpd2000
Dear rathinagiri

Excellant, Good utility

BPD

Re: DBF->SQLite Exporter

Posted: Wed Oct 12, 2011 8:26 am
by Rathinagiri
Hi,

As per Esgici's request, I have changed DBF->SQLite Exporter to DBF<-->SQLite Exporter. :)

Now, a SQLite Table can be exported to DBF. It seems to work fine for me. Kindly let me know if there is any bug/error...

Thank you.
dbf2sqlite.zip
(32.26 KiB) Downloaded 712 times