| MDemosWMF | |
| Nov 19 2025, 10:41 PM |
| F70306460: Screenshot 2025-11-20 at 3.56.38 PM.png | |
| Nov 20 2025, 9:58 PM |
| F70306462: Screenshot 2025-11-20 at 3.57.29 PM.png | |
| Nov 20 2025, 9:58 PM |
I'm trying to use import ID 2900 to run an NCOA update for a file of records in Civi. I keep getting the error that the date is Invalid, but I've checked the format setting and it seems to match what is in the file. I tried to change it to a new format as well and see if that worked, but no change. Can someone look into what might be happening?
The file is saved here: https://drive.google.com/file/d/1xevdMdI8lj5NoVrogM-5DGs_MYUA06CB/view?usp=drive_link
Thanks!
If you want to get this one done immediately though, you can just change the format of the date in the last column to MM/DD/YY in the csv.
@Lars I just tried to adjust again and it is still coming back with the error:
This should be the right formatting, correct?
@MDemosWMF Sorry about that, I misread the code that sets the date format. But I just did the import with YYYY-MM-DD (there are a couple errors)
And then it will correctly respect the setting once that upstream patch gets merged and we pull it down locally.
@Lars Thanks! It looks like those are a part of the Faircom using old CID issue. I will try to find the new CIDs myself since there are so few and reimport.
@Lars I tried to update the date in the file and reimport with the YYYY-MM-DD format and correct CIDs, but when I do the import the updates I made to the date format in the file are not reflected. I tried to save multiple times and reimport, but it is not showing that I changed it to YYYY-MM-DD in the file. Any ideas?
File is here: https://drive.google.com/file/d/1H59uOHCVbdFNjmtwBjH58riqTCES8jkF/view?usp=drive_link
@MDemosWMF Are you changing the date format in Excel? Maybe it is changing it on export somehow?
I just made a copy in Google Sheets, changed the format and exported as CSV and it looks correct: https://docs.google.com/spreadsheets/d/1fU51rpUUhxJFLys4D29WhypehA27o-nS7ZXoeF36Qkk/edit?usp=sharing
Change #1210701 had a related patch set uploaded (by Lars SG; author: Lars SG):
[wikimedia/fundraising/crm@master] Use submitted date format instead of template date format for contact imports This is merged upstream by Eileen.
Change #1210701 merged by Lars SG:
[wikimedia/fundraising/crm@master] Use submitted date format instead of template date format for contact imports This is merged upstream by Eileen (https://github.com/civicrm/civicrm-core/pull/34097).
@Lars The same thing is happening with a new NCOA file. I also tried to open it as a google sheet and export as a .csv but it's not working for me. The file is here: https://drive.google.com/file/d/1XY1WPeBuVFTjuBHOJj0v8pDlfPipKdq3/view?usp=drive_link. Any ideas why it's registering as an invalid date format?