question

LouisCortina-1114 avatar image
0 Votes"
LouisCortina-1114 asked SimpleSamples answered

How to correctly mimick the generation of a .DBF file (outside of Microsoft Visual FoxPro)

Hello,
Please help me identify the tasks that I need to do or considerations to be taken into account when trying to generate a .DBF file out of a Talend Job.
My name is Louis Cortina. I can be reached at, 1-847-550-7355 (x8083).
I’m an ETL Developer currently employed at Dovenmuehle, Inc. in Lake Zurich, Illinois, and I’m having the below ‘Not a table (Error 15)’ issue when attempting to create a .DBF file out of a Talend Job.
Please consider these questions:
1) I’m trying to create a .DBF file that should be able to be read by,
Microsoft Visual FoxPro 8.0 Copyright @1988-2002 ... (Version: 08.00.0000.2521) Product ID: 55181-270-1507393-03587
However, I’m getting the below listed error when trying to open the file (with MS FoxPro 8.0). So, my question is this:
Are there any considerations to be taken into account, with regards to the header portion of a .DBF file, when creating it?
2) Is it advisable to create a .DBF file outside of Foxpro (i.e. – As in this case, generate it out of a Talend Job)?
3) I had googled and found some documentation on how to ‘fix’ the corrupted file, etc., but unfortunately that didn’t work…
Considering the below error, are there any other instructions that I could follow (and or provide to my user(s)) to be able to ‘fix’ the file and open it with FoxPro?
Thank You Very Much for your assistance.
Louis Cortina
ETL Developer
Dovenmuehle Mortgage, Inc.
1 Corporate Drive, Suite 360
Lake Zurich, IL. 60047
Phone(s): Office -> 1-847-550-7355 (x8083) Mobile: 847-910-7483

windows-app-sdk-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Here is the error when trying to open the .DBF file that I generated with Talend using MS Visual FoxPro 8.0.

Topic ID: FoxPro8
Topic Title: Not a table (Error 15)
URL: mk:@MSITStore:c:\program files (x86)\microsoft visual foxpro 8\dv_foxhelp.chm::/html/err15.htm
Browser: Microsoft Internet Explorer 4.0 (compatible; MSIE 7.0; Windows NT 6.2; WOW64; Trident/7.0; .NET4.0C; .NET4.0E; Tablet PC 2.0; .NET CLR 2.0.50727; .NET CLR 3.0.30729; .NET CLR 3.5.30729)


0 Votes 0 ·

1 Answer

SimpleSamples avatar image
0 Votes"
SimpleSamples answered

I do not know what Talend Job is; can it write out CSV files? When I search for convert csv to dbf I get very many results; very many websites can do it online. You can try that; export the Talend Job data as a CSV and then convert to DBF.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.