code4romania / hartareciclarii

0 stars 0 forks source link

[Admin] Import points on map #89

Open anastk-code4 opened 7 months ago

anastk-code4 commented 7 months ago

User story As a user, I want to add multiple points on the map in bulk.

Description User wants to add an excel file containing multiple points details. Based on type of PCT_serviciu, user must attach a file that has an appropiate table header. (See Data Dictionary > Detalii punct) Nice to have: user can click on button "Descarca template-uri de import" to download an archive with import tables examples for each PCT_Serviciu.

Import flow described in Figma

Main flow User goes to Import page in the sidebar menu. User clicks on "Incarca lista" button, in order to create a new import. User sees a modal where they need to indicate type of import based on PCT_Serviciu, point coordinates types (Decimal, Stereo?), and upload an excel file. When other types of coordinates is selected, they are translated to Decimal coordinates; pins are placed where the coordinates indicate the position on map. The import is generated, and it is be displayed in the imports list, with a pending status, until it is executed. After it's executed and the points are added, a report is available for the user to check: user can click on "view report", to see number of added points and a list with added points, and number of failed attempts - with option to download an excel file containing the failed attempted rows in the sheet.