hello kentico dev i try to execute a schedul task to read csv file and save the data into custom table but i think but nothing created any one have idea but it thanks` string filePath = @"C:\convertcsv.csv";
// Check if file exists.
int datacreated = 0;
int dataupdated = 0;
int dataerror = 0;
// Read column headers from file
CsvReader csv = new CsvReader(File.OpenText(filePath));
List<string> headers = csv.Context.HeaderRecord.ToList();
// Prepares the code name (class name) of the custom table to which the data record will be added
string customTableClassName = "AT.People";
// Gets the custom table
DataClassInfo customTable = DataClassInfoProvider.GetDataClassInfo(customTableClassName);
if (customTable != null)
// Creates a new custom table item
CustomTableItem newCustomTableItem = CustomTableItem.New(customTableClassName);
// Sets the values for the fields of the custom table (ItemText in this case)
// Save the new custom table record into the database
EventLogProvider.LogInformation("No parent", "No parent", "Page can't be created as there is no parent page.");
catch (Exception ex)
string result = datacreated + " data are created and " + dataupdated + " data are updated and " + dataerror + " data have errors.";
Try to do exactly the same thing but manually: go to admin interface of your custom table and try to add a record with empty email only. See if this works. Most likely you have some constraints on your table.
Did you try to debug and see where it stops?
As I currently don't see anything filling the filePath. Is there any result being returned in the tasks module? Or any error?
Please, sign in to be able to submit a new answer.