import gnucash flat file into psql
Mike G
mike at thegodshalls.com
Wed Nov 5 22:19:17 CST 2003
I did try with an empty database. Last night the power cord on my pc
came loose and it shutdown. I just re-tried after that forced reboot
from scratch and it worked. Maybe postgres needed to be re-started.
Thanks for helping.
Mike
On Tue, 2003-11-04 at 09:35, warlord at MIT.EDU wrote:
> Mike G <mike at thegodshalls.com> writes:
>
> > 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.
>
> The QIF importer does not handle "memorized transactions", so that's
> not an issue.
>
> > 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.
>
> Ok, just making sure.
>
> > Never did customers/vendors in either and searching in gnucash found
> > none. Same goes for invoices.
>
> Ok.
>
> > Are split transactions a problem for it?
>
> Nope. If all you did was "Import to QIF" and then "Save to Postgres"
> it should work just fine.
>
> > Thank you for trying to help.
>
> Sorry it isn't working. Have you tried with an empty database? If
> the tables already exist then it might have problems.
>
> -derek
>
> > 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>
> > _______________________________________________
> > 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