ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Warren Bell" <war...@clarksnutrition.com>
Subject RE: Ibatis and flat files?
Date Thu, 22 Sep 2005 20:51:54 GMT
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:alan.hicks@omega.ie]
> Sent: Thursday, September 22, 2005 11:39 AM
> To: user-java@ibatis.apache.org
> 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
> <warren@clarksnutrition.com> 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
> >
> >
> >
> >
> >
>
>



Mime
View raw message