DBF<-->SQLite Exporter

Utilities like DBU, Make, IDE written in HMG/ used to create HMG based applications

Moderator: Rathinagiri

User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

DBF<-->SQLite Exporter

Post 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 17689 times
dbf2sqlite02.jpg
dbf2sqlite02.jpg (42.08 KiB) Viewed 17689 times
dbf2sqlite03.jpg
dbf2sqlite03.jpg (15.01 KiB) Viewed 17689 times
dbf2sqlite04.jpg
dbf2sqlite04.jpg (18.94 KiB) Viewed 17689 times
dbf2sqlite05.jpg
dbf2sqlite05.jpg (18.08 KiB) Viewed 17689 times
dbf2sqlite06.jpg
dbf2sqlite06.jpg (14.98 KiB) Viewed 17689 times
dbf2sqlite07.jpg
dbf2sqlite07.jpg (14.91 KiB) Viewed 17689 times
dbf2sqlite08.jpg
dbf2sqlite08.jpg (4.76 KiB) Viewed 17689 times
Attachments
dbf2sqlite.zip
(32.26 KiB) Downloaded 1319 times
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
esgici
Posts: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: DBF->SQLite Exporter

Post 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
Viva INTERNATIONAL HMG :D
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: DBF->SQLite Exporter

Post by Rathinagiri »

Hi Esgici,

How can you ask such type of questions?!

The answer is, 'Yes, with pleasure'. :)
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
esgici
Posts: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: DBF->SQLite Exporter

Post 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
Viva INTERNATIONAL HMG :D
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: DBF->SQLite Exporter

Post by Rathinagiri »

esgici wrote: Sorry :(
Nothing to worry Esgici. :) You need not ask this question. That is what I tried to express.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
esgici
Posts: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: DBF->SQLite Exporter

Post 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
Viva INTERNATIONAL HMG :D
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: DBF->SQLite Exporter

Post by Rathinagiri »

Esgici,

Yes, it is very much possible at least for the tables created using this utility. Let me try and do it.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
esgici
Posts: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: DBF->SQLite Exporter

Post by esgici »

Thanks :)

I will wait.

Best regards

--

Esgici
Viva INTERNATIONAL HMG :D
User avatar
bpd2000
Posts: 1207
Joined: Sat Sep 10, 2011 4:07 am
Location: India

Re: DBF->SQLite Exporter

Post by bpd2000 »

Dear rathinagiri

Excellant, Good utility

BPD
BPD
Convert Dream into Reality through HMG
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: DBF->SQLite Exporter

Post 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 1127 times
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
Post Reply