how to read dbf files in talend 2020

0 votes

hi , i am new in talend open studio and i found no way to read dbf files  .

i found actually 2 blocking ways where i am stuck each time with different errors .

i tried first to downlaod from exchange.talend , tDBFInput component and it shows  an exception  "dbflib.CorruptedTableException: Number of field descriptions in file could not be calculated" each time i try to run the job after putting the dbf file in that componenet . 

i also tried to perform a jdbc connection using a dbf driver i downloaded , after installing it as external jar , i cannot find out the driver class , i can select the driver and it is added from the list of drivers but  i  cannot find the class ,which class to use .and also how to later on make the connection to a file not a table .

i also tried a second tDBFInput component that i downloaded from the exchange.talend web site but it always shows MASHAPE KEY that i need to configure , where i have no idea what value it should take , i see people saying it should be an URL pointing to an API and you also must know the authentication needed to request that url  . 

can anyone who extracted data from dbf FOX pro files in  version 7.x tell me how to do it?

Dec 1, 2020 in Talend by aminegac
• 560 points
252 views

Hey, @Aminegac,

Could you provide the database you use, clear steps, and full error log text?

@Gitika thank you for replying to my post . 
I am using a dbf file coming from FOX . i can visualize it clearly with any simple DBFviewer software as shown here in the photo . there are exactly 40 fields on that table and the software already figured out the types of each field and its name .

still cannot find out why the exception is 

Exception in component tDBFInput_1 (DBFJob)

nl.knaw.dans.common.dbflib.CorruptedTableException: Number of field descriptions in file could not be calculated.

at nl.knaw.dans.common.dbflib.DbfHeader.getFieldCount(DbfHeader.java:181)

at nl.knaw.dans.common.dbflib.DbfHeader.readAll(DbfHeader.java:131)

at nl.knaw.dans.common.dbflib.Table.open(Table.java:275)

at local_project.dbfjob_0_1.DBFJob.tDBFInput_1Process(DBFJob.java:991)

at local_project.dbfjob_0_1.DBFJob.runJobInTOS(DBFJob.java:1780)

at local_project.dbfjob_0_1.DBFJob.main(DBFJob.java:1629)

Hi, @Aminegac

I just experience this problem by trying to insert a NULL data in a column that is configured in the data model to NOT NULL.
Look at all your data in your dataflow (Maybe if you use a tmap a join that is not managed in inner join type).

hi , @Roshni

thank you for the reply . does it mean the dbf file has some null values that made the error occur?

for the Tmap solution i do not think it will work because the exception is thrown at the very begining at the first component in the job where i am trying to read the dbf file itself. as you can see in this photo . i already changed the shcema so that it matches perfectly with the number of columns in the file and the type also .  the same error appeares.

 .

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Talend

0 votes
1 answer

How to load a set of files into database using Talend

Using tFileList component,  you can read all the files present ...READ MORE

answered Apr 16, 2018 in Talend by code.reaper12
• 3,500 points
2,584 views
0 votes
1 answer

How to generate multiple rows from a single row in Talend?

I think using tJavaFlex, tMap and tFlowToIterate ...READ MORE

answered Apr 18, 2018 in Talend by code.reaper12
• 3,500 points
4,637 views
0 votes
2 answers

How to use java classes in Talend?

For many data integration requirements, the standard ...READ MORE

answered Oct 3, 2018 in Talend by daisyridley
• 160 points

edited Oct 3, 2018 by Vardhan 1,604 views
0 votes
1 answer

In Talend, how to specify multiple conditions as expression

@Palaniswamy, have a look at this discussion ...READ MORE

answered Aug 5, 2019 in Talend by Vardhan
• 13,200 points
3,222 views
0 votes
1 answer

How to loading flat file from configuration in Talend?

Hey, @There, Regarding your query you need to ...READ MORE

answered Jun 3, 2020 in Talend by Gitika
• 65,910 points
355 views
0 votes
2 answers
0 votes
1 answer

Looping through all the schemas in Talend

It is really simple to make tOracleInput ...READ MORE

answered Apr 10, 2018 in Talend by code.reaper12
• 3,500 points
744 views
0 votes
1 answer

Parsing JSON in Talend

While working with JSON files, one thing ...READ MORE

answered Apr 2, 2018 in Talend by code.reaper12
• 3,500 points
1,796 views
+1 vote
1 answer