search

pfitzpaddy / ngm-reportDesk

The workdesk for ReportHub
1 stars 6 forks source link

Upload Monthly Report from xls #285

Closed drfaustusfade closed 4 years ago

drfaustusfade commented 5 years ago

Processing of uploaded xls file could be done directly on front end, in the same way, copy report functionality is done, but additionally looping through lists ( activities, locations etc ) and adding other _id fields ( report_id, project_id etc) to pick up required _id fields, so that the partners will need to specify only _name fields, with the common xls template provided .

pfitzpaddy commented 5 years ago

@drfaustusfade, FYI I’m currently working on a branch with js-xlsx for ngm-reportEngine. If that’s suitable let’s use the same lib (as I’ve completed XLSX backend work).

drfaustusfade commented 5 years ago

yes, this is the lib to use

drfaustusfade commented 4 years ago

satellite feature https://github.com/pfitzpaddy/ngm-reportDesk/issues/357

drfaustusfade commented 4 years ago

For upcomming open beta version Basic test cases: for xlsx, csv, textarea input:

  1. it should input by _named fields; template fields as per monthly report download, required columns to be present are so that to match location and activity, and activity required columns 2 it should match and add record by ( admin1,2,3names, sitename, sitetypename, implementationname ) and activity (cluster, type, description, details)
  2. it should validate if required value is missing or value is present in a not required activity field
  3. it should give error message if incorrect value is present
  4. it should respect cascading fields filtering
  5. it should limit to 1500 rows max
fakhrihawari commented 4 years ago

Link Pull Request : https://github.com/pfitzpaddy/ngm-reportHub/pull/400