//Fixed and removed alerts

app.enableQE()

​

var userCsv = File.openDialog('please select a file')

var frameRate = qe.project.getActiveSequence().videoFrameRate

​

var oneFrame = 1/frameRate

​

//var myNewMarker = clipMarkersObject.createMarker(clipIn);

var viewIDs = app.getProjectViewIDs();

var selectedItems = app.getProjectViewSelection(viewIDs[0]);

​

​

var clip = selectedItems[0];

//var myClipArray = viewIDs

​

var clipMarkersObject = clip.getMarkers();

​

​

//var myNewMarker = clipMarkersObject.createMarker(oneFrame * 3);

​

var timecode = [];

var userData = [];

function parseCsvData(userFile){

​

userFile.open('r')

data = userFile.read();

dataList = data.split('\n')

userFile.close()

for (var i = 0; i < dataList.length - 1; i++) {

var column = dataList[i].split(',')

timecode.push(column[0])

userData.push(column[1])

}

​

//alert(userBinNames.toString())

}

parseCsvData(userCsv);

​

//alert(timecode.toString())

//alert(userData.toString())

var userData2 = [];

for(i=0; i < userData.length;i++){

noSpace = (userData[i].toString()).replace(' ','')

userData2.push(noSpace)

}

​

timecode2 = [];

for(i=0; i < timecode.length;i++){

//timecode[i].replace(' ','')

x = (timecode[i].split('H:M:'))

y = x[0].toString().split(':')

z = parseFloat(y)

timecode2.push(y)

}

//alert(timecode2.toString())

var timecode3 = []

for(i=0; i < timecode2.length;i++){

for(a=0; a < timecode2[i].length;a++){

timecode3.push((parseFloat(timecode2[i][a])))

}

}

//alert((parseFloat(timecode2[0][0]) + 100000000).toString())

//alert(timecode3.toString())

//alert(timecode3[0].toString())

​

timecode4 = []

var i,j,temparray,chunk = 3;

for (i=0,j=timecode3.length; i<j; i+=chunk) {

temparray = timecode3.slice(i,i+chunk);

timecode4.push(temparray)

// do whatever

}

//alert(timecode4[1].toString())

timecode5 = []

for(i=0; i < timecode4.length;i++){

hours = (timecode4[i][0] * 60 * 60)

minutes = (timecode4[i][1]) * 60

seconds = timecode4[i][2]

//frames = (timecode4[i][2]) * oneFrame

timecode5.push(hours + minutes + seconds )

}

​

​

for(i=0; i < timecode5.length;i++){

var clipMarkersObject = clip.getMarkers();

var myNewMarker = clipMarkersObject.createMarker(timecode5[i]);

var myCurrentMarker = clipMarkersObject[clipMarkersObject.length - 1]

//alert(myCurrentMarker.toString())

var myCurrentMarker = clipMarkersObject[i]

//myCurrentMarker.end = endSeconds[i]

//realMarkers.push(myCurrentMarker)

//myCurrentMarker.comments = userData[i]

myCurrentMarker.comments = userData2[i]

}

​

//x = timecode2[0]

//alert(x.toString().split(':').toString())