From owner-freebsd-questions@FreeBSD.ORG Sat Jan 10 01:58:19 2009 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 9FDA8106564A for ; Sat, 10 Jan 2009 01:58:19 +0000 (UTC) (envelope-from tmende@optusnet.com.au) Received: from smtp-1.servers.netregistry.net (smtp.netregistry.net [202.124.241.204]) by mx1.freebsd.org (Postfix) with ESMTP id DF0888FC13 for ; Sat, 10 Jan 2009 01:58:18 +0000 (UTC) (envelope-from tmende@optusnet.com.au) Received: from [122.106.251.79] (helo=[192.168.10.12]) by smtp-1.servers.netregistry.net protocol: esmtpa (Exim 4.63 #1 (Debian)) id 1LLSSi-0005Ii-Rz for ; Sat, 10 Jan 2009 12:16:29 +1100 Message-Id: <64A560B0-B971-4A6C-A245-6D89F802628C@optusnet.com.au> From: Tom Mende To: freebsd-questions@freebsd.org Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Apple Message framework v930.3) Date: Sat, 10 Jan 2009 12:16:27 +1100 X-Mailer: Apple Mail (2.930.3) Subject: /usr/ports/databases/dbf segmentation fault X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 10 Jan 2009 01:58:19 -0000 Hi; Hoping for some help on this application that converts dbf files into =20= csv format. I'm not sure if the problem is with the source dbf file ... my usage / =20= 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 =20 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 +---------------+-------+---------------+---------------=20 +---------------+ | field name | type | field adress | length | field dec. = | +---------------+-------+---------------+---------------=20 +---------------+ | 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 = | | | =00 | 0 | 0 | 0 = | | | =00 | 0 | 0 | 0 = | | | =00 | 0 | 0 | 0 = | | | =00 | 0 | 0 | 0 = | | | =00 | 0 | 0 | 0 = | | | =00 | 0 | 0 | 0 = | | | =00 | 0 | 0 | 0 = | +---------------+-------+---------------+---------------=20 +---------------+ ...could the reported date be a problem??? >stat cardfile.dbf 97 918810 -rwxrwxrwx 1 tom tom 3704992 549139 "Jan 10 11:22:17 2009" =20 "Jan 9 18:32:14 2009" "Jan 10 10:00:05 2009" "Jan 9 18:32:13 2009" =20 4096 1120 0 cardfile.dbf ...so I don't think I can change the date...seems like the reported =20 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 =20 11 ... ...the file created is a csv format file with just the column headers =20= 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 =20 post it because it is an address file with at least one record =20 containing private contact info of one of my colleagues. Cheers, Tom