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"

Reply via email to