Skip to main content
Question

Issue with (unwanted) date conversion in CSV import

  • April 16, 2025
  • 2 replies
  • 66 views
G
Author
Forum|alt.badge.img+7

I have a CSV file with a column indicating  the month dimension. It is “Jan 25”, “Feb 25”, etc. 

On the initial import screen it looks correct,



however, as soon as I map it to the Pigment property (Month dimension type) it shows in the preview as 


My imported data is all loaded into the wrong months. 

I want it to just take the exact value in my CSV as the name for the Month dimension instead of converting a date. I tried double-quoting the field in the CSV, that didn’t help. Loading it into a regular text property works fine so it doesn’t appear to be an issue with the source data itself. 


 

2 replies

Min Li
Master Helper
Forum|alt.badge.img+12
  • Min LiMaster Helper
  • Master Helper
  • 70 replies
  • April 17, 2025

​@geoff_chovaz Can you try to convert your ending date format as 03-01-2025 in Excel, then map it to month dimension. I think pigment consider your ending date as date format instead of text format.

 

 

Min Li
G
Author
Forum|alt.badge.img+7
  • geoff_chovazAuthor
  • Author
  • Author
  • 14 replies
  • May 5, 2025

Yes, that’s what I had to end up doing (not in excel, but in the source). 

It’s a little unintuitive that all other dimensions can be mapped directly to the default property, but dimensions tagged as time have to be in a date format that then gets converted. I was (incorrectly) assuming that if I wanted to load data to Q1 22 I could just pass that in, but you can’t. Youd have to pick a date within that quarter. 


Ask your question here!

Terms & ConditionsCookie settingsAccessibility statement