avniproject / avni-webapp

Web application for management and data entry
https://avniproject.org
GNU Affero General Public License v3.0
12 stars 42 forks source link

Spaces in headers and locations needs to be truncated #1255

Closed mahalakshme closed 1 month ago

mahalakshme commented 4 months ago

This was erroring out because there was a space in the header 'Catchment Name '. And it took long time to figure out the issue.

AC:

Dinesh2019 commented 2 months ago

When we upload the file for user and catchment i am getting the error stating that provide location does not exist in the avni but the location is already exist in the system.

Env : staging org : Teststatus user : dinesh@teststatus

steps to reproduce :

1.Login to the webapp 2.Downloaded the user and catchment sample file 3.Edit the file according to the location 4.Upload the file

Expected result : it should accept and create or it should show Headers are incorrect if the data is invalid Actual : it shows the Provided Location does not exist in Avni. Please add it or check for spelling mistakes 'Karanataka,tel,sol,dol'

Sample files :

uploaded file sample-usersAndCatchments (1).csv

error file : errors-sample-usersAndCatchments (1)(1).csv

petmongrels commented 2 months ago

This is not a bug as the address lineage needs to have space in between. This fix is only for preceding and trailing space is any cell.

Dinesh2019 commented 2 months ago

We have changed the header for each header we are getting diff error message

error file :

1.

errors-sample-usersAndCatchments (1) (1).csv

2.

errors-sample-usersAndCatchments (3).csv

mahalakshme commented 1 month ago

@petmongrels yeah I also didn't mean the in between spaces in the AC. So all the points in the AC applies.

Dinesh2019 commented 1 month ago

Refer video :

Click here to watch video