aws configure import --csv Prompt error, Expected header "User Name" not found (when missing `file://` prefix)

[qian-jiahong]

Describe the bug

When executing: aws configure import --csv, the wrong file path is entered, and the "error prompt" received is wrong.

Expected Behavior

$ aws configure import --csv aws_user_credentials.csv
$ aws configure import --csv aws_user_credentials-noexist.csv

It should prompt that the file does not exist.
Instead of: Expected header "User Name" not found

Current Behavior

$ aws configure import --csv aws_user_credentials.csv
Expected header "User Name" not found

$ aws configure import --csv aws_user_credentials-noexist.csv
Expected header "User Name" not found

$ aws configure import --csv file://./aws_user_credentials.csv
Successfully imported 1 profile(s)

$ aws configure import --csv file://./aws_user_credentials-noexist.csv
Error parsing parameter '--csv': Unable to load paramfile file://./aws_user_credentials-noexist.csv: [Errno 2] No such file or directory: './aws_user_credentials-noexist.csv'

Reproduction Steps

Download the certificate file (.csv) from the aws website to the current directory. Named as: aws_user_credentials.csv
$ aws configure import --csv aws_user_credentials.csv
$ aws configure import --csv aws_user_credentials-noexist.csv

Possible Solution

No response

Additional Information/Context

No response

CLI version used

aws-cli/2.11.3 Python/3.11.2 Linux/5.15.0-56-generic exe/x86_64.ubuntu.20 prompt/off

Environment details (OS name and version, etc.)

Linux ubuntu20-s1 5.15.0-56-generic #62~20.04.1-Ubuntu SMP Tue Nov 22 21:24:20 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux

[tim-finnigan]

Hi @qian-jiahong thanks for reaching out. This is an error that I can reproduce. The documentation for aws configure import does use file:// as a prefix, but regardless the Expected header "User Name" not found is not a helpful error message.

We received another issue recently (#7721) involving this command, but that issue specifically had to do with a Byte Order Mark that wasn't getting parsed properly, and that also resulted in the Expected header "User Name" not found error. That issue should now be fixed in version 2.11.4. I will slightly modify the title of this issue to distinguish the two issues.

[vitaly-pavluk]

Thank you for that issue. It drives me crazy for 2 hours when I tried to figure out why on my win laptop I cannot import csv in the terminal using just the command
aws configure import --csv rootkey.csv
cli told me that Expected header "User Name" not found but it was in the csv file.
Finally when I changed the command on aws configure import --csv file://rootkey.csv everything was imported and no errors appeared in the terminal.
AWS SDK guys please just read "Principle of least astonishment" so it will dramatically reduce number of issues in AWS SDK GH.

[qian-jiahong]

Thank you for that issue. It drives me crazy for 2 hours when I tried to figure out why on my win laptop I cannot import csv in the terminal using just the command aws configure import --csv rootkey.csv cli told me that Expected header "User Name" not found but it was in the csv file. Finally when I changed the command on aws configure import --csv file://rootkey.csv everything was imported and no errors appeared in the terminal. AWS SDK guys please just read "Principle of least astonishment" so it will dramatically reduce number of issues in AWS SDK GH.

Me too.

[tarsir]

A couple weeks ago I gave this issue a try with my PR #7763, but I'm not sure if there's process I'm missing to get it reviewed by a maintainer 😅 My PR is probably a bit out of date by now, which I'm happy to fix if I could get a bit of guidance on the review process :)