Hi Matt,
A fantastic tool. Recently I have been having problems and it fails, the following in in the log. Does this give a clue to what is wrong?
thanks
2012-11-15 10:01:16.6686|Info|User selected file for import: C:\Program Files\Matt Smith\SIMS Bulk Import Tool\sims.csv
2012-11-15 10:01:18.6373|Error|System.ArgumentOutOfRangeException: Index and length must refer to a location within the string.
Parameter name: length
at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy)
at Matt40k.SIMSBulkImport.NumberAsText.fix(String toFix) in C:\Users\Matt\Documents\Visual Studio 2010\Projects\GingerBeard\SIMSBulkImport\NumberAsText.cs:line 76
at Matt40k.SIMSBulkImport.NumberAsText.Fixed(String file) in C:\Users\Matt\Documents\Visual Studio 2010\Projects\GingerBeard\SIMSBulkImport\NumberAsText.cs:line 47
2012-11-15 10:01:18.6373|Error|System.IO.IOException: The process cannot access the file 'C:\Documents and Settings\gdb\Local Settings\Temp\tmpE6.tmp' because it is being used by another process.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.File.Delete(String path)
at Matt40k.SIMSBulkImport.NumberAsText.Fixed(String file) in C:\Users\Matt\Documents\Visual Studio 2010\Projects\GingerBeard\SIMSBulkImport\NumberAsText.cs:line 56
at Matt40k.SIMSBulkImport.ImportFromFile.GetCSVFile(String pathName1, String fileName1) in C:\Users\Matt\Documents\Visual Studio 2010\Projects\GingerBeard\SIMSBulkImport\ImportFromFile.cs:line 141
2012-11-15 10:01:18.6373|Error|System.IndexOutOfRangeException: Cannot find table 0.
at System.Data.DataTableCollection.get_Item(Int32 index)
at Matt40k.SIMSBulkImport.Match.GetDataTable() in C:\Users\Matt\Documents\Visual Studio 2010\Projects\GingerBeard\SIMSBulkImport\Match.xaml.cs:line 200