07-27-2018, 01:08 PM
I'm not sure I follow you, you are using the normal import mechanism right? You should be able to indicate which fields you want to use for comparison/duplicate detection when you do step 3 of the import. If you have a column with the Service Contract no., use that and select merge. Make sure your column headings match the field label in the Service Contract no. exactly.
Secondly, comments are not a normal module. You may still need to set a column for 'time start' and populate it with some date/time. The SQL is failing because it's trying to set the time_start column but you haven't provided one.
The cbcalendar module may be pulled in because the calendar is trying to keep track of all modules that have some sort of date field, to be able to show that in the calendar, but I'm not sure about that.
Secondly, comments are not a normal module. You may still need to set a column for 'time start' and populate it with some date/time. The SQL is failing because it's trying to set the time_start column but you haven't provided one.
The cbcalendar module may be pulled in because the calendar is trying to keep track of all modules that have some sort of date field, to be able to show that in the calendar, but I'm not sure about that.