How can i solve this ? - Githubissues

doofpot / DBFToMySQL

xbase/dbf to MySQL import tool

Other

21 stars 25 forks source link

How can i solve this ? #5

Open Ariyatep-zz opened 7 years ago

Ariyatep-zz commented 7 years ago

When i run php dbf-import.php, it say: php Fatal error: Uncaught Error: Class 'XBase\Memo' not found ...

17690890_1405727666161019_748376703_n

ethaizone commented 7 years ago

edit php to require with absolute path and rename folder from 'DBFToMySQL' to be lower case.

I use this script but I need to adjust many things to make it usable such as numeric insert or null data.

adanielvv commented 7 years ago

Adding a line to dbf-import.php fixes it for me: #6 @include "classes/XBase/Memo.php";

adanielvv commented 7 years ago

@ethaizone Can you share your adjustments? I'm especially interested in a fix for null data in dates.

I use this script but I need to adjust many things to make it usable such as numeric insert or null data.

Ariyatep-zz commented 7 years ago

@DanielvV Thank you. I'll try. I fix for null data in date by SET GLOBAL sql_mode=''; in mysql.

adanielvv commented 7 years ago

@Ariyatep , FYI: I created a fork for testing and personal use. There I implemented and edited some of the old import_dbf() function into import_dbf_to_mysql() That fixed the null data for me (changes it to january first, 1970), and support for logical fields (L). Some other changes:

mb_convert_encoding() didn't have support for encoding CP437, changed it to iconv()
edited DBFhandler {} class to return column type
doubled the with of every character field (C) because it was giving errors (highly suspect that the converted special chars needed more space)

vjardin commented 6 years ago

+1 https://github.com/doofpot/DBFToMySQL/pull/6 is needed for XBase\Memo.