/*
get the data from system import set table into Scooby Do Data Migration Tracker
*/
var importedDataTableName = "x_221138_scooby_do_scooby_do_import_data"; // NOTE: change this value to match the table you created in the Load Data process
// get all the records from the imported data
var scoobyDoImportedRecords = new GlideRecord(importedDataTableName);
//scoobyDoImportedRecords.setLimit(3); // uncomment this line to limit the number of records to create in the data migration tracker

var scoobyDoDataMigrationTrackerTable = "x_221138_scooby_do_scooby_do_data_migration_tracker"; // NOTE: Change this value match name of the data migration tracker table you created
scoobyDoImportedRecords.query();
while (scoobyDoImportedRecords.next() ) {
	var scoobyDoImportedDataSysID = scoobyDoImportedRecords.getValue('sys_id');
	var scoobyDoImportedDataNumber = scoobyDoImportedRecords.getValue('u_case_number');
	
	var dataTracker = new GlideRecord(scoobyDoDataMigrationTrackerTable);
	var encodedQuery = "u_imported_data_sys_id=" + scoobyDoImportedDataSysID;
	dataTracker.addEncodedQuery(encodedQuery);
	dataTracker.query();
	// ONLY IF we haven't already imported this record from the imported data
	if (!dataTracker.next()) {
		dataTracker.initialize();
		gs.info("ScoobyDo - Get Imported Data into Data Migration Tracker >>> Adding Scooby Do Imported Record: " + scoobyDoImportedDataNumber + " to the tracker.");
		dataTracker.setValue('u_imported_data_sys_id', scoobyDoImportedDataSysID);
		dataTracker.setValue('u_imported_data_number', scoobyDoImportedDataNumber);
		dataTracker.insert();
	}
}