-- added file validation routine
-- addition of entities mapping to classes
-- addition of validation procedures
-- database connection and properties for connect params
-- implemented logic of looking up missing fields
-- todo: refactoring..