DBF and DBFAnalyser

tchoua_12

• August 01, 2007 00:00

• Answered

Follow

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

• 

  jausperger

  • August 02, 2007 08:22

  0

  Comment actions Permalink

  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
• 

  dpavlis

  • August 02, 2007 12:29

  0

  Comment actions Permalink

  DBFAnalyzer has following syntax when executed:
  
  DBFAnalyzer [-v(erbose)] <DBF filename> [<metadata output filename>]
  
  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.
• 

  tchoua_12

  • August 03, 2007 07:16

  0

  Comment actions Permalink

  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

Please sign in to leave a comment.