Index was outside the bounds of the array.

[sm7urw]

Hi!

Thanks for a great tool. I get the following error while trying to import Family.cvs:

2017-02-10 13:13:40,Transform Data,"System.IndexOutOfRangeException: Index was outside the bounds of the array. at Excavator.CSV.CSVComponent.LoadFamily(CSVInstance csvData) at Excavator.CSV.CSVComponent.TransformData(Dictionary`2 settings) at Excavator.ProgressPage.bwImportData_DoWork(Object sender, DoWorkEventArgs e)"

Whats the problem with my data?

God bless,

// Henrik

[dcs619]

Hey Henrik, thanks for sharing. You may want to verify the CSV is formatted correctly, usually that error signifies there is a unquoted comma somewhere.

Something like flat-file.net should point you in the right direction.

[sm7urw]

Hey and thanks @dcs619 !

That solved one issue but now I get the following error:

2017-02-21 09:19:05,Transform Data,"System.NullReferenceException: Object reference not set to an instance of an object. at Excavator.CSV.CSVComponent.LoadIndividuals(CSVInstance csvData) at Excavator.CSV.CSVComponent.TransformData(Dictionary`2 settings) at Excavator.ProgressPage.bwImportData_DoWork(Object sender, DoWorkEventArgs e)"

Do you know what that might mean?

[dcs619]

It sounds like there's a required field that's missing, but I can't tell from the error what it might be. Did you start with the sample CSVs to build your data file?

[sm7urw]

I've tried both importing the sample file and used that file to start building my own data file. Neither works.

[dcs619]

Ok, I'll take a look at the sample CSV file.

[sm7urw]

I managed to solve it somehow. Not sure what I did but I think the reason might be that I previously had changed fields such as Gender and Marital status to work with our language. Now it works great!

Thanks!