postman-app-support icon indicating copy to clipboard operation
postman-app-support copied to clipboard

CSV import auto-detect not detecting properly

Open beth-isp opened this issue 1 year ago • 0 comments

Is there an existing issue for this?

  • [X] I have searched the tracker for existing similar issues and I know that duplicates will be closed

Describe the Issue

I'm running a collection with a csv file to import the many data rows. Some of these fields contain numbers. I'm pretty certain that all of my values in the csv file are saved as strings. But in the Preview, they come up as Auto-Detect, and they get auto-detected as numbers. I can understand that for the fields that have only numbers, even though it is a little frustrating. But the main issue is, that I have a phone number that contains a +, but even this gets detected as a Number, and removes the + from the front. When I change it to String, the + is added back. Screenshot 2024-09-12 at 13 46 21 Screenshot 2024-09-12 at 13 46 27 CSV: AccountCreation1726148920.csv

Steps To Reproduce

  1. Create a CSV file with a value of a phone number with a plus, e.g. +447929601469
  2. Select to run a collection
  3. Import the CSV
  4. Preview the CSV

Screenshots or Videos

Screenshot 2024-09-12 at 13 46 21 Screenshot 2024-09-12 at 13 46 27

Operating System

macOS

Postman Version

11.11.1

Postman Platform

Postman App

User Account Type

Signed In User

Additional Context?

No response

beth-isp avatar Sep 12 '24 12:09 beth-isp