Hi there, I have about 100 transactions in a spreadsheet. I can export these to CSV file with the fields in any order and the date in any format.
EG: 26/10/05,£20.90,Joe Smith or 32.06,2005-10,26,Willy Gates (where the amount of the transaction is £32.06) These are costs of shipping of various items to customers - they constitute only postage paid to the local logistics company. Therefore I want to enter them into SL as AP transactions, all against the same vendor number (54) and account (7500), all invoice 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 the CSV file and the full amount marked as paid on the same day. There should be only one item in each transaction, with a description either of "Post & packing" or "Post & packing, $CUSTOMER" (where $CUSTOMER is read from the CSV file). I don't think the Generic import script at [1] will do the job. I have no doubt that I could learn enough Perl to perform the import, but since I've never used perl before it'd surely take me more than the two hours or so required for me to type these entries in manually. I'm ok in Bash so could probably write a shell script if 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 terribly important, but if someone has an import script laying around which I could use to add transactions then you'd save me some time wasted typing & I'd be grateful. Stroller. [1] http://www.sql-ledger.org/cgi-bin/nav.pl?page=misc/ conversions.html&title=Conversions ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ sql-ledger-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
