Part 1: Data format Creation : USER
Create a utility to upload excel format (set by user1) for data collection: PrimaryExcel
The ‘primary excel’ is configurable basis varying needs so the number of columns or rows is not fixed.
The column headers will be set by user basis the need.
Part 2: Format upload & intimation : SYSTEM & USER
The primary excel will be converted into secondary excel formats and corresponding intimation will go to the selected mailer group (MGrp).
The mailer group will have a set of email ids along with description.
User can define mailer groups beforehand and the system should allow multi-select option for MGrps while initiating any data collection request as explained in part 1.
Secondary excel formats will be a copy of the primary format in terms of columns and rows.
The ‘description’ in Mgrp should be pre-fixed to the name of primary excel format to create multiple secondary excel formats.
These secondary excel formats will be shared on mail to each of the email ids under the selected mailer group
Email : User 1 has requested the attached data. Request you to please update and share back. Kindly click on the below ‘upload link’ to upload the updated data format. Same link can be used to upload any data changes at a later date as well(entire excel format).
Upload link will enable the end user(user 2) to upload the updated data format.
The data upload date needs to be saved in the backend to track changes on account of re-upload.
Part 3: Data compilation & download : SYSTEM
User 2 should be able to see the file uploaded in the system by him.
User 2(Initiator) should be able to see & download the COMPILED data- excel. Compilation to happen with addition of a column corresponding to the ‘description’ field in the mailer group.
System to maintain a ‘request number’ against any data request & corresponding count of uploads(users from mailer group who have uploaded the data format). Same needs to be displayed to the User 1 as a summary report of ‘data upload’ status :
Report Format : columns
Request number(Primary format file name) |Requested from | Received from | Receipt date | Status
( Requested from=count of users in mailer group, Received from : User description, Receipt date : Upload date )