RE: validator framework in my Action class
Hello, Well, only one I know is http://jakarta.apache.org/commons , start >From there... or do a google search on Jakarta poi Hth marco -Original Message- From: Deepa Khetan [mailto:[EMAIL PROTECTED] Sent: 06 March 2006 15:24 To: Struts Users Mailing List Subject: Re: validator framework in my Action class Thanks a lot for the suggestions. Can u plz direct me to some links whr i get help for Jakarta POI?? On 3/6/06, Marco Mistroni <[EMAIL PROTECTED]> wrote: > > Hello, >If you need to validate against Excel 'parameters', you'd better > off validate using, as Niall suggested, Jakarta POI > > what you can do is to load your excel sheet using FileUpload, then use > Jakarta pOI from there on.. > > HTH >Marco > > -Original Message- > From: Niall Pemberton [mailto:[EMAIL PROTECTED] > Sent: 06 March 2006 12:53 > To: Struts Users Mailing List > Subject: Re: validator framework in my Action class > > If you want to call the Validator then the easiest way to find out how is > to > look at the "validate" method of one of the "validator" flavour > ActionForms - for example ValidatorForm. > > As to validating an excel spreadsheet - typically validator is called with > a > "bean" (or form) full of data. If you are extracting/converting your excel > data into some kind of bean - then looking at what the "validator" flavour > ActionForms do should help you out. If however you have it in some java > representation of a excel, then I'm not sure what the easiest solution > would > be (don't even know what software you're using to read excel) - without > knowing the format/structure. We have a small excel framework built on top > of Jakarta POI and found it easier to just build a small set of rules into > that framework, rather than trying to use something like validator. > > Niall > > - Original Message - > From: "Deepa Khetan" <[EMAIL PROTECTED]> > Sent: Saturday, March 04, 2006 11:46 AM > > > No body has any answers or work around for this?? :( > > -- Forwarded message ------ > From: Deepa Khetan <[EMAIL PROTECTED]> > Date: Mar 2, 2006 9:01 PM > Subject: validator framework in my Action class > To: Struts Users Mailing List > > Hi > > Is there a way in which i can use the validator framework in my Action > class? Actually, i have a functionality in which the user can upload an > Excel sheet with a number of records. Now, this excel sheet needs to be in > a > format and every column needs to be validated for minlength,maxlength, > mask > etc. So, validator framework is good for me. but for validation pupose i > will need to open the Excel sheet and read each value. Cant figur out what > to do. > Please help. > > Deepa > > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: validator framework in my Action class
POI Website is here: http://jakarta.apache.org/poi/index.html The excel part is called HSSF (horrible spreadsheet format :-) http://jakarta.apache.org/poi/hssf/index.html I'm still on an older version of POI, so I'm not up to speed on any new features. However the version I use provides 2 mechanisms for reading excel - either by creating a big worksheet object or by using a "listener" to listen for specified record types. We chose the second mechanism, since it was faster and lighter than the first - although probably the first mechanism is easier to get started with. Haven't looked at the site in a long time, but from memory the quick guide was a good place to begin: http://jakarta.apache.org/poi/hssf/quick-guide.html Niall - Original Message - From: "Deepa Khetan" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" Sent: Monday, March 06, 2006 3:24 PM Subject: Re: validator framework in my Action class Thanks a lot for the suggestions. Can u plz direct me to some links whr i get help for Jakarta POI?? On 3/6/06, Marco Mistroni <[EMAIL PROTECTED]> wrote: > > Hello, >If you need to validate against Excel 'parameters', you'd better > off validate using, as Niall suggested, Jakarta POI > > what you can do is to load your excel sheet using FileUpload, then use > Jakarta pOI from there on.. > > HTH >Marco > > -Original Message- > From: Niall Pemberton [mailto:[EMAIL PROTECTED] > Sent: 06 March 2006 12:53 > To: Struts Users Mailing List > Subject: Re: validator framework in my Action class > > If you want to call the Validator then the easiest way to find out how is > to > look at the "validate" method of one of the "validator" flavour > ActionForms - for example ValidatorForm. > > As to validating an excel spreadsheet - typically validator is called with > a > "bean" (or form) full of data. If you are extracting/converting your excel > data into some kind of bean - then looking at what the "validator" flavour > ActionForms do should help you out. If however you have it in some java > representation of a excel, then I'm not sure what the easiest solution > would > be (don't even know what software you're using to read excel) - without > knowing the format/structure. We have a small excel framework built on top > of Jakarta POI and found it easier to just build a small set of rules into > that framework, rather than trying to use something like validator. > > Niall > > - Original Message - > From: "Deepa Khetan" <[EMAIL PROTECTED]> > Sent: Saturday, March 04, 2006 11:46 AM > > > No body has any answers or work around for this?? :( > > -- Forwarded message -- > From: Deepa Khetan <[EMAIL PROTECTED]> > Date: Mar 2, 2006 9:01 PM > Subject: validator framework in my Action class > To: Struts Users Mailing List > > Hi > > Is there a way in which i can use the validator framework in my Action > class? Actually, i have a functionality in which the user can upload an > Excel sheet with a number of records. Now, this excel sheet needs to be in > a > format and every column needs to be validated for minlength,maxlength, > mask > etc. So, validator framework is good for me. but for validation pupose i > will need to open the Excel sheet and read each value. Cant figur out what > to do. > Please help. > > Deepa > > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: validator framework in my Action class
Deepa Khetan wrote: > Thanks a lot for the suggestions. Can u plz direct me to some links whr i > get help for Jakarta POI?? > The following link may help: http://www.google.com/search?q=poi Focus less on the fish and fire-twirling links. Dave - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: validator framework in my Action class
Thanks a lot for the suggestions. Can u plz direct me to some links whr i get help for Jakarta POI?? On 3/6/06, Marco Mistroni <[EMAIL PROTECTED]> wrote: > > Hello, >If you need to validate against Excel 'parameters', you'd better > off validate using, as Niall suggested, Jakarta POI > > what you can do is to load your excel sheet using FileUpload, then use > Jakarta pOI from there on.. > > HTH >Marco > > -Original Message- > From: Niall Pemberton [mailto:[EMAIL PROTECTED] > Sent: 06 March 2006 12:53 > To: Struts Users Mailing List > Subject: Re: validator framework in my Action class > > If you want to call the Validator then the easiest way to find out how is > to > look at the "validate" method of one of the "validator" flavour > ActionForms - for example ValidatorForm. > > As to validating an excel spreadsheet - typically validator is called with > a > "bean" (or form) full of data. If you are extracting/converting your excel > data into some kind of bean - then looking at what the "validator" flavour > ActionForms do should help you out. If however you have it in some java > representation of a excel, then I'm not sure what the easiest solution > would > be (don't even know what software you're using to read excel) - without > knowing the format/structure. We have a small excel framework built on top > of Jakarta POI and found it easier to just build a small set of rules into > that framework, rather than trying to use something like validator. > > Niall > > - Original Message - > From: "Deepa Khetan" <[EMAIL PROTECTED]> > Sent: Saturday, March 04, 2006 11:46 AM > > > No body has any answers or work around for this?? :( > > -- Forwarded message ------ > From: Deepa Khetan <[EMAIL PROTECTED]> > Date: Mar 2, 2006 9:01 PM > Subject: validator framework in my Action class > To: Struts Users Mailing List > > Hi > > Is there a way in which i can use the validator framework in my Action > class? Actually, i have a functionality in which the user can upload an > Excel sheet with a number of records. Now, this excel sheet needs to be in > a > format and every column needs to be validated for minlength,maxlength, > mask > etc. So, validator framework is good for me. but for validation pupose i > will need to open the Excel sheet and read each value. Cant figur out what > to do. > Please help. > > Deepa > > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
RE: validator framework in my Action class
Hello, If you need to validate against Excel 'parameters', you'd better off validate using, as Niall suggested, Jakarta POI what you can do is to load your excel sheet using FileUpload, then use Jakarta pOI from there on.. HTH Marco -Original Message- From: Niall Pemberton [mailto:[EMAIL PROTECTED] Sent: 06 March 2006 12:53 To: Struts Users Mailing List Subject: Re: validator framework in my Action class If you want to call the Validator then the easiest way to find out how is to look at the "validate" method of one of the "validator" flavour ActionForms - for example ValidatorForm. As to validating an excel spreadsheet - typically validator is called with a "bean" (or form) full of data. If you are extracting/converting your excel data into some kind of bean - then looking at what the "validator" flavour ActionForms do should help you out. If however you have it in some java representation of a excel, then I'm not sure what the easiest solution would be (don't even know what software you're using to read excel) - without knowing the format/structure. We have a small excel framework built on top of Jakarta POI and found it easier to just build a small set of rules into that framework, rather than trying to use something like validator. Niall - Original Message - From: "Deepa Khetan" <[EMAIL PROTECTED]> Sent: Saturday, March 04, 2006 11:46 AM No body has any answers or work around for this?? :( -- Forwarded message -- From: Deepa Khetan <[EMAIL PROTECTED]> Date: Mar 2, 2006 9:01 PM Subject: validator framework in my Action class To: Struts Users Mailing List Hi Is there a way in which i can use the validator framework in my Action class? Actually, i have a functionality in which the user can upload an Excel sheet with a number of records. Now, this excel sheet needs to be in a format and every column needs to be validated for minlength,maxlength, mask etc. So, validator framework is good for me. but for validation pupose i will need to open the Excel sheet and read each value. Cant figur out what to do. Please help. Deepa - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: validator framework in my Action class
If you want to call the Validator then the easiest way to find out how is to look at the "validate" method of one of the "validator" flavour ActionForms - for example ValidatorForm. As to validating an excel spreadsheet - typically validator is called with a "bean" (or form) full of data. If you are extracting/converting your excel data into some kind of bean - then looking at what the "validator" flavour ActionForms do should help you out. If however you have it in some java representation of a excel, then I'm not sure what the easiest solution would be (don't even know what software you're using to read excel) - without knowing the format/structure. We have a small excel framework built on top of Jakarta POI and found it easier to just build a small set of rules into that framework, rather than trying to use something like validator. Niall - Original Message - From: "Deepa Khetan" <[EMAIL PROTECTED]> Sent: Saturday, March 04, 2006 11:46 AM No body has any answers or work around for this?? :( -- Forwarded message -- From: Deepa Khetan <[EMAIL PROTECTED]> Date: Mar 2, 2006 9:01 PM Subject: validator framework in my Action class To: Struts Users Mailing List Hi Is there a way in which i can use the validator framework in my Action class? Actually, i have a functionality in which the user can upload an Excel sheet with a number of records. Now, this excel sheet needs to be in a format and every column needs to be validated for minlength,maxlength, mask etc. So, validator framework is good for me. but for validation pupose i will need to open the Excel sheet and read each value. Cant figur out what to do. Please help. Deepa - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
validator framework in my Action class
No body has any answers or work around for this?? :( -- Forwarded message -- From: Deepa Khetan <[EMAIL PROTECTED]> Date: Mar 2, 2006 9:01 PM Subject: validator framework in my Action class To: Struts Users Mailing List Hi Is there a way in which i can use the validator framework in my Action class? Actually, i have a functionality in which the user can upload an Excel sheet with a number of records. Now, this excel sheet needs to be in a format and every column needs to be validated for minlength,maxlength, mask etc. So, validator framework is good for me. but for validation pupose i will need to open the Excel sheet and read each value. Cant figur out what to do. Please help. Deepa
validator framework in my Action class
Hi Is there a way in which i can use the validator framework in my Action class? Actually, i have a functionality in which the user can upload an Excel sheet with a number of records. Now, this excel sheet needs to be in a format and every column needs to be validated for minlength,maxlength, mask etc. So, validator framework is good for me. but for validation pupose i will need to open the Excel sheet and read each value. Cant figur out what to do. Please help. Deepa