[SL] Importing some AP transactions from CSV file.

[Stroller <lin...@my...>]

Hi there,

I have about 100 transactions in a spreadsheet. I can export these to =20=

CSV file with the fields in any order and the date in any format.

EG:
   26/10/05,=A320.90,Joe Smith
or
   32.06,2005-10,26,Willy Gates
   (where the amount of the transaction is =A332.06)

These are costs of shipping of various items to customers - they =20
constitute only postage paid to the local logistics company. =20
Therefore I want to enter them into SL as AP transactions, all =20
against the same vendor number (54) and account (7500), all invoice =20
number "-".

Is it possible easily to import these all into SL, please?

In each case the amount & date of the transaction should be read from =20=

the CSV file and the full amount marked as paid on the same day. =20
There should be only one item in each transaction, with a description =20=

either of "Post & packing" or "Post & packing, $CUSTOMER" (where =20
$CUSTOMER is read from the CSV file).

I don't think the Generic import script at [1] will do the job. I =20
have no doubt that I could learn enough Perl to perform the import, =20
but since I've never used perl before it'd surely take me more than =20
the two hours or so required for me to type these entries in =20
manually. I'm ok in Bash so could probably write a shell script if =20
someone could suggest a format for dumping in via `psql`.

As this is a one-off and only 100 or so transactions this isn't =20
terribly important, but if someone has an import script laying around =20=

which I could use to add transactions then you'd save me some time =20
wasted typing & I'd be grateful.

Stroller.



[1] http://www.sql-ledger.org/cgi-bin/nav.pl?page=3Dmisc/=20
conversions.html&title=3DConversions=