Command line dbf editor for unix? :-)

Don't suppose anyone makes something like that right?

Thanks,

David

Command line dbf editor for unix? :-)



bah! you eunuchs ppl. so accustomed to command-line interfaces. ;)

i'm kidding, of course. just an idle question: how much is it worth to ya
to have a web-based interface for the same purpose?

Mike Lenyon <----- owns a linux server
----- Original Message -----
From: "Hubbard, David" <[email protected]>
To: <[email protected]>
Sent: Friday, June 21, 2002 5:09 PM
Subject: [meu] Command line dbf editor for unix? :-)


> Don't suppose anyone makes something like that right?
>
> Thanks,
>
> David
>

Command line dbf editor for unix? :-)



A web interface would be cool, don't know how useful it would
be though. I need to edit dbf files in customer directories
and editing them right on the server would certainly be easier
than scp'ing them down, copying them to my stupid windows
machine :-) to run dbfutils, and then reversing the process
to get them back.

David

> -----Original Message-----
> From: Mike Lenyon [mailto:[email protected]]
> Sent: Saturday, June 22, 2002 9:24 AM
> To: Hubbard, David; [email protected]
> Subject: Re: [meu] Command line dbf editor for unix? :-)
>
>
> bah! you eunuchs ppl. so accustomed to command-line interfaces. ;)
>
> i'm kidding, of course. just an idle question: how much is
> it worth to ya to have a web-based interface for the same purpose?
>
> Mike Lenyon <----- owns a linux server
> ----- Original Message -----
> From: "Hubbard, David" <[email protected]>
> To: <[email protected]>
> Sent: Friday, June 21, 2002 5:09 PM
> Subject: [meu] Command line dbf editor for unix? :-)
>
>
> > Don't suppose anyone makes something like that right?
> >
> > Thanks,
> >
> > David
> >

Command line dbf editor for unix? :-)



David,

Assuming you had a command line dbf editor could you resist the
temptation to make edits on the live files that would later cause you a
world of problems?

I know you would learn to resist over time, maybe learn so well that
for safety sake implement a procedure where you would download
the files, edit, test, test again, then upload, etc. in which case you
would be doing what you are now :)

But assuming you would resist temptation and use it wisely you could
check out CDBF Lite which runs on Windows, Linux, And FreeBSD.

They also sell a developer edition that comes with the source code so
you could compile it whatever flavor of Unix you may need.

For more info: <A HREF ="http://www.whitetown.com/cdbflite/">http://www.whitetown.com/cdbflite/</A>

I am not vouching for it, just passing along the information.

But to really get use/power out of a program like that you are going
to need to call it and reference a file with the commands you want to
carry out. In that case it is sort of like calling the miva binary and
passing it the script you want to execute the dbf editing commands
you want to use which leads me to wondering if you considered
writing a Miva script editor that you can run
from the command line?

I know it would be ugly because of the HTML headers always being
output -- though the header issue will be taken care of in Miva script
4.0 -- but ugly or not for now you could do it and it would work.

I hope that helps.

-Jeff Huber


----- Original Message -----
From: "Hubbard, David" <[email protected]>
To: "'Mike Lenyon'" <[email protected]>; <[email protected]>
Sent: Saturday, June 22, 2002 12:37 PM
Subject: RE: [meu] Command line dbf editor for unix? :-)


> A web interface would be cool, don't know how useful it would
> be though. I need to edit dbf files in customer directories
> and editing them right on the server would certainly be easier
> than scp'ing them down, copying them to my stupid windows
> machine :-) to run dbfutils, and then reversing the process
> to get them back.
>
> David
>
> > -----Original Message-----
> > From: Mike Lenyon [mailto:[email protected]]
> > Sent: Saturday, June 22, 2002 9:24 AM
> > To: Hubbard, David; [email protected]
> > Subject: Re: [meu] Command line dbf editor for unix? :-)
> >
> >
> > bah! you eunuchs ppl. so accustomed to command-line interfaces. ;)
> >
> > i'm kidding, of course. just an idle question: how much is
> > it worth to ya to have a web-based interface for the same purpose?
> >
> > Mike Lenyon <----- owns a linux server
> > ----- Original Message -----
> > From: "Hubbard, David" <[email protected]>
> > To: <[email protected]>
> > Sent: Friday, June 21, 2002 5:09 PM
> > Subject: [meu] Command line dbf editor for unix? :-)
> >
> >
> > > Don't suppose anyone makes something like that right?
> > >
> > > Thanks,
> > >
> > > David
> > >

Command line dbf editor for unix? :-)



From: [email protected] [mailto:[email protected]]
>
> David,
>
> Assuming you had a command line dbf editor could you resist the
> temptation to make edits on the live files that would later
> cause you a world of problems?
>
> I know you would learn to resist over time, maybe learn so well that
> for safety sake implement a procedure where you would download
> the files, edit, test, test again, then upload, etc. in which
> case you would be doing what you are now :)

If a customer corrupts their databases, my general procedure
is to tar up their mivadata directory so it can be replaced
if the problem gets worse before I fix it, bring the tar down
or the files if I know I just need one or two, fix the records,
put them back, pack. If I could edit on the server, I could
copy the files out I need to fix and then put them back,
problem solved and probably at least five to ten minutes
quicker. :-)

> But assuming you would resist temptation and use it wisely you could
> check out CDBF Lite which runs on Windows, Linux, And FreeBSD.
>
> They also sell a developer edition that comes with the source code so
> you could compile it whatever flavor of Unix you may need.
>
> For more info: <A HREF ="http://www.whitetown.com/cdbflite/">http://www.whitetown.com/cdbflite/</A>
>
> I am not vouching for it, just passing along the information.
>
> But to really get use/power out of a program like that you are going
> to need to call it and reference a file with the commands you want to
> carry out. In that case it is sort of like calling the miva
> binary and passing it the script you want to execute the dbf editing
> commands you want to use which leads me to wondering if you considered
> writing a Miva script editor that you can run from the command line?
>
> I know it would be ugly because of the HTML headers always being
> output -- though the header issue will be taken care of in
> Miva script 4.0 -- but ugly or not for now you could do it and it
> would work.

I don't think I could script the work I need to do since you never
really know what is wrong with the files until you get in them. And
then, sometimes customers need me to recover a specific record out of
the duplicates that are in there. I'll check it out though, thanks.

David