def Start(self, logger, moduleName, filelocs):
'''
Start of routine
'''
try:
ApplicationBase.Start(self, logger, moduleName, filelocs)
for sheet in self.job["ExcelSheets"]:
self.DownloadAllFiles(sheet)
self.ConvertExcel2Csv(sheet)
self.SkipPackAndLoad(self.job["ExcelSheets"])
if "postETLQueries" in self.job:
ApplicationBase.CreateTables(self, self.job["postETLQueries"])
except Exception:
logger.exception(moduleName + " - Exception!")
raise
def Start(self, logger, moduleName, filelocs):
'''
Start of routine
'''
try:
ApplicationBase.Start(self, logger, moduleName, filelocs)
for srcFileParameter in self.job["srcFileParameters"]:
self.DownloadAllFiles(srcFileParameter)
self.UnzipExcel(srcFileParameter)
self.SkipPackAndLoad(self.job["srcFileParameters"])
if "postETLQueries" in self.job:
ApplicationBase.CreateTables(self, self.job["postETLQueries"])
except Exception:
logger.exception(moduleName + " - Exception!")
raise