Re: [SL] importing csv files

[Nathan L. <nat...@ph...>]

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