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