CSV customised location sample file

[mahalakshme]

Issue:

• Currently we are having a sample file for locations in Upload menu. This causes issues since people who want to configure will not know what are the headers(from higher location hierachy to lower or reverse).
  https://avni.freshdesk.com/a/tickets/3603
  https://avni.freshdesk.com/a/tickets/2478
• When an existing location need to be updated, implementors are not sure how to update it.
• Since we had not mentioned sample values for GPS coordinates, sometimes users add degrees to it which leads it to break - https://avni.freshdesk.com/a/tickets/2700

Acceptance criteria:

• Move download sample file option to the left of upload.
• Do not show 'Download sample' button for 'Metadata.zip' upload selection.

• Display the location hierarchies based on the configuration in the 'Location Types'. Refer the image below.
  - Have the first option selected by default in both mode and location hierarchy. Should not be able to unselect it by clicking again. Thats how it already works for mode.
  - Display location hierarchies only for create mode and not for other modes
• Change 'Edit+create' to just 'Edit' mode. Add a tooltip for it that says 'Edit location's name, parent, GPS coordinates or properties'
• Also move the button locations as shown in below image

• The sample file should be according to the location hierarchy and mode selected

  1. sample file for create
     - Location hierarchy should be there based on highest to lowest level
     - Placeholder values need to be present as mentioned
     - Ignore last 4 columns mentioned - Out of scope

  2. sample file for Editing location
     - Modify the headers as mentioned in the sample file
     - Have the placeholder fields(3rd row) and descriptor row(2nd row) like mentioned
     - Ignore last 4 columns mentioned - Out of scope

• Link this here

Ignore the below:

Suggestions:

• In Edit+create we are allowing to create the lowest location as well - make it to be created only via Create mode.

• Since we are allowing to update parent - mention the entire hierarchy along with uuid to update to keep the expectation uniform

• In the locations export, along with titleLineage - mention it in separate columns as well

    -  [sample_locations.csv](https://github.com/avniproject/avni-product/files/15187945/sample_locations.csv) - teachAP sample file when downloaded should be like this
  

When data uploaded with that * it needs to continue to work.

Current behavior that need not be handled:

• when just mentioned space - doesn't create location with space
• When lower location mentioned without mentioning higher location - creates orphan lower locations - but this is okay

Note:

• GPS coordinates and location properties used in reports
• Though legacy id is supported in Create, didnt mention it in sample file, since it is not used mostly, and might cause confusion.

Inputs:

• show the location hierachy vs lower location level,
• if blank should not create
• Add notes - good to do vs effort - we skip it when processing
• UUID in the header is fine - is showing as Identifier a antipattern
• export locations - clean and neat,
• being able to export metadata as well along with along with transactional LE
• date, headers,
• if drop-downs simplifies this, we should think whether we want to move to xlsx and formats supported on other Operating system

Questions:

• Dual hierarchy like APF odisha?
• multiple level 1s like in rwb2023
• How would users know UUID in the Locations page is the ID? - add notes below, change UUID to ID in the webapp UI in the Admin -
• in RWB - location properties can set up via UI, so they do via CSV, MC also has

Analysis notes:

https://avni.freshdesk.com/a/tickets/2700 - degree in GPS and location already existing
--- degree - solved by data in sample file
--- location already existing - it does error out - so donno whats the case
https://avni.freshdesk.com/a/tickets/2442 - location properties related - possible answers are add, date add - add columns
--- should be fine since configuration is handled by implementation team

[himeshr]

Sample files:
sample-locations-RWB-Edit.csv
sample-locations-RWB-Create.csv
sample-locations-APF-Hierarchy1-Create.csv
sample-locations-APF-Hierarchy2-Create.csv

[AchalaBelokar]

• I Login with AchalaB@rwbniti the location csv should contain all the location level but dam is not visible in the csv.

sample-locations (9).csv

pls check this

[himeshr]

• AchalaB@rwbniti

@AchalaBelokar you would get only those location types, that are part of the selected locationHierarchy.
You would have selected the "Nalla" locationType's hierarchy, therefore the sample has only that and its parent lineage locationTypes.

[mahalakshme]

@AchalaBelokar uuid for location edit not needed, since location names are going to be unique. Just adding here for later reference, since I also keep forgetting the reasons.