how to validate excel spreadsheets
 

Hi guys

I am developing a document management solution in which some data will be
received as an xl spreadsheet that complies to a certain pre-defined
template/format (headings,datatypes etc) that maps to database columns where
the data will eventually be saved.How can I go about this also taking into
account that during validation all errors must be logged and routed to the
respective stakeholders

Please Help

how to validate excel spreadsheets
 

You need to define the fields you are bringing in and the type of data you
expect to be bringing in, then it would help to know the number of records
that you are expecting. Where is this data coming from, what is the source?
--
David


"Mason" wrote:

Hi guys

I am developing a document management solution in which some data will be
received as an xl spreadsheet that complies to a certain pre-defined
template/format (headings,datatypes etc) that maps to database columns where
the data will eventually be saved.How can I go about this also taking into
account that during validation all errors must be logged and routed to the
respective stakeholders

Please Help

how to validate excel spreadsheets
 

The number of records vary from 50 to about 500.The information is sent to us
by some 20 companies that supply us with information we use to generate
National reports. Ive had a look at an extract that about using xml with
excel but there didnt seem to be a way to automate the process

"David" wrote:

You need to define the fields you are bringing in and the type of data you
expect to be bringing in, then it would help to know the number of records
that you are expecting. Where is this data coming from, what is the source?
--
David


"Mason" wrote:

Hi guys

I am developing a document management solution in which some data will be
received as an xl spreadsheet that complies to a certain pre-defined
template/format (headings,datatypes etc) that maps to database columns where
the data will eventually be saved.How can I go about this also taking into
account that during validation all errors must be logged and routed to the
respective stakeholders

Please Help

how to validate excel spreadsheets
 

In this area, you will need to be very specific. The number of fields, the
type of each field, all suppliers of information supply their data in a
consistant format, all fields are filled in, etc.
--
David


"Mason" wrote:

The number of records vary from 50 to about 500.The information is sent to us
by some 20 companies that supply us with information we use to generate
National reports. Ive had a look at an extract that about using xml with
excel but there didnt seem to be a way to automate the process

"David" wrote:

You need to define the fields you are bringing in and the type of data you
expect to be bringing in, then it would help to know the number of records
that you are expecting. Where is this data coming from, what is the source?
--
David


"Mason" wrote:

Hi guys

I am developing a document management solution in which some data will be
received as an xl spreadsheet that complies to a certain pre-defined
template/format (headings,datatypes etc) that maps to database columns where
the data will eventually be saved.How can I go about this also taking into
account that during validation all errors must be logged and routed to the
respective stakeholders

Please Help

how to validate excel spreadsheets
 

That is exactly what I need to validate, that all required columns and fields
are on the spreadsheet,and that their format and/or datatype is what it
should be

"David" wrote:

In this area, you will need to be very specific. The number of fields, the
type of each field, all suppliers of information supply their data in a
consistant format, all fields are filled in, etc.
--
David


"Mason" wrote:

The number of records vary from 50 to about 500.The information is sent to us
by some 20 companies that supply us with information we use to generate
National reports. Ive had a look at an extract that about using xml with
excel but there didnt seem to be a way to automate the process

"David" wrote:

You need to define the fields you are bringing in and the type of data you
expect to be bringing in, then it would help to know the number of records
that you are expecting. Where is this data coming from, what is the source?
--
David


"Mason" wrote:

Hi guys

I am developing a document management solution in which some data will be
received as an xl spreadsheet that complies to a certain pre-defined
template/format (headings,datatypes etc) that maps to database columns where
the data will eventually be saved.How can I go about this also taking into
account that during validation all errors must be logged and routed to the
respective stakeholders

Please Help

how to validate excel spreadsheets
 

This is what you need to specify.
1) Number of fields
2) Type of field you are expecting

You can send some examples of the reports you recieve, including examples
with invalid data. Remove nopam , also include what
you expect the final report to look like and the data type of each field.

--
David


"Mason" wrote:

That is exactly what I need to validate, that all required columns and fields
are on the spreadsheet,and that their format and/or datatype is what it
should be

"David" wrote:

In this area, you will need to be very specific. The number of fields, the
type of each field, all suppliers of information supply their data in a
consistant format, all fields are filled in, etc.
--
David


"Mason" wrote:

The number of records vary from 50 to about 500.The information is sent to us
by some 20 companies that supply us with information we use to generate
National reports. Ive had a look at an extract that about using xml with
excel but there didnt seem to be a way to automate the process

"David" wrote:

You need to define the fields you are bringing in and the type of data you
expect to be bringing in, then it would help to know the number of records
that you are expecting. Where is this data coming from, what is the source?
--
David


"Mason" wrote:

Hi guys

I am developing a document management solution in which some data will be
received as an xl spreadsheet that complies to a certain pre-defined
template/format (headings,datatypes etc) that maps to database columns where
the data will eventually be saved.How can I go about this also taking into
account that during validation all errors must be logged and routed to the
respective stakeholders

Please Help