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 (00000271d)
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 | Y | 210 | 8 | 4 |
| CSUPPLIERB | C | 218 | 10 | 0 |
| CSUPPLIER2 | C | 222 | 11 | 0 |
| NDISCDAYS | N | 22d | 2 | 0 |
| NDISCPCENT | N | 22f | 7 | 4 |
| CBANKNAME | C | 236 | 35 | 0 |
| CBRANCHBSB | C | 259 | 18 | 0 |
| CCARDTYPE | C | 26b | 17 | 0 |
| CCARDNO | C | 27c | 19 | 0 |
| CCARDEXPIR | C | 28f | 4 | 0 |
| CCARDHOLDE | C | 293 | 35 | 0 |
| CUSER1 | C | 2b6 | 20 | 0 |
| CUSER2 | C | 2ca | 20 | 0 |
| CUSER3 | C | 2de | 20 | 0 |
| CKEYLIST_I | C | 2f2 | 8 | 0 |
| MNOTES | M | 2fa | 4 | 0 |
| ADDEDBY | C | 2fe | 3 | 0 |
| MWATCHOUT | M | 301 | 4 | 0 |
| DCREATED | D | 305 | 8 | 0 |
| LCUSTTAXIN | L | 30d | 1 | 0 |
| LUSEPARENT | L | 30e | 1 | 0 |
| CCONTACTIF | C | 30f | 4 | 0 |
| CCREDTAXCO | C | 313 | 3 | 0 |
| CCREDCACC_ | C | 316 | 10 | 0 |
| LPAYDIRECT | L | 320 | 1 | 0 |
| CSUPPLIERT | C | 321 | 15 | 0 |
| CDEFLOCID | C | 330 | 3 | 0 |
| LOCREQUIRE | L | 333 | 1 | 0 |
| CRM_CY_ID | C | 334 | 10 | 0 |
| CRM_CONTAC | C | 33e | 10 | 0 |
| CUSER4 | C | 348 | 20 | 0 |
| BPAYCODE | C | 35c | 9 | 0 |
| IBACKORDER | I | 365 | 4 | 0 |
| LPRINTBACK | L | 369 | 1 | 0 |
|
fps_data.d | b | 63 | 0 | 0 |
| | | 0 | 0 | 0 |
| | | 0 | 0 | 0 |
| | | 0 | 0 | 0 |
| | | 0 | 0 | 0 |
| | | 0 | 0 | 0 |
| | | 0 | 0 | 0 |
| | | 0 | 0 | 0 |
+---------------+-------+---------------+---------------
+---------------+
...could the reported date be a problem???
>stat cardfile.dbf
97 918810 -rwxrwxrwx 1 tom tom 3704992 549139 "Jan 10 11:22:17 2009"
"Jan 9 18:32:14 2009" "Jan 10 10:00:05 2009" "Jan 9 18:32:13 2009"
4096 1120 0 cardfile.dbf
...so I don't think I can change the date...seems like the reported
date is a separate date within the dbf file format???
THE COMMAND...
>dbf --csv ~/cardfile.csv ~/cardfile.dbf
dBase Reader and Converter V. 0.8.3.1, (c) 2002 - 2004 by Bjoern Berg
Export from /home/tom/cardfile.dbf to /home/tom/cardfile.csv
Segmentation fault (core dumped)
>ls -l cardfile*
-rw-r--r-- 1 tom tom 1032192 Jan 10 10:21 cardfile.csv
-rwxrwxrwx 1 tom tom 549139 Jan 9 18:32 cardfile.dbf
...tried this as root - same result sig 11...
...tried this using cardfile1.csv as output file - same result sig
11 ...
...the file created is a csv format file with just the column
headers from the dbf and part of the first record
>dmesg
pid 7005 (dbf), uid 1001: exited on signal 11 (core dumped)
I have a dump file dbf.core if this helps but I thought I shouldn't
post it because it is an address file with at least one record
containing private contact info of one of my colleagues.
Cheers,
Tom
_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org
"
_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"
