from iolite.QtGui import QFileDialog
from iolite.QtCore import QDateTime, QFileInfo
import pandas as pd
from datetime import datetime
import os

files = QFileDialog.getOpenFileNames(None, 'Select the xl files to import', '', 'PE xl files (*.xl);;')
#offset = QDateTime.currentMSecsSinceEpoch()/1000.0		#Will use file's mod time instead
tislabel = 'Time in Seconds ' # Note there is a trailing space

frames = []

for file in files:
	df = pd.read_csv(file, skiprows=1)
	duration = df.iloc[-1][tislabel]
	offset = os.path.getmtime(file)		#This should get the file's mod time in seconds
	df[tislabel] += offset
	frames.append(df)
	start = datetime.fromtimestamp(df.iloc[0][tislabel])
	end = datetime.fromtimestamp(df.iloc[-1][tislabel])
	data.createFileSampleMetadata(QFileInfo(file).fileName(),start , end, 'Script')

df = pd.concat(frames)
t = df[tislabel]
df = df.drop(tislabel, axis=1)

data.createImportedFileMetadata(datetime.fromtimestamp(t.iloc[0]), datetime.fromtimestamp(t.iloc[-1]), 'Script', datetime.today(), len(df), df.columns)

for col in df.columns:
	data.addDataToInput(col, t, df[col], {'machineName': 'PE xl', 'sampleName': 'From script'})