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