How can we help you today?

Start a new topic
Discussions Raiser's Edge ImportOmatic

Invalid Date, Individual constituent record

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:

8107192 8107192 Mr Jonny Algeo M 03/09/1985
8107212 8107212 Master Charlie Adam M 17/04/1995
8107230 8107230 Master Tiwa Akinjide M 26/12/1999
8107264 8107264 Mr Tom Archer Tom M 03/09/1988
8107276 8107276 Miss Tosin Ade-Ajayi F 25/06/1996
8107296 8107296 Master Edward Ajibade M 25/07/1998
8107485 8107485 Mr Ali Amati M 16/09/1988
8107589 8107589 Miss Eleanor Atkinson Ellie F 07/07/1996
8107644 8107644 Miss Bethia Atkinson F 13/12/1994
8107690 8107690 Mr Peter Auld Peter M 13/11/1987
8107827 8107827 Miss Ruth Aymer F 18/05/1988


If anyone can help us understand what is invalid about the dates, that would be most helpful!

Thanks,

Ryan

2 CommentsSorted by Oldest First
Hello Ryan,

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

Hi Amanda, 

Required files sent to Support@omaticsoftware.com as requested.

Cheers, Ian

Login or Signup to post a comment
More topics in ImportOmatic
See all 1139 topics
Help Desk Software by Freshdesk