Re: Fw: creating invoices from imported data

[Luca V. <lu...@ye...>]

ok, here I give you the scripts.
They worked with sql-ledger-1.6.6.

There are two different way of insert data:

1. I insert the customers and vendors without
fear of breaking data. I use a script to translate
text data file in sql insert queries. Then I
run the queries via psql.

2. I insert the transactions using SL modules
just like someone using the program via the
mozilla interface.

I'm sorry for some italian documentation and
for my junk programming. The code should be
self explanatory.

In case of need, feel free to ask me.

Luca



Olaf Faaland wrote:
> 
> Hi Luca,
> 
> I have no desire to fill in the tables directly.  I _like_ that there's an
> app that keeps things balanced and prevents me from breaking my data
> accidentally.
> 
> Would you be willing to share your script so I can use it as a starting
> point for mine?
> 
> Either way, thank you for the response.  It sounds like sql-ledger is set up
> so that it was fairly straightforward.
> 
> thanks,
> Olaf
> 
> ----- Original Message -----
> From: "Luca Venturini" <lu...@ye...>
> To: "Olaf Faaland" <ofa...@at...>
> Cc: <sql...@li...>
> Sent: Wednesday, January 30, 2002 8:12 AM
> Subject: Re: Fw: creating invoices from imported data
> 
> > Hi,
> >
> > I spend some time in the last month to import
> > my data from an other system to SL.
> > My data was in the form of a text file for each
> > transaction.
> >
> > I'm not sure that my way was the best one. I
> > produced a perl script that call the SL/* modules.
> > Something like an agent that work for me
> > on SQL-Ledger and input the transactions.
> >
> > Maybe a better way to do it is to fill directly
> > the tables with the data... The fear of db consistence
> > loss was to much
> >
> > Luca
> >