nice idea... but to make it useful to anybody other than you, you need to
create a seperate validation API that is reusable and extensible... There
are many such packages already available, so using one might save you some
time...

On 1/4/07, etoom etoom <[EMAIL PROTECTED]> wrote:


I'm writing a module that validates a csv file against a simple
schema, here is an example on how it should work:

Simple schema(might be given in a file or as argument):
int, char, char, date,bool

Here is a sample of valid data:
123, hello, all, 12/12/06, 0

in my program I only need dates with the (MM/DD/YY) format and 0/1
booleans. but extending that won't be a tough problem.

I also think that auto sql generation will be usefull.

On 1/4/07, Jad madi <[EMAIL PROTECTED]> wrote:
>
> I second Ammai, there is and there should be a universal validator, it
> depends on your data 7aj
>
>
> On 1/3/07, Ammar Ibrahim <[EMAIL PROTECTED]> wrote:
> > It would be easy to write a validator yourself to check on the number
of
> > column, but as for the types of data, this is more of a business logic
in
> > your application, and I doubt you'd find anything like that. Best
thing to
> > do is to write one yourself.
> >
> >
> > - Ammar
> >
> > On 1/3/07, etoom etoom <[EMAIL PROTECTED]> wrote:
> > >
> > > yes of course, the number of columns, the type of data each column
is
> > > supposed to have (numbers, dates,..). that's it.
> > >
> > > On 1/3/07, Ammar Ibrahim <[EMAIL PROTECTED] > wrote:
> > > > What would make a CSV file valid or invalid? e.g. every record to
have
> > the
> > > > same number of column? etc
> > > >
> > > > - Ammar
> > > >
> > > >
> > > >
> > > > On 1/3/07, etoom etoom < [EMAIL PROTECTED]> wrote:
> > > > >
> > > > >
> > > > > Salam all,
> > > > > I'm trying to read a csv (comma separated values) file and store
the
> > > > > values in a database using perl, every thing is going great
except I
> > > > > can't find any module that validates csv file against a schema
of some
> > > > > form like we have in xml. Is their any?
> > > > >
> > > > > Yazan
> > > > >
> > > > > > >
> > > > >
> > > >
> > >
> > > > >
> > >
> >
>
> >
>

>



--
Al-Faisal El-Dajani
P.O Box: 140056
11814 Amman, Jordan

--~--~---------~--~----~------------~-------~--~----~
 You received this message because you are subscribed to the Google Groups 
"Jolug" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups-beta.google.com/group/Jolug?hl=en-GB
-~----------~----~----~----~------~----~------~--~---

رد على