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: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: Dbf To MySql 'New' Table

Post by Rathinagiri »

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: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: Dbf To MySql 'New' Table

Post by sudip »

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: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: Dbf To MySql 'New' Table

Post by Rathinagiri »

Hi,

I had attached a new version of DBF2MySQL.
dbf2mysql new.zip
(28.13 KiB) Downloaded 883 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 10850 times
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
sudip
Posts: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: Dbf To MySql 'New' Table

Post by sudip »

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: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: Dbf To MySql 'New' Table

Post by Rathinagiri »

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: 3718
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: Dbf To MySql 'New' Table

Post by mol »

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: 3718
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: Dbf To MySql 'New' Table

Post by mol »

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

Uff, One problem less :)
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 To MySql 'New' Table

Post by Rathinagiri »

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: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: Dbf To MySql 'New' Table

Post by sudip »

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:

Re: Dbf To MySql 'New' Table

Post by swapan »

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