import gnucash flat file into psql

[Derek Atkins]

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

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