Page 3 of 4

Re: Dbf To MySql 'New' Table

Posted: Sat May 02, 2009 3:57 pm
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.

Re: Dbf To MySql 'New' Table

Posted: Sun May 03, 2009 5:04 am
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

Re: Dbf To MySql 'New' Table

Posted: Tue Jun 23, 2009 9:15 am
by Rathinagiri
Hi,

I had attached a new version of DBF2MySQL.
dbf2mysql new.zip
(28.13 KiB) Downloaded 544 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 4692 times

Re: Dbf To MySql 'New' Table

Posted: Tue Jun 23, 2009 1:11 pm
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

Re: Dbf To MySql 'New' Table

Posted: Tue Jun 23, 2009 1:56 pm
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?! :)

Re: Dbf To MySql 'New' Table

Posted: Fri Oct 02, 2009 8:25 am
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 !!!

Re: Dbf To MySql 'New' Table

Posted: Mon Oct 05, 2009 8:48 am
by mol
I found that date fields are retrieved correctly when SET CENTURY is ON.

Uff, One problem less :)

Re: Dbf To MySql 'New' Table

Posted: Mon Oct 05, 2009 9:03 am
by Rathinagiri
Thanks for the info. :)

Re: Dbf To MySql 'New' Table

Posted: Mon Oct 05, 2009 12:40 pm
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

Re: Dbf To MySql 'New' Table

Posted: Tue Oct 06, 2009 4:23 am
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!]