Insert data in application

1. User Login
2. Batch Upload data in xls format
   1. This requires a consistent model
   2. Align xls data headers with model entities
3. View of these data
   1. User has specific need of view
      1. adjust the labels of the data forms according to user needs.

View of data

• Categorize views
• Authorization view of data. (categories of users, roles )

Secure view of data to appropriately authorized users

Not all users have the same rights at all columns/headers (according to xls) and entities according to our model.

1. user login
2. Check users ' rights
3. Show only data views he has right to view
4. permit edit only to entities he has teh appropriate right

APPROVE CHANGES

(In case unauthorized user) Give permission to write/insert data in DB , and trigger an event for the editor or admin user to permit these changes.

Access to previous views of data

The versioning of the data is currently done by backup the different xls files 

but it could be implemented by versioning  in the tables .