One option I have used is to write an app in Ruby on Rails that integrates with SL. With Rails ActiveRecord you just give the name of the table representing your object and you can then address fields as attributes. Ruby has built-in libraries for dealing with CSV, so getting data in from there is no problem.
This is most effective for what I call "master" data (parts, customers, etc.), but be careful of the ID sequences that SL uses. I had trouble with those until I found out how to specify them within ActiveRecord. I won't bore the entire list with more details, but if you are interested contact me off list. Thanks, Nathan On Wed, 2006-11-01 at 04:27 -0700, Dieter Simader wrote: > On Wed, 1 Nov 2006, Graeme Bruton wrote: > > > Hi all > > > > This may be slightly off the real topic, but I import clients from a csv > > sheet using the command line in psql every once in a while (new members to a > > sports club), but I can't find the field to select "Tax Included", so I have > > to manually go and select the radio button on each new client. Does anyone > > know how I can get around this? > > You could purchase technical support which includes the ERD. > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ sql-ledger-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
