Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
aminegac
Creator
Creator

read dbf file in talend 2020 with "tdbfInput" Exception

hello , i found no one posting about dbf files , i found big difficulty checking how to read dbf files to extract data from them and use them later , so i finally found the hand made component "tDBFinput" in the exchange talend web site , i found 3 of them. i downloaded them and successfully used each time one of them in talend open studio v7.3.1 , my problem is that all 3 "tDBFinput" either return null when i try to extract data from any dbf file even the simplest examples , and my main problem is that it shows an exception when i try to load a 15mb dbf file that i checked and visualized in dbf viewers apps , i mean the file is correct and i could open it in other apps while every column and its data is shown well and0693p00000AYr9VAAT.png correctly but in talend it always shows exception "dbflib.CorruptedTableException: Number of field descriptions in file could not be calculated"

is there any way to load the content of a ".dbf" file in talend v7.x ?? or to properly use the "tDBFinput" component ??

Talend OS 4 yrs / Java 17 Web Dev
Labels (2)
2 Replies
Anonymous
Not applicable

Hello,

Which version tDBFinput component are you using? The version 2.0 of the tDBFInput component?

So far, tDBFxxx components are not provided by Talend officially.

Best regards

Sabrina

aminegac
Creator
Creator
Author

Hello Mrs.Sabrina ,

thx for the quick reply .

i am used all these 3 in the photo below , but let's assume i will only be using 2.0 the first compnent in the photo.

i always get that kind of exception dbflib.CorruptedTableException: Number of field descriptions in file could not be calculated when i try to read dbf files that i have .

my biggest problem is that i need to read any bdf file without knowing the fields' names and tables' names that are in .

what i mean is that is there a way to extract all data from a .DBF file with generic or dynamic fields.??

or at least with field names that i set myself assuming that i am the creator of that dbf file and i know what table and column names are in it . 0693p00000AYs68AAD.png

Talend OS 4 yrs / Java 17 Web Dev