Python Excel 예제들

예제 #1

파일: importLawsuit.py 프로젝트: heodat234/worldfone4xs_ibm

import time
import sys
import os
import json
import csv
from pprint import pprint
from datetime import datetime
from datetime import date
from bson import ObjectId
from helper.ftp import Ftp
from helper.mongod import Mongodb
from helper.excel import Excel
from helper.jaccs import Config
from helper.common import Common

excel = Excel()
config = Config()
ftp = Ftp()
common = Common()
base_url = common.base_url()
wff_env = common.wff_env(base_url)
mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env)
_mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env)
log = open(base_url + "cronjob/python/Loan/log/importlawsuit.txt", "a")
now = datetime.now()
subUserType = 'LO'
collection = common.getSubUser(subUserType, 'Lawsuit')

try:
    modelColumns = []
    modelConverters = {}

예제 #2

import os
import csv
import json
from pprint import pprint
from datetime import datetime, timedelta
from datetime import date
from bson import ObjectId
from dateutil import parser
from helper.ftp import Ftp
from helper.mongod import Mongodb
from helper.excel import Excel
from helper.jaccs import Config
from helper.common import Common

try:
    excel = Excel()
    config = Config()
    ftp = Ftp()
    common = Common()
    base_url = common.base_url()
    wff_env = common.wff_env(base_url)
    mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env)
    _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env)
    log = open(
        base_url +
        "cronjob/python/Loan/log/importListOfAccountInCollection.txt", "a")
    now = datetime.now()
    subUserType = 'LO'
    collection = common.getSubUser(subUserType,
                                   'List_of_account_in_collection')

예제 #3

파일: importLNJC05Yesterday.py 프로젝트: heodat234/worldfone4xs_ibm

import time
import sys
import os
import json
import csv
from pprint import pprint
from datetime import datetime, timedelta
from datetime import date
from bson import ObjectId
from helper.ftp import Ftp
from helper.mongod import Mongodb
from helper.excel import Excel
from helper.jaccs import Config
from helper.common import Common

excel = Excel()
config = Config()
ftp = Ftp()
common = Common()
base_url = common.base_url()
wff_env = common.wff_env(base_url)
mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env)
_mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env)
log = open(base_url + "cronjob/python/Loan/log/importlnjc05yesterday.txt","a")
now = datetime.now()
subUserType = 'LO'
collection = common.getSubUser(subUserType, 'LNJC05_yesterday')
modelCollection = common.getSubUser(subUserType, 'LNJC05')

try:
    modelColumns = []

예제 #4

파일: importLNJC05F_bak.py 프로젝트: heodat234/worldfone4xs_ibm

import sys
import os
import json
from pprint import pprint
from datetime import datetime
from datetime import date
from bson import ObjectId
from helper.ftp import Ftp
from helper.mongod import Mongodb
from helper.excel import Excel
from helper.jaccs import Config
from helper.common import Common

mongodb = Mongodb("worldfone4xs")
_mongodb = Mongodb("_worldfone4xs")
excel = Excel()
config = Config()
ftp = Ftp()
common = Common()
base_url = config.base_url()
log = open(base_url + "cronjob/python/Loan/log/importLNJC05F.txt","a")
now = datetime.now()
subUserType = 'LO'
collection = common.getSubUser(subUserType, 'LNJC05')

try:
    modelColumns = []
    modelConverters = {}
    modelPosition = {}
    modelFormat = {}
    updateKey = []

예제 #5

import calendar
import time
import sys
import os
import json
from pprint import pprint
from datetime import datetime
from datetime import date
from bson import ObjectId
from helper.ftp import Ftp
from helper.mongod import Mongodb
from helper.excel import Excel
from helper.jaccs import Config
from helper.common import Common

excel = Excel()
config = Config()
ftp = Ftp()
common = Common()
base_url = common.base_url()
wff_env = common.wff_env(base_url)
mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env)
_mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env)
log = open(base_url + "cronjob/python/Loan/log/importSiteResult.txt","a")
now = datetime.now()
subUserType = 'LO'
collection = common.getSubUser(subUserType, 'Site_result')

try:
    modelColumns = []
    modelConverters = {}

예제 #6

import time
import sys
import os
import json
import csv
from pprint import pprint
from datetime import datetime
from datetime import date
from bson import ObjectId
from helper.ftp import Ftp
from helper.mongod import Mongodb
from helper.excel import Excel
from helper.jaccs import Config
from helper.common import Common

excel = Excel()
config = Config()
ftp = Ftp()
common = Common()
base_url = common.base_url()
wff_env = common.wff_env(base_url)
mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env)
_mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env)
now = datetime.now()
subUserType = 'TS'
collection = common.getSubUser(subUserType, 'Appointment')
log = open('/data/log_data/python/telesales/importAppointment.txt', "a")

try:
    modelColumns = []
    modelConverters = {}

예제 #7

파일: importSCSchedule.py 프로젝트: heodat234/worldfone4xs_ibm

from xlsxwriter.utility import xl_rowcol_to_cell
from pprint import pprint
from bson import ObjectId
from time import mktime as mktime
from helper.ftp import Ftp
from helper.mongod import Mongodb
from helper.excel import Excel
from helper.jaccs import Config
from helper.common import Common

common = Common()
base_url = common.base_url()
wff_env = common.wff_env(base_url)
mongodb = Mongodb("worldfone4xs", wff_env)
_mongodb = Mongodb("_worldfone4xs", wff_env)
excel = Excel()
config = Config()
ftp = Ftp()
# base_url = config.base_url()
log = open(base_url + "cronjob/python/Telesales/importSCschedule.txt", "a")
now = datetime.now()
subUserType = 'TS'
collection = common.getSubUser(subUserType, 'Sc_schedule')

try:
    importLogId = sys.argv[1]
    insertData = []
    resultData = []
    errorData = []
    countRow = 0

예제 #8

파일: importTelesale.py 프로젝트: heodat234/worldfone4xs_ibm

from pprint import pprint
from bson import ObjectId
from helper.common import Common
from helper.mongod import Mongodb
from helper.excel import Excel
from helper.jaccs import Config
from dateutil.parser import parse
import os.path
from os import path

common = Common()
base_url = common.base_url()
wff_env = common.wff_env(base_url)
mongodb = Mongodb("worldfone4xs", WFF_ENV=wff_env)
_mongodb = Mongodb("_worldfone4xs", WFF_ENV=wff_env)
excel = Excel()
config = Config()
base_url = config.base_url()
subUserType = 'TS'
collection = common.getSubUser(subUserType, 'Telesalelist')
# log         = open(base_url + "cronjob/python/Telesales/importTelesales.txt","a")
now = datetime.now()
# log.write(now.strftime("%d/%m/%Y, %H:%M:%S") + ': Start Import' + '\n')
try:

    try:
        sys.argv[1]
        importLogId = str(sys.argv[1])
        importLogInfo = mongodb.getOne(MONGO_COLLECTION=common.getSubUser(
            subUserType, 'Import'),
                                       WHERE={'_id': ObjectId(importLogId)})

예제 #9

파일: importSibs.py 프로젝트: heodat234/worldfone4xs_ibm

import calendar
import time
import sys
from pprint import pprint
from datetime import datetime
from datetime import date
from bson import ObjectId
from helper.ftp import Ftp
from helper.mongod import Mongodb
from helper.excel import Excel
from helper.jaccs import Config
from helper.common import Common

mongodb = Mongodb("worldfone4xs")
_mongodb = Mongodb("_worldfone4xs")
excel = Excel()
config = Config()
ftp = Ftp()
common = Common()
base_url = config.base_url()
log = open(base_url + "cronjob/python/Telesales/importSCschedule.txt","a")
now = datetime.now()
subUserType = 'TS'
collection = common.getSubUser(subUserType, 'Sibs')

importLogId = sys.argv[1]
sibsColumns = []
sibsConverters = {}

try:
    importLogInfo = mongodb.getOne(MONGO_COLLECTION=common.getSubUser(subUserType, 'Import'), WHERE={'_id': ObjectId(importLogId)})

예제 #10

import time
import sys
import os
import json
from pprint import pprint
from datetime import datetime
from datetime import date
from bson import ObjectId
from helper.ftp import Ftp
from helper.mongod import Mongodb
from helper.excel import Excel
from helper.jaccs import Config
from helper.common import Common

try:
    excel = Excel()
    config = Config()
    ftp = Ftp()
    common = Common()
    base_url = common.base_url()
    wff_env = common.wff_env(base_url)
    mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env)
    _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env)
    log = open(base_url + "cronjob/python/Loan/log/importNewOverdueListDaily.txt","a")
    now = datetime.now()
    subUserType = 'LO'
    collection = common.getSubUser(subUserType, 'New_overdue_list_daily')

    modelColumns = []
    modelConverters = {}
    modelPosition = {}

예제 #11

import sys
import os
import json
from pprint import pprint
from datetime import datetime
from datetime import date
from bson import ObjectId
from helper.ftp import Ftp
from helper.mongod import Mongodb
from helper.excel import Excel
from helper.jaccs import Config
from helper.common import Common

mongodb = Mongodb("worldfone4xs")
_mongodb = Mongodb("_worldfone4xs")
excel = Excel()
config = Config()
ftp = Ftp()
common = Common()
base_url = config.base_url()
log = open(base_url + "cronjob/python/Loan/log/importZACCF.txt", "a")
logRun = open(base_url + "cronjob/python/Loan/log/runImportZACCF.txt", "a")
now = datetime.now()
subUserType = 'LO'
collection = common.getSubUser(subUserType, 'ZACCF')

try:
    modelColumns = []
    modelConverters = {}
    modelPosition = {}
    modelFormat = {}

예제 #12

파일: importSibs_cron.py 프로젝트: heodat234/worldfone4xs_ibm

import os
import json
import csv
from pprint import pprint
from datetime import datetime
from datetime import date
from bson import ObjectId
from helper.ftp import Ftp
from helper.mongod import Mongodb
from helper.excel import Excel
from helper.jaccs import Config
from helper.common import Common

mongodb = Mongodb("worldfone4xs")
_mongodb = Mongodb("_worldfone4xs")
excel = Excel()
config = Config()
ftp = Ftp()
common = Common()
base_url = config.base_url()
log = open(base_url + "cronjob/python/Telesales/log/importSibs.txt", "a")
now = datetime.now()
subUserType = 'TS'
collection = common.getSubUser(subUserType, 'Sibs')

try:
    modelColumns = []
    modelConverters = {}
    modelConverters1 = []
    modelPosition = {}
    modelPosition1 = []

예제 #13

파일: importNote.py 프로젝트: heodat234/worldfone4xs_ibm

import time
import sys
import os
import json
import csv
from pprint import pprint
from datetime import datetime
from datetime import date
from helper.ftp import Ftp
from helper.mongod import Mongodb
from helper.excel import Excel
from helper.jaccs import Config
from helper.common import Common

try:
    excel = Excel()
    common = Common()
    base_url = common.base_url()
    wff_env = common.wff_env(base_url)

    mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env)
    _mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env)
    file_path = '/mnt/nas/upload_file/20191226/CARD_A02_26122019.xlsx'
    subUserType = 'LO'
    collection = common.getSubUser(subUserType, 'Note')

    inputDataRaw = excel.getDataExcel(file_path=file_path,
                                      active_sheet="Sheet1",
                                      header=None,
                                      na_values='')
    inputData = inputDataRaw.to_dict('records')

예제 #14

파일: importHeaderTemplate.py 프로젝트: heodat234/worldfone4xs_ibm

from datetime import datetime
from datetime import date
from bson import ObjectId
from dateutil import parser
import pandas as pd
import csv
from helper.ftp import Ftp
from helper.mongod import Mongodb
from helper.excel import Excel
from helper.jaccs import Config
from helper.common import Common

try:
    mongodb = Mongodb("worldfone4xs")
    _mongodb = Mongodb("_worldfone4xs")
    excel = Excel()
    config = Config()
    ftp = Ftp()
    common = Common()
    base_url = config.base_url()
    now = datetime.now()
    subUserType = 'LO'
    collection = common.getSubUser(subUserType, 'SBV')

    url = '/var/www/html/worldfone4xs_ibm/cronjob/python/Loan/ZACCF_header.xlsx'
    filename = 'ZACCF_header.xlsx'
    filenameExtension = filename.split('.')
    if (filenameExtension[1] == 'csv'):
        inputDataRaw = excel.getDataCSV(file_path=url,
                                        sep=',',
                                        header=0,

예제 #15

from pprint import pprint
from bson import ObjectId
from helper.common import Common
from helper.mongod import Mongodb
from helper.excel import Excel
from helper.jaccs import Config
from dateutil.parser import parse
import os.path
from os import path

common = Common()
base_url = common.base_url()
wff_env = common.wff_env(base_url)
mongodb = Mongodb("worldfone4xs", wff_env)
_mongodb = Mongodb("_worldfone4xs", wff_env)
excel = Excel()
config = Config()
subUserType = 'TS'
collection = common.getSubUser(subUserType, 'Datalibrary')
now = datetime.now()
# log         = open(base_url + "cronjob/python/Telesales/importDataLibrary.txt","a")
now = datetime.now()
# log.write(now.strftime("%d/%m/%Y, %H:%M:%S") + ': Start Import' + '\n')
try:

    try:
        sys.argv[1]
        importLogId = str(sys.argv[1])
        importLogInfo = mongodb.getOne(MONGO_COLLECTION=common.getSubUser(
            subUserType, 'Import'),
                                       WHERE={'_id': ObjectId(importLogId)})

예제 #16

파일: importWoPayment.py 프로젝트: heodat234/worldfone4xs_ibm

import sys
import os
import json
from pprint import pprint
from datetime import datetime, timedelta
from datetime import date
from bson import ObjectId
from helper.ftp import Ftp
from helper.mongod import Mongodb
from helper.excel import Excel
from helper.jaccs import Config
from helper.common import Common

mongodb = Mongodb("worldfone4xs")
_mongodb = Mongodb("_worldfone4xs")
excel = Excel()
config = Config()
ftp = Ftp()
common = Common()
base_url = common.base_url()
wff_env = common.wff_env(base_url)
mongodb = Mongodb(MONGODB="worldfone4xs", WFF_ENV=wff_env)
_mongodb = Mongodb(MONGODB="_worldfone4xs", WFF_ENV=wff_env)
log = open(base_url + "cronjob/python/Loan/log/importWoPayment.txt", "a")
now = datetime.now()
subUserType = 'LO'
collection = common.getSubUser(subUserType, 'Wo_payment')

try:
    modelColumns = []
    modelConverters = {}