CsvBeans looks promising, I will try it out. I am using PostgreSQL and have heard of the COPY feature, but have not looked into it yet.
Thanks for the sugestions, > -----Original Message----- > From: Alan Hicks [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 22, 2005 11:39 AM > To: [email protected] > Subject: Re: Ibatis and flat files? > > > I stumbled across a project: www.csvBeans.org . It generates > beans from a > CSV file. The mappings are defined using XML. > > Worth a look -saved me loads of time. > > Alan. > > > On Thu, 22 Sep 2005 18:57:57 +0100, Warren Bell > <[EMAIL PROTECTED]> wrote: > > > My company has several vendors who send us invoices in the form of comma > > delimited flat text files via FTP. My question is, is there a way using > > Ibatis to pul in the data from the text file and insert it into > a table. > > I > > can get the data in manually and use Ibatis to insert into the table, > > but it > > would sure be nice if I could use Ibatis and map the fields in > the flat > > file > > to my objects the same way they are maped from tables or say do a query > > like: > > > > INSERT INTO table SELECT field1, field2 ... FROM flat_file > > > > These vendors have no other way to get us our invoices except paper. > > > > Thanks, > > > > Warren Bell > > > > > > > > > > > >
