DBF<-->SQLite Exporter

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

Moderator: Rathinagiri

User avatar
Rathinagiri
Posts: 5173
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 136 times
Been thanked: 131 times
Contact:

DBF<-->SQLite Exporter

Post by Rathinagiri » Tue Oct 11, 2011 3:49 pm

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 6890 times
dbf2sqlite02.jpg
dbf2sqlite02.jpg (42.08 KiB) Viewed 6890 times
dbf2sqlite03.jpg
dbf2sqlite03.jpg (15.01 KiB) Viewed 6890 times
dbf2sqlite04.jpg
dbf2sqlite04.jpg (18.94 KiB) Viewed 6890 times
dbf2sqlite05.jpg
dbf2sqlite05.jpg (18.08 KiB) Viewed 6890 times
dbf2sqlite06.jpg
dbf2sqlite06.jpg (14.98 KiB) Viewed 6890 times
dbf2sqlite07.jpg
dbf2sqlite07.jpg (14.91 KiB) Viewed 6890 times
dbf2sqlite08.jpg
dbf2sqlite08.jpg (4.76 KiB) Viewed 6890 times
Attachments
dbf2sqlite.zip
(32.26 KiB) Downloaded 892 times
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
esgici
Posts: 4346
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 234 times
Been thanked: 80 times
Contact:

Post by esgici » Tue Oct 11, 2011 4:01 pm

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: 5173
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 136 times
Been thanked: 131 times
Contact:

Post by Rathinagiri » Tue Oct 11, 2011 4:13 pm

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: 4346
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 234 times
Been thanked: 80 times
Contact:

Post by esgici » Tue Oct 11, 2011 4:33 pm

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: 5173
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 136 times
Been thanked: 131 times
Contact:

Post by Rathinagiri » Tue Oct 11, 2011 4:45 pm

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: 4346
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 234 times
Been thanked: 80 times
Contact:

Post by esgici » Tue Oct 11, 2011 5:14 pm

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: 5173
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 136 times
Been thanked: 131 times
Contact:

Post by Rathinagiri » Tue Oct 11, 2011 7:03 pm

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: 4346
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 234 times
Been thanked: 80 times
Contact:

Post by esgici » Tue Oct 11, 2011 7:41 pm

Thanks :)

I will wait.

Best regards

--

Esgici
Viva INTERNATIONAL HMG :D

User avatar
bpd2000
Posts: 953
Joined: Sat Sep 10, 2011 4:07 am
Location: India
Has thanked: 127 times
Been thanked: 43 times

Post by bpd2000 » Wed Oct 12, 2011 4:31 am

Dear rathinagiri

Excellant, Good utility

BPD
BPD
Convert Dream into Reality through HMG

User avatar
Rathinagiri
Posts: 5173
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 136 times
Been thanked: 131 times
Contact:

Post by Rathinagiri » Wed Oct 12, 2011 8:26 am

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

Post Reply