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

Re: Dbf To MySql 'New' Table

Post by sudip »

For me, it works fine. I don't know why.
Very good news!
So, I must did something wrong. :(

I tested that it works fine for existing table but I faced problem with new MySql table.

I tried to create the new table (Acct in my case) with Dbf2MySql and tried to transfer data. But I got following error.
Dbf2MySqlError.jpg
Dbf2MySqlError.jpg (36.16 KiB) Viewed 9035 times
I like your your utility very much. So, I want to know where I made the mistake.

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 »

I can't reproduce the error here.

Does this occur only for VFP tables?
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 can't reproduce the error here.

Does this occur only for VFP tables?
I just tested. Problem occurs for all tables. But funny thing is that, it doesn't occur in my (sorry to say 'my' it's actually 'our') project. :?

I am using MySql 5.1.

So, may be I shall use 2 utilities one for new and other for existing table :)

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 »

I had uploaded the exe file here. Use this and tell me whether you are getting the same error.
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,

Same problem :)

May be I am running the software in wrong steps.

Can you please tell me how to run the software (exe file) step by step (idiot proof, I mean ;) )

Thank you very much for your co-operation.

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 »

Ok.

After connecting to MySQL and selecting the database, I select the dbf file, then give the name of the new table after selecting the radio group. Just press export. That's all.
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 also did the same thing :D

May be after some days we can discover what goes wrong :)

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 »

Here comes the avi capture of the utility running without any errors.
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 »

Rathi, my friend,

Problem is solved :D

It was my mistake!!! I didn't type the name of the new table for MySql (as in my project I used the same name of dbf table, but your idea is better)

I told you to give "idiot-proof" instructon :lol:

Your "training video" showed me how to use this utility.

I must archive this video to remember this "incident" :lol:

Thank you very much!!!

Next thing I want to learn (you may guess), how did you make this video? :)

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 »

Oh. Thanks Sudip.

I think, when selecting the dbf file, we can fill the name of the file in the textbox. I will change the code accordingly and update the new version.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
Post Reply