Cannot import queue message in Azure Queue

[viennamari]

Preflight Checklist

• [X] I have installed the latest version of Storage Explorer.
• [X] I have checked existing resources, including the troubleshooting guide and the release notes.
• [X] I have searched for similar issues.

Storage Explorer Version

1.34.0

Regression From

1.34.0

Architecture

x64

Storage Explorer Build Number

20240532.2

Platform

Windows

OS Version

Windows 10

Bug Description

Cannot parse queue message with double quotes or quoation marks but can be inserted in add new queue message option.

Steps to Reproduce

1. Launch Azure Storage Explorer.
2. Go to Azure Queues.
3. Click Import button to import csv file
4. Unable to parse error resulted due to double quotes or quotation marks.

Actual Experience

Error happened in importing a csv file to insert to Queues.

Expected Experience

Should accept the csv file as valid and should continue normally with the import.

Additional Context

No response

[craxal]

@RichardMSFT CSV parsing should be consistent. Can you make sure parsing for queue import functions the same way as table import?

@viennamari Can you provide a sample CSV file for us?

[viennamari]

sampleimportCSV.csv here is the sample csv I created based on the queue messages I can insert which contains two queue messages seperated by "||". Thanks!

[craxal]

@viennamari The file contents you sent appears to be XML, not CSV:

[viennamari]

Hello, yes because our queue messages are in xml format but I saved two queue messages separated by "||" in csv file

[richardMSFT]

@viennamari If I'm understanding correctly, it looks like what you're intending to do is not possible with how import queue message is setup as of today. Currently importing messages into a queue from a .csv file behaves where each row is a message and the value in the first column is the message text. This was done to give room for the future where other columns could specify properties like time to live and visibility timeout if there was a demand for it.

So as it stands, when importing from a .csv file the delimiter string is what separates columns and line breaks are what separates the rows. In the case of the .csv file you shared, because each "XML document" spans multiple lines they will be inserted into the queue as multiple messages, one per line. I don't think this is what you intended, but instead I believe you are trying to insert only two messages separated by the || characters.

For today, you have either the option of having each "XML document" be contained within one line for queue import or continue to use the add message action. If you think that import queue message functionality could be improved, please open a separate issue on GitHub as a feature request

[richardMSFT]

Parsing queue messages with quotes will however be fixed in the upcoming release 1.35.0.