FaishalAnis
commented
9 months ago Here are some steps you can take to address this issue:
Check Date Format in CSV: First, open your CSV file in a text editor (such as Notepad) and verify the format of the date column. Ensure that it matches the expected format (e.g., “2-8-24” or “02/08/24”). If the date format in the CSV is different from what you expect, you may need to adjust it.
Importing into Excel: When importing the CSV into Excel, follow these steps: Use the Data tab and select Get Data or From Text/CSV (depending on your Excel version). In the Text Import Wizard, choose the correct delimiter (usually comma or semicolon). For the date column, select the Date option and specify the existing date format used in the CSV (e.g., “mm-dd-yy” or “dd/mm/yy”). https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-control-date-format-when-importing-csv/56ec1db7-929f-4c51-ac29-51e243b88561
Regional Settings: Ensure that your computer’s regional settings match the expected date format. Sometimes Excel uses the system’s regional settings to interpret dates. If necessary, adjust your regional settings to match the format used in the CSV.
Test with a Smaller Dataset: Create a smaller test CSV file with a few rows containing different date formats. Import this test file into Excel and observe how the dates are handled. This will help you identify any specific issues related to date formatting.
Version Compatibility: Ensure that you are using a compatible version of the CSV importer with your application. Sometimes, issues arise due to version mismatches between different components of a system.
Hope this helps you with your problem
Describe the bug CSV importer is not correctly capturing the Acquired date. On the csv importer screen it will show the acquired date that it pulled form the CSV, but once it imports, it just puts the current date(todays date) as the Acquired date. I'll attach a small csv with 2-8-24 (I tested this import on 2-11)_ The import results screenafter selecting the csv, captures the correct cards and shows acquired date and value, but the date on my collection screen after importing them is today, 2-11 instead of 2-8 from the csv.
To Reproduce Submit a loom video, screenshots or illustrate the steps to reproduce the behavior:
Expected behavior the collection tab to have captured the acquired date as listed from the CSV
Screenshots or Videos testing date.csv
If applicable, add screenshots to help explain your problem. You can copy and paste right into this comment section.