I need to import data into an existing application and need a program
or method that handles both the *.dbf and *.cdx files.

*.dbf files can be edited with e. g. Openoffice. Added data do however
not show up in the application. My understanding is that the reason is
that the corresponding *.cdx file is not modified.

Recommendations and advices are appreciated.

Bengt T wrote:

> I need to import data into an existing application and need a program
> or method that handles both the *.dbf and *.cdx files.
>
> *.dbf files can be edited with e. g. Openoffice. Added data do however
> not show up in the application. My understanding is that the reason is
> that the corresponding *.cdx file is not modified.
>
> Recommendations and advices are appreciated.

Back up your data for safety first! Perhaps your application can be
induced to regenerate its index files. Edit a .dbf file and delete
the related .cdx file(s), then try starting the application. No joy?
Try again after deleting all the index files. Look through the .exe
files for a name that hints at reindexing and run it. Database apps
frequently support a way to cleanup index damage by regeneration.

I have dBase V I used (a little) a very long time ago. Still have
the program and all docs around here somewhere. If above doesn't
help, write back and I will see what Borland says.

Man-wai Chang ToDie (33.6k) wrote:
> Bengt T wrote:
>> I need to import data into an existing application and need a program
>> or method that handles both the *.dbf and *.cdx files.
>>
>> *.dbf files can be edited with e. g. Openoffice. Added data do however
>> not show up in the application. My understanding is that the reason is
>> that the corresponding *.cdx file is not modified.
>
> dBase has a command "COPY TO" that exports data to CSV or other plain
> text format, as well as old Excel, Lotus formats.
>
Sorry... the reverse to "COPY TO" is "APPEND FROM". It could handle CSV
plain text files. Read their man pages. :)

--
@~@ Might, Courage, Vision, SINCERITY.
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Xubuntu 8.04.1) Linux 2.6.24-16-generic
^ ^ 19:13:02 up 24 min 3 users load average: 7.12 8.18 7.03
¤£*ɶU! ¤£¶BÄF! ¤£´©¥æ! ¤£¥´¥æ! ¤£¥´§T! ¤£¦Û±þ! ½Ð¦Ò¼{ºî´© (CSSA):
http://www.swd.gov.hk/tc/index/site_...sub_addressesa

> I'm finishing 2 other script projects first, then I'll look into what I can
> find. Might have to re-write a DBF lib, as the one I had was for Turbo-C
> under DOS. Kinda puts some mold on the actual program. :-)

The structure of DBF is basically unchanged.

--
@~@ Might, Courage, Vision, SINCERITY.
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Xubuntu 8.04.2) Linux 2.6.28.1
^ ^ 11:41:01 up 20:26 1 user load average: 1.11 1.37 1.24
¤£*ɶU! ¤£¶BÄF! ¤£´©¥æ! ¤£¥´¥æ! ¤£¥´§T! ¤£¦Û±þ! ½Ð¦Ò¼{ºî´© (CSSA):
http://www.swd.gov.hk/tc/index/site_...sub_addressesa

Bengt T wrote:
> I need to import data into an existing application and need a program
> or method that handles both the *.dbf and *.cdx files.
>
> *.dbf files can be edited with e. g. Openoffice. Added data do however
> not show up in the application. My understanding is that the reason is
> that the corresponding *.cdx file is not modified.

dBase has a command "COPY TO" that exports data to CSV or other plain
text format, as well as old Excel, Lotus formats.

--
@~@ Might, Courage, Vision, SINCERITY.
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Xubuntu 8.04.1) Linux 2.6.24-16-generic
^ ^ 19:13:02 up 24 min 3 users load average: 7.12 8.18 7.03
¤£*ɶU! ¤£¶BÄF! ¤£´©¥æ! ¤£¥´¥æ! ¤£¥´§T! ¤£¦Û±þ! ½Ð¦Ò¼{ºî´© (CSSA):
http://www.swd.gov.hk/tc/index/site_...sub_addressesa

On 20 Jan, 15:21, Bryce <inva...@invalid.invalid> wrote:
> Bengt T wrote:
> > I need to import data into an existing application and need a program
> > or method that handles both the *.dbf and *.cdx files.
>
> > *.dbf files can be edited with e. g. Openoffice. Added data do however
> > not show up in the application. My understanding is that the reason is
> > that the corresponding *.cdx file is not modified.
>
> > Recommendations and advices are appreciated.
>
> Back up your data for safety first! Perhaps your application can be
> induced to regenerate its index files. Edit a .dbf file and delete
> the related .cdx file(s), then try starting the application. No joy?
> Try again after deleting all the index files. Look through the .exe
> files for a name that hints at reindexing and run it. Database apps
> frequently support a way to cleanup index damage by regeneration.
>
> I have dBase V I used (a little) a very long time ago. Still have
> the program and all docs around here somewhere. If above doesn't
> help, write back and I will see what Borland says.

Your suggested method, to delete the *.cdx files, helped.

Thanks for your assistance!

Bengt T

On 20 Jan, 15:41, "Man-wai Chang ToDie (33.6k)"
<toylet.toy...******.com> wrote:
> Man-wai Chang ToDie (33.6k) wrote:> Bengt T wrote:
> >> I need to import data into an existing application and need a program
> >> or method that handles both the *.dbf and *.cdx files.
>
> >> *.dbf files can be edited with e. g. Openoffice. Added data do however
> >> not show up in the application. My understanding is that the reason is
> >> that the corresponding *.cdx file is not modified.
>
> > dBase has a command "COPY TO" that exports data to CSV or other plain
> > text format, as well as old Excel, Lotus formats.
>
> Sorry... the reverse to "COPY TO" is "APPEND FROM". It could handle CSV
> plain text files. Read their man pages. :)
>
> --
> @~@ Might, Courage, Vision, SINCERITY.
> / v \ Simplicity is Beauty! May the Force and Farce be with you!
> /( _ )\ (Xubuntu 8.04.1) Linux 2.6.24-16-generic
> ^ ^ 19:13:02 up 24 min 3 users load average: 7.12 8.18 7.03
> ¤£*ɶU! ¤£¶BÄF! ¤£´©¥æ! ¤£¥´¥æ!¤£¥´§T! ¤£¦Û±þ! ½Ð¦Ò¼{ºî´© (CSSA):http://www.swd.gov.hk/tc/index/site_...sub_addressesa

The application I am using does not have any "APPEND FROM"...

I assume that I have to start some database application program, which
I am not familiar with. Can you elaborate more on this please.

Bengt T

Lastly, you might want to talk to your fellow Americans:

news://msnews.microsoft.com:119/micr...ammer.exchange

--
@~@ Might, Courage, Vision, SINCERITY.
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Xubuntu 8.04.2) Linux 2.6.28.2
^ ^ 18:17:01 up 1:43 0 users load average: 0.00 0.01 0.04
¤£*ɶU! ¤£¶BÄF! ¤£´©¥æ! ¤£¥´¥æ! ¤£¥´§T! ¤£¦Û±þ! ½Ð¦Ò¼{ºî´© (CSSA):
http://www.swd.gov.hk/tc/index/site_...sub_addressesa

Bengt T wrote:
> I need to import data into an existing application and need a program
> or method that handles both the *.dbf and *.cdx files.
>
> *.dbf files can be edited with e. g. Openoffice. Added data do however
> not show up in the application. My understanding is that the reason is
> that the corresponding *.cdx file is not modified.

What are the linux programs that need to deal with those dBase/Foxpro
files? PHP?


--
@~@ Might, Courage, Vision, SINCERITY.
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Xubuntu 8.04.1) Linux 2.6.24-16-generic
^ ^ 19:13:02 up 24 min 3 users load average: 7.12 8.18 7.03
¤£*ɶU! ¤£¶BÄF! ¤£´©¥æ! ¤£¥´¥æ! ¤£¥´§T! ¤£¦Û±þ! ½Ð¦Ò¼{ºî´© (CSSA):
http://www.swd.gov.hk/tc/index/site_...sub_addressesa

> The application I am using does not have any "APPEND FROM"...
>
> I assume that I have to start some database application program, which
> I am not familiar with. Can you elaborate more on this please.

I read your question again. *.cdx are Foxpro indexes, NOT dBase 4. Are
you sure that that it's dBase 4?

You can re-generate *.cdx from *.dbf files using the Foxpro INDEX ON
command. You can see the index expression under Foxpro:

select 0
use file.dbf
? sys(14,1) <-- 1st index expression
? sys(14,2) <-- 2nd index expression
use

COPY TO and APPEND FROM are Foxpro commands. Type "HELP APPEND FROM" at
Foxpro's command window to read online help.

DO you have a Foxpro person in your team or the client side?

--
@~@ Might, Courage, Vision, SINCERITY.
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Xubuntu 8.04.1) Linux 2.6.24-16-generic
^ ^ 19:13:02 up 24 min 3 users load average: 7.12 8.18 7.03
¤£*ɶU! ¤£¶BÄF! ¤£´©¥æ! ¤£¥´¥æ! ¤£¥´§T! ¤£¦Û±þ! ½Ð¦Ò¼{ºî´© (CSSA):
http://www.swd.gov.hk/tc/index/site_...sub_addressesa

On 21 Jan, 05:05, "Man-wai Chang ToDie (33.6k)"
<toylet.toy...******.com> wrote:
> Bengt T wrote:
> > I need to import data into an existing application and need a program
> > or method that handles both the *.dbf and *.cdx files.
>
> > *.dbf files can be edited with e. g. Openoffice. Added data do however
> > not show up in the application. My understanding is that the reason is
> > that the corresponding *.cdx file is not modified.
>
> What are the linux programs that need to deal with those dBase/Foxpro
> files? PHP?
>
> --
> @~@ Might, Courage, Vision, SINCERITY.
> / v \ Simplicity is Beauty! May the Force and Farce be with you!
> /( _ )\ (Xubuntu 8.04.1) Linux 2.6.24-16-generic
> ^ ^ 19:13:02 up 24 min 3 users load average: 7.12 8.18 7.03
> ɶU! B F! ! ! T! ۱ ! ЦҼ{  (CSSA):http://www.swd.gov.hk/tc/index/site_...sub_addressesa

My application is an economic account program. It is actually executed
in Windows environment but I am trying to modify the *.dbf and *.cdx
files in Linux, which I am much more familiar with.

According to the supplier, Dbase is used by the application.

> My application is an economic account program. It is actually executed
> in Windows environment but I am trying to modify the *.dbf and *.cdx
> files in Linux, which I am much more familiar with.

Under Window$, you should be able to use ODBC (or maybe OLEDB/COM+) to
access dBase/Foxpro files. At least the *.dbf could be read. The indexes
(*.cdx), I believe, could be ignored.

--
@~@ Might, Courage, Vision, SINCERITY.
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Xubuntu 8.04.1) Linux 2.6.24-16-generic
^ ^ 19:13:02 up 24 min 3 users load average: 7.12 8.18 7.03
¤£*ɶU! ¤£¶BÄF! ¤£´©¥æ! ¤£¥´¥æ! ¤£¥´§T! ¤£¦Û±þ! ½Ð¦Ò¼{ºî´© (CSSA):
http://www.swd.gov.hk/tc/index/site_...sub_addressesa

On 21 Jan, 11:38, "Man-wai Chang ToDie (33.6k)"
<toylet.toy...******.com> wrote:
> > My application is an economic account program. It is actually executed
> > in Windows environment but I am trying to modify the *.dbf and *.cdx
> > files in Linux, which I am much more familiar with.
>
> Under Window$, you should be able to use ODBC (or maybe OLEDB/COM+) to
> access dBase/Foxpro files. At least the *.dbf could be read. The indexes
> (*.cdx), I believe, could be ignored.
>
> --
> @~@ Might, Courage, Vision, SINCERITY.
> / v \ Simplicity is Beauty! May the Force and Farce be with you!
> /( _ )\ (Xubuntu 8.04.1) Linux 2.6.24-16-generic
> ^ ^ 19:13:02 up 24 min 3 users load average: 7.12 8.18 7.03
> ¤£*ɶU! ¤£¶BÄF! ¤£´©¥æ! ¤£¥´¥æ!¤£¥´§T! ¤£¦Û±þ! ½Ð¦Ò¼{ºî´© (CSSA):http://www.swd.gov.hk/tc/index/site_...sub_addressesa

Can not find ODBC or OLEDB in my PC. I use Windows XP Pro.

Anyway, I can survive with by editing *.dbf files with Openoffice and
delete *.cdx files. In my case, it is more or less a one time effort.
I was just interested in understanding your alternative way.

Thanks for your support.

> Thanks for your support.

Well... tip me via paypal? :)

--
@~@ Might, Courage, Vision, SINCERITY.
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Xubuntu 8.04.1) Linux 2.6.24-16-generic
^ ^ 19:13:02 up 24 min 3 users load average: 7.12 8.18 7.03
¤£*ɶU! ¤£¶BÄF! ¤£´©¥æ! ¤£¥´¥æ! ¤£¥´§T! ¤£¦Û±þ! ½Ð¦Ò¼{ºî´© (CSSA):
http://www.swd.gov.hk/tc/index/site_...sub_addressesa

> Can not find ODBC or OLEDB in my PC. I use Windows XP Pro.

Control Panel -> Administrative Tools -> Data Sources (ODBC)

Also google "Microsoft MDAC".


> Anyway, I can survive with by editing *.dbf files with Openoffice and
> delete *.cdx files. In my case, it is more or less a one time effort.
> I was just interested in understanding your alternative way.

You don't need to use OpenOffice to delete *.cdx. Just delete them from
the file exporer. Make sure there are no other applications using those
index files.....

--
@~@ Might, Courage, Vision, SINCERITY.
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Xubuntu 8.04.1) Linux 2.6.24-16-generic
^ ^ 19:13:02 up 24 min 3 users load average: 7.12 8.18 7.03
¤£*ɶU! ¤£¶BÄF! ¤£´©¥æ! ¤£¥´¥æ! ¤£¥´§T! ¤£¦Û±þ! ½Ð¦Ò¼{ºî´© (CSSA):
http://www.swd.gov.hk/tc/index/site_...sub_addressesa