import gnucash flat file into psql

Mike G mike at thegodshalls.com
Mon Nov 3 23:06:06 CST 2003


Hi,

That still is not working for me.

I am getting this error message.  The server at URL postgres://localhost
experienced an error or corrupt data.  No tables etc are created.

If I open a blank gnucash flat file, do the file->save as then tables
are created.

The Actions->Check & Repair->check and repair all didn't help either.

	
On Mon, 2003-11-03 at 22:06, Derek Atkins wrote:
> File -> Save As
> 
> Give it your postgres URI as the filename

> -derek
> 
> Mike G <mike at thegodshalls.com> writes:
> 
> > Hi,
> >
> > I have been using gnucash for a few months now storing all my financials
> > in the gnucash flat file.
> >
> > I have always had postgres on my pc and would now like to use gnucash
> > with it.
> >
> > I have successfully created the database and tables in postgresql.  
> >
> > I am now trying to import my current gnucash flat file into the database
> > but cannot figure out how to do it.  
> >
> > I am using 1.8.7 and postgres 7.3.4.
> >
> > I have tried to import it using File->Import Qif and the other option
> > file type(my current gnucash flat file).
> >
> > I have also tried to export the accounts so that they could possible be
> > re-imported(nothing seems to be exported).
> >
> > Lastly I have opened the flat file in gnucash and then done a File->Save
> > As using postgres://local... as the path.
> >
> > Is it not possible to convert a current flat file to postgres?
> >
> > Mike
> > -- 
> > Mike G <mike at thegodshalls.com>
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at lists.gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >
> >
-- 
Mike G <mike at thegodshalls.com>


More information about the gnucash-user mailing list