[FX.php List] To data condition or not data condition. That is the question

[Jonathan Schwartz]

Hi Folks,

To data condition or not data condition. That is the question

This is a philosophical question, I believe.

Up until now, most of my projects have dealt with collecting records 
where 100% of the records would be used later in the client's 
FileMaker systems. It made sense to apply capitalization and phone 
number formatting and such to have the data comply with existing data 
standards.

In a new project, however, records are being submitted that will be 
stored in a remote database and undergo a series of reviews before 
potentially being accepted and copied to the main database.  Perhaps 
5% will make it.

Because..
	- Data conditioning isn't a perfect process
	- It costs time to develop
	- It costs cycles to run
	- It "taints" the original data entry. (What would ee 
cummings think about having his name be capitalized?)
	- Only a small number of records will emerge from the process

...does it makes sense to perform this step?

Also, is this a question best left to the client?

Would appreciate the insight of folks who have dealt with 
this....except Bob of course. ;-)

Jonathan
-- 
Jonathan Schwartz
Exit 445 Group
jonathan at exit445.com
http://www.exit445.com
415-370-5011