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; try { if (File.Exists(filePath)) { // Read column headers from file CsvReader csv = new CsvReader(File.OpenText(filePath)); csv.Read(); csv.ReadHeader(); 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) newCustomTableItem.SetValue("Email",""); // Save the new custom table record into the database newCustomTableItem.Insert(); } else EventLogProvider.LogInformation("No parent", "No parent", "Page can't be created as there is no parent page."); datacreated++; } } catch (Exception ex) { dataerror++; } string result = datacreated + " data are created and " + dataupdated + " data are updated and " + dataerror + " data have errors."; return result;`
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?
filePath
Please, sign in to be able to submit a new answer.