Converting DBM to other DB file type

[Archi3]

I have an older program which stores information in a dbm file...is there a
way to convert this file into something Windows based or that can data
transferred into SQL?

I appreciate any help.
[email]archi3@nospamarchiventure.net[/email]

[James Willmore]

On Thu, 11 Sep 2003 10:48:00 -0400
"Archi3" <archi3@archiventure.net> wrote:

> I have an older program which stores information in a dbm file...is
> there a way to convert this file into something Windows based or
> that can data transferred into SQL?
>
> I appreciate any help.

As you get each record from the dbm file, you can then insert the
record into your new database using DBI. Or, you can loop through
each dbm record and write it to a CSV file - then, using your database
client, you can insert the records into your database (because _most_
databases will allow you to update/insert/etc. records from a CSV
file).

Since you have given little information about what your doing (code,
database your going to use, what you have tried so far), this is all I
can offer.

HTH

--
Jim

Copyright notice: all code written by the author in this post is
released under the GPL. [url]http://www.gnu.org/licenses/gpl.txt[/url]
for more information.

a fortune quote ...
For perfect happiness, remember two things: (1) Be content with
what you've got. (2) Be sure you've got plenty.

[Gunnar Hjalmarsson]

Archi3 wrote:

> I have an older program which stores information in a dbm file...is
> there a way to convert this file into something Windows based or

----------------------------------------^^^^^^^^^^^^^^^^^^^^^^^

It's not apparent from the info you provided that there is a need to
convert the format in order to make it work on Windows. Simple DBM
files (SDBM), for instance, work fine on both *nix and Windows platforms.

[url]http://www.perldoc.com/perl5.8.0/pod/perlport.html#Standard-Modules[/url]

/ Gunnar

--
Gunnar Hjalmarsson
Email: [url]http://www.gunnar.cc/cgi-bin/contact.pl[/url]

[Archi3]

Jim,

I have the account file (account.dbm) from an older program I use...can I
just manipulate that file?
My background..VB6 programmer with little knowledge of PERL, CGI, Linux..etc
etc
I was hoping I could take the files and DTS them into a SQL db or something
to that effect
Is there a program I can open the file in, that is windows based?

Thanks,
Archi3

> > I have an older program which stores information in a dbm file...is
> > there a way to convert this file into something Windows based or
> > that can data transferred into SQL?
> >
> > I appreciate any help.

>
> As you get each record from the dbm file, you can then insert the
> record into your new database using DBI. Or, you can loop through
> each dbm record and write it to a CSV file - then, using your database
> client, you can insert the records into your database (because _most_
> databases will allow you to update/insert/etc. records from a CSV
> file).
>
> Since you have given little information about what your doing (code,
> database your going to use, what you have tried so far), this is all I
> can offer.
>
> HTH
>
> --
> Jim
>
> Copyright notice: all code written by the author in this post is
> released under the GPL. [url]http://www.gnu.org/licenses/gpl.txt[/url]
> for more information.
>
> a fortune quote ...
> For perfect happiness, remember two things: (1) Be content with
> what you've got. (2) Be sure you've got plenty.

[Gunnar Hjalmarsson]

Please do not top post! [url]http://web.presby.edu/~nnqadmin/nnq/nquote.html[/url]

Archi3 wrote:

> James Willmore wrote:

>> On Thu, 11 Sep 2003 10:48:00 -0400 "Archi3"
>> <archi3@archiventure.net> wrote:

>>> I have an older program which stores information in a dbm
>>> file...is there a way to convert this file into something
>>> Windows based or that can data transferred into SQL?

>>
>> As you get each record from the dbm file, you can then insert the
>> record into your new database using DBI. Or, you can loop
>> through each dbm record and write it to a CSV file - then, using
>> your database client, you can insert the records into your
>> database (because _most_ databases will allow you to
>> update/insert/etc. records from a CSV file).

>
> I have the account file (account.dbm) from an older program I
> use...can I just manipulate that file?

In your first post you said "dbm file", and now you are talking about
a file whose extension is .dbm, which probably is quite another thing.

> My background..VB6 programmer

If you are a programmer - any kind of programmer - you should realize
that you need to provide accurate and detailed information if anybody
shall be able to help you with this kind of problem.

Also, please note that this is a group for discussing the Perl
program. I'm not sure what made you post here in the first place.

--
Gunnar Hjalmarsson
Email: [url]http://www.gunnar.cc/cgi-bin/contact.pl[/url]

[James Willmore]

"Archi3" <archi3@archiventure.net> wrote in message news:<3f61f6ec@news.greennet.net>...

> I have the account file (account.dbm) from an older program I use...can I
> just manipulate that file?
> My background..VB6 programmer with little knowledge of PERL, CGI, Linux..etc
> etc
> I was hoping I could take the files and DTS them into a SQL db or something
> to that effect
> Is there a program I can open the file in, that is windows based?

<snip>

> >
> > As you get each record from the dbm file, you can then insert the
> > record into your new database using DBI. Or, you can loop through
> > each dbm record and write it to a CSV file - then, using your database
> > client, you can insert the records into your database (because _most_
> > databases will allow you to update/insert/etc. records from a CSV
> > file).
> >
> > Since you have given little information about what your doing (code,
> > database your going to use, what you have tried so far), this is all I
> > can offer.

How was the DBM file created? Was it created with Perl or some other
software?

If you have the code that produced the DBM file lying around, you
could modify it to write out each record to a CSV file (a comma
separated values file). _Most_, if not all modern RDBMS's have _some_
facility to import information into a database from a CSV file. That
was the basic jist of the previous reply.

Did you want to write a script to do this -or- were you looking for
someplace with something pre-made? If the later, go to
[url]http://freshmeat.net[/url]. It's an open source repository. There you may
find something pre-made. If you wanted to write your own, check out
[url]http://www.perl.com[/url]. The latest "Perl Cookbook" article applies, in
part, to databases (DBD::SQLLite I believe). This may give you some
ideas. If nothing else, it will show you some Perl syntax and
generate some more questions and/or code.

HTH

Jim