Dbf To MySql 'New' Table

You can share your experience with HMG. Share with some screenshots/project details so that others will also be benefited.

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:

Re: Dbf To MySql 'New' Table

Post by Rathinagiri » Sat May 02, 2009 3:57 pm

I had used an open source software called camstudio (Free Screen Recording Software) to capture the screen and save the file as avi.

I use this software to create training presentations because, a picture is worth 1000 words and movie is worth 1000 pictures.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
sudip
Posts: 1444
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India
Has thanked: 4 times

Post by sudip » Sun May 03, 2009 5:04 am

rathinagiri wrote:I had used an open source software called camstudio (Free Screen Recording Software) to capture the screen and save the file as avi.

I use this software to create training presentations because, a picture is worth 1000 words and movie is worth 1000 pictures.
Thanks a lot!!! CamStudio is an excellent software. :) I shall use it also for training purpose also!!!

Now, I have a suggestion for your Dbf2MySql software. When a dbf table is selected, it's name (alias()) will be stored to New Table Name of MySql.

With best regards.

Sudip
With best regards,
Sudip

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 Jun 23, 2009 9:15 am

Hi,

I had attached a new version of DBF2MySQL.
dbf2mysql new.zip
(28.13 KiB) Downloaded 396 times
Change log:

1. Fixed some errors.
2. Now, maximum of 20 records are exported in every query to increase the speed.
3. Small logo & icon designed for the utility.
dbf2mysql.jpg
dbf2mysql.jpg (10.86 KiB) Viewed 2052 times
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
sudip
Posts: 1444
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India
Has thanked: 4 times

Post by sudip » Tue Jun 23, 2009 1:11 pm

Hi Rathi,
rathinagiri wrote: Change log:
1. Fixed some errors.
2. Now, maximum of 20 records are exported in every query to increase the speed.
3. Small logo & icon designed for the utility.
Thanks a lot for sharing! :-)
Excellent!!!
I like the logo!!!
Regards.
Sudip
With best regards,
Sudip

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 Jun 23, 2009 1:56 pm

Thanks Sudip.

I think the executable utility can be shared in the public.

I do have a doubt. Whether we require the libmysql.dll along with the executable or not?! :)
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
mol
Posts: 2856
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 127 times
Been thanked: 65 times
Contact:

Post by mol » Fri Oct 02, 2009 8:25 am

Hi guys!
I'm refreshing this topic.
I'm testing MySQL for use in my project and I have problem with national charactes - ąćęłńóśżź ĄĆĘÓŁŃÓŚŻŹ while translating dbf to MySQL table.
First, I've tried my own routine, later I've tried to use your's converter.
Always the same problem - Error while saving records with national character. The only way to resolve this problem is to change definition of character fields from VarChar to VarBinary.
Please write, if you know another way.

And the second:
Problem with translating empty date fields.
In your project empty date is convertet to "00000000".
I've tested, that it may be converted to "null"

Best regards, Marek

PS.
When I run "SELECT .... " to retrieve date field, I get empty char value??? What's going on?!

I love dbf files !!!

User avatar
mol
Posts: 2856
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 127 times
Been thanked: 65 times
Contact:

Post by mol » Mon Oct 05, 2009 8:48 am

I found that date fields are retrieved correctly when SET CENTURY is ON.

Uff, One problem less :)

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 » Mon Oct 05, 2009 9:03 am

Thanks for the info. :)
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
sudip
Posts: 1444
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India
Has thanked: 4 times

Post by sudip » Mon Oct 05, 2009 12:40 pm

I use DTOS() and STOD() functions, as some DBMS (eg., Sqlite) don't have date field!!! Moreover date conversion is correct also for DBMS having date field type :)
With best regards.
Sudip
With best regards,
Sudip

User avatar
swapan
Posts: 242
Joined: Mon Mar 16, 2009 4:23 am
Location: Kolkata, India
Contact:

Post by swapan » Tue Oct 06, 2009 4:23 am

rathinagiri wrote:Here comes the avi capture of the utility running without any errors.
Guys sorry for not able to give value-added inputs in this thread, but plz. allow me to share the following:

Dear Rathi:
it was so nice to see a capsule created in Camtasia. I used it a few years back - when my previous employer introduced it to me & said with this you can create audio/video tutorials/presentations. Really its a nice tool.

But is it free?! Not visited their site ever since.........................

Rgds,

Swapan
[Rathi, its great to see that u single handedly gather so much info. about different products - yes internet is such a great tool!]
Thanks & Regards,
Swapan Das

http://www.swapandas.com/

Post Reply