Stroller Your import script will prolly need to update ALL the relevant SL tables, including balanced DR and CR entries for the GL table, else you'll throw the whole system into OOB. For your 100 or so entries, I suspect that you'll be better to enter them manually. Perhaps become familiar with the SL keyboard shortcuts (Alt-O) to post, etc, so that your data entry can be achieved smoothly and swiftly, rather than being mousebound. My $0.02 only (GST and VAT included). - David J (via webmail)
[OOB = Out of balance] > 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
