sql-ledger-users

Fw: creating invoices from imported data

[Olaf F. <ofa...@at...>]

I should say, that I'm reasonably capable in perl - it's just this =
particular application that I don't know anything about.  I just want to =
know if it's a reasonable project before I start putting in time on it.

Thanks again,
Olaf

----- Original Message -----=20
From: Olaf Faaland=20
To: sql...@li...=20
Sent: Monday, January 28, 2002 9:58 AM
Subject: creating invoices from imported data


Hi,

First, my apologies if this is already addressed somewhere.  I found no =
reference to "import" in the last year's mailing list archives or the =
docs, but then again I may be blind.

I am considering using sql-ledger primarily for A/R.  I get billing data =
from a third party, in a form which could easily be turned into CSV or =
other easily-parsed text file.  I would want to use an import or extend =
sql-ledger to suck in my file, generate a series of invoices with it =
(each of which may have one or many line items), and then print the =
batch of invoices.  Payment entry would be performed by hand using the =
web i/f.

Are there facilities for this in sql-ledger already, that would make =
doing this straightforward?

thanks,
Olaf

Re: Fw: creating invoices from imported data

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

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

Re: Fw: creating invoices from imported data

[Olaf F. <ofa...@at...>]

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
>

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