Dbf To MySql 'New' Table
Moderator: Rathinagiri
- 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
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.
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.
South or North HMG is worth.
...the possibilities are endless.
Re: Dbf To MySql 'New' Table
Thanks a lot!!! CamStudio is an excellent software.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.
![Smile :)](./images/smilies/icon_e_smile.gif)
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
Sudip
- 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
Hi,
I had attached a new version of DBF2MySQL.
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.
I had attached a new version of DBF2MySQL.
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.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
Re: Dbf To MySql 'New' Table
Hi Rathi,
Excellent!!!
I like the logo!!!
Regards.
Sudip
Thanks a lot for sharing!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.
![Smile :-)](./images/smilies/icon_e_smile.gif)
Excellent!!!
I like the logo!!!
Regards.
Sudip
With best regards,
Sudip
Sudip
- 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
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?!![Smile :)](./images/smilies/icon_e_smile.gif)
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?!
![Smile :)](./images/smilies/icon_e_smile.gif)
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
Re: Dbf To MySql 'New' Table
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 !!!
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
I found that date fields are retrieved correctly when SET CENTURY is ON.
Uff, One problem less![Smile :)](./images/smilies/icon_e_smile.gif)
Uff, One problem less
![Smile :)](./images/smilies/icon_e_smile.gif)
- 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
Thanks for the info. ![Smile :)](./images/smilies/icon_e_smile.gif)
![Smile :)](./images/smilies/icon_e_smile.gif)
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
Re: Dbf To MySql 'New' Table
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 ![Smile :)](./images/smilies/icon_e_smile.gif)
With best regards.
Sudip
![Smile :)](./images/smilies/icon_e_smile.gif)
With best regards.
Sudip
With best regards,
Sudip
Sudip
Re: Dbf To MySql 'New' Table
Guys sorry for not able to give value-added inputs in this thread, but plz. allow me to share the following:rathinagiri wrote:Here comes the avi capture of the utility running without any errors.
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!]