DBF and DBFAnalyser

CloverDX Platform
1

Hello,

I am trying to make a flow witch is taking DBF files and copy it into a MySql database.
I would like to reverse the dbf file into metadatafile .fmt but I can’t find any documentation about the DBFAnalyser tool.

the only documentation I could found is on this link :
http://wiki.clovergui.net/doku.php?id=components:readers&s=dbase
at the DBFDataReader section but unfortunatly there is nothing about how to use it.

Does anyone know where I can found documentation about DBFAnalyser

Thanks

Best regards.

Francois

2

Hello,

The documentation is on http://www.cloveretl.org/download/clove … -2-2-0.zip, you can see a java doc for DBFAnalyser.

An example how to use dbf file reader is in examples on wiki pages. DBFAnalyser (private analyze method) gets a dbf type, count of fields, dbf field informations, etc from dbf file. DBFDataParser class compares metadata fields and dbf fields from a dbf file and reads data. You must know how many fields and field types are in dbf file before you create metadata file. There exist some tools on internet which can read data structure of dbf file.

With regards,

ja

3

DBFAnalyzer has following syntax when executed:

DBFAnalyzer [-v(erbose)] []

You might use/modify “clover”/“clover.bat” scripts (distributed with CloverETL binary package) to execute this utility - instead of [org.jetel.main.runGraph] run [org.jetel.database.dbf.DBFAnalyzer] - you would need to modify the script.

4

Thanks a lot for your response.

I found the DBFAnalyser in the java doc but that is not what I wanted. I’m not trying to write a java program but thanks for the response.
What I wanted was to call the DBFAnalyse tool as a standalone tool.
So I will try dpavlis’s call methode.

Thanks a lot.

Regards,

Francois