We are attempting to import individuals, and some records are rejected with the error "Invalid Date".
We have seen the "Fuzzy date" error before, when the date format mask was wrong (MM/DD/YYYY instead of DD/MM/YYYY) - but we can't see what the meaning on "Invalid Date" is... the dates look in the same format.
I am sorry you are encountering a more complicated issue! In order to properly assist you with this particular issue, I will need to examine the following files: the data file, the error.txt and the IOM profile being used for this import. Please send these files to Support@omaticsoftware.com so that I can better assist you with your issue. When I have a resolution, I will post to this thread.
To send your IOM profile, please follow these steps:
* Go to IOM Configuration * Highlight the name of the profile you are using * Right click on it and choose to export * Send the .xml file that is created * It will be named in this fashion: IOM_Profile_Export_.xml
Thanks! Amanda Omatic Support
I
Ian Hamilton
said
over 7 years ago
Hi Amanda,
Required files sent to Support@omaticsoftware.com as requested.
Ryan Davies
Hi Omatic,
We are attempting to import individuals, and some records are rejected with the error "Invalid Date".
We have seen the "Fuzzy date" error before, when the date format mask was wrong (MM/DD/YYYY instead of DD/MM/YYYY) - but we can't see what the meaning on "Invalid Date" is... the dates look in the same format.
The errors appear as:
Line 3150: Invalid Date: Description [Object: 'CAttribute', PK: '132805', Import ID: 'Attr1-8107192', Desc: 'Yes', Field: 'Description', Value: 'Yes'] -->BBREAPI.CRecordClass.Save()-->#=qNpfjBqfSJoHzk5lIP2 4TI2O1FS5s2jghQVloBAfku0=.#=qhn_P8zQo_cwWoyJNKRH3CQ==()
Line 3162: Invalid Date: Description [Object: 'CAttribute', PK: '133002', Import ID: 'Attr1-8107212', Desc: 'Yes', Field: 'Description', Value: 'Yes'] -->BBREAPI.CRecordClass.Save()-->#=qNpfjBqfSJoHzk5lIP2 4TI2O1FS5s2jghQVloBAfku0=.#=qhn_P8zQo_cwWoyJNKRH3CQ==()
And here's the input data:
If anyone can help us understand what is invalid about the dates, that would be most helpful!
Thanks,
Ryan