import gnucash flat file into psql

[warlord at MIT.EDU]

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
>
>

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available