Redirect Manager Import Spreadsheet Issue

[gagandeepsaluja22]

Required Information

• AEM Version, including Service Packs, Cumulative Fix Packs, etc: AEMaaCS SDK 2021.12.6151_
• ACS AEM Commons Version: 5.6.0___
• Reproducible on Latest? yes

Expected Behavior

Redirect Manager import functionality should work without any issues.

Actual Behavior

Redirect Manager import functionality is giving 400 Bad request error.

Steps to Reproduce

1. Open the Redirect Manager on the AEM instance.
2. Go to Import tab and use the below CSV values (Create a sample CSV) -> Import the CSV

Source Target Status Code Tags
/content/geometrixx/en/blog /content/project1/us/en1 301 wknd-shared:

Links

Links to related assets, e.g. content packages containing test components

[YegorKozlov]

Can you please attach the input spreadsheet?
Redirect Manager imports from an Excel spreadsheet and you seem to be uploading a CSV file.

[gagandeepsaluja22]

acs-redirects (2).xls
acs-redirects (2).xlsx

[gagandeepsaluja22]

Tried with attached sheets and it doesn't seem to work.

[YegorKozlov]

@gagandeepsaluja22 Importing from spreadsheet was improved in the latest release 5.7.0. The attached spreadsheets worked fine for me.
Also, instead of silent page reload user now gets a feedback dialog with the information which cell had what problem