import gnucash flat file into psql
Mike G
mike at thegodshalls.com
Mon Nov 3 23:18:03 CST 2003
Hmmmm no scheduled transactions but this file did start off as a
Microsoft Money 98, then 2001, then a few months ago I did export as QIF
and import into gnucash flat file.
While it was in Money I did have scheduled transactions. When I
converted it to gnucash I did not set up any scheduled transactions. I
checked to see if the set up for those transactions were carried over to
gnucash and found none under Actions->Scheduled Transactions.
Never did customers/vendors in either and searching in gnucash found
none. Same goes for invoices.
Are split transactions a problem for it?
Thank you for trying to help.
On Mon, 2003-11-03 at 23:09, Derek Atkins wrote:
> Do you have any of:
>
> scheduled tranasctions
> customers/vendors
> invoices
>
> in your data file?
>
> -derek
>
> Mike G <mike at thegodshalls.com> writes:
>
> > 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>
> > _______________________________________________
> > 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