We're importing a data file with 73 lines, but keep getting the below error message on 3 lines.

Input string was not in a correct format. -->Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value, NumberFormatInfo NumberFormat)-->Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value)

 

The data isn't any different to the other 70 lines, so the whole team is confused.

 

The import is for Event Participants, adding the constituent to the event, with the relevant attributes and communication preferences. It also adds a new assigned canvasser (solicitor), and an Action to send out fundraising materials. 

 

We just can't find a reason for this error, can anyone help?

It looks like something to do with a decimal number trying to be converted to an integer.

check the columns with numbers in the rows that are exceptions. Sometimes Excel will automatically round numbers up/down in the display even if they have a decimal.

It would also be helpful to post the whole error file text.

There aren't any decimals in the import file, there isn't anything different about these 3 lines from the other 70. 

 

The error report is below:

IOM Version: 3.2.0.6 RE Version: 793.5782.4

Profile: S-O-E New Template

REImport Error File

Import Source: J:\SS&DBAdmin\ACD\Final_output.csv

Master ID Source: Raiser's Edge

 

Line 41: Input string was not in a correct format. -->Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value, NumberFormatInfo NumberFormat)-->Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value)

Line 58: Input string was not in a correct format. -->Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value, NumberFormatInfo NumberFormat)-->Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value)

Line 68: Input string was not in a correct format. -->Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value, NumberFormatInfo NumberFormat)-->Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value)

Omatic support will have to help with this one since they will need to try to recreate the issue using your input file and profile. I would suggest starting a case with them.