Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #103793 > unrolled thread

Re: convert Dbase (.dbf) files to SQLite databases

Back to article view | Back to comp.lang.python

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

  Re: convert Dbase (.dbf) files to SQLite databases starkwedder2009@gmail.com - 2016-03-01 05:36 -0800
    Re: convert Dbase (.dbf) files to SQLite databases Ethan Furman <ethan@stoneleaf.us> - 2016-03-01 08:39 -0800
    Re: convert Dbase (.dbf) files to SQLite databases Ethan Furman <ethan@stoneleaf.us> - 2016-03-01 08:49 -0800
    Re: convert Dbase (.dbf) files to SQLite databases Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2016-03-01 21:08 -0500
    Re: convert Dbase (.dbf) files to SQLite databases Ethan Furman <ethan@stoneleaf.us> - 2016-03-01 20:37 -0800

#103793 — Re: convert Dbase (.dbf) files to SQLite databases

Il giorno mercoledì 15 luglio 2009 18:30:29 UTC+2, John Machin ha scritto:
> On Jul 15, 8:39 pm, David Lyon <david.l...@preisshare.net> wrote:
> > On Wed, 15 Jul 2009 11:53:28 +0200, Helmut Jarausch
> >
> > <jarau...@igpm.rwth-aachen.de> wrote:
> > > Hi,
> >
> > > I have a lot of old Dbase files (.dbf) and I'll like to convert these
> > > to SQLite databases as automatically as possible.
> > > Does anybody know a tool/Python script to do so?
> >
> > > I know, I could use dbfpy and create the SQLite table and import all
> > > data. But is there something easier?
> >
> > yes...
> >
> > Use OpenOffice-Scalc or MS-Office-Excel to open the table...
> 
> Max 64K rows for Scalc and Excel 2003; 2007 can take 2**20 rows.
> Only old dBase (not dBase 7). Memo fields not handled. Visual FoxPro
> DBFs not supported by Excel even tho' VFP is an MS product.
> 
> 
> > Export to csv....
> 
> Yuk.
> 
> >
> > Use SQLite Manager (https://addons.mozilla.org/en-US/firefox/addon/5817)
> >
> > and use the import wizard to import your data....
> >
> > It shouldn't take too long...
> 
> ... before you get sick of the error-prone manual tasks.
> 
> I'd write a script that took a DBF file, analysed the field
> descriptions, made a CREATE TABLE statement, executed it, and then
> started doing inserts. Fairly easy to write. Scripts have the great
> benefit that you can fix them and re-run a whole lot easier than
> redoing manual steps.
> 
> If dbfpy can't handle any new-fangled stuff you may have in your
> files, drop me a line ... I have a soon-to-be released DBF module that
> should be able to read the "new" stuff up to dBase7 and VFP9,
> including memo files, conversion from whatever to Unicode if
> needed, ...
> 
> Cheers,
> John

[toc] | [next] | [standalone]

#103797

> Il giorno mercoledì 15 luglio 2009 18:30:29 UTC+2, John Machin ha scritto:

>> If dbfpy can't handle any new-fangled stuff you may have in your
>> files, drop me a line ... I have a soon-to-be released DBF module that
>> should be able to read the "new" stuff up to dBase7 and VFP9,
>> including memo files, conversion from whatever to Unicode if
>> needed, ...

Or you can use my dbf module [1] which has been in the wild for several 
years now and is fairly robust instead of waiting for John's module 
which has been in the "soon to be released" category for nearly as long.

--
~Ethan~

[1] https://pypi.python.org/pypi/dbf

[toc] | [prev] | [next] | [standalone]

#103799

>> Il giorno mercoledì 15 luglio 2009 18:30:29 UTC+2, John Machin ha
>> scritto:

Hmm, looks like that email was sent back in 2009.  Sorry for the noise. 
  I'm still not able to find a dbf module from John, though.

--
~Ethan~

[toc] | [prev] | [next] | [standalone]

#103830

On Tue, 01 Mar 2016 08:49:08 -0800, Ethan Furman <ethan@stoneleaf.us>
declaimed the following:

>>> Il giorno mercoledì 15 luglio 2009 18:30:29 UTC+2, John Machin ha
>>> scritto:
>
>Hmm, looks like that email was sent back in 2009.  Sorry for the noise. 
>  I'm still not able to find a dbf module from John, though.
>
	Is it one of:

https://www.google.com/#q=dbf.py
-- 
	Wulfraed                 Dennis Lee Bieber         AF6VN
    wlfraed@ix.netcom.com    HTTP://wlfraed.home.netcom.com/

[toc] | [prev] | [next] | [standalone]

#103837

On 03/01/2016 06:08 PM, Dennis Lee Bieber wrote:
> On Tue, 01 Mar 2016 08:49:08 -0800, Ethan Furman declaimed the following:

>> Hmm, looks like that email was sent back in 2009.  Sorry for the noise.
>>   I'm still not able to find a dbf module from John, though.
>>
> 	Is it one of:
>
> https://www.google.com/#q=dbf.py

I only checked the first three pages:

- 12 refer to mine
- 4 refer to pydbf
- various others

The third page drifts off into non-English languages and non-Python 
links.  A search for his name and dbf also did not reveal anything.

Ah well (aka *sigh*).

--
~Ethan~

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web