Hi;
Problem solved - the source dbf file is somehow corrupted when
downloaded from an NT server to a PPC G4 Mac over a Microsoft RDC
client connection. This is a repeatable result. Used rdesktop to
download the files directly onto the trusty FreeBSD machine and it
works fine that way.
Cheers,
Tom
On 10/01/2009, at 12:16 PM, Tom Mende wrote:
Hi;
Hoping for some help on this application that converts dbf files
into csv format.
I'm not sure if the problem is with the source dbf file ... my
usage / syntax ... and/or something else...
BACKGROUND...
uname -rs
FreeBSD 7.0-RELEASE
dbf --version
dBase Reader and Converter V. 0.8.3.1, (c) 2002 - 2004 by Bjoern Berg
...intalled as a port from /usr/ports/databases/dbf ...make install
clean
...chmod 777 cardfile.dbf # to avoid permissions problems
ls -l cardfile*
-rwxrwxrwx 1 tom tom 549139 Jan 9 18:32 cardfile.dbf
dbf --view-info ~/cardfile.dbf
-- File statistics
dBase version.: Visual FoxPro (without memo)
Date of last update...: 1908-12-15
Number of records.: 625 (0271d)
Length of header..: 2888 (0b48d)
Record length.: 874 (036ad)
Columns in file...: 89
Rows in file..: 625
+---+---+---+---
+---+
| field name| type | field adress | length| field dec.|
+---+---+---+---
+---+
| CF_NAME | C |1 | 45 | 0 |
| CF_REGNAME | C | 2e | 45 | 0 |
|CF_ID | C | 5b | 8 | 0 |
| CF_CODE | C | 63 | 8 | 0 |
|CF_EDI_ID | C | 6b | 13 | 0 |
| CABN | C | 78 | 14 | 0 |
| CPARENT_ID | C | 86 | 8 | 0 |
|LINACTIVE | L | 8e | 1 | 0 |
|LCUSTOMER | L | 8f | 1 | 0 |
|LSUPPLIER | L | 90 | 1 | 0 |
|LCREDITOR | L | 91 | 1 | 0 |
|LEMPLOYEE | L | 92 | 1 | 0 |
|LPROSPECT | L | 93 | 1 | 0 |
| LSALESPERS | L | 94 | 1 | 0 |
| CINVOICEST | C | 95 | 35 | 0 |
| CINVOICES2 | C | b8 | 35 | 0 |
| CINVOICECI | C | db | 20 | 0 |
| CINVOICES3 | C | ef | 3 | 0 |
| CINVOICEPO | C | f2 | 6 | 0 |
| CINVOICECO | C | f8 | 25 | 0 |
| CINVOICEPH | C | 111 | 20 | 0 |
| CINVOICEFA | C | 125 | 20 | 0 |
| CINVOICEC2 | C | 139 | 25 | 0 |
| CEMAIL | C | 152 | 35 | 0 |
| CMOBILE | C | 175 | 15 | 0 |
| CDEFSHIPLO | C | 184 | 20 | 0 |
| CDEFINVFOR | C | 198 | 1 | 0 |
| CDEFSELLCU | C | 199 | 3 | 0 |
| CDEFBUYCUR | C | 19c | 3 | 0 |
| CDEFSALESR | C | 19f | 8 | 0 |
| LPARTIALSH | L | 1a7 | 1 | 0 |
| CDEFDEPT | C | 1a8 | 3 | 0 |
| LWEBACCOUN | L | 1ab | 1 | 0 |
|CWEBLOGIN | C | 1ac | 15 | 0 |
| CWEBPASSWD | C | 1bb | 15 | 0 |
| CGROUPCODE | C | 1ca | 4 | 0 |
|CSORTCODE | C | 1ce | 4 | 0 |
|LPRICECAT | L | 1d2 | 1 | 0 |
|NPRICECAT | I | 1d3 | 4 | 0 |
| IPM_ID | I | 1d7 | 4 | 0 |
| LPRICEDISC | L | 1db | 1 | 0 |
|NDISCOUNT | N | 1dc | 7 | 4 |
| LTAXEXEMPT | L | 1e3 | 1 | 0 |
| CREASON | C | 1e4 | 25 | 0 |
| CF_BALANCE | Y | 1fd | 8 | 4 |
| NLIMIT | Y | 205 | 8 | 4 |
| NTERMS | N | 20d | 3 | 0 |
| NSUPPLIERL |