id sid tid token lemma pos ajst-20793 1 1 academic academic ADJ ajst-20793 1 2 journal journal NOUN ajst-20793 1 3 of of ADP ajst-20793 1 4 science science NOUN ajst-20793 1 5 and and CCONJ ajst-20793 1 6 technology technology NOUN ajst-20793 1 7 issn issn NOUN ajst-20793 1 8 : : PUNCT ajst-20793 1 9 2771 2771 NUM ajst-20793 1 10 - - SYM ajst-20793 1 11 3032 3032 NUM ajst-20793 1 12 | | NOUN ajst-20793 1 13 vol vol NOUN ajst-20793 1 14 . . PROPN ajst-20793 2 1 10 10 NUM ajst-20793 2 2 , , PUNCT ajst-20793 2 3 no no INTJ ajst-20793 2 4 . . NOUN ajst-20793 2 5 3 3 NUM ajst-20793 2 6 , , PUNCT ajst-20793 2 7 2024 2024 NUM ajst-20793 2 8 99 99 NUM ajst-20793 2 9 analysis analysis NOUN ajst-20793 2 10 and and CCONJ ajst-20793 2 11 implementation implementation NOUN ajst-20793 2 12 of of ADP ajst-20793 2 13 a a DET ajst-20793 2 14 simple simple ADJ ajst-20793 2 15 database database NOUN ajst-20793 2 16 management management NOUN ajst-20793 2 17 software software NOUN ajst-20793 2 18 based base VERB ajst-20793 2 19 on on ADP ajst-20793 2 20 python python NOUN ajst-20793 2 21 and and CCONJ ajst-20793 2 22 excel excel VERB ajst-20793 2 23 shanwen shanwen PROPN ajst-20793 2 24 lei lei PROPN ajst-20793 2 25 philippine philippine PROPN ajst-20793 2 26 christian christian PROPN ajst-20793 2 27 university university PROPN ajst-20793 2 28 , , PUNCT ajst-20793 2 29 1004 1004 NUM ajst-20793 2 30 , , PUNCT ajst-20793 2 31 philippines philippine NOUN ajst-20793 2 32 abstract abstract ADJ ajst-20793 2 33 : : PUNCT ajst-20793 2 34 this this DET ajst-20793 2 35 paper paper NOUN ajst-20793 2 36 aims aim VERB ajst-20793 2 37 to to PART ajst-20793 2 38 address address VERB ajst-20793 2 39 the the DET ajst-20793 2 40 challenges challenge NOUN ajst-20793 2 41 faced face VERB ajst-20793 2 42 by by ADP ajst-20793 2 43 small small ADJ ajst-20793 2 44 and and CCONJ ajst-20793 2 45 medium medium ADJ ajst-20793 2 46 - - PUNCT ajst-20793 2 47 sized sized ADJ ajst-20793 2 48 enterprises enterprise NOUN ajst-20793 2 49 ( ( PUNCT ajst-20793 2 50 smes sme NOUN ajst-20793 2 51 ) ) PUNCT ajst-20793 2 52 and and CCONJ ajst-20793 2 53 individual individual ADJ ajst-20793 2 54 users user NOUN ajst-20793 2 55 in in ADP ajst-20793 2 56 database database NOUN ajst-20793 2 57 management management NOUN ajst-20793 2 58 . . PUNCT ajst-20793 3 1 it it PRON ajst-20793 3 2 adopts adopt VERB ajst-20793 3 3 a a DET ajst-20793 3 4 combination combination NOUN ajst-20793 3 5 of of ADP ajst-20793 3 6 python python NOUN ajst-20793 3 7 and and CCONJ ajst-20793 3 8 excel excel VERB ajst-20793 3 9 to to PART ajst-20793 3 10 simplify simplify VERB ajst-20793 3 11 the the DET ajst-20793 3 12 operational operational ADJ ajst-20793 3 13 process process NOUN ajst-20793 3 14 and and CCONJ ajst-20793 3 15 enhance enhance VERB ajst-20793 3 16 the the DET ajst-20793 3 17 user user NOUN ajst-20793 3 18 interface interface NOUN ajst-20793 3 19 , , PUNCT ajst-20793 3 20 thereby thereby ADV ajst-20793 3 21 reducing reduce VERB ajst-20793 3 22 the the DET ajst-20793 3 23 learning learn VERB ajst-20793 3 24 curve curve NOUN ajst-20793 3 25 and and CCONJ ajst-20793 3 26 technical technical ADJ ajst-20793 3 27 requirements requirement NOUN ajst-20793 3 28 for for ADP ajst-20793 3 29 managing manage VERB ajst-20793 3 30 databases database NOUN ajst-20793 3 31 . . PUNCT ajst-20793 4 1 users user NOUN ajst-20793 4 2 can can AUX ajst-20793 4 3 effortlessly effortlessly ADV ajst-20793 4 4 manage manage VERB ajst-20793 4 5 their their PRON ajst-20793 4 6 databases database NOUN ajst-20793 4 7 , , PUNCT ajst-20793 4 8 leading lead VERB ajst-20793 4 9 to to ADP ajst-20793 4 10 improved improved ADJ ajst-20793 4 11 work work NOUN ajst-20793 4 12 efficiency efficiency NOUN ajst-20793 4 13 . . PUNCT ajst-20793 5 1 this this DET ajst-20793 5 2 project project NOUN ajst-20793 5 3 breaks break VERB ajst-20793 5 4 through through ADP ajst-20793 5 5 the the DET ajst-20793 5 6 limitations limitation NOUN ajst-20793 5 7 of of ADP ajst-20793 5 8 traditional traditional ADJ ajst-20793 5 9 database database NOUN ajst-20793 5 10 management management NOUN ajst-20793 5 11 software software NOUN ajst-20793 5 12 , , PUNCT ajst-20793 5 13 offering offer VERB ajst-20793 5 14 a a DET ajst-20793 5 15 simple simple ADJ ajst-20793 5 16 , , PUNCT ajst-20793 5 17 efficient efficient ADJ ajst-20793 5 18 , , PUNCT ajst-20793 5 19 and and CCONJ ajst-20793 5 20 low low ADJ ajst-20793 5 21 - - PUNCT ajst-20793 5 22 resource resource NOUN ajst-20793 5 23 solution solution NOUN ajst-20793 5 24 . . PUNCT ajst-20793 6 1 keywords keyword NOUN ajst-20793 6 2 : : PUNCT ajst-20793 6 3 database database NOUN ajst-20793 6 4 management management NOUN ajst-20793 6 5 software software PROPN ajst-20793 6 6 , , PUNCT ajst-20793 6 7 python python PROPN ajst-20793 6 8 , , PUNCT ajst-20793 6 9 data datum NOUN ajst-20793 6 10 export export NOUN ajst-20793 6 11 , , PUNCT ajst-20793 6 12 data datum NOUN ajst-20793 6 13 import import NOUN ajst-20793 6 14 . . PUNCT ajst-20793 7 1 1 1 X ajst-20793 7 2 . . X ajst-20793 7 3 introduction introduction NOUN ajst-20793 7 4 in in ADP ajst-20793 7 5 the the DET ajst-20793 7 6 current current ADJ ajst-20793 7 7 era era NOUN ajst-20793 7 8 of of ADP ajst-20793 7 9 rapid rapid ADJ ajst-20793 7 10 information information NOUN ajst-20793 7 11 technology technology NOUN ajst-20793 7 12 development development NOUN ajst-20793 7 13 , , PUNCT ajst-20793 7 14 effective effective ADJ ajst-20793 7 15 management management NOUN ajst-20793 7 16 of of ADP ajst-20793 7 17 data datum NOUN ajst-20793 7 18 information information NOUN ajst-20793 7 19 in in ADP ajst-20793 7 20 databases database NOUN ajst-20793 7 21 has have AUX ajst-20793 7 22 become become VERB ajst-20793 7 23 a a DET ajst-20793 7 24 crucial crucial ADJ ajst-20793 7 25 issue issue NOUN ajst-20793 7 26 . . PUNCT ajst-20793 8 1 for for ADP ajst-20793 8 2 large large ADJ ajst-20793 8 3 - - PUNCT ajst-20793 8 4 scale scale NOUN ajst-20793 8 5 enterprises enterprise NOUN ajst-20793 8 6 , , PUNCT ajst-20793 8 7 they they PRON ajst-20793 8 8 usually usually ADV ajst-20793 8 9 can can AUX ajst-20793 8 10 allocate allocate VERB ajst-20793 8 11 a a DET ajst-20793 8 12 large large ADJ ajst-20793 8 13 amount amount NOUN ajst-20793 8 14 of of ADP ajst-20793 8 15 manpower manpower NOUN ajst-20793 8 16 and and CCONJ ajst-20793 8 17 resources resource NOUN ajst-20793 8 18 for for ADP ajst-20793 8 19 data data NOUN ajst-20793 8 20 management management NOUN ajst-20793 8 21 or or CCONJ ajst-20793 8 22 hire hire VERB ajst-20793 8 23 professional professional ADJ ajst-20793 8 24 teams team NOUN ajst-20793 8 25 to to PART ajst-20793 8 26 tackle tackle VERB ajst-20793 8 27 the the DET ajst-20793 8 28 complexity complexity NOUN ajst-20793 8 29 and and CCONJ ajst-20793 8 30 maintenance maintenance NOUN ajst-20793 8 31 challenges challenge NOUN ajst-20793 8 32 of of ADP ajst-20793 8 33 data datum NOUN ajst-20793 8 34 management management NOUN ajst-20793 8 35 . . PUNCT ajst-20793 9 1 however however ADV ajst-20793 9 2 , , PUNCT ajst-20793 9 3 for for ADP ajst-20793 9 4 small small ADJ ajst-20793 9 5 and and CCONJ ajst-20793 9 6 medium medium ADJ ajst-20793 9 7 - - PUNCT ajst-20793 9 8 sized sized ADJ ajst-20793 9 9 enterprises enterprise NOUN ajst-20793 9 10 ( ( PUNCT ajst-20793 9 11 smes sme NOUN ajst-20793 9 12 ) ) PUNCT ajst-20793 9 13 and and CCONJ ajst-20793 9 14 individual individual ADJ ajst-20793 9 15 users user NOUN ajst-20793 9 16 , , PUNCT ajst-20793 9 17 there there PRON ajst-20793 9 18 is be VERB ajst-20793 9 19 often often ADV ajst-20793 9 20 insufficient insufficient ADJ ajst-20793 9 21 resources resource NOUN ajst-20793 9 22 to to PART ajst-20793 9 23 establish establish VERB ajst-20793 9 24 a a DET ajst-20793 9 25 scalable scalable ADJ ajst-20793 9 26 database database NOUN ajst-20793 9 27 management management NOUN ajst-20793 9 28 team team NOUN ajst-20793 9 29 . . PUNCT ajst-20793 10 1 although although SCONJ ajst-20793 10 2 existing exist VERB ajst-20793 10 3 database database NOUN ajst-20793 10 4 maintenance maintenance NOUN ajst-20793 10 5 software software NOUN ajst-20793 10 6 can can AUX ajst-20793 10 7 simplify simplify VERB ajst-20793 10 8 the the DET ajst-20793 10 9 management management NOUN ajst-20793 10 10 process process NOUN ajst-20793 10 11 , , PUNCT ajst-20793 10 12 users user NOUN ajst-20793 10 13 still still ADV ajst-20793 10 14 need need VERB ajst-20793 10 15 to to PART ajst-20793 10 16 have have VERB ajst-20793 10 17 a a DET ajst-20793 10 18 certain certain ADJ ajst-20793 10 19 level level NOUN ajst-20793 10 20 of of ADP ajst-20793 10 21 database database NOUN ajst-20793 10 22 management management NOUN ajst-20793 10 23 knowledge knowledge NOUN ajst-20793 10 24 and and CCONJ ajst-20793 10 25 operational operational ADJ ajst-20793 10 26 skills skill NOUN ajst-20793 10 27 to to PART ajst-20793 10 28 use use VERB ajst-20793 10 29 them they PRON ajst-20793 10 30 proficiently proficiently ADV ajst-20793 10 31 , , PUNCT ajst-20793 10 32 which which PRON ajst-20793 10 33 increases increase VERB ajst-20793 10 34 the the DET ajst-20793 10 35 learning learning NOUN ajst-20793 10 36 curve curve NOUN ajst-20793 10 37 and and CCONJ ajst-20793 10 38 usage usage NOUN ajst-20793 10 39 threshold threshold NOUN ajst-20793 10 40 for for ADP ajst-20793 10 41 users user NOUN ajst-20793 10 42 . . PUNCT ajst-20793 11 1 therefore therefore ADV ajst-20793 11 2 , , PUNCT ajst-20793 11 3 a a DET ajst-20793 11 4 simple simple ADJ ajst-20793 11 5 , , PUNCT ajst-20793 11 6 efficient efficient ADJ ajst-20793 11 7 , , PUNCT ajst-20793 11 8 and and CCONJ ajst-20793 11 9 low low ADJ ajst-20793 11 10 - - PUNCT ajst-20793 11 11 resource resource NOUN ajst-20793 11 12 database database NOUN ajst-20793 11 13 management management NOUN ajst-20793 11 14 solution solution NOUN ajst-20793 11 15 is be AUX ajst-20793 11 16 more more ADV ajst-20793 11 17 important important ADJ ajst-20793 11 18 and and CCONJ ajst-20793 11 19 necessary necessary ADJ ajst-20793 11 20 for for ADP ajst-20793 11 21 these these DET ajst-20793 11 22 users user NOUN ajst-20793 11 23 . . PUNCT ajst-20793 12 1 2 2 X ajst-20793 12 2 . . X ajst-20793 12 3 functional functional ADJ ajst-20793 12 4 implementation implementation NOUN ajst-20793 12 5 analysis analysis NOUN ajst-20793 12 6 to to PART ajst-20793 12 7 achieve achieve VERB ajst-20793 12 8 a a DET ajst-20793 12 9 simple simple ADJ ajst-20793 12 10 , , PUNCT ajst-20793 12 11 efficient efficient ADJ ajst-20793 12 12 , , PUNCT ajst-20793 12 13 and and CCONJ ajst-20793 12 14 low low ADJ ajst-20793 12 15 - - PUNCT ajst-20793 12 16 resource resource NOUN ajst-20793 12 17 database database NOUN ajst-20793 12 18 management management NOUN ajst-20793 12 19 solution solution NOUN ajst-20793 12 20 , , PUNCT ajst-20793 12 21 researchers researcher NOUN ajst-20793 12 22 feel feel VERB ajst-20793 12 23 that that SCONJ ajst-20793 12 24 the the DET ajst-20793 12 25 following follow VERB ajst-20793 12 26 issues issue NOUN ajst-20793 12 27 need need VERB ajst-20793 12 28 to to PART ajst-20793 12 29 be be AUX ajst-20793 12 30 addressed address VERB ajst-20793 12 31 , , PUNCT ajst-20793 12 32 combined combine VERB ajst-20793 12 33 with with ADP ajst-20793 12 34 existing exist VERB ajst-20793 12 35 database database NOUN ajst-20793 12 36 management management NOUN ajst-20793 12 37 software software NOUN ajst-20793 12 38 : : PUNCT ajst-20793 12 39 first first ADJ ajst-20793 12 40 , , PUNCT ajst-20793 12 41 different different ADJ ajst-20793 12 42 types type NOUN ajst-20793 12 43 of of ADP ajst-20793 12 44 database database NOUN ajst-20793 12 45 management management NOUN ajst-20793 12 46 software software NOUN ajst-20793 12 47 have have VERB ajst-20793 12 48 different different ADJ ajst-20793 12 49 functions function NOUN ajst-20793 12 50 and and CCONJ ajst-20793 12 51 operation operation NOUN ajst-20793 12 52 interfaces interface NOUN ajst-20793 12 53 , , PUNCT ajst-20793 12 54 and and CCONJ ajst-20793 12 55 often often ADV ajst-20793 12 56 require require VERB ajst-20793 12 57 the the DET ajst-20793 12 58 use use NOUN ajst-20793 12 59 of of ADP ajst-20793 12 60 sql sql NOUN ajst-20793 12 61 language language NOUN ajst-20793 12 62 for for ADP ajst-20793 12 63 operation operation NOUN ajst-20793 12 64 , , PUNCT ajst-20793 12 65 which which PRON ajst-20793 12 66 requires require VERB ajst-20793 12 67 users user NOUN ajst-20793 12 68 to to PART ajst-20793 12 69 have have VERB ajst-20793 12 70 a a DET ajst-20793 12 71 certain certain ADJ ajst-20793 12 72 level level NOUN ajst-20793 12 73 of of ADP ajst-20793 12 74 database database NOUN ajst-20793 12 75 management management NOUN ajst-20793 12 76 knowledge knowledge NOUN ajst-20793 12 77 and and CCONJ ajst-20793 12 78 operational operational ADJ ajst-20793 12 79 experience experience NOUN ajst-20793 12 80 to to PART ajst-20793 12 81 use use VERB ajst-20793 12 82 proficiently proficiently ADV ajst-20793 12 83 , , PUNCT ajst-20793 12 84 increasing increase VERB ajst-20793 12 85 the the DET ajst-20793 12 86 learning learning NOUN ajst-20793 12 87 and and CCONJ ajst-20793 12 88 usage usage NOUN ajst-20793 12 89 threshold threshold NOUN ajst-20793 12 90 for for ADP ajst-20793 12 91 users user NOUN ajst-20793 12 92 . . PUNCT ajst-20793 13 1 second second ADJ ajst-20793 13 2 , , PUNCT ajst-20793 13 3 database database NOUN ajst-20793 13 4 management management NOUN ajst-20793 13 5 software software NOUN ajst-20793 13 6 usually usually ADV ajst-20793 13 7 consumes consume VERB ajst-20793 13 8 a a DET ajst-20793 13 9 lot lot NOUN ajst-20793 13 10 of of ADP ajst-20793 13 11 system system NOUN ajst-20793 13 12 resources resource NOUN ajst-20793 13 13 , , PUNCT ajst-20793 13 14 and and CCONJ ajst-20793 13 15 most most ADJ ajst-20793 13 16 database database NOUN ajst-20793 13 17 management management NOUN ajst-20793 13 18 software software NOUN ajst-20793 13 19 is be AUX ajst-20793 13 20 usually usually ADV ajst-20793 13 21 client client NOUN ajst-20793 13 22 - - PUNCT ajst-20793 13 23 server server NOUN ajst-20793 13 24 architecture architecture NOUN ajst-20793 13 25 , , PUNCT ajst-20793 13 26 requiring require VERB ajst-20793 13 27 connection connection NOUN ajst-20793 13 28 to to ADP ajst-20793 13 29 the the DET ajst-20793 13 30 database database NOUN ajst-20793 13 31 server server NOUN ajst-20793 13 32 for for ADP ajst-20793 13 33 management management NOUN ajst-20793 13 34 and and CCONJ ajst-20793 13 35 operation operation NOUN ajst-20793 13 36 . . PUNCT ajst-20793 14 1 third third ADJ ajst-20793 14 2 , , PUNCT ajst-20793 14 3 the the DET ajst-20793 14 4 cross cross ADJ ajst-20793 14 5 - - ADJ ajst-20793 14 6 platform platform ADJ ajst-20793 14 7 compatibility compatibility NOUN ajst-20793 14 8 of of ADP ajst-20793 14 9 database database NOUN ajst-20793 14 10 management management NOUN ajst-20793 14 11 software software NOUN ajst-20793 14 12 is be AUX ajst-20793 14 13 poor poor ADJ ajst-20793 14 14 , , PUNCT ajst-20793 14 15 and and CCONJ ajst-20793 14 16 many many ADJ ajst-20793 14 17 commercial commercial ADJ ajst-20793 14 18 database database NOUN ajst-20793 14 19 management management NOUN ajst-20793 14 20 software software NOUN ajst-20793 14 21 only only ADV ajst-20793 14 22 supports support VERB ajst-20793 14 23 specific specific ADJ ajst-20793 14 24 operating operating NOUN ajst-20793 14 25 systems system NOUN ajst-20793 14 26 , , PUNCT ajst-20793 14 27 which which PRON ajst-20793 14 28 increases increase VERB ajst-20793 14 29 the the DET ajst-20793 14 30 complexity complexity NOUN ajst-20793 14 31 and and CCONJ ajst-20793 14 32 cost cost NOUN ajst-20793 14 33 of of ADP ajst-20793 14 34 use use NOUN ajst-20793 14 35 for for ADP ajst-20793 14 36 users user NOUN ajst-20793 14 37 who who PRON ajst-20793 14 38 use use VERB ajst-20793 14 39 other other ADJ ajst-20793 14 40 incompatible incompatible ADJ ajst-20793 14 41 operating operating NOUN ajst-20793 14 42 systems system NOUN ajst-20793 14 43 . . PUNCT ajst-20793 15 1 fourth fourth ADJ ajst-20793 15 2 , , PUNCT ajst-20793 15 3 commercial commercial ADJ ajst-20793 15 4 database database NOUN ajst-20793 15 5 management management NOUN ajst-20793 15 6 software software NOUN ajst-20793 15 7 often often ADV ajst-20793 15 8 requires require VERB ajst-20793 15 9 payment payment NOUN ajst-20793 15 10 or or CCONJ ajst-20793 15 11 subscription subscription NOUN ajst-20793 15 12 , , PUNCT ajst-20793 15 13 which which PRON ajst-20793 15 14 will will AUX ajst-20793 15 15 be be AUX ajst-20793 15 16 a a DET ajst-20793 15 17 significant significant ADJ ajst-20793 15 18 investment investment NOUN ajst-20793 15 19 for for ADP ajst-20793 15 20 users user NOUN ajst-20793 15 21 with with ADP ajst-20793 15 22 limited limited ADJ ajst-20793 15 23 budgets budget NOUN ajst-20793 15 24 . . PUNCT ajst-20793 16 1 how how SCONJ ajst-20793 16 2 to to PART ajst-20793 16 3 solve solve VERB ajst-20793 16 4 these these DET ajst-20793 16 5 problems problem NOUN ajst-20793 16 6 ? ? PUNCT ajst-20793 17 1 researchers researcher NOUN ajst-20793 17 2 analyze analyze VERB ajst-20793 17 3 from from ADP ajst-20793 17 4 the the DET ajst-20793 17 5 perspectives perspective NOUN ajst-20793 17 6 of of ADP ajst-20793 17 7 simplifying simplify VERB ajst-20793 17 8 database database NOUN ajst-20793 17 9 management management NOUN ajst-20793 17 10 operations operation NOUN ajst-20793 17 11 , , PUNCT ajst-20793 17 12 reducing reduce VERB ajst-20793 17 13 the the DET ajst-20793 17 14 learning learning NOUN ajst-20793 17 15 curve curve NOUN ajst-20793 17 16 , , PUNCT ajst-20793 17 17 and and CCONJ ajst-20793 17 18 improving improve VERB ajst-20793 17 19 work work NOUN ajst-20793 17 20 efficiency efficiency NOUN ajst-20793 17 21 , , PUNCT ajst-20793 17 22 and and CCONJ ajst-20793 17 23 decide decide VERB ajst-20793 17 24 to to PART ajst-20793 17 25 use use VERB ajst-20793 17 26 the the DET ajst-20793 17 27 combination combination NOUN ajst-20793 17 28 of of ADP ajst-20793 17 29 python+excel python+excel PROPN ajst-20793 17 30 to to PART ajst-20793 17 31 solve solve VERB ajst-20793 17 32 these these DET ajst-20793 17 33 problems problem NOUN ajst-20793 17 34 faced face VERB ajst-20793 17 35 by by ADP ajst-20793 17 36 small small ADJ ajst-20793 17 37 and and CCONJ ajst-20793 17 38 medium medium ADJ ajst-20793 17 39 - - PUNCT ajst-20793 17 40 sized sized ADJ ajst-20793 17 41 enterprises enterprise NOUN ajst-20793 17 42 or or CCONJ ajst-20793 17 43 individual individual ADJ ajst-20793 17 44 users user NOUN ajst-20793 17 45 in in ADP ajst-20793 17 46 the the DET ajst-20793 17 47 database database NOUN ajst-20793 17 48 management management NOUN ajst-20793 17 49 process process NOUN ajst-20793 17 50 . . PUNCT ajst-20793 18 1 first first ADV ajst-20793 18 2 , , PUNCT ajst-20793 18 3 through through ADP ajst-20793 18 4 python python NOUN ajst-20793 18 5 scripts script NOUN ajst-20793 18 6 to to PART ajst-20793 18 7 achieve achieve VERB ajst-20793 18 8 database database NOUN ajst-20793 18 9 connection connection NOUN ajst-20793 18 10 , , PUNCT ajst-20793 18 11 data datum NOUN ajst-20793 18 12 query query NOUN ajst-20793 18 13 , , PUNCT ajst-20793 18 14 and and CCONJ ajst-20793 18 15 processing processing NOUN ajst-20793 18 16 operations operation NOUN ajst-20793 18 17 . . PUNCT ajst-20793 19 1 this this PRON ajst-20793 19 2 is be AUX ajst-20793 19 3 attributed attribute VERB ajst-20793 19 4 to to ADP ajst-20793 19 5 python python PROPN ajst-20793 19 6 's 's PART ajst-20793 19 7 rich rich ADJ ajst-20793 19 8 third third ADJ ajst-20793 19 9 - - PUNCT ajst-20793 19 10 party party NOUN ajst-20793 19 11 libraries library NOUN ajst-20793 19 12 and and CCONJ ajst-20793 19 13 tools tool NOUN ajst-20793 19 14 resources resource NOUN ajst-20793 19 15 . . PUNCT ajst-20793 20 1 using use VERB ajst-20793 20 2 these these DET ajst-20793 20 3 libraries library NOUN ajst-20793 20 4 and and CCONJ ajst-20793 20 5 tools tool NOUN ajst-20793 20 6 can can AUX ajst-20793 20 7 help help VERB ajst-20793 20 8 users user NOUN ajst-20793 20 9 simplify simplify VERB ajst-20793 20 10 the the DET ajst-20793 20 11 database database NOUN ajst-20793 20 12 management management NOUN ajst-20793 20 13 process process NOUN ajst-20793 20 14 and and CCONJ ajst-20793 20 15 reduce reduce VERB ajst-20793 20 16 the the DET ajst-20793 20 17 complexity complexity NOUN ajst-20793 20 18 of of ADP ajst-20793 20 19 operations operation NOUN ajst-20793 20 20 . . PUNCT ajst-20793 21 1 second second ADJ ajst-20793 21 2 , , PUNCT ajst-20793 21 3 using use VERB ajst-20793 21 4 excel excel NOUN ajst-20793 21 5 as as ADP ajst-20793 21 6 the the DET ajst-20793 21 7 main main ADJ ajst-20793 21 8 tool tool NOUN ajst-20793 21 9 for for ADP ajst-20793 21 10 data datum NOUN ajst-20793 21 11 display display NOUN ajst-20793 21 12 , , PUNCT ajst-20793 21 13 analysis analysis NOUN ajst-20793 21 14 , , PUNCT ajst-20793 21 15 and and CCONJ ajst-20793 21 16 processing processing NOUN ajst-20793 21 17 . . PUNCT ajst-20793 22 1 it it PRON ajst-20793 22 2 has have VERB ajst-20793 22 3 an an DET ajst-20793 22 4 intuitive intuitive ADJ ajst-20793 22 5 and and CCONJ ajst-20793 22 6 friendly friendly ADJ ajst-20793 22 7 user user NOUN ajst-20793 22 8 interface interface NOUN ajst-20793 22 9 and and CCONJ ajst-20793 22 10 powerful powerful ADJ ajst-20793 22 11 data datum NOUN ajst-20793 22 12 processing processing NOUN ajst-20793 22 13 capabilities capability NOUN ajst-20793 22 14 . . PUNCT ajst-20793 23 1 users user NOUN ajst-20793 23 2 can can AUX ajst-20793 23 3 perform perform VERB ajst-20793 23 4 operations operation NOUN ajst-20793 23 5 such such ADJ ajst-20793 23 6 as as ADP ajst-20793 23 7 data datum NOUN ajst-20793 23 8 entry entry NOUN ajst-20793 23 9 , , PUNCT ajst-20793 23 10 editing editing NOUN ajst-20793 23 11 , , PUNCT ajst-20793 23 12 and and CCONJ ajst-20793 23 13 viewing view VERB ajst-20793 23 14 without without ADP ajst-20793 23 15 mastering master VERB ajst-20793 23 16 complex complex ADJ ajst-20793 23 17 database database NOUN ajst-20793 23 18 management management NOUN ajst-20793 23 19 techniques technique NOUN ajst-20793 23 20 , , PUNCT ajst-20793 23 21 thereby thereby ADV ajst-20793 23 22 improving improve VERB ajst-20793 23 23 the the DET ajst-20793 23 24 convenience convenience NOUN ajst-20793 23 25 and and CCONJ ajst-20793 23 26 flexibility flexibility NOUN ajst-20793 23 27 of of ADP ajst-20793 23 28 operations operation NOUN ajst-20793 23 29 . . PUNCT ajst-20793 24 1 this this DET ajst-20793 24 2 combination combination NOUN ajst-20793 24 3 solution solution NOUN ajst-20793 24 4 not not PART ajst-20793 24 5 only only ADV ajst-20793 24 6 meets meet VERB ajst-20793 24 7 various various ADJ ajst-20793 24 8 needs need NOUN ajst-20793 24 9 of of ADP ajst-20793 24 10 users user NOUN ajst-20793 24 11 for for ADP ajst-20793 24 12 database database NOUN ajst-20793 24 13 data datum NOUN ajst-20793 24 14 management management NOUN ajst-20793 24 15 but but CCONJ ajst-20793 24 16 also also ADV ajst-20793 24 17 reduces reduce VERB ajst-20793 24 18 the the DET ajst-20793 24 19 difficulty difficulty NOUN ajst-20793 24 20 for for ADP ajst-20793 24 21 users user NOUN ajst-20793 24 22 in in ADP ajst-20793 24 23 learning learning NOUN ajst-20793 24 24 and and CCONJ ajst-20793 24 25 usage usage NOUN ajst-20793 24 26 , , PUNCT ajst-20793 24 27 improves improve VERB ajst-20793 24 28 work work NOUN ajst-20793 24 29 efficiency efficiency NOUN ajst-20793 24 30 , , PUNCT ajst-20793 24 31 and and CCONJ ajst-20793 24 32 is be AUX ajst-20793 24 33 a a DET ajst-20793 24 34 simple simple ADJ ajst-20793 24 35 , , PUNCT ajst-20793 24 36 efficient efficient ADJ ajst-20793 24 37 , , PUNCT ajst-20793 24 38 and and CCONJ ajst-20793 24 39 low low ADJ ajst-20793 24 40 - - PUNCT ajst-20793 24 41 resource resource NOUN ajst-20793 24 42 database database NOUN ajst-20793 24 43 management management NOUN ajst-20793 24 44 solution solution NOUN ajst-20793 24 45 . . PUNCT ajst-20793 25 1 according accord VERB ajst-20793 25 2 to to ADP ajst-20793 25 3 the the DET ajst-20793 25 4 proposed propose VERB ajst-20793 25 5 solution solution NOUN ajst-20793 25 6 , , PUNCT ajst-20793 25 7 to to PART ajst-20793 25 8 meet meet VERB ajst-20793 25 9 the the DET ajst-20793 25 10 needs need NOUN ajst-20793 25 11 of of ADP ajst-20793 25 12 users user NOUN ajst-20793 25 13 , , PUNCT ajst-20793 25 14 the the DET ajst-20793 25 15 software software NOUN ajst-20793 25 16 should should AUX ajst-20793 25 17 mainly mainly ADV ajst-20793 25 18 implement implement VERB ajst-20793 25 19 the the DET ajst-20793 25 20 following follow VERB ajst-20793 25 21 functions function NOUN ajst-20793 25 22 : : PUNCT ajst-20793 25 23 database database NOUN ajst-20793 25 24 connection connection NOUN ajst-20793 25 25 function function NOUN ajst-20793 25 26 : : PUNCT ajst-20793 25 27 allow allow VERB ajst-20793 25 28 users user NOUN ajst-20793 25 29 to to PART ajst-20793 25 30 connect connect VERB ajst-20793 25 31 mainstream mainstream NOUN ajst-20793 25 32 database database NOUN ajst-20793 25 33 resources resource NOUN ajst-20793 25 34 easily easily ADV ajst-20793 25 35 through through ADP ajst-20793 25 36 configuration configuration NOUN ajst-20793 25 37 parameters parameter NOUN ajst-20793 25 38 to to PART ajst-20793 25 39 ensure ensure VERB ajst-20793 25 40 the the DET ajst-20793 25 41 universality universality NOUN ajst-20793 25 42 and and CCONJ ajst-20793 25 43 applicability applicability NOUN ajst-20793 25 44 of of ADP ajst-20793 25 45 the the DET ajst-20793 25 46 software software NOUN ajst-20793 25 47 . . PUNCT ajst-20793 26 1 database database NOUN ajst-20793 26 2 export export NOUN ajst-20793 26 3 to to PART ajst-20793 26 4 excel excel VERB ajst-20793 26 5 function function NOUN ajst-20793 26 6 : : PUNCT ajst-20793 26 7 allow allow VERB ajst-20793 26 8 users user NOUN ajst-20793 26 9 to to PART ajst-20793 26 10 select select VERB ajst-20793 26 11 specified specified ADJ ajst-20793 26 12 data data NOUN ajst-20793 26 13 tables table NOUN ajst-20793 26 14 from from ADP ajst-20793 26 15 the the DET ajst-20793 26 16 database database NOUN ajst-20793 26 17 , , PUNCT ajst-20793 26 18 export export VERB ajst-20793 26 19 the the DET ajst-20793 26 20 data data NOUN ajst-20793 26 21 tables table NOUN ajst-20793 26 22 to to PART ajst-20793 26 23 excel excel VERB ajst-20793 26 24 files file NOUN ajst-20793 26 25 , , PUNCT ajst-20793 26 26 and and CCONJ ajst-20793 26 27 save save VERB ajst-20793 26 28 them they PRON ajst-20793 26 29 in in ADP ajst-20793 26 30 the the DET ajst-20793 26 31 specified specified ADJ ajst-20793 26 32 file file NOUN ajst-20793 26 33 path path NOUN ajst-20793 26 34 specified specify VERB ajst-20793 26 35 by by ADP ajst-20793 26 36 the the DET ajst-20793 26 37 user user NOUN ajst-20793 26 38 . . PUNCT ajst-20793 27 1 excel excel VERB ajst-20793 27 2 import import NOUN ajst-20793 27 3 to to ADP ajst-20793 27 4 database database NOUN ajst-20793 27 5 function function NOUN ajst-20793 27 6 : : PUNCT ajst-20793 27 7 allow allow VERB ajst-20793 27 8 users user NOUN ajst-20793 27 9 to to PART ajst-20793 27 10 import import VERB ajst-20793 27 11 data datum NOUN ajst-20793 27 12 from from ADP ajst-20793 27 13 their their PRON ajst-20793 27 14 specified specify VERB ajst-20793 27 15 excel excel NOUN ajst-20793 27 16 files file NOUN ajst-20793 27 17 into into ADP ajst-20793 27 18 the the DET ajst-20793 27 19 database database NOUN ajst-20793 27 20 and and CCONJ ajst-20793 27 21 save save VERB ajst-20793 27 22 them they PRON ajst-20793 27 23 in in ADP ajst-20793 27 24 the the DET ajst-20793 27 25 specified specified ADJ ajst-20793 27 26 data data NOUN ajst-20793 27 27 table table NOUN ajst-20793 27 28 . . PUNCT ajst-20793 28 1 simple simple ADJ ajst-20793 28 2 user user NOUN ajst-20793 28 3 interface interface NOUN ajst-20793 28 4 : : PUNCT ajst-20793 28 5 design design VERB ajst-20793 28 6 an an DET ajst-20793 28 7 intuitive intuitive ADJ ajst-20793 28 8 and and CCONJ ajst-20793 28 9 concise concise ADJ ajst-20793 28 10 user user NOUN ajst-20793 28 11 interface interface NOUN ajst-20793 28 12 to to PART ajst-20793 28 13 simplify simplify VERB ajst-20793 28 14 the the DET ajst-20793 28 15 user user NOUN ajst-20793 28 16 operation operation NOUN ajst-20793 28 17 process process NOUN ajst-20793 28 18 and and CCONJ ajst-20793 28 19 reduce reduce VERB ajst-20793 28 20 the the DET ajst-20793 28 21 learning learning NOUN ajst-20793 28 22 and and CCONJ ajst-20793 28 23 usage usage NOUN ajst-20793 28 24 threshold threshold NOUN ajst-20793 28 25 for for ADP ajst-20793 28 26 users user NOUN ajst-20793 28 27 . . PUNCT ajst-20793 28 28 100 100 NUM ajst-20793 28 29 with with ADP ajst-20793 28 30 the the DET ajst-20793 28 31 above above ADJ ajst-20793 28 32 functions function NOUN ajst-20793 28 33 , , PUNCT ajst-20793 28 34 combined combine VERB ajst-20793 28 35 with with ADP ajst-20793 28 36 excel excel PROPN ajst-20793 28 37 's 's PART ajst-20793 28 38 powerful powerful ADJ ajst-20793 28 39 data datum NOUN ajst-20793 28 40 processing processing NOUN ajst-20793 28 41 capabilities capability NOUN ajst-20793 28 42 , , PUNCT ajst-20793 28 43 such such ADJ ajst-20793 28 44 functions function NOUN ajst-20793 28 45 are be AUX ajst-20793 28 46 sufficient sufficient ADJ ajst-20793 28 47 to to PART ajst-20793 28 48 meet meet VERB ajst-20793 28 49 the the DET ajst-20793 28 50 basic basic ADJ ajst-20793 28 51 needs need NOUN ajst-20793 28 52 of of ADP ajst-20793 28 53 users user NOUN ajst-20793 28 54 for for ADP ajst-20793 28 55 database database NOUN ajst-20793 28 56 management management NOUN ajst-20793 28 57 . . PUNCT ajst-20793 29 1 3 3 X ajst-20793 29 2 . . X ajst-20793 29 3 functional functional ADJ ajst-20793 29 4 implementation implementation NOUN ajst-20793 29 5 method method NOUN ajst-20793 29 6 this this DET ajst-20793 29 7 chapter chapter NOUN ajst-20793 29 8 will will AUX ajst-20793 29 9 guide guide VERB ajst-20793 29 10 readers reader NOUN ajst-20793 29 11 step step VERB ajst-20793 29 12 by by ADP ajst-20793 29 13 step step NOUN ajst-20793 29 14 to to PART ajst-20793 29 15 build build VERB ajst-20793 29 16 a a DET ajst-20793 29 17 complete complete ADJ ajst-20793 29 18 python python NOUN ajst-20793 29 19 - - PUNCT ajst-20793 29 20 based base VERB ajst-20793 29 21 data data NOUN ajst-20793 29 22 management management NOUN ajst-20793 29 23 software software NOUN ajst-20793 29 24 , , PUNCT ajst-20793 29 25 which which PRON ajst-20793 29 26 can can AUX ajst-20793 29 27 effectively effectively ADV ajst-20793 29 28 manage manage VERB ajst-20793 29 29 access access NOUN ajst-20793 29 30 databases database NOUN ajst-20793 29 31 , , PUNCT ajst-20793 29 32 and and CCONJ ajst-20793 29 33 realize realize VERB ajst-20793 29 34 the the DET ajst-20793 29 35 functional functional ADJ ajst-20793 29 36 requirements requirement NOUN ajst-20793 29 37 analysis analysis NOUN ajst-20793 29 38 of of ADP ajst-20793 29 39 researchers researcher NOUN ajst-20793 29 40 for for ADP ajst-20793 29 41 software software NOUN ajst-20793 29 42 functions function NOUN ajst-20793 29 43 . . PUNCT ajst-20793 30 1 at at ADP ajst-20793 30 2 the the DET ajst-20793 30 3 same same ADJ ajst-20793 30 4 time time NOUN ajst-20793 30 5 , , PUNCT ajst-20793 30 6 it it PRON ajst-20793 30 7 also also ADV ajst-20793 30 8 deepens deepen VERB ajst-20793 30 9 readers reader NOUN ajst-20793 30 10 ' ' PART ajst-20793 30 11 understanding understanding NOUN ajst-20793 30 12 of of ADP ajst-20793 30 13 the the DET ajst-20793 30 14 python python NOUN ajst-20793 30 15 language language NOUN ajst-20793 30 16 through through ADP ajst-20793 30 17 practice practice NOUN ajst-20793 30 18 , , PUNCT ajst-20793 30 19 and and CCONJ ajst-20793 30 20 realizes realize VERB ajst-20793 30 21 more more ADV ajst-20793 30 22 flexible flexible ADJ ajst-20793 30 23 application application NOUN ajst-20793 30 24 in in ADP ajst-20793 30 25 reality reality NOUN ajst-20793 30 26 . . PUNCT ajst-20793 31 1 3.1 3.1 NUM ajst-20793 31 2 . . PUNCT ajst-20793 31 3 framework framework NOUN ajst-20793 31 4 analysis analysis NOUN ajst-20793 31 5 according accord VERB ajst-20793 31 6 to to ADP ajst-20793 31 7 the the DET ajst-20793 31 8 functional functional ADJ ajst-20793 31 9 requirement requirement NOUN ajst-20793 31 10 analysis analysis NOUN ajst-20793 31 11 , , PUNCT ajst-20793 31 12 the the DET ajst-20793 31 13 program program NOUN ajst-20793 31 14 mainly mainly ADV ajst-20793 31 15 consists consist VERB ajst-20793 31 16 of of ADP ajst-20793 31 17 two two NUM ajst-20793 31 18 major major ADJ ajst-20793 31 19 functional functional ADJ ajst-20793 31 20 categories category NOUN ajst-20793 31 21 : : PUNCT ajst-20793 31 22 database database NOUN ajst-20793 31 23 export export NOUN ajst-20793 31 24 and and CCONJ ajst-20793 31 25 database database PROPN ajst-20793 31 26 import import NOUN ajst-20793 31 27 . . PUNCT ajst-20793 32 1 to to PART ajst-20793 32 2 make make VERB ajst-20793 32 3 the the DET ajst-20793 32 4 code code NOUN ajst-20793 32 5 clearer clear ADJ ajst-20793 32 6 , , PUNCT ajst-20793 32 7 researchers researcher NOUN ajst-20793 32 8 divide divide VERB ajst-20793 32 9 the the DET ajst-20793 32 10 code code NOUN ajst-20793 32 11 into into ADP ajst-20793 32 12 two two NUM ajst-20793 32 13 classes class NOUN ajst-20793 32 14 , , PUNCT ajst-20793 32 15 exportapp exportapp ADJ ajst-20793 32 16 and and CCONJ ajst-20793 32 17 importapp importapp NOUN ajst-20793 32 18 , , PUNCT ajst-20793 32 19 respectively respectively ADV ajst-20793 32 20 . . PUNCT ajst-20793 33 1 encapsulating encapsulate VERB ajst-20793 33 2 different different ADJ ajst-20793 33 3 functional functional ADJ ajst-20793 33 4 implementation implementation NOUN ajst-20793 33 5 codes code NOUN ajst-20793 33 6 in in ADP ajst-20793 33 7 different different ADJ ajst-20793 33 8 classes class NOUN ajst-20793 33 9 can can AUX ajst-20793 33 10 help help VERB ajst-20793 33 11 improve improve VERB ajst-20793 33 12 the the DET ajst-20793 33 13 overall overall ADJ ajst-20793 33 14 structure structure NOUN ajst-20793 33 15 of of ADP ajst-20793 33 16 the the DET ajst-20793 33 17 program program NOUN ajst-20793 33 18 and and CCONJ ajst-20793 33 19 enhance enhance VERB ajst-20793 33 20 its its PRON ajst-20793 33 21 capabilities capability NOUN ajst-20793 33 22 in in ADP ajst-20793 33 23 readability readability NOUN ajst-20793 33 24 , , PUNCT ajst-20793 33 25 maintainability maintainability NOUN ajst-20793 33 26 , , PUNCT ajst-20793 33 27 and and CCONJ ajst-20793 33 28 extensibility extensibility NOUN ajst-20793 33 29 . . PUNCT ajst-20793 34 1 class class NOUN ajst-20793 34 2     SPACE ajst-20793 34 3 exportapp exportapp ADJ ajst-20793 34 4 : : PUNCT ajst-20793 34 5                     SPACE ajst-20793 34 6 class class NOUN ajst-20793 34 7     SPACE ajst-20793 34 8 importapp importapp NOUN ajst-20793 34 9 : : PUNCT ajst-20793 34 10                                 SPACE ajst-20793 34 11 if if SCONJ ajst-20793 34 12     SPACE ajst-20793 34 13 _ _ PUNCT ajst-20793 35 1 _ _ PUNCT ajst-20793 35 2 name name VERB ajst-20793 35 3 _ _ PUNCT ajst-20793 36 1 _ _ PUNCT ajst-20793 36 2     SPACE ajst-20793 37 1 = = PUNCT ajst-20793 37 2 = = NOUN ajst-20793 37 3     SPACE ajst-20793 37 4 " " PUNCT ajst-20793 37 5 _ _ NOUN ajst-20793 37 6 _ _ PUNCT ajst-20793 38 1 main main ADJ ajst-20793 38 2 _ _ PUNCT ajst-20793 39 1 _ _ PUNCT ajst-20793 39 2 " " PUNCT ajst-20793 39 3 : : PUNCT ajst-20793 39 4               SPACE ajst-20793 39 5 root root NOUN ajst-20793 39 6     SPACE ajst-20793 39 7 = = NOUN ajst-20793 39 8     SPACE ajst-20793 39 9 tk tk PROPN ajst-20793 39 10 ( ( PUNCT ajst-20793 39 11 ) ) PUNCT ajst-20793 39 12               SPACE ajst-20793 39 13 root.title("database root.title("database NOUN ajst-20793 39 14     SPACE ajst-20793 39 15 management management NOUN ajst-20793 39 16 " " PUNCT ajst-20793 39 17 ) ) PUNCT ajst-20793 39 18               SPACE ajst-20793 39 19 master master NOUN ajst-20793 39 20     SPACE ajst-20793 39 21 = = NOUN ajst-20793 39 22     SPACE ajst-20793 39 23 notebook(root notebook(root PROPN ajst-20793 39 24 ) ) PUNCT ajst-20793 39 25               SPACE ajst-20793 39 26 export_tab export_tab NOUN ajst-20793 39 27     SPACE ajst-20793 39 28 = = NOUN ajst-20793 39 29     SPACE ajst-20793 39 30 frame(master frame(master PROPN ajst-20793 39 31 ) ) PUNCT ajst-20793 39 32               SPACE ajst-20793 39 33 import_tab import_tab NOUN ajst-20793 39 34     SPACE ajst-20793 39 35 = = NOUN ajst-20793 39 36     SPACE ajst-20793 39 37 frame(master frame(master PROPN ajst-20793 39 38 ) ) PUNCT ajst-20793 39 39               SPACE ajst-20793 39 40 master.add(export_tab master.add(export_tab PROPN ajst-20793 39 41 , , PUNCT ajst-20793 39 42     SPACE ajst-20793 39 43 text="export text="export NOUN ajst-20793 39 44 " " PUNCT ajst-20793 39 45 ) ) PUNCT ajst-20793 39 46               SPACE ajst-20793 39 47 master.add(import_tab master.add(import_tab NOUN ajst-20793 39 48 , , PUNCT ajst-20793 39 49     SPACE ajst-20793 39 50 text="import text="import NOUN ajst-20793 39 51 " " PUNCT ajst-20793 39 52 ) ) PUNCT ajst-20793 39 53               SPACE ajst-20793 39 54 master.pack(expand=1 master.pack(expand=1 PROPN ajst-20793 39 55 , , PUNCT ajst-20793 39 56     SPACE ajst-20793 39 57 fill="both fill="both NOUN ajst-20793 39 58 " " PUNCT ajst-20793 39 59 ) ) PUNCT ajst-20793 39 60                   SPACE ajst-20793 39 61 export_app export_app NUM ajst-20793 39 62     SPACE ajst-20793 39 63 = = NOUN ajst-20793 39 64     SPACE ajst-20793 39 65 exportapp(export_tab exportapp(export_tab NOUN ajst-20793 39 66 ) ) PUNCT ajst-20793 39 67               SPACE ajst-20793 39 68 import_app import_app NUM ajst-20793 39 69     SPACE ajst-20793 39 70 = = NOUN ajst-20793 39 71     SPACE ajst-20793 39 72 importapp(import_tab importapp(import_tab NOUN ajst-20793 39 73 ) ) PUNCT ajst-20793 39 74               SPACE ajst-20793 39 75 root.mainloop root.mainloop PROPN ajst-20793 39 76 ( ( PUNCT ajst-20793 39 77 ) ) PUNCT ajst-20793 39 78 figure figure NOUN ajst-20793 39 79 1 1 NUM ajst-20793 39 80 . . PUNCT ajst-20793 39 81 software software NOUN ajst-20793 39 82 framework framework NOUN ajst-20793 39 83 code code NOUN ajst-20793 39 84 here here ADV ajst-20793 39 85 , , PUNCT ajst-20793 39 86 by by ADP ajst-20793 39 87 defining define VERB ajst-20793 39 88 exportapp exportapp NOUN ajst-20793 39 89 and and CCONJ ajst-20793 39 90 importapp importapp NOUN ajst-20793 39 91 as as ADP ajst-20793 39 92 classes class NOUN ajst-20793 39 93 , , PUNCT ajst-20793 39 94 they they PRON ajst-20793 39 95 become become VERB ajst-20793 39 96 two two NUM ajst-20793 39 97 classes class NOUN ajst-20793 39 98 , , PUNCT ajst-20793 39 99 and and CCONJ ajst-20793 39 100 then then ADV ajst-20793 39 101 using use VERB ajst-20793 39 102 the the DET ajst-20793 39 103 tkinter tkinter NOUN ajst-20793 39 104 library library NOUN ajst-20793 39 105 in in ADP ajst-20793 39 106 the the DET ajst-20793 39 107 main main ADJ ajst-20793 39 108 function function NOUN ajst-20793 39 109 of of ADP ajst-20793 39 110 the the DET ajst-20793 39 111 program program NOUN ajst-20793 39 112 , , PUNCT ajst-20793 39 113 a a DET ajst-20793 39 114 gui gui NOUN ajst-20793 39 115 interface interface NOUN ajst-20793 39 116 named name VERB ajst-20793 39 117 " " PUNCT ajst-20793 39 118 database database NOUN ajst-20793 39 119 management management NOUN ajst-20793 39 120 " " PUNCT ajst-20793 39 121 is be AUX ajst-20793 39 122 established establish VERB ajst-20793 39 123 . . PUNCT ajst-20793 40 1 at at ADP ajst-20793 40 2 the the DET ajst-20793 40 3 same same ADJ ajst-20793 40 4 time time NOUN ajst-20793 40 5 , , PUNCT ajst-20793 40 6 two two NUM ajst-20793 40 7 tabs tab NOUN ajst-20793 40 8 are be AUX ajst-20793 40 9 set set VERB ajst-20793 40 10 in in ADP ajst-20793 40 11 the the DET ajst-20793 40 12 interface interface NOUN ajst-20793 40 13 , , PUNCT ajst-20793 40 14 one one NUM ajst-20793 40 15 for for ADP ajst-20793 40 16 export export NOUN ajst-20793 40 17 and and CCONJ ajst-20793 40 18 one one NUM ajst-20793 40 19 for for ADP ajst-20793 40 20 import import NOUN ajst-20793 40 21 , , PUNCT ajst-20793 40 22 and and CCONJ ajst-20793 40 23 the the DET ajst-20793 40 24 exportapp exportapp ADJ ajst-20793 40 25 and and CCONJ ajst-20793 40 26 importapp importapp NOUN ajst-20793 40 27 classes class NOUN ajst-20793 40 28 previously previously ADV ajst-20793 40 29 defined define VERB ajst-20793 40 30 are be AUX ajst-20793 40 31 respectively respectively ADV ajst-20793 40 32 connected connect VERB ajst-20793 40 33 to to ADP ajst-20793 40 34 these these DET ajst-20793 40 35 two two NUM ajst-20793 40 36 tabs tab NOUN ajst-20793 40 37 . . PUNCT ajst-20793 41 1 this this PRON ajst-20793 41 2 achieves achieve VERB ajst-20793 41 3 the the DET ajst-20793 41 4 function function NOUN ajst-20793 41 5 of of ADP ajst-20793 41 6 switching switch VERB ajst-20793 41 7 between between ADP ajst-20793 41 8 functional functional ADJ ajst-20793 41 9 page page NOUN ajst-20793 41 10 tabs tab NOUN ajst-20793 41 11 in in ADP ajst-20793 41 12 the the DET ajst-20793 41 13 gui gui NOUN ajst-20793 41 14 interface interface NOUN ajst-20793 41 15 . . PUNCT ajst-20793 42 1 as as SCONJ ajst-20793 42 2 shown show VERB ajst-20793 42 3 in in ADP ajst-20793 42 4 the the DET ajst-20793 42 5 figure figure NOUN ajst-20793 42 6 below below ADV ajst-20793 42 7 . . PUNCT ajst-20793 43 1 figure figure NOUN ajst-20793 43 2 2 2 NUM ajst-20793 43 3 . . PUNCT ajst-20793 43 4 framework framework NOUN ajst-20793 43 5 gui gui PROPN ajst-20793 43 6 display display NOUN ajst-20793 43 7 3.2 3.2 NUM ajst-20793 43 8 . . PUNCT ajst-20793 44 1 export export NOUN ajst-20793 44 2 function function NOUN ajst-20793 44 3 implementation implementation NOUN ajst-20793 44 4 : : PUNCT ajst-20793 44 5 after after ADP ajst-20793 44 6 building build VERB ajst-20793 44 7 the the DET ajst-20793 44 8 overall overall ADJ ajst-20793 44 9 framework framework NOUN ajst-20793 44 10 of of ADP ajst-20793 44 11 the the DET ajst-20793 44 12 program program NOUN ajst-20793 44 13 , , PUNCT ajst-20793 44 14 researchers researcher NOUN ajst-20793 44 15 need need VERB ajst-20793 44 16 to to PART ajst-20793 44 17 design design VERB ajst-20793 44 18 the the DET ajst-20793 44 19 specific specific ADJ ajst-20793 44 20 function function NOUN ajst-20793 44 21 implementation implementation NOUN ajst-20793 44 22 . . PUNCT ajst-20793 45 1 let let VERB ajst-20793 45 2 's us PRON ajst-20793 45 3 start start VERB ajst-20793 45 4 with with ADP ajst-20793 45 5 designing design VERB ajst-20793 45 6 the the DET ajst-20793 45 7 code code NOUN ajst-20793 45 8 in in ADP ajst-20793 45 9 the the DET ajst-20793 45 10 exportapp exportapp ADJ ajst-20793 45 11 class class NOUN ajst-20793 45 12 . . PUNCT ajst-20793 46 1 first first ADV ajst-20793 46 2 , , PUNCT ajst-20793 46 3 we we PRON ajst-20793 46 4 analyze analyze VERB ajst-20793 46 5 what what PRON ajst-20793 46 6 operations operation NOUN ajst-20793 46 7 the the DET ajst-20793 46 8 user user NOUN ajst-20793 46 9 needs need VERB ajst-20793 46 10 to to PART ajst-20793 46 11 perform perform VERB ajst-20793 46 12 to to PART ajst-20793 46 13 export export NOUN ajst-20793 46 14 data datum NOUN ajst-20793 46 15 from from ADP ajst-20793 46 16 the the DET ajst-20793 46 17 database database NOUN ajst-20793 46 18 . . PUNCT ajst-20793 47 1 first first ADV ajst-20793 47 2 , , PUNCT ajst-20793 47 3 the the DET ajst-20793 47 4 user user NOUN ajst-20793 47 5 needs need VERB ajst-20793 47 6 to to PART ajst-20793 47 7 specify specify VERB ajst-20793 47 8 the the DET ajst-20793 47 9 path path NOUN ajst-20793 47 10 of of ADP ajst-20793 47 11 the the DET ajst-20793 47 12 database database NOUN ajst-20793 47 13 to to PART ajst-20793 47 14 be be AUX ajst-20793 47 15 exported export VERB ajst-20793 47 16 , , PUNCT ajst-20793 47 17 then then ADV ajst-20793 47 18 select select VERB ajst-20793 47 19 which which DET ajst-20793 47 20 table table NOUN ajst-20793 47 21 to to PART ajst-20793 47 22 export export VERB ajst-20793 47 23 from from ADP ajst-20793 47 24 the the DET ajst-20793 47 25 database database NOUN ajst-20793 47 26 , , PUNCT ajst-20793 47 27 and and CCONJ ajst-20793 47 28 finally finally ADV ajst-20793 47 29 select select VERB ajst-20793 47 30 where where SCONJ ajst-20793 47 31 to to PART ajst-20793 47 32 store store VERB ajst-20793 47 33 the the DET ajst-20793 47 34 exported export VERB ajst-20793 47 35 excel excel NOUN ajst-20793 47 36 file file NOUN ajst-20793 47 37 . . PUNCT ajst-20793 48 1 combining combine VERB ajst-20793 48 2 the the DET ajst-20793 48 3 user user NOUN ajst-20793 48 4 's 's PART ajst-20793 48 5 execution execution NOUN ajst-20793 48 6 steps step NOUN ajst-20793 48 7 , , PUNCT ajst-20793 48 8 we we PRON ajst-20793 48 9 analyze analyze VERB ajst-20793 48 10 how how SCONJ ajst-20793 48 11 to to PART ajst-20793 48 12 implement implement VERB ajst-20793 48 13 the the DET ajst-20793 48 14 function function NOUN ajst-20793 48 15 . . PUNCT ajst-20793 49 1 the the DET ajst-20793 49 2 first first ADJ ajst-20793 49 3 step step NOUN ajst-20793 49 4 is be AUX ajst-20793 49 5 to to PART ajst-20793 49 6 design design VERB ajst-20793 49 7 a a DET ajst-20793 49 8 function function NOUN ajst-20793 49 9 that that PRON ajst-20793 49 10 allows allow VERB ajst-20793 49 11 users user NOUN ajst-20793 49 12 to to PART ajst-20793 49 13 specify specify VERB ajst-20793 49 14 the the DET ajst-20793 49 15 path path NOUN ajst-20793 49 16 of of ADP ajst-20793 49 17 the the DET ajst-20793 49 18 database database NOUN ajst-20793 49 19 to to PART ajst-20793 49 20 be be AUX ajst-20793 49 21 exported export VERB ajst-20793 49 22 . . PUNCT ajst-20793 50 1 the the DET ajst-20793 50 2 second second ADJ ajst-20793 50 3 step step NOUN ajst-20793 50 4 is be AUX ajst-20793 50 5 to to PART ajst-20793 50 6 design design VERB ajst-20793 50 7 a a DET ajst-20793 50 8 function function NOUN ajst-20793 50 9 to to PART ajst-20793 50 10 connect connect VERB ajst-20793 50 11 to to ADP ajst-20793 50 12 the the DET ajst-20793 50 13 selected select VERB ajst-20793 50 14 database database NOUN ajst-20793 50 15 and and CCONJ ajst-20793 50 16 display display VERB ajst-20793 50 17 the the DET ajst-20793 50 18 tables table NOUN ajst-20793 50 19 in in ADP ajst-20793 50 20 the the DET ajst-20793 50 21 database database NOUN ajst-20793 50 22 for for ADP ajst-20793 50 23 user user NOUN ajst-20793 50 24 selection selection NOUN ajst-20793 50 25 . . PUNCT ajst-20793 51 1 the the DET ajst-20793 51 2 third third ADJ ajst-20793 51 3 step step NOUN ajst-20793 51 4 is be AUX ajst-20793 51 5 to to PART ajst-20793 51 6 design design VERB ajst-20793 51 7 a a DET ajst-20793 51 8 function function NOUN ajst-20793 51 9 to to PART ajst-20793 51 10 provide provide VERB ajst-20793 51 11 users user NOUN ajst-20793 51 12 with with ADP ajst-20793 51 13 the the DET ajst-20793 51 14 option option NOUN ajst-20793 51 15 to to PART ajst-20793 51 16 select select VERB ajst-20793 51 17 the the DET ajst-20793 51 18 export export NOUN ajst-20793 51 19 file file NOUN ajst-20793 51 20 storage storage NOUN ajst-20793 51 21 101 101 NUM ajst-20793 51 22 location location NOUN ajst-20793 51 23 . . PUNCT ajst-20793 52 1 the the DET ajst-20793 52 2 fourth fourth ADJ ajst-20793 52 3 step step NOUN ajst-20793 52 4 is be AUX ajst-20793 52 5 to to PART ajst-20793 52 6 export export VERB ajst-20793 52 7 the the DET ajst-20793 52 8 specified specify VERB ajst-20793 52 9 table table NOUN ajst-20793 52 10 from from ADP ajst-20793 52 11 the the DET ajst-20793 52 12 database database NOUN ajst-20793 52 13 and and CCONJ ajst-20793 52 14 store store VERB ajst-20793 52 15 it it PRON ajst-20793 52 16 at at ADP ajst-20793 52 17 the the DET ajst-20793 52 18 specified specified ADJ ajst-20793 52 19 path path NOUN ajst-20793 52 20 . . PUNCT ajst-20793 53 1 combining combine VERB ajst-20793 53 2 the the DET ajst-20793 53 3 above above ADJ ajst-20793 53 4 requirements requirement NOUN ajst-20793 53 5 , , PUNCT ajst-20793 53 6 we we PRON ajst-20793 53 7 design design NOUN ajst-20793 53 8 functions function NOUN ajst-20793 53 9 for for ADP ajst-20793 53 10 each each DET ajst-20793 53 11 step step NOUN ajst-20793 53 12 to to PART ajst-20793 53 13 implement implement VERB ajst-20793 53 14 the the DET ajst-20793 53 15 functionality functionality NOUN ajst-20793 53 16 . . PUNCT ajst-20793 54 1 class class NOUN ajst-20793 54 2     SPACE ajst-20793 54 3 exportapp exportapp ADJ ajst-20793 54 4 : : PUNCT ajst-20793 54 5               SPACE ajst-20793 54 6 def def ADJ ajst-20793 54 7     SPACE ajst-20793 54 8 _ _ PUNCT ajst-20793 55 1 _ _ PUNCT ajst-20793 55 2 init__(self init__(self PRON ajst-20793 55 3 , , PUNCT ajst-20793 55 4     SPACE ajst-20793 55 5 tab tab NOUN ajst-20793 55 6 ): ): PUNCT ajst-20793 55 7                       SPACE ajst-20793 55 8 self.export_db_path self.export_db_path NOUN ajst-20793 55 9     SPACE ajst-20793 55 10 = = NOUN ajst-20793 55 11     SPACE ajst-20793 55 12 " " PUNCT ajst-20793 55 13 " " PUNCT ajst-20793 55 14                       SPACE ajst-20793 55 15 self.export_file_path self.export_file_path NOUN ajst-20793 55 16     SPACE ajst-20793 55 17 = = NOUN ajst-20793 55 18     SPACE ajst-20793 55 19 " " PUNCT ajst-20793 55 20 " " PUNCT ajst-20793 55 21                       SPACE ajst-20793 55 22 self.create_widgets(tab self.create_widgets(tab PROPN ajst-20793 55 23 ) ) PUNCT ajst-20793 55 24                   SPACE ajst-20793 55 25 def def PROPN ajst-20793 55 26     SPACE ajst-20793 55 27 create_widgets(self create_widgets(self PROPN ajst-20793 55 28 , , PUNCT ajst-20793 55 29     SPACE ajst-20793 55 30 tab tab NOUN ajst-20793 55 31 ): ): PUNCT ajst-20793 55 32                       SPACE ajst-20793 55 33 self.export_db_label_text self.export_db_label_text NOUN ajst-20793 55 34     SPACE ajst-20793 55 35 = = NOUN ajst-20793 55 36     SPACE ajst-20793 55 37 " " PUNCT ajst-20793 55 38 select select ADJ ajst-20793 55 39     SPACE ajst-20793 55 40 database database NOUN ajst-20793 55 41     SPACE ajst-20793 55 42 path path NOUN ajst-20793 55 43 : : PUNCT ajst-20793 55 44 " " PUNCT ajst-20793 55 45                       SPACE ajst-20793 55 46 self.export_file_label_text self.export_file_label_text PRON ajst-20793 55 47     SPACE ajst-20793 55 48 = = NOUN ajst-20793 55 49     SPACE ajst-20793 55 50 " " PUNCT ajst-20793 55 51 select select ADJ ajst-20793 55 52     SPACE ajst-20793 55 53 export export NOUN ajst-20793 55 54     SPACE ajst-20793 55 55 path path NOUN ajst-20793 55 56 : : PUNCT ajst-20793 55 57 " " PUNCT ajst-20793 55 58                       SPACE ajst-20793 55 59 self.export_table_label_text self.export_table_label_text NOUN ajst-20793 55 60     SPACE ajst-20793 55 61 = = NOUN ajst-20793 55 62     SPACE ajst-20793 55 63 " " PUNCT ajst-20793 55 64 select select ADJ ajst-20793 55 65     SPACE ajst-20793 55 66 table table NOUN ajst-20793 55 67     SPACE ajst-20793 55 68 to to PART ajst-20793 55 69     SPACE ajst-20793 55 70 export export VERB ajst-20793 55 71 : : PUNCT ajst-20793 55 72 " " PUNCT ajst-20793 55 73                           SPACE ajst-20793 55 74 self.export_db_label self.export_db_label VERB ajst-20793 55 75     SPACE ajst-20793 55 76 = = NOUN ajst-20793 55 77     SPACE ajst-20793 55 78 label(tab label(tab NOUN ajst-20793 55 79 , , PUNCT ajst-20793 55 80     SPACE ajst-20793 55 81 text text NOUN ajst-20793 55 82 = = SYM ajst-20793 55 83 self.export_db_label_text self.export_db_label_text NOUN ajst-20793 55 84 ) ) PUNCT ajst-20793 55 85                       SPACE ajst-20793 55 86 self.export_db_label.grid(row=0 self.export_db_label.grid(row=0 PROPN ajst-20793 55 87 , , PUNCT ajst-20793 55 88     SPACE ajst-20793 55 89 column=0 column=0 VERB ajst-20793 55 90 , , PUNCT ajst-20793 55 91     SPACE ajst-20793 55 92 padx=10 padx=10 NOUN ajst-20793 55 93 , , PUNCT ajst-20793 55 94     SPACE ajst-20793 55 95 pady=5 pady=5 PROPN ajst-20793 55 96 , , PUNCT ajst-20793 55 97     SPACE ajst-20793 55 98 sticky="w sticky="w PROPN ajst-20793 55 99 " " PUNCT ajst-20793 55 100 ) ) PUNCT ajst-20793 55 101                           SPACE ajst-20793 55 102 self.export_db_path_entry self.export_db_path_entry NOUN ajst-20793 55 103     SPACE ajst-20793 55 104 = = NOUN ajst-20793 55 105     SPACE ajst-20793 55 106 entry(tab entry(tab NOUN ajst-20793 55 107 , , PUNCT ajst-20793 55 108     SPACE ajst-20793 55 109 width=50 width=50 ADJ ajst-20793 55 110 ) ) PUNCT ajst-20793 55 111                       SPACE ajst-20793 55 112 self.export_db_path_entry.grid(row=1 self.export_db_path_entry.grid(row=1 NUM ajst-20793 55 113 , , PUNCT ajst-20793 55 114     SPACE ajst-20793 55 115 column=0 column=0 VERB ajst-20793 55 116 , , PUNCT ajst-20793 55 117     SPACE ajst-20793 55 118 padx=10 padx=10 NOUN ajst-20793 55 119 , , PUNCT ajst-20793 55 120     SPACE ajst-20793 55 121 pady=5 pady=5 PROPN ajst-20793 55 122 , , PUNCT ajst-20793 55 123     SPACE ajst-20793 55 124 sticky="w sticky="w PROPN ajst-20793 55 125 " " PUNCT ajst-20793 55 126 ) ) PUNCT ajst-20793 55 127                                 SPACE ajst-20793 55 128 self.export_db_button self.export_db_button PROPN ajst-20793 55 129     SPACE ajst-20793 55 130 = = NOUN ajst-20793 55 131     SPACE ajst-20793 55 132 button(tab button(tab NOUN ajst-20793 55 133 , , PUNCT ajst-20793 55 134     SPACE ajst-20793 55 135 text="browse text="browse NOUN ajst-20793 55 136 " " PUNCT ajst-20793 55 137 , , PUNCT ajst-20793 55 138     SPACE ajst-20793 55 139 command command NOUN ajst-20793 55 140 = = NOUN ajst-20793 55 141 self.select_export_database self.select_export_database NOUN ajst-20793 55 142 ) ) PUNCT ajst-20793 55 143                       SPACE ajst-20793 55 144 self.export_db_button.grid(row=1 self.export_db_button.grid(row=1 PROPN ajst-20793 55 145 , , PUNCT ajst-20793 55 146     SPACE ajst-20793 55 147 column=1 column=1 PROPN ajst-20793 55 148 , , PUNCT ajst-20793 55 149     SPACE ajst-20793 55 150 padx=10 padx=10 NOUN ajst-20793 55 151 , , PUNCT ajst-20793 55 152     SPACE ajst-20793 55 153 pady=5 pady=5 PROPN ajst-20793 55 154 , , PUNCT ajst-20793 55 155     SPACE ajst-20793 55 156 sticky="w sticky="w PROPN ajst-20793 55 157 " " PUNCT ajst-20793 55 158 ) ) PUNCT ajst-20793 55 159                           SPACE ajst-20793 55 160 self.export_file_label self.export_file_label NOUN ajst-20793 55 161     SPACE ajst-20793 55 162 = = NOUN ajst-20793 55 163     SPACE ajst-20793 55 164 label(tab label(tab NOUN ajst-20793 55 165 , , PUNCT ajst-20793 55 166     SPACE ajst-20793 55 167 text text NOUN ajst-20793 55 168 = = PRON ajst-20793 55 169 self.export_file_label_text self.export_file_label_text NOUN ajst-20793 55 170 ) ) PUNCT ajst-20793 55 171                       SPACE ajst-20793 55 172 self.export_file_label.grid(row=2 self.export_file_label.grid(row=2 PROPN ajst-20793 55 173 , , PUNCT ajst-20793 55 174     SPACE ajst-20793 55 175 column=0 column=0 VERB ajst-20793 55 176 , , PUNCT ajst-20793 55 177     SPACE ajst-20793 55 178 padx=10 padx=10 NOUN ajst-20793 55 179 , , PUNCT ajst-20793 55 180     SPACE ajst-20793 55 181 pady=5 pady=5 PROPN ajst-20793 55 182 , , PUNCT ajst-20793 55 183     SPACE ajst-20793 55 184 sticky="w sticky="w PROPN ajst-20793 55 185 " " PUNCT ajst-20793 55 186 ) ) PUNCT ajst-20793 55 187                           SPACE ajst-20793 55 188 self.export_file_path_entry self.export_file_path_entry NOUN ajst-20793 55 189     SPACE ajst-20793 55 190 = = NOUN ajst-20793 55 191     SPACE ajst-20793 55 192 entry(tab entry(tab NOUN ajst-20793 55 193 , , PUNCT ajst-20793 55 194     SPACE ajst-20793 55 195 width=50 width=50 ADJ ajst-20793 55 196 ) ) PUNCT ajst-20793 55 197                       SPACE ajst-20793 55 198 self.export_file_path_entry.grid(row=3 self.export_file_path_entry.grid(row=3 PROPN ajst-20793 55 199 , , PUNCT ajst-20793 55 200     SPACE ajst-20793 55 201 column=0 column=0 VERB ajst-20793 55 202 , , PUNCT ajst-20793 55 203     SPACE ajst-20793 55 204 padx=10 padx=10 NOUN ajst-20793 55 205 , , PUNCT ajst-20793 55 206     SPACE ajst-20793 55 207 pady=5 pady=5 PROPN ajst-20793 55 208 , , PUNCT ajst-20793 55 209     SPACE ajst-20793 55 210 sticky="w sticky="w PROPN ajst-20793 55 211 " " PUNCT ajst-20793 55 212 ) ) PUNCT ajst-20793 55 213                                 SPACE ajst-20793 55 214 self.export_file_button self.export_file_button NOUN ajst-20793 55 215     SPACE ajst-20793 55 216 = = NOUN ajst-20793 55 217     SPACE ajst-20793 55 218 button(tab button(tab NOUN ajst-20793 55 219 , , PUNCT ajst-20793 55 220     SPACE ajst-20793 55 221 text="browse text="browse NOUN ajst-20793 55 222 " " PUNCT ajst-20793 55 223 , , PUNCT ajst-20793 55 224     SPACE ajst-20793 55 225 command command NOUN ajst-20793 55 226 = = SYM ajst-20793 55 227 self.select_export_file self.select_export_file ADJ ajst-20793 55 228 ) ) PUNCT ajst-20793 55 229                       SPACE ajst-20793 55 230 self.export_file_button.grid(row=3 self.export_file_button.grid(row=3 NOUN ajst-20793 55 231 , , PUNCT ajst-20793 55 232     SPACE ajst-20793 55 233 column=1 column=1 PROPN ajst-20793 55 234 , , PUNCT ajst-20793 55 235     SPACE ajst-20793 55 236 padx=10 padx=10 NOUN ajst-20793 55 237 , , PUNCT ajst-20793 55 238     SPACE ajst-20793 55 239 pady=5 pady=5 PROPN ajst-20793 55 240 , , PUNCT ajst-20793 55 241     SPACE ajst-20793 55 242 sticky="w sticky="w PROPN ajst-20793 55 243 " " PUNCT ajst-20793 55 244 ) ) PUNCT ajst-20793 55 245                           SPACE ajst-20793 55 246 self.export_table_label self.export_table_label NOUN ajst-20793 55 247     SPACE ajst-20793 55 248 = = NOUN ajst-20793 55 249     SPACE ajst-20793 55 250 label(tab label(tab NOUN ajst-20793 55 251 , , PUNCT ajst-20793 55 252     SPACE ajst-20793 55 253 text text NOUN ajst-20793 55 254 = = SYM ajst-20793 55 255 self.export_table_label_text self.export_table_label_text NOUN ajst-20793 55 256 ) ) PUNCT ajst-20793 55 257                       SPACE ajst-20793 55 258 self.export_table_label.grid(row=4 self.export_table_label.grid(row=4 PROPN ajst-20793 55 259 , , PUNCT ajst-20793 55 260     SPACE ajst-20793 55 261 column=0 column=0 VERB ajst-20793 55 262 , , PUNCT ajst-20793 55 263     SPACE ajst-20793 55 264 padx=10 padx=10 NOUN ajst-20793 55 265 , , PUNCT ajst-20793 55 266     SPACE ajst-20793 55 267 pady=5 pady=5 PROPN ajst-20793 55 268 , , PUNCT ajst-20793 55 269     SPACE ajst-20793 55 270 sticky="w sticky="w PROPN ajst-20793 55 271 " " PUNCT ajst-20793 55 272 ) ) PUNCT ajst-20793 55 273                           SPACE ajst-20793 55 274 self.export_selected_table self.export_selected_table ADJ ajst-20793 55 275     SPACE ajst-20793 55 276 = = NOUN ajst-20793 55 277     SPACE ajst-20793 55 278 stringvar(tab stringvar(tab NOUN ajst-20793 55 279 ) ) PUNCT ajst-20793 55 280                       SPACE ajst-20793 55 281 self.export_selected_table.set("select self.export_selected_table.set("select NOUN ajst-20793 55 282 " " PUNCT ajst-20793 55 283 ) ) PUNCT ajst-20793 55 284                             SPACE ajst-20793 55 285 self.export_table_dropdown self.export_table_dropdown ADV ajst-20793 55 286     SPACE ajst-20793 55 287 = = NOUN ajst-20793 55 288     SPACE ajst-20793 55 289 combobox(tab combobox(tab NOUN ajst-20793 55 290 , , PUNCT ajst-20793 55 291     SPACE ajst-20793 55 292 textvariable textvariable ADJ ajst-20793 55 293 = = NOUN ajst-20793 55 294 self.export_selected_table self.export_selected_table ADJ ajst-20793 55 295 , , PUNCT ajst-20793 55 296     SPACE ajst-20793 55 297 width=47 width=47 PROPN ajst-20793 55 298 ) ) PUNCT ajst-20793 55 299                             SPACE ajst-20793 55 300 self.export_table_dropdown.grid(row=5 self.export_table_dropdown.grid(row=5 VERB ajst-20793 55 301 , , PUNCT ajst-20793 55 302     SPACE ajst-20793 55 303 column=0 column=0 VERB ajst-20793 55 304 , , PUNCT ajst-20793 55 305     SPACE ajst-20793 55 306 columnspan=2 columnspan=2 PROPN ajst-20793 55 307 , , PUNCT ajst-20793 55 308     SPACE ajst-20793 55 309 padx=(10 padx=(10 NOUN ajst-20793 55 310 , , PUNCT ajst-20793 55 311     SPACE ajst-20793 55 312 5 5 NUM ajst-20793 55 313 ) ) PUNCT ajst-20793 55 314 , , PUNCT ajst-20793 55 315     SPACE ajst-20793 55 316 pady=5 pady=5 PROPN ajst-20793 55 317 , , PUNCT ajst-20793 55 318     SPACE ajst-20793 55 319 sticky="w sticky="w PROPN ajst-20793 55 320 " " PUNCT ajst-20793 55 321 ) ) PUNCT ajst-20793 55 322                           SPACE ajst-20793 55 323 self.export_button self.export_button NOUN ajst-20793 55 324     SPACE ajst-20793 55 325 = = NOUN ajst-20793 55 326     SPACE ajst-20793 55 327 button(tab button(tab NOUN ajst-20793 55 328 , , PUNCT ajst-20793 55 329     SPACE ajst-20793 55 330 text="export text="export NOUN ajst-20793 55 331 " " PUNCT ajst-20793 55 332 , , PUNCT ajst-20793 55 333     SPACE ajst-20793 55 334 command command NOUN ajst-20793 55 335 = = SYM ajst-20793 55 336 self.export_to_excel self.export_to_excel PROPN ajst-20793 55 337 ) ) PUNCT ajst-20793 55 338                       SPACE ajst-20793 55 339 self.export_button.grid(row=5 self.export_button.grid(row=5 PROPN ajst-20793 55 340 , , PUNCT ajst-20793 55 341     SPACE ajst-20793 55 342 column=1 column=1 PROPN ajst-20793 55 343 , , PUNCT ajst-20793 55 344     SPACE ajst-20793 55 345 padx=10 padx=10 NOUN ajst-20793 55 346 , , PUNCT ajst-20793 55 347     SPACE ajst-20793 55 348 pady=5 pady=5 PROPN ajst-20793 55 349 , , PUNCT ajst-20793 55 350     SPACE ajst-20793 55 351 sticky="w sticky="w PROPN ajst-20793 55 352 " " PUNCT ajst-20793 55 353 ) ) PUNCT ajst-20793 55 354                           SPACE ajst-20793 55 355 self.export_status_label self.export_status_label NOUN ajst-20793 55 356     SPACE ajst-20793 55 357 = = NOUN ajst-20793 55 358     SPACE ajst-20793 55 359 text(tab text(tab NOUN ajst-20793 55 360 , , PUNCT ajst-20793 55 361     SPACE ajst-20793 55 362 height=10 height=10 NOUN ajst-20793 55 363 , , PUNCT ajst-20793 55 364     SPACE ajst-20793 55 365 width=50 width=50 ADJ ajst-20793 55 366 ) ) PUNCT ajst-20793 55 367                             SPACE ajst-20793 55 368 self.export_status_label.grid(row=6 self.export_status_label.grid(row=6 NOUN ajst-20793 55 369 , , PUNCT ajst-20793 55 370     SPACE ajst-20793 55 371 column=0 column=0 VERB ajst-20793 55 372 , , PUNCT ajst-20793 55 373     SPACE ajst-20793 55 374 columnspan=2 columnspan=2 PROPN ajst-20793 55 375 , , PUNCT ajst-20793 55 376     SPACE ajst-20793 55 377 padx=10 padx=10 NOUN ajst-20793 55 378 , , PUNCT ajst-20793 55 379     SPACE ajst-20793 55 380 pady=5 pady=5 PROPN ajst-20793 55 381 , , PUNCT ajst-20793 55 382     SPACE ajst-20793 55 383 sticky="w sticky="w PROPN ajst-20793 55 384 " " PUNCT ajst-20793 55 385 ) ) PUNCT ajst-20793 55 386                   SPACE ajst-20793 55 387 def def ADJ ajst-20793 55 388     SPACE ajst-20793 55 389 select_export_database(self select_export_database(self PRON ajst-20793 55 390 ): ): PUNCT ajst-20793 55 391                             SPACE ajst-20793 55 392 self.export_db_path self.export_db_path NOUN ajst-20793 55 393     SPACE ajst-20793 55 394 = = NOUN ajst-20793 55 395     SPACE ajst-20793 55 396 filedialog.askopenfilename(filetypes=[("access filedialog.askopenfilename(filetypes=[("access NOUN ajst-20793 55 397     SPACE ajst-20793 55 398 database database NOUN ajst-20793 55 399     SPACE ajst-20793 55 400 files file NOUN ajst-20793 55 401 " " PUNCT ajst-20793 55 402 , , PUNCT ajst-20793 55 403     SPACE ajst-20793 55 404 " " PUNCT ajst-20793 55 405 * * PUNCT ajst-20793 55 406 .mdb;*.accdb .mdb;*.accdb PUNCT ajst-20793 55 407 " " PUNCT ajst-20793 55 408 ) ) PUNCT ajst-20793 55 409 ] ] PUNCT ajst-20793 55 410 ) ) PUNCT ajst-20793 55 411                       SPACE ajst-20793 55 412 self.export_db_path_entry.delete(0 self.export_db_path_entry.delete(0 PROPN ajst-20793 55 413 , , PUNCT ajst-20793 55 414     SPACE ajst-20793 55 415 " " PUNCT ajst-20793 55 416 end end NOUN ajst-20793 55 417 " " PUNCT ajst-20793 55 418 ) ) PUNCT ajst-20793 55 419                       SPACE ajst-20793 55 420 self.export_db_path_entry.insert(0 self.export_db_path_entry.insert(0 PROPN ajst-20793 55 421 , , PUNCT ajst-20793 55 422     SPACE ajst-20793 55 423 self.export_db_path self.export_db_path NOUN ajst-20793 55 424 ) ) PUNCT ajst-20793 55 425                       SPACE ajst-20793 56 1 if if SCONJ ajst-20793 56 2     SPACE ajst-20793 56 3 self.export_db_path self.export_db_path NOUN ajst-20793 56 4 : : PUNCT ajst-20793 56 5                               SPACE ajst-20793 56 6 self.connect_to_export_database self.connect_to_export_database NOUN ajst-20793 56 7 ( ( PUNCT ajst-20793 56 8 ) ) PUNCT ajst-20793 56 9                   SPACE ajst-20793 56 10 def def PROPN ajst-20793 56 11     SPACE ajst-20793 56 12 connect_to_export_database(self connect_to_export_database(self PRON ajst-20793 56 13 ): ): PUNCT ajst-20793 56 14                             SPACE ajst-20793 56 15 conn_str conn_str NOUN ajst-20793 56 16     SPACE ajst-20793 56 17 = = NOUN ajst-20793 56 18     SPACE ajst-20793 56 19 f"driver={{microsoft f"driver={{microsoft NOUN ajst-20793 56 20     SPACE ajst-20793 56 21 access access NOUN ajst-20793 56 22     SPACE ajst-20793 56 23 driver driver NOUN ajst-20793 56 24     SPACE ajst-20793 56 25 ( ( PUNCT ajst-20793 56 26 * * PUNCT ajst-20793 56 27 .mdb .mdb PROPN ajst-20793 56 28 , , PUNCT ajst-20793 56 29     SPACE ajst-20793 56 30 * * PUNCT ajst-20793 56 31 .accdb)}};dbq={self.export_db_path .accdb)}};dbq={self.export_db_path PROPN ajst-20793 56 32 } } PUNCT ajst-20793 56 33 ; ; PUNCT ajst-20793 56 34 " " PUNCT ajst-20793 56 35                       SPACE ajst-20793 56 36 conn conn PROPN ajst-20793 56 37     SPACE ajst-20793 56 38 = = NOUN ajst-20793 56 39     SPACE ajst-20793 56 40 pyodbc.connect(conn_str pyodbc.connect(conn_str PROPN ajst-20793 56 41 ) ) PUNCT ajst-20793 56 42                       SPACE ajst-20793 56 43 cursor cursor NOUN ajst-20793 56 44     SPACE ajst-20793 56 45 = = NOUN ajst-20793 56 46     SPACE ajst-20793 56 47 conn.cursor conn.cursor NOUN ajst-20793 56 48 ( ( PUNCT ajst-20793 56 49 ) ) PUNCT ajst-20793 56 50                             SPACE ajst-20793 56 51 self.export_tables self.export_table NOUN ajst-20793 56 52     SPACE ajst-20793 56 53 = = NOUN ajst-20793 56 54     SPACE ajst-20793 56 55 [ [ X ajst-20793 56 56 table.table_name table.table_name NOUN ajst-20793 56 57     SPACE ajst-20793 56 58 for for ADP ajst-20793 56 59     SPACE ajst-20793 56 60 table table NOUN ajst-20793 56 61     SPACE ajst-20793 56 62 in in ADP ajst-20793 56 63     SPACE ajst-20793 56 64 cursor.tables(tabletype='table cursor.tables(tabletype='table NOUN ajst-20793 56 65 ' ' PUNCT ajst-20793 56 66 ) ) PUNCT ajst-20793 56 67 ] ] PUNCT ajst-20793 56 68                       SPACE ajst-20793 56 69 self.export_table_dropdown["values self.export_table_dropdown["value NOUN ajst-20793 56 70 " " PUNCT ajst-20793 56 71 ] ] X ajst-20793 56 72     SPACE ajst-20793 56 73 = = NOUN ajst-20793 56 74     SPACE ajst-20793 56 75 self.export_tables self.export_table NOUN ajst-20793 56 76                       SPACE ajst-20793 56 77 conn.close conn.close NUM ajst-20793 56 78 ( ( PUNCT ajst-20793 56 79 ) ) PUNCT ajst-20793 56 80                   SPACE ajst-20793 56 81 def def PROPN ajst-20793 56 82     SPACE ajst-20793 56 83 select_export_file(self select_export_file(self PRON ajst-20793 56 84 ): ): NOUN ajst-20793 56 85                       SPACE ajst-20793 56 86 self.export_file_path self.export_file_path NOUN ajst-20793 56 87     SPACE ajst-20793 56 88 = = NOUN ajst-20793 56 89     SPACE ajst-20793 56 90 filedialog.askdirectory filedialog.askdirectory PROPN ajst-20793 56 91 ( ( PUNCT ajst-20793 56 92 ) ) PUNCT ajst-20793 56 93                       SPACE ajst-20793 56 94 self.export_file_path_entry.delete(0 self.export_file_path_entry.delete(0 NOUN ajst-20793 56 95 , , PUNCT ajst-20793 56 96     SPACE ajst-20793 56 97 " " PUNCT ajst-20793 56 98 end end NOUN ajst-20793 56 99 " " PUNCT ajst-20793 56 100 ) ) PUNCT ajst-20793 56 101                       SPACE ajst-20793 56 102 self.export_file_path_entry.insert(0 self.export_file_path_entry.insert(0 PROPN ajst-20793 56 103 , , PUNCT ajst-20793 56 104     SPACE ajst-20793 56 105 self.export_file_path self.export_file_path NOUN ajst-20793 56 106 ) ) PUNCT ajst-20793 56 107     SPACE ajst-20793 56 108 102 102 NUM ajst-20793 56 109               SPACE ajst-20793 56 110 def def PROPN ajst-20793 56 111     SPACE ajst-20793 56 112 export_to_excel(self export_to_excel(self PRON ajst-20793 56 113 ): ): PUNCT ajst-20793 56 114                       SPACE ajst-20793 56 115 if if SCONJ ajst-20793 56 116     SPACE ajst-20793 56 117 not not PART ajst-20793 56 118     SPACE ajst-20793 56 119 self.export_db_path self.export_db_path NOUN ajst-20793 56 120 : : PUNCT ajst-20793 56 121                               SPACE ajst-20793 56 122 self.export_status_label.delete(1.0 self.export_status_label.delete(1.0 PROPN ajst-20793 56 123 , , PUNCT ajst-20793 56 124     SPACE ajst-20793 56 125 " " PUNCT ajst-20793 56 126 end end NOUN ajst-20793 56 127 " " PUNCT ajst-20793 56 128 ) ) PUNCT ajst-20793 56 129                               SPACE ajst-20793 56 130 self.export_status_label.insert("end self.export_status_label.insert("end ADJ ajst-20793 56 131 " " PUNCT ajst-20793 56 132 , , PUNCT ajst-20793 56 133     SPACE ajst-20793 56 134 " " PUNCT ajst-20793 56 135 please please INTJ ajst-20793 56 136     SPACE ajst-20793 56 137 select select VERB ajst-20793 56 138     SPACE ajst-20793 56 139 database database NOUN ajst-20793 56 140     SPACE ajst-20793 56 141 path path NOUN ajst-20793 56 142     SPACE ajst-20793 56 143 first first ADJ ajst-20793 56 144 " " PUNCT ajst-20793 56 145 ) ) PUNCT ajst-20793 56 146                               SPACE ajst-20793 56 147 return return NOUN ajst-20793 56 148                       SPACE ajst-20793 56 149 if if SCONJ ajst-20793 56 150     SPACE ajst-20793 56 151 not not PART ajst-20793 56 152     SPACE ajst-20793 56 153 self.export_file_path self.export_file_path PROPN ajst-20793 56 154 : : PUNCT ajst-20793 56 155                               SPACE ajst-20793 56 156 self.export_status_label.delete(1.0 self.export_status_label.delete(1.0 PROPN ajst-20793 56 157 , , PUNCT ajst-20793 56 158     SPACE ajst-20793 56 159 " " PUNCT ajst-20793 56 160 end end NOUN ajst-20793 56 161 " " PUNCT ajst-20793 56 162 ) ) PUNCT ajst-20793 56 163                               SPACE ajst-20793 56 164 self.export_status_label.insert("end self.export_status_label.insert("end ADJ ajst-20793 56 165 " " PUNCT ajst-20793 56 166 , , PUNCT ajst-20793 56 167     SPACE ajst-20793 56 168 " " PUNCT ajst-20793 56 169 please please INTJ ajst-20793 56 170     SPACE ajst-20793 56 171 select select VERB ajst-20793 56 172     SPACE ajst-20793 56 173 export export NOUN ajst-20793 56 174     SPACE ajst-20793 56 175 file file NOUN ajst-20793 56 176     SPACE ajst-20793 56 177 path path NOUN ajst-20793 56 178     SPACE ajst-20793 56 179 first first ADJ ajst-20793 56 180 " " PUNCT ajst-20793 56 181 ) ) PUNCT ajst-20793 56 182                               SPACE ajst-20793 56 183 return return NOUN ajst-20793 56 184                             SPACE ajst-20793 56 185 if if SCONJ ajst-20793 56 186     SPACE ajst-20793 56 187 not not PART ajst-20793 56 188     SPACE ajst-20793 56 189 self.export_selected_table.get self.export_selected_table.get VERB ajst-20793 56 190 ( ( PUNCT ajst-20793 56 191 ) ) PUNCT ajst-20793 56 192     SPACE ajst-20793 56 193 or or CCONJ ajst-20793 56 194     SPACE ajst-20793 56 195 self.export_selected_table.get self.export_selected_table.get NOUN ajst-20793 56 196 ( ( PUNCT ajst-20793 56 197 ) ) PUNCT ajst-20793 56 198     SPACE ajst-20793 57 1 = = PUNCT ajst-20793 57 2 = = NOUN ajst-20793 57 3     SPACE ajst-20793 57 4 " " PUNCT ajst-20793 57 5 select select ADJ ajst-20793 57 6 " " PUNCT ajst-20793 57 7 : : PUNCT ajst-20793 57 8                               SPACE ajst-20793 57 9 self.export_status_label.delete(1.0 self.export_status_label.delete(1.0 PROPN ajst-20793 57 10 , , PUNCT ajst-20793 57 11     SPACE ajst-20793 57 12 " " PUNCT ajst-20793 57 13 end end NOUN ajst-20793 57 14 " " PUNCT ajst-20793 57 15 ) ) PUNCT ajst-20793 57 16                               SPACE ajst-20793 57 17 self.export_status_label.insert("end self.export_status_label.insert("end ADJ ajst-20793 57 18 " " PUNCT ajst-20793 57 19 , , PUNCT ajst-20793 57 20     SPACE ajst-20793 57 21 " " PUNCT ajst-20793 57 22 please please INTJ ajst-20793 57 23     SPACE ajst-20793 57 24 select select VERB ajst-20793 57 25     SPACE ajst-20793 57 26 table table NOUN ajst-20793 57 27     SPACE ajst-20793 57 28 to to PART ajst-20793 57 29     SPACE ajst-20793 57 30 export export VERB ajst-20793 57 31 " " PUNCT ajst-20793 57 32 ) ) PUNCT ajst-20793 57 33                               SPACE ajst-20793 57 34 return return VERB ajst-20793 57 35                           SPACE ajst-20793 57 36 table_name table_name NOUN ajst-20793 57 37     SPACE ajst-20793 57 38 = = NOUN ajst-20793 57 39     SPACE ajst-20793 57 40 self.export_selected_table.get self.export_selected_table.get NOUN ajst-20793 57 41 ( ( PUNCT ajst-20793 57 42 ) ) PUNCT ajst-20793 57 43                             SPACE ajst-20793 57 44 conn_str conn_str NOUN ajst-20793 57 45     SPACE ajst-20793 57 46 = = NOUN ajst-20793 57 47     SPACE ajst-20793 57 48 f"driver={{microsoft f"driver={{microsoft NOUN ajst-20793 57 49     SPACE ajst-20793 57 50 access access NOUN ajst-20793 57 51     SPACE ajst-20793 57 52 driver driver NOUN ajst-20793 57 53     SPACE ajst-20793 57 54 ( ( PUNCT ajst-20793 57 55 * * PUNCT ajst-20793 57 56 .mdb .mdb PROPN ajst-20793 57 57 , , PUNCT ajst-20793 57 58     SPACE ajst-20793 57 59 * * PUNCT ajst-20793 57 60 .accdb)}};dbq={self.export_db_path .accdb)}};dbq={self.export_db_path PROPN ajst-20793 57 61 } } PUNCT ajst-20793 57 62 ; ; PUNCT ajst-20793 57 63 " " PUNCT ajst-20793 57 64                       SPACE ajst-20793 57 65 conn conn PROPN ajst-20793 57 66     SPACE ajst-20793 57 67 = = NOUN ajst-20793 57 68     SPACE ajst-20793 57 69 pyodbc.connect(conn_str pyodbc.connect(conn_str PROPN ajst-20793 57 70 ) ) PUNCT ajst-20793 57 71                       SPACE ajst-20793 57 72 timestamp timestamp NOUN ajst-20793 57 73     SPACE ajst-20793 57 74 = = ADJ ajst-20793 57 75     SPACE ajst-20793 57 76 datetime.now().strftime("%y%m%d_%h%m%s datetime.now().strftime("%y%m%d_%h%m% NOUN ajst-20793 57 77 " " PUNCT ajst-20793 57 78 ) ) PUNCT ajst-20793 57 79                               SPACE ajst-20793 57 80 excel_path excel_path NOUN ajst-20793 57 81     SPACE ajst-20793 57 82 = = NOUN ajst-20793 57 83     SPACE ajst-20793 57 84 os.path.join(self.export_file_path os.path.join(self.export_file_path NOUN ajst-20793 57 85 , , PUNCT ajst-20793 57 86     SPACE ajst-20793 57 87 f"{table_name}_{timestamp}.xlsx f"{table_name}_{timestamp}.xlsx NOUN ajst-20793 57 88 " " PUNCT ajst-20793 57 89 ) ) PUNCT ajst-20793 57 90                       SPACE ajst-20793 57 91 query query NOUN ajst-20793 57 92     SPACE ajst-20793 57 93 = = PRON ajst-20793 57 94     SPACE ajst-20793 57 95 f"select f"select VERB ajst-20793 57 96     SPACE ajst-20793 57 97 * * NOUN ajst-20793 57 98     SPACE ajst-20793 57 99 from from ADP ajst-20793 57 100     SPACE ajst-20793 57 101 { { PUNCT ajst-20793 57 102 table_name table_name NOUN ajst-20793 57 103 } } PUNCT ajst-20793 57 104 " " PUNCT ajst-20793 57 105                       SPACE ajst-20793 57 106 df df PROPN ajst-20793 57 107     SPACE ajst-20793 57 108 = = NOUN ajst-20793 57 109     SPACE ajst-20793 57 110 pd.read_sql(query pd.read_sql(query NOUN ajst-20793 57 111 , , PUNCT ajst-20793 57 112     SPACE ajst-20793 57 113 conn conn PROPN ajst-20793 57 114 ) ) PUNCT ajst-20793 57 115                       SPACE ajst-20793 57 116 df.to_excel(excel_path df.to_excel(excel_path PROPN ajst-20793 57 117 , , PUNCT ajst-20793 57 118     SPACE ajst-20793 57 119 index index NOUN ajst-20793 57 120 = = NOUN ajst-20793 57 121 false false ADJ ajst-20793 57 122 ) ) PUNCT ajst-20793 57 123                       SPACE ajst-20793 57 124 timestamp timestamp NOUN ajst-20793 57 125     SPACE ajst-20793 57 126 = = NOUN ajst-20793 57 127     SPACE ajst-20793 57 128 datetime.now().strftime("%h:%m:%s datetime.now().strftime("%h:%m:%s NOUN ajst-20793 57 129 " " PUNCT ajst-20793 57 130 ) ) PUNCT ajst-20793 57 131                       SPACE ajst-20793 57 132 self.export_status_label.delete(1.0 self.export_status_label.delete(1.0 PROPN ajst-20793 57 133 , , PUNCT ajst-20793 57 134     SPACE ajst-20793 57 135 " " PUNCT ajst-20793 57 136 end end NOUN ajst-20793 57 137 " " PUNCT ajst-20793 57 138 ) ) PUNCT ajst-20793 57 139                             SPACE ajst-20793 57 140 self.export_status_label.insert("end self.export_status_label.insert("end PROPN ajst-20793 57 141 " " PUNCT ajst-20793 57 142 , , PUNCT ajst-20793 57 143     SPACE ajst-20793 57 144 f"{timestamp f"{timestamp NOUN ajst-20793 57 145 } } PUNCT ajst-20793 57 146 : : PUNCT ajst-20793 57 147     SPACE ajst-20793 57 148 table table NOUN ajst-20793 57 149     SPACE ajst-20793 57 150 ' ' PUNCT ajst-20793 57 151 { { PUNCT ajst-20793 57 152 table_name table_name NOUN ajst-20793 57 153 } } PUNCT ajst-20793 57 154 ' ' NUM ajst-20793 57 155     SPACE ajst-20793 57 156 successfully successfully ADV ajst-20793 57 157     SPACE ajst-20793 57 158 exported export VERB ajst-20793 57 159     SPACE ajst-20793 57 160 to to ADP ajst-20793 57 161     SPACE ajst-20793 57 162 ' ' PUNCT ajst-20793 57 163 { { PUNCT ajst-20793 57 164 self.export_file_path}/{table_name}_{timestamp}.xlsx self.export_file_path}/{table_name}_{timestamp}.xlsx PROPN ajst-20793 57 165 ' ' PUNCT ajst-20793 57 166 " " PUNCT ajst-20793 57 167 ) ) PUNCT ajst-20793 57 168                       SPACE ajst-20793 57 169 conn.close conn.close NUM ajst-20793 57 170 ( ( PUNCT ajst-20793 57 171 ) ) PUNCT ajst-20793 57 172 figure figure NOUN ajst-20793 57 173 3 3 NUM ajst-20793 57 174 . . PUNCT ajst-20793 57 175 export export NOUN ajst-20793 57 176 function function NOUN ajst-20793 57 177 implementation implementation NOUN ajst-20793 57 178 code code NOUN ajst-20793 57 179 as as SCONJ ajst-20793 57 180 shown show VERB ajst-20793 57 181 in in ADP ajst-20793 57 182 the the DET ajst-20793 57 183 code code NOUN ajst-20793 57 184 , , PUNCT ajst-20793 57 185 we we PRON ajst-20793 57 186 first first ADV ajst-20793 57 187 initialize initialize VERB ajst-20793 57 188 the the DET ajst-20793 57 189 exportapp exportapp ADJ ajst-20793 57 190 class class NOUN ajst-20793 57 191 and and CCONJ ajst-20793 57 192 design design VERB ajst-20793 57 193 a a DET ajst-20793 57 194 simple simple ADJ ajst-20793 57 195 gui gui NOUN ajst-20793 57 196 display display NOUN ajst-20793 57 197 interface interface NOUN ajst-20793 57 198 according accord VERB ajst-20793 57 199 to to ADP ajst-20793 57 200 the the DET ajst-20793 57 201 functional functional ADJ ajst-20793 57 202 requirements requirement NOUN ajst-20793 57 203 . . PUNCT ajst-20793 58 1 next next ADV ajst-20793 58 2 , , PUNCT ajst-20793 58 3 we we PRON ajst-20793 58 4 create create VERB ajst-20793 58 5 the the DET ajst-20793 58 6 select_export_database select_export_database PROPN ajst-20793 58 7 function function NOUN ajst-20793 58 8 , , PUNCT ajst-20793 58 9 which which PRON ajst-20793 58 10 allows allow VERB ajst-20793 58 11 the the DET ajst-20793 58 12 user user NOUN ajst-20793 58 13 to to PART ajst-20793 58 14 choose choose VERB ajst-20793 58 15 the the DET ajst-20793 58 16 database database NOUN ajst-20793 58 17 path path NOUN ajst-20793 58 18 . . PUNCT ajst-20793 59 1 since since SCONJ ajst-20793 59 2 this this DET ajst-20793 59 3 software software NOUN ajst-20793 59 4 is be AUX ajst-20793 59 5 primarily primarily ADV ajst-20793 59 6 used use VERB ajst-20793 59 7 to to PART ajst-20793 59 8 access access VERB ajst-20793 59 9 access access NOUN ajst-20793 59 10 databases database NOUN ajst-20793 59 11 , , PUNCT ajst-20793 59 12 we we PRON ajst-20793 59 13 limit limit VERB ajst-20793 59 14 the the DET ajst-20793 59 15 file file NOUN ajst-20793 59 16 names name NOUN ajst-20793 59 17 in in ADP ajst-20793 59 18 the the DET ajst-20793 59 19 function function NOUN ajst-20793 59 20 to to PART ajst-20793 59 21 only only ADV ajst-20793 59 22 import import VERB ajst-20793 59 23 * * NOUN ajst-20793 59 24 .mdb .mdb PROPN ajst-20793 59 25 or or CCONJ ajst-20793 59 26 * * NOUN ajst-20793 59 27 .accdb .accdb PUNCT ajst-20793 59 28 access access NOUN ajst-20793 59 29 databases database NOUN ajst-20793 59 30 . . PUNCT ajst-20793 60 1 then then ADV ajst-20793 60 2 , , PUNCT ajst-20793 60 3 we we PRON ajst-20793 60 4 create create VERB ajst-20793 60 5 the the DET ajst-20793 60 6 connect_to_export_database connect_to_export_database NOUN ajst-20793 60 7 function function NOUN ajst-20793 60 8 , , PUNCT ajst-20793 60 9 which which PRON ajst-20793 60 10 uses use VERB ajst-20793 60 11 the the DET ajst-20793 60 12 api api NOUN ajst-20793 60 13 in in ADP ajst-20793 60 14 the the DET ajst-20793 60 15 pyodbc pyodbc NOUN ajst-20793 60 16 library library NOUN ajst-20793 60 17 to to PART ajst-20793 60 18 establish establish VERB ajst-20793 60 19 a a DET ajst-20793 60 20 connection connection NOUN ajst-20793 60 21 with with ADP ajst-20793 60 22 the the DET ajst-20793 60 23 access access NOUN ajst-20793 60 24 database database NOUN ajst-20793 60 25 and and CCONJ ajst-20793 60 26 retrieve retrieve VERB ajst-20793 60 27 the the DET ajst-20793 60 28 names name NOUN ajst-20793 60 29 of of ADP ajst-20793 60 30 all all DET ajst-20793 60 31 tables table NOUN ajst-20793 60 32 in in ADP ajst-20793 60 33 the the DET ajst-20793 60 34 database database NOUN ajst-20793 60 35 . . PUNCT ajst-20793 61 1 these these DET ajst-20793 61 2 table table NOUN ajst-20793 61 3 names name NOUN ajst-20793 61 4 are be AUX ajst-20793 61 5 displayed display VERB ajst-20793 61 6 in in ADP ajst-20793 61 7 a a DET ajst-20793 61 8 dropdown dropdown ADJ ajst-20793 61 9 list list NOUN ajst-20793 61 10 for for SCONJ ajst-20793 61 11 the the DET ajst-20793 61 12 user user NOUN ajst-20793 61 13 to to PART ajst-20793 61 14 select select VERB ajst-20793 61 15 . . PUNCT ajst-20793 62 1 this this DET ajst-20793 62 2 function function NOUN ajst-20793 62 3 is be AUX ajst-20793 62 4 also also ADV ajst-20793 62 5 called call VERB ajst-20793 62 6 in in ADP ajst-20793 62 7 the the DET ajst-20793 62 8 select_export_database select_export_database PROPN ajst-20793 62 9 function function NOUN ajst-20793 62 10 , , PUNCT ajst-20793 62 11 so so CCONJ ajst-20793 62 12 when when SCONJ ajst-20793 62 13 the the DET ajst-20793 62 14 user user NOUN ajst-20793 62 15 selects select VERB ajst-20793 62 16 an an DET ajst-20793 62 17 access access NOUN ajst-20793 62 18 database database NOUN ajst-20793 62 19 through through ADP ajst-20793 62 20 select_export_database select_export_database PROPN ajst-20793 62 21 , , PUNCT ajst-20793 62 22 the the DET ajst-20793 62 23 software software NOUN ajst-20793 62 24 automatically automatically ADV ajst-20793 62 25 executes execute VERB ajst-20793 62 26 the the DET ajst-20793 62 27 connect_to_export_database connect_to_export_database NOUN ajst-20793 62 28 function function NOUN ajst-20793 62 29 to to PART ajst-20793 62 30 display display VERB ajst-20793 62 31 all all DET ajst-20793 62 32 tables table NOUN ajst-20793 62 33 in in ADP ajst-20793 62 34 the the DET ajst-20793 62 35 access access NOUN ajst-20793 62 36 database database NOUN ajst-20793 62 37 in in ADP ajst-20793 62 38 the the DET ajst-20793 62 39 dropdown dropdown ADJ ajst-20793 62 40 list list NOUN ajst-20793 62 41 , , PUNCT ajst-20793 62 42 awaiting await VERB ajst-20793 62 43 user user NOUN ajst-20793 62 44 selection selection NOUN ajst-20793 62 45 . . PUNCT ajst-20793 63 1 next next ADV ajst-20793 63 2 , , PUNCT ajst-20793 63 3 we we PRON ajst-20793 63 4 create create VERB ajst-20793 63 5 the the DET ajst-20793 63 6 select_export_file select_export_file ADJ ajst-20793 63 7 function function NOUN ajst-20793 63 8 , , PUNCT ajst-20793 63 9 which which PRON ajst-20793 63 10 allows allow VERB ajst-20793 63 11 the the DET ajst-20793 63 12 user user NOUN ajst-20793 63 13 to to PART ajst-20793 63 14 choose choose VERB ajst-20793 63 15 the the DET ajst-20793 63 16 export export NOUN ajst-20793 63 17 file file NOUN ajst-20793 63 18 storage storage NOUN ajst-20793 63 19 path path NOUN ajst-20793 63 20 . . PUNCT ajst-20793 64 1 finally finally ADV ajst-20793 64 2 , , PUNCT ajst-20793 64 3 we we PRON ajst-20793 64 4 create create VERB ajst-20793 64 5 the the DET ajst-20793 64 6 export_to_excel export_to_excel PROPN ajst-20793 64 7 function function NOUN ajst-20793 64 8 , , PUNCT ajst-20793 64 9 which which PRON ajst-20793 64 10 , , PUNCT ajst-20793 64 11 after after SCONJ ajst-20793 64 12 the the DET ajst-20793 64 13 user user NOUN ajst-20793 64 14 executes execute VERB ajst-20793 64 15 all all DET ajst-20793 64 16 the the DET ajst-20793 64 17 above above ADJ ajst-20793 64 18 functions function NOUN ajst-20793 64 19 , , PUNCT ajst-20793 64 20 uses use VERB ajst-20793 64 21 sql sql NOUN ajst-20793 64 22 query query NOUN ajst-20793 64 23 language language NOUN ajst-20793 64 24 corresponding correspond VERB ajst-20793 64 25 to to ADP ajst-20793 64 26 access access NOUN ajst-20793 64 27 to to PART ajst-20793 64 28 retrieve retrieve VERB ajst-20793 64 29 data datum NOUN ajst-20793 64 30 from from ADP ajst-20793 64 31 the the DET ajst-20793 64 32 user user NOUN ajst-20793 64 33 - - PUNCT ajst-20793 64 34 selected select VERB ajst-20793 64 35 table table NOUN ajst-20793 64 36 . . PUNCT ajst-20793 65 1 the the DET ajst-20793 65 2 retrieved retrieve VERB ajst-20793 65 3 data data NOUN ajst-20793 65 4 is be AUX ajst-20793 65 5 then then ADV ajst-20793 65 6 saved save VERB ajst-20793 65 7 in in ADP ajst-20793 65 8 an an DET ajst-20793 65 9 excel excel NOUN ajst-20793 65 10 file file NOUN ajst-20793 65 11 at at ADP ajst-20793 65 12 the the DET ajst-20793 65 13 specified specified ADJ ajst-20793 65 14 path path NOUN ajst-20793 65 15 using use VERB ajst-20793 65 16 the the DET ajst-20793 65 17 api api NOUN ajst-20793 65 18 in in ADP ajst-20793 65 19 the the DET ajst-20793 65 20 pandas panda NOUN ajst-20793 65 21 library library NOUN ajst-20793 65 22 . . PUNCT ajst-20793 66 1 to to PART ajst-20793 66 2 improve improve VERB ajst-20793 66 3 interaction interaction NOUN ajst-20793 66 4 between between ADP ajst-20793 66 5 the the DET ajst-20793 66 6 program program NOUN ajst-20793 66 7 and and CCONJ ajst-20793 66 8 the the DET ajst-20793 66 9 user user NOUN ajst-20793 66 10 , , PUNCT ajst-20793 66 11 we we PRON ajst-20793 66 12 add add VERB ajst-20793 66 13 a a DET ajst-20793 66 14 detection detection NOUN ajst-20793 66 15 mechanism mechanism NOUN ajst-20793 66 16 in in ADP ajst-20793 66 17 the the DET ajst-20793 66 18 export_to_excel export_to_excel PROPN ajst-20793 66 19 function function NOUN ajst-20793 66 20 to to PART ajst-20793 66 21 check check VERB ajst-20793 66 22 whether whether SCONJ ajst-20793 66 23 the the DET ajst-20793 66 24 previous previous ADJ ajst-20793 66 25 steps step NOUN ajst-20793 66 26 have have AUX ajst-20793 66 27 been be AUX ajst-20793 66 28 completed complete VERB ajst-20793 66 29 . . PUNCT ajst-20793 67 1 if if SCONJ ajst-20793 67 2 not not PART ajst-20793 67 3 , , PUNCT ajst-20793 67 4 the the DET ajst-20793 67 5 user user NOUN ajst-20793 67 6 is be AUX ajst-20793 67 7 prompted prompt VERB ajst-20793 67 8 to to PART ajst-20793 67 9 complete complete VERB ajst-20793 67 10 the the DET ajst-20793 67 11 necessary necessary ADJ ajst-20793 67 12 steps step NOUN ajst-20793 67 13 first first ADV ajst-20793 67 14 . . PUNCT ajst-20793 68 1 additionally additionally ADV ajst-20793 68 2 , , PUNCT ajst-20793 68 3 for for ADP ajst-20793 68 4 the the DET ajst-20793 68 5 exported export VERB ajst-20793 68 6 excel excel NOUN ajst-20793 68 7 file file NOUN ajst-20793 68 8 , , PUNCT ajst-20793 68 9 we we PRON ajst-20793 68 10 name name VERB ajst-20793 68 11 it it PRON ajst-20793 68 12 consistently consistently ADV ajst-20793 68 13 with with ADP ajst-20793 68 14 the the DET ajst-20793 68 15 table table NOUN ajst-20793 68 16 names name NOUN ajst-20793 68 17 in in ADP ajst-20793 68 18 the the DET ajst-20793 68 19 database database NOUN ajst-20793 68 20 and and CCONJ ajst-20793 68 21 add add VERB ajst-20793 68 22 a a DET ajst-20793 68 23 timestamp timestamp NOUN ajst-20793 68 24 of of ADP ajst-20793 68 25 the the DET ajst-20793 68 26 current current ADJ ajst-20793 68 27 time time NOUN ajst-20793 68 28 . . PUNCT ajst-20793 69 1 this this PRON ajst-20793 69 2 allows allow VERB ajst-20793 69 3 the the DET ajst-20793 69 4 exported export VERB ajst-20793 69 5 file file NOUN ajst-20793 69 6 to to PART ajst-20793 69 7 serve serve VERB ajst-20793 69 8 as as ADP ajst-20793 69 9 a a DET ajst-20793 69 10 valid valid ADJ ajst-20793 69 11 backup backup ADJ ajst-20793 69 12 file file NOUN ajst-20793 69 13 for for ADP ajst-20793 69 14 the the DET ajst-20793 69 15 database database NOUN ajst-20793 69 16 table table NOUN ajst-20793 69 17 , , PUNCT ajst-20793 69 18 enhancing enhance VERB ajst-20793 69 19 the the DET ajst-20793 69 20 convenience convenience NOUN ajst-20793 69 21 of of ADP ajst-20793 69 22 database database NOUN ajst-20793 69 23 backup backup NOUN ajst-20793 69 24 operations operation NOUN ajst-20793 69 25 . . PUNCT ajst-20793 70 1 finally finally ADV ajst-20793 70 2 , , PUNCT ajst-20793 70 3 when when SCONJ ajst-20793 70 4 the the DET ajst-20793 70 5 program program NOUN ajst-20793 70 6 successfully successfully ADV ajst-20793 70 7 completes complete VERB ajst-20793 70 8 the the DET ajst-20793 70 9 export export NOUN ajst-20793 70 10 , , PUNCT ajst-20793 70 11 the the DET ajst-20793 70 12 program program NOUN ajst-20793 70 13 status status NOUN ajst-20793 70 14 display display NOUN ajst-20793 70 15 window window NOUN ajst-20793 70 16 notifies notifie NOUN ajst-20793 70 17 the the DET ajst-20793 70 18 user user NOUN ajst-20793 70 19 that that PRON ajst-20793 70 20 the the DET ajst-20793 70 21 data datum NOUN ajst-20793 70 22 has have AUX ajst-20793 70 23 been be AUX ajst-20793 70 24 successfully successfully ADV ajst-20793 70 25 exported export VERB ajst-20793 70 26 . . PUNCT ajst-20793 71 1 with with ADP ajst-20793 71 2 this this PRON ajst-20793 71 3 , , PUNCT ajst-20793 71 4 all all DET ajst-20793 71 5 the the DET ajst-20793 71 6 functional functional ADJ ajst-20793 71 7 requirements requirement NOUN ajst-20793 71 8 of of ADP ajst-20793 71 9 the the DET ajst-20793 71 10 exportapp exportapp ADJ ajst-20793 71 11 class class NOUN ajst-20793 71 12 are be AUX ajst-20793 71 13 completed complete VERB ajst-20793 71 14 , , PUNCT ajst-20793 71 15 and and CCONJ ajst-20793 71 16 the the DET ajst-20793 71 17 specified specify VERB ajst-20793 71 18 tables table NOUN ajst-20793 71 19 in in ADP ajst-20793 71 20 the the DET ajst-20793 71 21 database database NOUN ajst-20793 71 22 are be AUX ajst-20793 71 23 successfully successfully ADV ajst-20793 71 24 exported export VERB ajst-20793 71 25 to to PART ajst-20793 71 26 excel excel VERB ajst-20793 71 27 files file NOUN ajst-20793 71 28 , , PUNCT ajst-20793 71 29 saved save VERB ajst-20793 71 30 in in ADP ajst-20793 71 31 the the DET ajst-20793 71 32 userspecified userspecified ADJ ajst-20793 71 33 path path NOUN ajst-20793 71 34 . . PUNCT ajst-20793 72 1 the the DET ajst-20793 72 2 advantages advantage NOUN ajst-20793 72 3 of of ADP ajst-20793 72 4 using use VERB ajst-20793 72 5 the the DET ajst-20793 72 6 python python NOUN ajst-20793 72 7 language language NOUN ajst-20793 72 8 are be AUX ajst-20793 72 9 also also ADV ajst-20793 72 10 demonstrated demonstrate VERB ajst-20793 72 11 , , PUNCT ajst-20793 72 12 as as SCONJ ajst-20793 72 13 many many ADJ ajst-20793 72 14 important important ADJ ajst-20793 72 15 functionalities functionality NOUN ajst-20793 72 16 can can AUX ajst-20793 72 17 be be AUX ajst-20793 72 18 achieved achieve VERB ajst-20793 72 19 using use VERB ajst-20793 72 20 apis apis PROPN ajst-20793 72 21 in in ADP ajst-20793 72 22 third third ADJ ajst-20793 72 23 - - PUNCT ajst-20793 72 24 party party NOUN ajst-20793 72 25 libraries library NOUN ajst-20793 72 26 without without ADP ajst-20793 72 27 requiring require VERB ajst-20793 72 28 users user NOUN ajst-20793 72 29 to to PART ajst-20793 72 30 analyze analyze VERB ajst-20793 72 31 how how SCONJ ajst-20793 72 32 to to PART ajst-20793 72 33 implement implement VERB ajst-20793 72 34 them they PRON ajst-20793 72 35 , , PUNCT ajst-20793 72 36 truly truly ADV ajst-20793 72 37 achieving achieve VERB ajst-20793 72 38 the the DET ajst-20793 72 39 convenience convenience NOUN ajst-20793 72 40 of of ADP ajst-20793 72 41 " " PUNCT ajst-20793 72 42 plug plug VERB ajst-20793 72 43 and and CCONJ ajst-20793 72 44 play play VERB ajst-20793 72 45 " " PUNCT ajst-20793 72 46 . . PUNCT ajst-20793 73 1 figure figure VERB ajst-20793 73 2 4 4 NUM ajst-20793 73 3 . . PUNCT ajst-20793 73 4 export export NOUN ajst-20793 73 5 gui gui PROPN ajst-20793 73 6 display display NOUN ajst-20793 73 7 3.3 3.3 NUM ajst-20793 73 8 . . PUNCT ajst-20793 74 1 implementation implementation NOUN ajst-20793 74 2 of of ADP ajst-20793 74 3 import import NOUN ajst-20793 74 4 functionality functionality NOUN ajst-20793 74 5 : : PUNCT ajst-20793 74 6 after after ADP ajst-20793 74 7 implementing implement VERB ajst-20793 74 8 the the DET ajst-20793 74 9 functionality functionality NOUN ajst-20793 74 10 of of ADP ajst-20793 74 11 the the DET ajst-20793 74 12 exportapp exportapp ADJ ajst-20793 74 13 class class NOUN ajst-20793 74 14 , , PUNCT ajst-20793 74 15 the the DET ajst-20793 74 16 researchers researcher NOUN ajst-20793 74 17 proceeded proceed VERB ajst-20793 74 18 to to PART ajst-20793 74 19 build build VERB ajst-20793 74 20 the the DET ajst-20793 74 21 code code NOUN ajst-20793 74 22 for for ADP ajst-20793 74 23 the the DET ajst-20793 74 24 importapp importapp NOUN ajst-20793 74 25 class class NOUN ajst-20793 74 26 . . PUNCT ajst-20793 75 1 103 103 NUM ajst-20793 75 2 with with ADP ajst-20793 75 3 the the DET ajst-20793 75 4 foundation foundation NOUN ajst-20793 75 5 laid lay VERB ajst-20793 75 6 by by ADP ajst-20793 75 7 the the DET ajst-20793 75 8 previous previous ADJ ajst-20793 75 9 analysis analysis NOUN ajst-20793 75 10 of of ADP ajst-20793 75 11 export export NOUN ajst-20793 75 12 functionality functionality NOUN ajst-20793 75 13 requirements requirement NOUN ajst-20793 76 1 , , PUNCT ajst-20793 76 2 we we PRON ajst-20793 76 3 now now ADV ajst-20793 76 4 only only ADV ajst-20793 76 5 need need VERB ajst-20793 76 6 to to PART ajst-20793 76 7 address address VERB ajst-20793 76 8 the the DET ajst-20793 76 9 user user NOUN ajst-20793 76 10 's 's PART ajst-20793 76 11 needs need NOUN ajst-20793 76 12 in in ADP ajst-20793 76 13 reverse reverse NOUN ajst-20793 76 14 . . PUNCT ajst-20793 77 1 firstly firstly ADV ajst-20793 77 2 , , PUNCT ajst-20793 77 3 users user NOUN ajst-20793 77 4 need need VERB ajst-20793 77 5 to to PART ajst-20793 77 6 specify specify VERB ajst-20793 77 7 the the DET ajst-20793 77 8 excel excel NOUN ajst-20793 77 9 file file NOUN ajst-20793 77 10 and and CCONJ ajst-20793 77 11 its its PRON ajst-20793 77 12 path path NOUN ajst-20793 77 13 for for ADP ajst-20793 77 14 import import NOUN ajst-20793 77 15 . . PUNCT ajst-20793 78 1 then then ADV ajst-20793 78 2 , , PUNCT ajst-20793 78 3 they they PRON ajst-20793 78 4 select select VERB ajst-20793 78 5 the the DET ajst-20793 78 6 database database NOUN ajst-20793 78 7 path path NOUN ajst-20793 78 8 for for ADP ajst-20793 78 9 import import NOUN ajst-20793 78 10 , , PUNCT ajst-20793 78 11 followed follow VERB ajst-20793 78 12 by by ADP ajst-20793 78 13 choosing choose VERB ajst-20793 78 14 the the DET ajst-20793 78 15 table table NOUN ajst-20793 78 16 within within ADP ajst-20793 78 17 the the DET ajst-20793 78 18 database database NOUN ajst-20793 78 19 for for ADP ajst-20793 78 20 import import NOUN ajst-20793 78 21 , , PUNCT ajst-20793 78 22 and and CCONJ ajst-20793 78 23 finally finally ADV ajst-20793 78 24 executing execute VERB ajst-20793 78 25 the the DET ajst-20793 78 26 import import NOUN ajst-20793 78 27 operation operation NOUN ajst-20793 78 28 . . PUNCT ajst-20793 79 1 considering consider VERB ajst-20793 79 2 the the DET ajst-20793 79 3 user user NOUN ajst-20793 79 4 's 's PART ajst-20793 79 5 execution execution NOUN ajst-20793 79 6 steps step NOUN ajst-20793 79 7 , , PUNCT ajst-20793 79 8 we we PRON ajst-20793 79 9 analyze analyze VERB ajst-20793 79 10 how how SCONJ ajst-20793 79 11 to to PART ajst-20793 79 12 implement implement VERB ajst-20793 79 13 each each DET ajst-20793 79 14 functionality functionality NOUN ajst-20793 79 15 . . PUNCT ajst-20793 80 1 the the DET ajst-20793 80 2 first first ADJ ajst-20793 80 3 step step NOUN ajst-20793 80 4 involves involve VERB ajst-20793 80 5 designing design VERB ajst-20793 80 6 a a DET ajst-20793 80 7 function function NOUN ajst-20793 80 8 for for SCONJ ajst-20793 80 9 the the DET ajst-20793 80 10 user user NOUN ajst-20793 80 11 to to PART ajst-20793 80 12 specify specify VERB ajst-20793 80 13 the the DET ajst-20793 80 14 import import NOUN ajst-20793 80 15 file file NOUN ajst-20793 80 16 and and CCONJ ajst-20793 80 17 its its PRON ajst-20793 80 18 path path NOUN ajst-20793 80 19 . . PUNCT ajst-20793 81 1 the the DET ajst-20793 81 2 second second ADJ ajst-20793 81 3 step step NOUN ajst-20793 81 4 is be AUX ajst-20793 81 5 to to PART ajst-20793 81 6 provide provide VERB ajst-20793 81 7 the the DET ajst-20793 81 8 user user NOUN ajst-20793 81 9 with with ADP ajst-20793 81 10 the the DET ajst-20793 81 11 option option NOUN ajst-20793 81 12 to to PART ajst-20793 81 13 choose choose VERB ajst-20793 81 14 the the DET ajst-20793 81 15 database database NOUN ajst-20793 81 16 import import NOUN ajst-20793 81 17 path path NOUN ajst-20793 81 18 . . PUNCT ajst-20793 82 1 the the DET ajst-20793 82 2 third third ADJ ajst-20793 82 3 step step NOUN ajst-20793 82 4 requires require VERB ajst-20793 82 5 designing design VERB ajst-20793 82 6 a a DET ajst-20793 82 7 function function NOUN ajst-20793 82 8 to to PART ajst-20793 82 9 establish establish VERB ajst-20793 82 10 a a DET ajst-20793 82 11 connection connection NOUN ajst-20793 82 12 to to ADP ajst-20793 82 13 the the DET ajst-20793 82 14 selected select VERB ajst-20793 82 15 database database NOUN ajst-20793 82 16 and and CCONJ ajst-20793 82 17 display display VERB ajst-20793 82 18 the the DET ajst-20793 82 19 tables table NOUN ajst-20793 82 20 within within ADP ajst-20793 82 21 the the DET ajst-20793 82 22 database database NOUN ajst-20793 82 23 for for ADP ajst-20793 82 24 user user NOUN ajst-20793 82 25 selection selection NOUN ajst-20793 82 26 . . PUNCT ajst-20793 83 1 the the DET ajst-20793 83 2 fourth fourth ADJ ajst-20793 83 3 step step NOUN ajst-20793 83 4 involves involve VERB ajst-20793 83 5 importing import VERB ajst-20793 83 6 the the DET ajst-20793 83 7 data datum NOUN ajst-20793 83 8 from from ADP ajst-20793 83 9 the the DET ajst-20793 83 10 excel excel NOUN ajst-20793 83 11 file file NOUN ajst-20793 83 12 into into ADP ajst-20793 83 13 the the DET ajst-20793 83 14 specified specify VERB ajst-20793 83 15 table table NOUN ajst-20793 83 16 within within ADP ajst-20793 83 17 the the DET ajst-20793 83 18 database database NOUN ajst-20793 83 19 . . PUNCT ajst-20793 84 1 based base VERB ajst-20793 84 2 on on ADP ajst-20793 84 3 these these DET ajst-20793 84 4 requirements requirement NOUN ajst-20793 84 5 , , PUNCT ajst-20793 84 6 we we PRON ajst-20793 84 7 proceed proceed VERB ajst-20793 84 8 to to PART ajst-20793 84 9 design design VERB ajst-20793 84 10 individual individual ADJ ajst-20793 84 11 functions function NOUN ajst-20793 84 12 for for ADP ajst-20793 84 13 each each DET ajst-20793 84 14 step step NOUN ajst-20793 84 15 to to PART ajst-20793 84 16 implement implement VERB ajst-20793 84 17 the the DET ajst-20793 84 18 desired desire VERB ajst-20793 84 19 functionality functionality NOUN ajst-20793 84 20 . . PUNCT ajst-20793 85 1 class class NOUN ajst-20793 85 2     SPACE ajst-20793 85 3 importapp importapp NOUN ajst-20793 85 4 : : PUNCT ajst-20793 85 5               SPACE ajst-20793 85 6 def def ADJ ajst-20793 85 7     SPACE ajst-20793 85 8 _ _ PUNCT ajst-20793 86 1 _ _ PUNCT ajst-20793 86 2 init__(self init__(self PRON ajst-20793 86 3 , , PUNCT ajst-20793 86 4     SPACE ajst-20793 86 5 tab tab NOUN ajst-20793 86 6 ): ): PUNCT ajst-20793 86 7                       SPACE ajst-20793 86 8 self.import_file_path self.import_file_path NOUN ajst-20793 86 9     SPACE ajst-20793 86 10 = = NOUN ajst-20793 86 11     SPACE ajst-20793 86 12 " " PUNCT ajst-20793 86 13 " " PUNCT ajst-20793 86 14                       SPACE ajst-20793 86 15 self.import_db_path self.import_db_path NOUN ajst-20793 86 16     SPACE ajst-20793 86 17 = = NOUN ajst-20793 86 18     SPACE ajst-20793 86 19 " " PUNCT ajst-20793 86 20 " " PUNCT ajst-20793 86 21                       SPACE ajst-20793 86 22 self.create_widgets(tab self.create_widgets(tab PROPN ajst-20793 86 23 ) ) PUNCT ajst-20793 86 24                                   SPACE ajst-20793 86 25 def def ADJ ajst-20793 86 26     SPACE ajst-20793 86 27 create_widgets(self create_widgets(self PROPN ajst-20793 86 28 , , PUNCT ajst-20793 86 29     SPACE ajst-20793 86 30 tab tab NOUN ajst-20793 86 31 ): ): PUNCT ajst-20793 86 32                       SPACE ajst-20793 86 33 self.import_file_label_text self.import_file_label_text NOUN ajst-20793 86 34     SPACE ajst-20793 86 35 = = NOUN ajst-20793 86 36     SPACE ajst-20793 86 37 " " PUNCT ajst-20793 86 38 select select ADJ ajst-20793 86 39     SPACE ajst-20793 86 40 import import NOUN ajst-20793 86 41     SPACE ajst-20793 86 42 file file NOUN ajst-20793 86 43 : : PUNCT ajst-20793 86 44 " " PUNCT ajst-20793 86 45                       SPACE ajst-20793 86 46 self.import_db_label_text self.import_db_label_text NOUN ajst-20793 86 47     SPACE ajst-20793 86 48 = = NOUN ajst-20793 86 49     SPACE ajst-20793 86 50 " " PUNCT ajst-20793 86 51 select select ADJ ajst-20793 86 52     SPACE ajst-20793 86 53 import import NOUN ajst-20793 86 54     SPACE ajst-20793 86 55 database database NOUN ajst-20793 86 56 : : PUNCT ajst-20793 86 57 " " PUNCT ajst-20793 86 58                       SPACE ajst-20793 86 59 self.import_table_label_text self.import_table_label_text NOUN ajst-20793 86 60     SPACE ajst-20793 86 61 = = NOUN ajst-20793 86 62     SPACE ajst-20793 86 63 " " PUNCT ajst-20793 86 64 select select ADJ ajst-20793 86 65     SPACE ajst-20793 86 66 table table NOUN ajst-20793 86 67     SPACE ajst-20793 86 68 to to PART ajst-20793 86 69     SPACE ajst-20793 86 70 import import VERB ajst-20793 86 71 : : PUNCT ajst-20793 86 72 " " PUNCT ajst-20793 86 73                           SPACE ajst-20793 86 74 self.import_file_label self.import_file_label NOUN ajst-20793 86 75     SPACE ajst-20793 86 76 = = NOUN ajst-20793 86 77     SPACE ajst-20793 86 78 label(tab label(tab NOUN ajst-20793 86 79 , , PUNCT ajst-20793 86 80     SPACE ajst-20793 86 81 text text NOUN ajst-20793 86 82 = = PRON ajst-20793 86 83 self.import_file_label_text self.import_file_label_text X ajst-20793 86 84 ) ) PUNCT ajst-20793 86 85                       SPACE ajst-20793 86 86 self.import_file_label.grid(row=0 self.import_file_label.grid(row=0 PROPN ajst-20793 86 87 , , PUNCT ajst-20793 86 88     SPACE ajst-20793 86 89 column=0 column=0 VERB ajst-20793 86 90 , , PUNCT ajst-20793 86 91     SPACE ajst-20793 86 92 padx=10 padx=10 NOUN ajst-20793 86 93 , , PUNCT ajst-20793 86 94     SPACE ajst-20793 86 95 pady=5 pady=5 PROPN ajst-20793 86 96 , , PUNCT ajst-20793 86 97     SPACE ajst-20793 86 98 sticky="w sticky="w PROPN ajst-20793 86 99 " " PUNCT ajst-20793 86 100 ) ) PUNCT ajst-20793 86 101                           SPACE ajst-20793 86 102 self.import_file_path_entry self.import_file_path_entry PROPN ajst-20793 86 103     SPACE ajst-20793 86 104 = = NOUN ajst-20793 86 105     SPACE ajst-20793 86 106 entry(tab entry(tab NOUN ajst-20793 86 107 , , PUNCT ajst-20793 86 108     SPACE ajst-20793 86 109 width=50 width=50 ADJ ajst-20793 86 110 ) ) PUNCT ajst-20793 86 111                       SPACE ajst-20793 86 112 self.import_file_path_entry.grid(row=1 self.import_file_path_entry.grid(row=1 NOUN ajst-20793 86 113 , , PUNCT ajst-20793 86 114     SPACE ajst-20793 86 115 column=0 column=0 VERB ajst-20793 86 116 , , PUNCT ajst-20793 86 117     SPACE ajst-20793 86 118 padx=10 padx=10 NOUN ajst-20793 86 119 , , PUNCT ajst-20793 86 120     SPACE ajst-20793 86 121 pady=5 pady=5 PROPN ajst-20793 86 122 , , PUNCT ajst-20793 86 123     SPACE ajst-20793 86 124 sticky="w sticky="w PROPN ajst-20793 86 125 " " PUNCT ajst-20793 86 126 ) ) PUNCT ajst-20793 86 127                                 SPACE ajst-20793 86 128 self.import_file_button self.import_file_button NOUN ajst-20793 86 129     SPACE ajst-20793 86 130 = = NOUN ajst-20793 86 131     SPACE ajst-20793 86 132 button(tab button(tab NOUN ajst-20793 86 133 , , PUNCT ajst-20793 86 134     SPACE ajst-20793 86 135 text="browse text="browse NOUN ajst-20793 86 136 " " PUNCT ajst-20793 86 137 , , PUNCT ajst-20793 86 138     SPACE ajst-20793 86 139 command command NOUN ajst-20793 86 140 = = SYM ajst-20793 86 141 self.select_import_file self.select_import_file NOUN ajst-20793 86 142 ) ) PUNCT ajst-20793 86 143                       SPACE ajst-20793 86 144 self.import_file_button.grid(row=1 self.import_file_button.grid(row=1 PROPN ajst-20793 86 145 , , PUNCT ajst-20793 86 146     SPACE ajst-20793 86 147 column=1 column=1 PROPN ajst-20793 86 148 , , PUNCT ajst-20793 86 149     SPACE ajst-20793 86 150 padx=10 padx=10 NOUN ajst-20793 86 151 , , PUNCT ajst-20793 86 152     SPACE ajst-20793 86 153 pady=5 pady=5 PROPN ajst-20793 86 154 , , PUNCT ajst-20793 86 155     SPACE ajst-20793 86 156 sticky="w sticky="w PROPN ajst-20793 86 157 " " PUNCT ajst-20793 86 158 ) ) PUNCT ajst-20793 86 159                           SPACE ajst-20793 86 160 self.import_db_label self.import_db_label NOUN ajst-20793 86 161     SPACE ajst-20793 86 162 = = NOUN ajst-20793 86 163     SPACE ajst-20793 86 164 label(tab label(tab NOUN ajst-20793 86 165 , , PUNCT ajst-20793 86 166     SPACE ajst-20793 86 167 text text NOUN ajst-20793 86 168 = = SYM ajst-20793 86 169 self.import_db_label_text self.import_db_label_text NOUN ajst-20793 86 170 ) ) PUNCT ajst-20793 86 171                       SPACE ajst-20793 86 172 self.import_db_label.grid(row=2 self.import_db_label.grid(row=2 PROPN ajst-20793 86 173 , , PUNCT ajst-20793 86 174     SPACE ajst-20793 86 175 column=0 column=0 VERB ajst-20793 86 176 , , PUNCT ajst-20793 86 177     SPACE ajst-20793 86 178 padx=10 padx=10 NOUN ajst-20793 86 179 , , PUNCT ajst-20793 86 180     SPACE ajst-20793 86 181 pady=5 pady=5 PROPN ajst-20793 86 182 , , PUNCT ajst-20793 86 183     SPACE ajst-20793 86 184 sticky="w sticky="w PROPN ajst-20793 86 185 " " PUNCT ajst-20793 86 186 ) ) PUNCT ajst-20793 86 187                           SPACE ajst-20793 86 188 self.import_db_path_entry self.import_db_path_entry NOUN ajst-20793 86 189     SPACE ajst-20793 86 190 = = NOUN ajst-20793 86 191     SPACE ajst-20793 86 192 entry(tab entry(tab NOUN ajst-20793 86 193 , , PUNCT ajst-20793 86 194     SPACE ajst-20793 86 195 width=50 width=50 ADJ ajst-20793 86 196 ) ) PUNCT ajst-20793 86 197                       SPACE ajst-20793 86 198 self.import_db_path_entry.grid(row=3 self.import_db_path_entry.grid(row=3 NOUN ajst-20793 86 199 , , PUNCT ajst-20793 86 200     SPACE ajst-20793 86 201 column=0 column=0 VERB ajst-20793 86 202 , , PUNCT ajst-20793 86 203     SPACE ajst-20793 86 204 padx=10 padx=10 NOUN ajst-20793 86 205 , , PUNCT ajst-20793 86 206     SPACE ajst-20793 86 207 pady=5 pady=5 PROPN ajst-20793 86 208 , , PUNCT ajst-20793 86 209     SPACE ajst-20793 86 210 sticky="w sticky="w PROPN ajst-20793 86 211 " " PUNCT ajst-20793 86 212 ) ) PUNCT ajst-20793 86 213                                 SPACE ajst-20793 87 1 self.import_db_button self.import_db_button NOUN ajst-20793 87 2     SPACE ajst-20793 87 3 = = NOUN ajst-20793 87 4     SPACE ajst-20793 87 5 button(tab button(tab NOUN ajst-20793 87 6 , , PUNCT ajst-20793 87 7     SPACE ajst-20793 87 8 text="browse text="browse NOUN ajst-20793 87 9 " " PUNCT ajst-20793 87 10 , , PUNCT ajst-20793 87 11     SPACE ajst-20793 87 12 command command NOUN ajst-20793 87 13 = = SYM ajst-20793 87 14 self.select_import_database self.select_import_database ADJ ajst-20793 87 15 ) ) PUNCT ajst-20793 87 16                       SPACE ajst-20793 87 17 self.import_db_button.grid(row=3 self.import_db_button.grid(row=3 NOUN ajst-20793 87 18 , , PUNCT ajst-20793 87 19     SPACE ajst-20793 87 20 column=1 column=1 PROPN ajst-20793 87 21 , , PUNCT ajst-20793 87 22     SPACE ajst-20793 87 23 padx=10 padx=10 NOUN ajst-20793 87 24 , , PUNCT ajst-20793 87 25     SPACE ajst-20793 87 26 pady=5 pady=5 PROPN ajst-20793 87 27 , , PUNCT ajst-20793 87 28     SPACE ajst-20793 87 29 sticky="w sticky="w PROPN ajst-20793 87 30 " " PUNCT ajst-20793 87 31 ) ) PUNCT ajst-20793 87 32                           SPACE ajst-20793 87 33 self.import_table_label self.import_table_label VERB ajst-20793 87 34     SPACE ajst-20793 87 35 = = NOUN ajst-20793 87 36     SPACE ajst-20793 87 37 label(tab label(tab NOUN ajst-20793 87 38 , , PUNCT ajst-20793 87 39     SPACE ajst-20793 87 40 text text NOUN ajst-20793 87 41 = = SYM ajst-20793 87 42 self.import_table_label_text self.import_table_label_text NUM ajst-20793 87 43 ) ) PUNCT ajst-20793 87 44                       SPACE ajst-20793 87 45 self.import_table_label.grid(row=4 self.import_table_label.grid(row=4 PROPN ajst-20793 87 46 , , PUNCT ajst-20793 87 47     SPACE ajst-20793 87 48 column=0 column=0 VERB ajst-20793 87 49 , , PUNCT ajst-20793 87 50     SPACE ajst-20793 87 51 padx=10 padx=10 NOUN ajst-20793 87 52 , , PUNCT ajst-20793 87 53     SPACE ajst-20793 87 54 pady=5 pady=5 PROPN ajst-20793 87 55 , , PUNCT ajst-20793 87 56     SPACE ajst-20793 87 57 sticky="w sticky="w PROPN ajst-20793 87 58 " " PUNCT ajst-20793 87 59 ) ) PUNCT ajst-20793 87 60                           SPACE ajst-20793 87 61 self.import_selected_table self.import_selected_table ADJ ajst-20793 87 62     SPACE ajst-20793 87 63 = = NOUN ajst-20793 87 64     SPACE ajst-20793 87 65 stringvar(tab stringvar(tab NOUN ajst-20793 87 66 ) ) PUNCT ajst-20793 87 67                       SPACE ajst-20793 87 68 self.import_selected_table.set("select self.import_selected_table.set("select NOUN ajst-20793 87 69 " " PUNCT ajst-20793 87 70 ) ) PUNCT ajst-20793 87 71                             SPACE ajst-20793 87 72 self.import_table_dropdown self.import_table_dropdown NOUN ajst-20793 87 73     SPACE ajst-20793 87 74 = = NOUN ajst-20793 87 75     SPACE ajst-20793 87 76 combobox(tab combobox(tab NOUN ajst-20793 87 77 , , PUNCT ajst-20793 87 78     SPACE ajst-20793 87 79 textvariable textvariable ADJ ajst-20793 87 80 = = NOUN ajst-20793 87 81 self.import_selected_table self.import_selected_table ADJ ajst-20793 87 82 , , PUNCT ajst-20793 87 83     SPACE ajst-20793 87 84 width=47 width=47 PROPN ajst-20793 87 85 ) ) PUNCT ajst-20793 87 86                             SPACE ajst-20793 87 87 self.import_table_dropdown.grid(row=5 self.import_table_dropdown.grid(row=5 VERB ajst-20793 87 88 , , PUNCT ajst-20793 87 89     SPACE ajst-20793 87 90 column=0 column=0 VERB ajst-20793 87 91 , , PUNCT ajst-20793 87 92     SPACE ajst-20793 87 93 columnspan=2 columnspan=2 PROPN ajst-20793 87 94 , , PUNCT ajst-20793 87 95     SPACE ajst-20793 87 96 padx=(10 padx=(10 NOUN ajst-20793 87 97 , , PUNCT ajst-20793 87 98     SPACE ajst-20793 87 99 5 5 NUM ajst-20793 87 100 ) ) PUNCT ajst-20793 87 101 , , PUNCT ajst-20793 87 102     SPACE ajst-20793 87 103 pady=5 pady=5 PROPN ajst-20793 87 104 , , PUNCT ajst-20793 87 105     SPACE ajst-20793 87 106 sticky="w sticky="w PROPN ajst-20793 87 107 " " PUNCT ajst-20793 87 108 ) ) PUNCT ajst-20793 87 109                           SPACE ajst-20793 87 110 self.import_button self.import_button NOUN ajst-20793 87 111     SPACE ajst-20793 87 112 = = NOUN ajst-20793 87 113     SPACE ajst-20793 87 114 button(tab button(tab NOUN ajst-20793 87 115 , , PUNCT ajst-20793 87 116     SPACE ajst-20793 87 117 text="import text="import NOUN ajst-20793 87 118 " " PUNCT ajst-20793 87 119 , , PUNCT ajst-20793 87 120     SPACE ajst-20793 87 121 command command NOUN ajst-20793 87 122 = = NOUN ajst-20793 87 123 self.import_from_excel self.import_from_excel NOUN ajst-20793 87 124 ) ) PUNCT ajst-20793 87 125                       SPACE ajst-20793 87 126 self.import_button.grid(row=5 self.import_button.grid(row=5 PROPN ajst-20793 87 127 , , PUNCT ajst-20793 87 128     SPACE ajst-20793 87 129 column=1 column=1 PROPN ajst-20793 87 130 , , PUNCT ajst-20793 87 131     SPACE ajst-20793 87 132 padx=10 padx=10 NOUN ajst-20793 87 133 , , PUNCT ajst-20793 87 134     SPACE ajst-20793 87 135 pady=5 pady=5 PROPN ajst-20793 87 136 , , PUNCT ajst-20793 87 137     SPACE ajst-20793 87 138 sticky="w sticky="w PROPN ajst-20793 87 139 " " PUNCT ajst-20793 87 140 ) ) PUNCT ajst-20793 87 141                           SPACE ajst-20793 87 142 self.import_status_label self.import_status_label NOUN ajst-20793 87 143     SPACE ajst-20793 87 144 = = NOUN ajst-20793 87 145     SPACE ajst-20793 87 146 text(tab text(tab NOUN ajst-20793 87 147 , , PUNCT ajst-20793 87 148     SPACE ajst-20793 87 149 height=10 height=10 NOUN ajst-20793 87 150 , , PUNCT ajst-20793 87 151     SPACE ajst-20793 87 152 width=50 width=50 ADJ ajst-20793 87 153 ) ) PUNCT ajst-20793 87 154                             SPACE ajst-20793 87 155 self.import_status_label.grid(row=6 self.import_status_label.grid(row=6 NOUN ajst-20793 87 156 , , PUNCT ajst-20793 87 157     SPACE ajst-20793 87 158 column=0 column=0 VERB ajst-20793 87 159 , , PUNCT ajst-20793 87 160     SPACE ajst-20793 87 161 columnspan=2 columnspan=2 PROPN ajst-20793 87 162 , , PUNCT ajst-20793 87 163     SPACE ajst-20793 87 164 padx=10 padx=10 NOUN ajst-20793 87 165 , , PUNCT ajst-20793 87 166     SPACE ajst-20793 87 167 pady=5 pady=5 PROPN ajst-20793 87 168 , , PUNCT ajst-20793 87 169     SPACE ajst-20793 87 170 sticky="w sticky="w PROPN ajst-20793 87 171 " " PUNCT ajst-20793 87 172 ) ) PUNCT ajst-20793 87 173                   SPACE ajst-20793 87 174 def def ADJ ajst-20793 87 175     SPACE ajst-20793 87 176 select_import_file(self select_import_file(self SYM ajst-20793 87 177 ): ): NOUN ajst-20793 87 178                             SPACE ajst-20793 87 179 self.import_file_path self.import_file_path ADJ ajst-20793 87 180     SPACE ajst-20793 87 181 = = NOUN ajst-20793 87 182     SPACE ajst-20793 87 183 filedialog.askopenfilename(filetypes=[("excel filedialog.askopenfilename(filetypes=[("excel PROPN ajst-20793 87 184     SPACE ajst-20793 87 185 files file NOUN ajst-20793 87 186 " " PUNCT ajst-20793 87 187 , , PUNCT ajst-20793 87 188     SPACE ajst-20793 87 189 " " PUNCT ajst-20793 87 190 * * PUNCT ajst-20793 87 191 .xlsx;*.xls .xlsx;*.xls PROPN ajst-20793 87 192 " " PUNCT ajst-20793 87 193 ) ) PUNCT ajst-20793 87 194 ] ] PUNCT ajst-20793 87 195 ) ) PUNCT ajst-20793 87 196                       SPACE ajst-20793 87 197 self.import_file_path_entry.delete(0 self.import_file_path_entry.delete(0 NOUN ajst-20793 87 198 , , PUNCT ajst-20793 87 199     SPACE ajst-20793 87 200 " " PUNCT ajst-20793 87 201 end end NOUN ajst-20793 87 202 " " PUNCT ajst-20793 87 203 ) ) PUNCT ajst-20793 87 204                       SPACE ajst-20793 87 205 self.import_file_path_entry.insert(0 self.import_file_path_entry.insert(0 NOUN ajst-20793 87 206 , , PUNCT ajst-20793 87 207     SPACE ajst-20793 87 208 self.import_file_path self.import_file_path NOUN ajst-20793 87 209 ) ) PUNCT ajst-20793 87 210                   SPACE ajst-20793 87 211 def def PROPN ajst-20793 87 212     SPACE ajst-20793 87 213 select_import_database(self select_import_database(self PRON ajst-20793 87 214 ): ): NOUN ajst-20793 87 215                             SPACE ajst-20793 87 216 self.import_db_path self.import_db_path NOUN ajst-20793 87 217     SPACE ajst-20793 87 218 = = NOUN ajst-20793 87 219     SPACE ajst-20793 87 220 filedialog.askopenfilename(filetypes=[("access filedialog.askopenfilename(filetypes=[("access NOUN ajst-20793 87 221     SPACE ajst-20793 87 222 database database NOUN ajst-20793 87 223     SPACE ajst-20793 87 224 files file NOUN ajst-20793 87 225 " " PUNCT ajst-20793 87 226 , , PUNCT ajst-20793 87 227     SPACE ajst-20793 87 228 " " PUNCT ajst-20793 87 229 * * PUNCT ajst-20793 87 230 .mdb;*.accdb .mdb;*.accdb PUNCT ajst-20793 87 231 " " PUNCT ajst-20793 87 232 ) ) PUNCT ajst-20793 87 233 ] ] PUNCT ajst-20793 87 234 ) ) PUNCT ajst-20793 87 235                       SPACE ajst-20793 88 1 self.import_db_path_entry.delete(0 self.import_db_path_entry.delete(0 ADV ajst-20793 88 2 , , PUNCT ajst-20793 88 3     SPACE ajst-20793 88 4 " " PUNCT ajst-20793 88 5 end end NOUN ajst-20793 88 6 " " PUNCT ajst-20793 88 7 ) ) PUNCT ajst-20793 88 8                       SPACE ajst-20793 88 9 self.import_db_path_entry.insert(0 self.import_db_path_entry.insert(0 VERB ajst-20793 88 10 , , PUNCT ajst-20793 88 11     SPACE ajst-20793 88 12 self.import_db_path self.import_db_path NOUN ajst-20793 88 13 ) ) PUNCT ajst-20793 88 14                       SPACE ajst-20793 88 15 if if SCONJ ajst-20793 88 16     SPACE ajst-20793 88 17 self.import_db_path self.import_db_path NOUN ajst-20793 88 18 : : PUNCT ajst-20793 88 19                               SPACE ajst-20793 88 20 self.connect_to_import_database self.connect_to_import_database PROPN ajst-20793 88 21 ( ( PUNCT ajst-20793 88 22 ) ) PUNCT ajst-20793 88 23         SPACE ajst-20793 88 24 104 104 NUM ajst-20793 88 25           SPACE ajst-20793 88 26 def def ADJ ajst-20793 88 27     SPACE ajst-20793 88 28 connect_to_import_database(self connect_to_import_database(self NOUN ajst-20793 88 29 ): ): PUNCT ajst-20793 88 30                             SPACE ajst-20793 88 31 conn_str conn_str NOUN ajst-20793 88 32     SPACE ajst-20793 88 33 = = NOUN ajst-20793 88 34     SPACE ajst-20793 88 35 f"driver={{microsoft f"driver={{microsoft NOUN ajst-20793 88 36     SPACE ajst-20793 88 37 access access NOUN ajst-20793 88 38     SPACE ajst-20793 88 39 driver driver NOUN ajst-20793 88 40     SPACE ajst-20793 88 41 ( ( PUNCT ajst-20793 88 42 * * PUNCT ajst-20793 88 43 .mdb .mdb PROPN ajst-20793 88 44 , , PUNCT ajst-20793 88 45     SPACE ajst-20793 88 46 * * PROPN ajst-20793 88 47 .accdb)}};dbq={self.import_db_path .accdb)}};dbq={self.import_db_path NUM ajst-20793 88 48 } } PUNCT ajst-20793 88 49 ; ; PUNCT ajst-20793 88 50 " " PUNCT ajst-20793 88 51                       SPACE ajst-20793 88 52 conn conn PROPN ajst-20793 88 53     SPACE ajst-20793 88 54 = = NOUN ajst-20793 88 55     SPACE ajst-20793 88 56 pyodbc.connect(conn_str pyodbc.connect(conn_str PROPN ajst-20793 88 57 ) ) PUNCT ajst-20793 88 58                       SPACE ajst-20793 88 59 cursor cursor NOUN ajst-20793 88 60     SPACE ajst-20793 88 61 = = NOUN ajst-20793 88 62     SPACE ajst-20793 88 63 conn.cursor conn.cursor X ajst-20793 88 64 ( ( PUNCT ajst-20793 88 65 ) ) PUNCT ajst-20793 88 66                             SPACE ajst-20793 88 67 self.import_tables self.import_table NOUN ajst-20793 88 68     SPACE ajst-20793 88 69 = = NOUN ajst-20793 88 70     SPACE ajst-20793 88 71 [ [ X ajst-20793 88 72 table.table_name table.table_name NOUN ajst-20793 88 73     SPACE ajst-20793 88 74 for for ADP ajst-20793 88 75     SPACE ajst-20793 88 76 table table NOUN ajst-20793 88 77     SPACE ajst-20793 88 78 in in ADP ajst-20793 88 79     SPACE ajst-20793 88 80 cursor.tables(tabletype='table cursor.tables(tabletype='table NOUN ajst-20793 88 81 ' ' PUNCT ajst-20793 88 82 ) ) PUNCT ajst-20793 88 83 ] ] PUNCT ajst-20793 88 84                       SPACE ajst-20793 88 85 self.import_table_dropdown["values self.import_table_dropdown["value NOUN ajst-20793 88 86 " " PUNCT ajst-20793 88 87 ] ] X ajst-20793 88 88     SPACE ajst-20793 88 89 = = NOUN ajst-20793 88 90     SPACE ajst-20793 88 91 self.import_tables self.import_table NOUN ajst-20793 88 92                       SPACE ajst-20793 88 93 conn.close conn.close NUM ajst-20793 88 94 ( ( PUNCT ajst-20793 88 95 ) ) PUNCT ajst-20793 88 96                   SPACE ajst-20793 88 97 def def ADJ ajst-20793 88 98     SPACE ajst-20793 88 99 import_from_excel(self import_from_excel(self PRON ajst-20793 88 100 ): ): PUNCT ajst-20793 88 101                       SPACE ajst-20793 88 102 if if SCONJ ajst-20793 88 103     SPACE ajst-20793 88 104 not not PART ajst-20793 88 105     SPACE ajst-20793 88 106 self.import_file_path self.import_file_path ADJ ajst-20793 88 107 : : PUNCT ajst-20793 88 108                               SPACE ajst-20793 88 109 self.import_status_label.delete(1.0 self.import_status_label.delete(1.0 PROPN ajst-20793 88 110 , , PUNCT ajst-20793 88 111     SPACE ajst-20793 88 112 " " PUNCT ajst-20793 88 113 end end NOUN ajst-20793 88 114 " " PUNCT ajst-20793 88 115 ) ) PUNCT ajst-20793 88 116                               SPACE ajst-20793 88 117 self.import_status_label.insert("end self.import_status_label.insert("end NOUN ajst-20793 88 118 " " PUNCT ajst-20793 88 119 , , PUNCT ajst-20793 88 120     SPACE ajst-20793 88 121 " " PUNCT ajst-20793 88 122 please please INTJ ajst-20793 88 123     SPACE ajst-20793 88 124 select select VERB ajst-20793 88 125     SPACE ajst-20793 88 126 import import NOUN ajst-20793 88 127     SPACE ajst-20793 88 128 file file NOUN ajst-20793 88 129     SPACE ajst-20793 88 130 path path NOUN ajst-20793 88 131     SPACE ajst-20793 88 132 first first ADJ ajst-20793 88 133 " " PUNCT ajst-20793 88 134 ) ) PUNCT ajst-20793 88 135                               SPACE ajst-20793 88 136 return return NOUN ajst-20793 88 137                       SPACE ajst-20793 88 138 if if SCONJ ajst-20793 88 139     SPACE ajst-20793 88 140 not not PART ajst-20793 88 141     SPACE ajst-20793 88 142 self.import_db_path self.import_db_path NOUN ajst-20793 88 143 : : PUNCT ajst-20793 88 144                               SPACE ajst-20793 88 145 self.import_status_label.delete(1.0 self.import_status_label.delete(1.0 PROPN ajst-20793 88 146 , , PUNCT ajst-20793 88 147     SPACE ajst-20793 88 148 " " PUNCT ajst-20793 88 149 end end NOUN ajst-20793 88 150 " " PUNCT ajst-20793 88 151 ) ) PUNCT ajst-20793 88 152                                         SPACE ajst-20793 88 153 self.import_status_label.insert("end self.import_status_label.insert("end NOUN ajst-20793 88 154 " " PUNCT ajst-20793 88 155 , , PUNCT ajst-20793 88 156     SPACE ajst-20793 88 157 " " PUNCT ajst-20793 88 158 please please INTJ ajst-20793 88 159     SPACE ajst-20793 88 160 select select VERB ajst-20793 88 161     SPACE ajst-20793 88 162 import import NOUN ajst-20793 88 163     SPACE ajst-20793 88 164 database database NOUN ajst-20793 88 165     SPACE ajst-20793 88 166 path path NOUN ajst-20793 88 167     SPACE ajst-20793 88 168 first first ADJ ajst-20793 88 169 " " PUNCT ajst-20793 88 170 ) ) PUNCT ajst-20793 88 171                               SPACE ajst-20793 88 172 return return NOUN ajst-20793 88 173                             SPACE ajst-20793 88 174 if if SCONJ ajst-20793 88 175     SPACE ajst-20793 88 176 not not PART ajst-20793 88 177     SPACE ajst-20793 88 178 self.import_selected_table.get self.import_selected_table.get NOUN ajst-20793 88 179 ( ( PUNCT ajst-20793 88 180 ) ) PUNCT ajst-20793 88 181     SPACE ajst-20793 88 182 or or CCONJ ajst-20793 88 183     SPACE ajst-20793 88 184 self.import_selected_table.get self.import_selected_table.get NOUN ajst-20793 88 185 ( ( PUNCT ajst-20793 88 186 ) ) PUNCT ajst-20793 88 187     SPACE ajst-20793 89 1 = = PUNCT ajst-20793 89 2 = = NOUN ajst-20793 89 3     SPACE ajst-20793 89 4 " " PUNCT ajst-20793 89 5 select select ADJ ajst-20793 89 6 " " PUNCT ajst-20793 89 7 : : PUNCT ajst-20793 89 8                               SPACE ajst-20793 89 9 self.import_status_label.delete(1.0 self.import_status_label.delete(1.0 PROPN ajst-20793 89 10 , , PUNCT ajst-20793 89 11     SPACE ajst-20793 89 12 " " PUNCT ajst-20793 89 13 end end NOUN ajst-20793 89 14 " " PUNCT ajst-20793 89 15 ) ) PUNCT ajst-20793 89 16                               SPACE ajst-20793 89 17 self.import_status_label.insert("end self.import_status_label.insert("end NOUN ajst-20793 89 18 " " PUNCT ajst-20793 89 19 , , PUNCT ajst-20793 89 20     SPACE ajst-20793 89 21 " " PUNCT ajst-20793 89 22 please please INTJ ajst-20793 89 23     SPACE ajst-20793 89 24 select select VERB ajst-20793 89 25     SPACE ajst-20793 89 26 table table NOUN ajst-20793 89 27     SPACE ajst-20793 89 28 to to PART ajst-20793 89 29     SPACE ajst-20793 89 30 import import VERB ajst-20793 89 31 " " PUNCT ajst-20793 89 32 ) ) PUNCT ajst-20793 89 33                               SPACE ajst-20793 89 34 return return VERB ajst-20793 89 35                           SPACE ajst-20793 89 36 table_name table_name NOUN ajst-20793 89 37     SPACE ajst-20793 89 38 = = NOUN ajst-20793 89 39     SPACE ajst-20793 89 40 self.import_selected_table.get self.import_selected_table.get NOUN ajst-20793 89 41 ( ( PUNCT ajst-20793 89 42 ) ) PUNCT ajst-20793 89 43                             SPACE ajst-20793 89 44 conn_str conn_str NOUN ajst-20793 89 45     SPACE ajst-20793 89 46 = = NOUN ajst-20793 89 47     SPACE ajst-20793 89 48 f"driver={{microsoft f"driver={{microsoft NOUN ajst-20793 89 49     SPACE ajst-20793 89 50 access access NOUN ajst-20793 89 51     SPACE ajst-20793 89 52 driver driver NOUN ajst-20793 89 53     SPACE ajst-20793 89 54 ( ( PUNCT ajst-20793 89 55 * * PUNCT ajst-20793 89 56 .mdb .mdb PROPN ajst-20793 89 57 , , PUNCT ajst-20793 89 58     SPACE ajst-20793 89 59 * * PROPN ajst-20793 89 60 .accdb)}};dbq={self.import_db_path .accdb)}};dbq={self.import_db_path NUM ajst-20793 89 61 } } PUNCT ajst-20793 89 62 ; ; PUNCT ajst-20793 89 63 " " PUNCT ajst-20793 89 64                       SPACE ajst-20793 89 65 conn conn PROPN ajst-20793 89 66     SPACE ajst-20793 89 67 = = NOUN ajst-20793 89 68     SPACE ajst-20793 89 69 pyodbc.connect(conn_str pyodbc.connect(conn_str PROPN ajst-20793 89 70 ) ) PUNCT ajst-20793 89 71                       SPACE ajst-20793 89 72 cursor cursor NOUN ajst-20793 89 73     SPACE ajst-20793 89 74 = = NOUN ajst-20793 89 75     SPACE ajst-20793 89 76 conn.cursor conn.cursor X ajst-20793 89 77 ( ( PUNCT ajst-20793 89 78 ) ) PUNCT ajst-20793 89 79                       SPACE ajst-20793 89 80 cursor.execute(f"delete cursor.execute(f"delete NOUN ajst-20793 89 81     SPACE ajst-20793 89 82 from from ADP ajst-20793 89 83     SPACE ajst-20793 89 84 { { PUNCT ajst-20793 89 85 table_name table_name NOUN ajst-20793 89 86 } } PUNCT ajst-20793 89 87 " " PUNCT ajst-20793 89 88 ) ) PUNCT ajst-20793 89 89                           SPACE ajst-20793 89 90 df df PROPN ajst-20793 89 91     SPACE ajst-20793 89 92 = = NOUN ajst-20793 89 93     SPACE ajst-20793 89 94 pd.read_excel(self.import_file_path pd.read_excel(self.import_file_path NOUN ajst-20793 89 95 ) ) PUNCT ajst-20793 89 96                       SPACE ajst-20793 89 97 for for ADP ajst-20793 89 98     SPACE ajst-20793 89 99 index index NOUN ajst-20793 89 100 , , PUNCT ajst-20793 89 101     SPACE ajst-20793 89 102 row row NOUN ajst-20793 89 103     SPACE ajst-20793 89 104 in in ADP ajst-20793 89 105     SPACE ajst-20793 89 106 df.iterrows df.iterrow NOUN ajst-20793 89 107 ( ( PUNCT ajst-20793 89 108 ): ): PUNCT ajst-20793 89 109                               SPACE ajst-20793 89 110 values_str values_str NOUN ajst-20793 89 111     SPACE ajst-20793 89 112 = = NOUN ajst-20793 89 113     SPACE ajst-20793 89 114 ' ' PROPN ajst-20793 89 115 , , PUNCT ajst-20793 89 116     SPACE ajst-20793 89 117 ' ' PART ajst-20793 89 118 .join([f"'{value .join([f"'{value CCONJ ajst-20793 89 119 } } PUNCT ajst-20793 89 120 ' ' PUNCT ajst-20793 89 121 " " PUNCT ajst-20793 89 122     SPACE ajst-20793 89 123 if if SCONJ ajst-20793 89 124     SPACE ajst-20793 89 125 isinstance(value isinstance(value PROPN ajst-20793 89 126 , , PUNCT ajst-20793 89 127     SPACE ajst-20793 89 128 str str NOUN ajst-20793 89 129 ) ) PUNCT ajst-20793 89 130     SPACE ajst-20793 89 131 else else ADV ajst-20793 89 132     SPACE ajst-20793 89 133 str(value str(value NOUN ajst-20793 89 134 ) ) PUNCT ajst-20793 89 135     SPACE ajst-20793 89 136 for for ADP ajst-20793 89 137     SPACE ajst-20793 89 138 value value NOUN ajst-20793 89 139     SPACE ajst-20793 89 140 in in ADP ajst-20793 89 141     SPACE ajst-20793 89 142 row row NOUN ajst-20793 89 143 ] ] PUNCT ajst-20793 89 144 ) ) PUNCT ajst-20793 89 145                               SPACE ajst-20793 89 146 sql sql NOUN ajst-20793 89 147     SPACE ajst-20793 89 148 = = NOUN ajst-20793 89 149     SPACE ajst-20793 89 150 f"insert f"insert NOUN ajst-20793 89 151     SPACE ajst-20793 89 152 into into ADP ajst-20793 89 153     SPACE ajst-20793 89 154 { { PUNCT ajst-20793 89 155 table_name table_name PROPN ajst-20793 89 156 } } PUNCT ajst-20793 89 157     SPACE ajst-20793 89 158 values value NOUN ajst-20793 89 159     SPACE ajst-20793 89 160 ( ( PUNCT ajst-20793 89 161 { { PUNCT ajst-20793 89 162 values_str values_str NOUN ajst-20793 89 163 } } PUNCT ajst-20793 89 164 ) ) PUNCT ajst-20793 89 165 " " PUNCT ajst-20793 89 166                               SPACE ajst-20793 89 167 cursor.execute(sql cursor.execute(sql NOUN ajst-20793 89 168 ) ) PUNCT ajst-20793 89 169                       SPACE ajst-20793 89 170 cursor.connection.commit cursor.connection.commit NOUN ajst-20793 89 171 ( ( PUNCT ajst-20793 89 172 ) ) PUNCT ajst-20793 89 173                                                       SPACE ajst-20793 89 174 timestamp timestamp NOUN ajst-20793 89 175     SPACE ajst-20793 89 176 = = NOUN ajst-20793 89 177     SPACE ajst-20793 89 178 datetime.now().strftime("%h:%m:%s datetime.now().strftime("%h:%m:%s NOUN ajst-20793 89 179 " " PUNCT ajst-20793 89 180 ) ) PUNCT ajst-20793 89 181                       SPACE ajst-20793 89 182 self.import_status_label.delete(1.0 self.import_status_label.delete(1.0 PROPN ajst-20793 89 183 , , PUNCT ajst-20793 89 184     SPACE ajst-20793 89 185 " " PUNCT ajst-20793 89 186 end end NOUN ajst-20793 89 187 " " PUNCT ajst-20793 89 188 ) ) PUNCT ajst-20793 89 189                             SPACE ajst-20793 89 190 self.import_status_label.insert("end self.import_status_label.insert("end NOUN ajst-20793 89 191 " " PUNCT ajst-20793 89 192 , , PUNCT ajst-20793 89 193     SPACE ajst-20793 89 194 f"{timestamp f"{timestamp NOUN ajst-20793 89 195 } } PUNCT ajst-20793 89 196 : : PUNCT ajst-20793 89 197     SPACE ajst-20793 89 198 file file VERB ajst-20793 89 199     SPACE ajst-20793 89 200 ' ' PUNCT ajst-20793 89 201 { { PUNCT ajst-20793 89 202 self.import_file_path self.import_file_path NOUN ajst-20793 89 203 } } PUNCT ajst-20793 89 204 ' ' VERB ajst-20793 89 205     SPACE ajst-20793 89 206 successfully successfully ADV ajst-20793 89 207     SPACE ajst-20793 89 208 imported import VERB ajst-20793 89 209     SPACE ajst-20793 89 210 to to ADP ajst-20793 89 211     SPACE ajst-20793 89 212 table table VERB ajst-20793 89 213     SPACE ajst-20793 89 214 ' ' PUNCT ajst-20793 89 215 { { PUNCT ajst-20793 89 216 table_name table_name NOUN ajst-20793 89 217 } } PUNCT ajst-20793 89 218 ' ' PUNCT ajst-20793 89 219 " " PUNCT ajst-20793 89 220 ) ) PUNCT ajst-20793 89 221                       SPACE ajst-20793 89 222 conn.close conn.close NUM ajst-20793 89 223 ( ( PUNCT ajst-20793 89 224 ) ) PUNCT ajst-20793 89 225 figure figure NOUN ajst-20793 89 226 5 5 NUM ajst-20793 89 227 . . PUNCT ajst-20793 89 228 importapp importapp NOUN ajst-20793 89 229 class class NOUN ajst-20793 89 230 function function NOUN ajst-20793 89 231 code code NOUN ajst-20793 89 232 as as SCONJ ajst-20793 89 233 shown show VERB ajst-20793 89 234 in in ADP ajst-20793 89 235 the the DET ajst-20793 89 236 code code NOUN ajst-20793 89 237 , , PUNCT ajst-20793 89 238 most most ADJ ajst-20793 89 239 of of ADP ajst-20793 89 240 the the DET ajst-20793 89 241 operations operation NOUN ajst-20793 89 242 are be AUX ajst-20793 89 243 similar similar ADJ ajst-20793 89 244 to to ADP ajst-20793 89 245 when when SCONJ ajst-20793 89 246 writing write VERB ajst-20793 89 247 the the DET ajst-20793 89 248 exportapp exportapp ADJ ajst-20793 89 249 class class NOUN ajst-20793 89 250 code code NOUN ajst-20793 89 251 , , PUNCT ajst-20793 89 252 with with ADP ajst-20793 89 253 the the DET ajst-20793 89 254 main main ADJ ajst-20793 89 255 difference difference NOUN ajst-20793 89 256 being be AUX ajst-20793 89 257 the the DET ajst-20793 89 258 use use NOUN ajst-20793 89 259 of of ADP ajst-20793 89 260 " " PUNCT ajst-20793 89 261 import import NOUN ajst-20793 89 262 " " PUNCT ajst-20793 89 263 in in ADP ajst-20793 89 264 function function NOUN ajst-20793 89 265 naming name VERB ajst-20793 89 266 for for ADP ajst-20793 89 267 readability readability NOUN ajst-20793 89 268 . . PUNCT ajst-20793 90 1 additionally additionally ADV ajst-20793 90 2 , , PUNCT ajst-20793 90 3 the the DET ajst-20793 90 4 functions function NOUN ajst-20793 90 5 created create VERB ajst-20793 90 6 , , PUNCT ajst-20793 90 7 such such ADJ ajst-20793 90 8 as as ADP ajst-20793 90 9 select_import_file select_import_file ADJ ajst-20793 90 10 , , PUNCT ajst-20793 90 11 select_import_database select_import_database ADJ ajst-20793 90 12 , , PUNCT ajst-20793 90 13 and and CCONJ ajst-20793 90 14 connect_to_import_database connect_to_import_database VERB ajst-20793 90 15 , , PUNCT ajst-20793 90 16 have have VERB ajst-20793 90 17 functionalities functionality NOUN ajst-20793 90 18 similar similar ADJ ajst-20793 90 19 to to ADP ajst-20793 90 20 their their PRON ajst-20793 90 21 counterparts counterpart NOUN ajst-20793 90 22 in in ADP ajst-20793 90 23 the the DET ajst-20793 90 24 exportapp exportapp ADJ ajst-20793 90 25 class class NOUN ajst-20793 90 26 . . PUNCT ajst-20793 91 1 the the DET ajst-20793 91 2 key key ADJ ajst-20793 91 3 distinction distinction NOUN ajst-20793 91 4 lies lie VERB ajst-20793 91 5 in in ADP ajst-20793 91 6 the the DET ajst-20793 91 7 creation creation NOUN ajst-20793 91 8 of of ADP ajst-20793 91 9 the the DET ajst-20793 91 10 import_from_excel import_from_excel PROPN ajst-20793 91 11 function function NOUN ajst-20793 91 12 . . PUNCT ajst-20793 92 1 after after SCONJ ajst-20793 92 2 the the DET ajst-20793 92 3 user user NOUN ajst-20793 92 4 executes execute VERB ajst-20793 92 5 the the DET ajst-20793 92 6 aforementioned aforementione VERB ajst-20793 92 7 functions function NOUN ajst-20793 92 8 , , PUNCT ajst-20793 92 9 this this DET ajst-20793 92 10 function function NOUN ajst-20793 92 11 utilizes utilize VERB ajst-20793 92 12 the the DET ajst-20793 92 13 pandas panda NOUN ajst-20793 92 14 library library NOUN ajst-20793 92 15 's 's PART ajst-20793 92 16 api api NOUN ajst-20793 92 17 to to PART ajst-20793 92 18 retrieve retrieve VERB ajst-20793 92 19 data datum NOUN ajst-20793 92 20 from from ADP ajst-20793 92 21 the the DET ajst-20793 92 22 specified specify VERB ajst-20793 92 23 excel excel NOUN ajst-20793 92 24 file file NOUN ajst-20793 92 25 . . PUNCT ajst-20793 93 1 it it PRON ajst-20793 93 2 then then ADV ajst-20793 93 3 generates generate VERB ajst-20793 93 4 sql sql NOUN ajst-20793 93 5 input input NOUN ajst-20793 93 6 language language NOUN ajst-20793 93 7 suitable suitable ADJ ajst-20793 93 8 for for ADP ajst-20793 93 9 the the DET ajst-20793 93 10 access access NOUN ajst-20793 93 11 database database NOUN ajst-20793 93 12 , , PUNCT ajst-20793 93 13 executes execute VERB ajst-20793 93 14 the the DET ajst-20793 93 15 sql sql NOUN ajst-20793 93 16 input input NOUN ajst-20793 93 17 language language NOUN ajst-20793 93 18 , , PUNCT ajst-20793 93 19 and and CCONJ ajst-20793 93 20 imports import VERB ajst-20793 93 21 the the DET ajst-20793 93 22 data datum NOUN ajst-20793 93 23 into into ADP ajst-20793 93 24 the the DET ajst-20793 93 25 table table NOUN ajst-20793 93 26 selected select VERB ajst-20793 93 27 by by ADP ajst-20793 93 28 the the DET ajst-20793 93 29 user user NOUN ajst-20793 93 30 . . PUNCT ajst-20793 94 1 similarly similarly ADV ajst-20793 94 2 , , PUNCT ajst-20793 94 3 to to PART ajst-20793 94 4 enhance enhance VERB ajst-20793 94 5 interaction interaction NOUN ajst-20793 94 6 with with ADP ajst-20793 94 7 the the DET ajst-20793 94 8 user user NOUN ajst-20793 94 9 , , PUNCT ajst-20793 94 10 we we PRON ajst-20793 94 11 've have AUX ajst-20793 94 12 incorporated incorporate VERB ajst-20793 94 13 similar similar ADJ ajst-20793 94 14 interactive interactive ADJ ajst-20793 94 15 displays display NOUN ajst-20793 94 16 in in ADP ajst-20793 94 17 the the DET ajst-20793 94 18 import_from_excel import_from_excel PROPN ajst-20793 94 19 function function NOUN ajst-20793 94 20 , , PUNCT ajst-20793 94 21 including include VERB ajst-20793 94 22 a a DET ajst-20793 94 23 detection detection NOUN ajst-20793 94 24 mechanism mechanism NOUN ajst-20793 94 25 and and CCONJ ajst-20793 94 26 prompts prompt NOUN ajst-20793 94 27 upon upon SCONJ ajst-20793 94 28 completion completion NOUN ajst-20793 94 29 of of ADP ajst-20793 94 30 the the DET ajst-20793 94 31 import import NOUN ajst-20793 94 32 process process NOUN ajst-20793 94 33 . . PUNCT ajst-20793 95 1 with with ADP ajst-20793 95 2 this this PRON ajst-20793 95 3 , , PUNCT ajst-20793 95 4 all all DET ajst-20793 95 5 the the DET ajst-20793 95 6 functionality functionality NOUN ajst-20793 95 7 requirements requirement NOUN ajst-20793 95 8 of of ADP ajst-20793 95 9 the the DET ajst-20793 95 10 importapp importapp NOUN ajst-20793 95 11 class class NOUN ajst-20793 95 12 have have AUX ajst-20793 95 13 been be AUX ajst-20793 95 14 fulfilled fulfil VERB ajst-20793 95 15 , , PUNCT ajst-20793 95 16 and and CCONJ ajst-20793 95 17 the the DET ajst-20793 95 18 data datum NOUN ajst-20793 95 19 from from ADP ajst-20793 95 20 the the DET ajst-20793 95 21 specified specify VERB ajst-20793 95 22 excel excel NOUN ajst-20793 95 23 file file NOUN ajst-20793 95 24 has have AUX ajst-20793 95 25 been be AUX ajst-20793 95 26 successfully successfully ADV ajst-20793 95 27 imported import VERB ajst-20793 95 28 into into ADP ajst-20793 95 29 the the DET ajst-20793 95 30 table table NOUN ajst-20793 95 31 within within ADP ajst-20793 95 32 the the DET ajst-20793 95 33 user user NOUN ajst-20793 95 34 's 's PART ajst-20793 95 35 specified specify VERB ajst-20793 95 36 database database NOUN ajst-20793 95 37 . . PUNCT ajst-20793 96 1 figure figure NOUN ajst-20793 96 2 6 6 NUM ajst-20793 96 3 . . PUNCT ajst-20793 97 1 export export NOUN ajst-20793 97 2 gui gui PROPN ajst-20793 97 3 display display NOUN ajst-20793 97 4 105 105 NUM ajst-20793 97 5 3.4 3.4 NUM ajst-20793 97 6 . . PUNCT ajst-20793 98 1 program program NOUN ajst-20793 98 2 integration integration NOUN ajst-20793 98 3 finally finally ADV ajst-20793 98 4 , , PUNCT ajst-20793 98 5 combine combine VERB ajst-20793 98 6 the the DET ajst-20793 98 7 codes code NOUN ajst-20793 98 8 of of ADP ajst-20793 98 9 exportapp exportapp ADJ ajst-20793 98 10 and and CCONJ ajst-20793 98 11 importapp importapp NOUN ajst-20793 98 12 classes class NOUN ajst-20793 98 13 with with ADP ajst-20793 98 14 the the DET ajst-20793 98 15 previous previous ADJ ajst-20793 98 16 main main ADJ ajst-20793 98 17 function function NOUN ajst-20793 98 18 , , PUNCT ajst-20793 98 19 ensuring ensure VERB ajst-20793 98 20 to to PART ajst-20793 98 21 import import VERB ajst-20793 98 22 all all DET ajst-20793 98 23 the the DET ajst-20793 98 24 necessary necessary ADJ ajst-20793 98 25 libraries library NOUN ajst-20793 98 26 . . PUNCT ajst-20793 99 1 with with ADP ajst-20793 99 2 this this PRON ajst-20793 99 3 , , PUNCT ajst-20793 99 4 the the DET ajst-20793 99 5 entire entire ADJ ajst-20793 99 6 program program NOUN ajst-20793 99 7 design design NOUN ajst-20793 99 8 is be AUX ajst-20793 99 9 complete complete ADJ ajst-20793 99 10 . . PUNCT ajst-20793 100 1 the the DET ajst-20793 100 2 program program NOUN ajst-20793 100 3 can can AUX ajst-20793 100 4 be be AUX ajst-20793 100 5 executed execute VERB ajst-20793 100 6 by by ADP ajst-20793 100 7 running run VERB ajst-20793 100 8 the the DET ajst-20793 100 9 python python NOUN ajst-20793 100 10 file file NOUN ajst-20793 100 11 , , PUNCT ajst-20793 100 12 or or CCONJ ajst-20793 100 13 the the DET ajst-20793 100 14 code code NOUN ajst-20793 100 15 can can AUX ajst-20793 100 16 be be AUX ajst-20793 100 17 packaged package VERB ajst-20793 100 18 into into ADP ajst-20793 100 19 an an DET ajst-20793 100 20 * * ADJ ajst-20793 100 21 .exe .exe NOUN ajst-20793 100 22 file file NOUN ajst-20793 100 23 for for ADP ajst-20793 100 24 execution execution NOUN ajst-20793 100 25 . . PUNCT ajst-20793 101 1 import import NOUN ajst-20793 101 2     SPACE ajst-20793 101 3 os os PROPN ajst-20793 101 4     SPACE ajst-20793 101 5 import import NOUN ajst-20793 101 6     SPACE ajst-20793 101 7 pyodbc pyodbc PROPN ajst-20793 101 8     SPACE ajst-20793 101 9 import import NOUN ajst-20793 101 10     SPACE ajst-20793 101 11 pandas panda NOUN ajst-20793 101 12     SPACE ajst-20793 101 13 as as ADP ajst-20793 101 14     SPACE ajst-20793 101 15 pd pd NOUN ajst-20793 101 16     SPACE ajst-20793 101 17 from from ADP ajst-20793 101 18     SPACE ajst-20793 101 19 tkinter tkinter NOUN ajst-20793 101 20     SPACE ajst-20793 101 21 import import NOUN ajst-20793 101 22     SPACE ajst-20793 101 23 filedialog filedialog PROPN ajst-20793 101 24 , , PUNCT ajst-20793 101 25     SPACE ajst-20793 101 26 tk tk PROPN ajst-20793 101 27 , , PUNCT ajst-20793 101 28     SPACE ajst-20793 101 29 label label NOUN ajst-20793 101 30 , , PUNCT ajst-20793 101 31     SPACE ajst-20793 101 32 button button NOUN ajst-20793 101 33 , , PUNCT ajst-20793 101 34     SPACE ajst-20793 101 35 stringvar stringvar NOUN ajst-20793 101 36 , , PUNCT ajst-20793 101 37     SPACE ajst-20793 101 38 entry entry NOUN ajst-20793 101 39 , , PUNCT ajst-20793 101 40     SPACE ajst-20793 101 41 text text NOUN ajst-20793 101 42     SPACE ajst-20793 101 43 from from ADP ajst-20793 101 44     SPACE ajst-20793 101 45 tkinter.ttk tkinter.ttk PROPN ajst-20793 101 46     SPACE ajst-20793 101 47 import import NOUN ajst-20793 101 48     SPACE ajst-20793 101 49 combobox combobox NOUN ajst-20793 101 50 , , PUNCT ajst-20793 101 51     SPACE ajst-20793 101 52 notebook notebook NOUN ajst-20793 101 53 , , PUNCT ajst-20793 101 54     SPACE ajst-20793 101 55 frame frame NOUN ajst-20793 101 56     SPACE ajst-20793 101 57 from from ADP ajst-20793 101 58     SPACE ajst-20793 101 59 datetime datetime NOUN ajst-20793 101 60     SPACE ajst-20793 101 61 import import NOUN ajst-20793 101 62     SPACE ajst-20793 101 63 datetime datetime ADJ ajst-20793 101 64 figure figure NOUN ajst-20793 101 65 7 7 NUM ajst-20793 101 66 . . PUNCT ajst-20793 101 67 dependency dependency NOUN ajst-20793 101 68 on on ADP ajst-20793 101 69 libraries library NOUN ajst-20793 101 70 in in ADP ajst-20793 101 71 the the DET ajst-20793 101 72 import import NOUN ajst-20793 101 73 program program NOUN ajst-20793 101 74 4 4 NUM ajst-20793 101 75 . . PUNCT ajst-20793 101 76 conclusion conclusion NOUN ajst-20793 101 77 this this DET ajst-20793 101 78 project project NOUN ajst-20793 101 79 implements implement VERB ajst-20793 101 80 a a DET ajst-20793 101 81 simple simple ADJ ajst-20793 101 82 yet yet CCONJ ajst-20793 101 83 fully fully ADV ajst-20793 101 84 functional functional ADJ ajst-20793 101 85 database database NOUN ajst-20793 101 86 management management NOUN ajst-20793 101 87 process process NOUN ajst-20793 101 88 using use VERB ajst-20793 101 89 python python NOUN ajst-20793 101 90 programs program NOUN ajst-20793 101 91 and and CCONJ ajst-20793 101 92 excel excel NOUN ajst-20793 101 93 software software NOUN ajst-20793 101 94 . . PUNCT ajst-20793 102 1 it it PRON ajst-20793 102 2 greatly greatly ADV ajst-20793 102 3 reduces reduce VERB ajst-20793 102 4 the the DET ajst-20793 102 5 learning learning NOUN ajst-20793 102 6 curve curve NOUN ajst-20793 102 7 and and CCONJ ajst-20793 102 8 technical technical ADJ ajst-20793 102 9 requirements requirement NOUN ajst-20793 102 10 for for ADP ajst-20793 102 11 users user NOUN ajst-20793 102 12 in in ADP ajst-20793 102 13 database database NOUN ajst-20793 102 14 management management NOUN ajst-20793 102 15 . . PUNCT ajst-20793 103 1 additionally additionally ADV ajst-20793 103 2 , , PUNCT ajst-20793 103 3 it it PRON ajst-20793 103 4 provides provide VERB ajst-20793 103 5 readers reader NOUN ajst-20793 103 6 with with ADP ajst-20793 103 7 an an DET ajst-20793 103 8 understanding understanding NOUN ajst-20793 103 9 of of ADP ajst-20793 103 10 python python NOUN ajst-20793 103 11 language language NOUN ajst-20793 103 12 programming programming NOUN ajst-20793 103 13 and and CCONJ ajst-20793 103 14 its its PRON ajst-20793 103 15 rich rich ADJ ajst-20793 103 16 array array NOUN ajst-20793 103 17 of of ADP ajst-20793 103 18 thirdparty thirdparty NOUN ajst-20793 103 19 libraries library NOUN ajst-20793 103 20 and and CCONJ ajst-20793 103 21 tools tool NOUN ajst-20793 103 22 , , PUNCT ajst-20793 103 23 making make VERB ajst-20793 103 24 it it PRON ajst-20793 103 25 particularly particularly ADV ajst-20793 103 26 suitable suitable ADJ ajst-20793 103 27 for for ADP ajst-20793 103 28 small small ADJ ajst-20793 103 29 and and CCONJ ajst-20793 103 30 medium medium ADJ ajst-20793 103 31 - - PUNCT ajst-20793 103 32 sized sized ADJ ajst-20793 103 33 enterprises enterprise NOUN ajst-20793 103 34 and and CCONJ ajst-20793 103 35 individual individual ADJ ajst-20793 103 36 users user NOUN ajst-20793 103 37 with with ADP ajst-20793 103 38 limited limited ADJ ajst-20793 103 39 budgets budget NOUN ajst-20793 103 40 . . PUNCT ajst-20793 104 1 however however ADV ajst-20793 104 2 , , PUNCT ajst-20793 104 3 there there PRON ajst-20793 104 4 are be VERB ajst-20793 104 5 areas area NOUN ajst-20793 104 6 where where SCONJ ajst-20793 104 7 the the DET ajst-20793 104 8 program program NOUN ajst-20793 104 9 can can AUX ajst-20793 104 10 be be AUX ajst-20793 104 11 improved improve VERB ajst-20793 104 12 and and CCONJ ajst-20793 104 13 enhanced enhance VERB ajst-20793 104 14 , , PUNCT ajst-20793 104 15 such such ADJ ajst-20793 104 16 as as ADP ajst-20793 104 17 supporting support VERB ajst-20793 104 18 operations operation NOUN ajst-20793 104 19 on on ADP ajst-20793 104 20 more more ADJ ajst-20793 104 21 database database NOUN ajst-20793 104 22 types type NOUN ajst-20793 104 23 and and CCONJ ajst-20793 104 24 optimizing optimize VERB ajst-20793 104 25 user user NOUN ajst-20793 104 26 interface interface NOUN ajst-20793 104 27 design design NOUN ajst-20793 104 28 . . PUNCT ajst-20793 105 1 references reference NOUN ajst-20793 105 2 [ [ X ajst-20793 105 3 1 1 NUM ajst-20793 105 4 ] ] X ajst-20793 105 5 lemahieu lemahieu PROPN ajst-20793 105 6 , , PUNCT ajst-20793 105 7 w. w. PROPN ajst-20793 105 8 , , PUNCT ajst-20793 105 9 vanden vanden PROPN ajst-20793 105 10 broucke broucke PROPN ajst-20793 105 11 , , PUNCT ajst-20793 105 12 s. s. PROPN ajst-20793 105 13 , , PUNCT ajst-20793 105 14 & & CCONJ ajst-20793 105 15 baesens baesens PROPN ajst-20793 105 16 , , PUNCT ajst-20793 105 17 b. b. PROPN ajst-20793 105 18 ( ( PUNCT ajst-20793 105 19 2018 2018 NUM ajst-20793 105 20 ) ) PUNCT ajst-20793 105 21 . . PUNCT ajst-20793 106 1 principles principle NOUN ajst-20793 106 2 of of ADP ajst-20793 106 3 database database NOUN ajst-20793 106 4 management management NOUN ajst-20793 106 5 : : PUNCT ajst-20793 106 6 the the DET ajst-20793 106 7 practical practical ADJ ajst-20793 106 8 guide guide NOUN ajst-20793 106 9 to to ADP ajst-20793 106 10 storing store VERB ajst-20793 106 11 , , PUNCT ajst-20793 106 12 managing manage VERB ajst-20793 106 13 and and CCONJ ajst-20793 106 14 analyzing analyze VERB ajst-20793 106 15 big big ADJ ajst-20793 106 16 and and CCONJ ajst-20793 106 17 small small ADJ ajst-20793 106 18 data datum NOUN ajst-20793 106 19 . . PUNCT ajst-20793 107 1 cambridge cambridge PROPN ajst-20793 107 2 university university PROPN ajst-20793 107 3 press press NOUN ajst-20793 107 4 . . PUNCT ajst-20793 108 1 [ [ X ajst-20793 108 2 2 2 NUM ajst-20793 108 3 ] ] X ajst-20793 108 4 ghiani ghiani PROPN ajst-20793 108 5 , , PUNCT ajst-20793 108 6 g. g. PROPN ajst-20793 108 7 , , PUNCT ajst-20793 108 8 laporte laporte NOUN ajst-20793 108 9 , , PUNCT ajst-20793 108 10 g. g. PROPN ajst-20793 108 11 , , PUNCT ajst-20793 108 12 & & CCONJ ajst-20793 108 13 musmanno musmanno PROPN ajst-20793 108 14 , , PUNCT ajst-20793 108 15 r. r. PROPN ajst-20793 108 16 ( ( PUNCT ajst-20793 108 17 2022 2022 NUM ajst-20793 108 18 ) ) PUNCT ajst-20793 108 19 . . PUNCT ajst-20793 109 1 introduction introduction NOUN ajst-20793 109 2 to to ADP ajst-20793 109 3 logistics logistic NOUN ajst-20793 109 4 systems system NOUN ajst-20793 109 5 management management NOUN ajst-20793 109 6 : : PUNCT ajst-20793 109 7 with with ADP ajst-20793 109 8 microsoft microsoft PROPN ajst-20793 109 9 excel excel PROPN ajst-20793 109 10 and and CCONJ ajst-20793 109 11 python python NOUN ajst-20793 109 12 examples example NOUN ajst-20793 109 13 . . PUNCT ajst-20793 110 1 john john PROPN ajst-20793 110 2 wiley wiley PROPN ajst-20793 110 3 & & CCONJ ajst-20793 110 4 sons son NOUN ajst-20793 110 5 . . PUNCT ajst-20793 111 1 [ [ X ajst-20793 111 2 3 3 NUM ajst-20793 111 3 ] ] X ajst-20793 111 4 suraya suraya PROPN ajst-20793 111 5 , , PUNCT ajst-20793 111 6 s. s. PROPN ajst-20793 111 7 , , PUNCT ajst-20793 111 8 & & CCONJ ajst-20793 111 9 sholeh sholeh PROPN ajst-20793 111 10 , , PUNCT ajst-20793 111 11 m. m. NOUN ajst-20793 111 12 ( ( PUNCT ajst-20793 111 13 2022 2022 NUM ajst-20793 111 14 ) ) PUNCT ajst-20793 111 15 . . PUNCT ajst-20793 112 1 designing design VERB ajst-20793 112 2 and and CCONJ ajst-20793 112 3 implementing implement VERB ajst-20793 112 4 a a DET ajst-20793 112 5 database database NOUN ajst-20793 112 6 for for ADP ajst-20793 112 7 thesis thesis NOUN ajst-20793 112 8 data datum NOUN ajst-20793 112 9 management management NOUN ajst-20793 112 10 by by ADP ajst-20793 112 11 using use VERB ajst-20793 112 12 the the DET ajst-20793 112 13 python python NOUN ajst-20793 112 14 flask flask NOUN ajst-20793 112 15 framework framework NOUN ajst-20793 112 16 . . PUNCT ajst-20793 113 1 international international ADJ ajst-20793 113 2 journal journal PROPN ajst-20793 113 3 of of ADP ajst-20793 113 4 engineering engineering NOUN ajst-20793 113 5 , , PUNCT ajst-20793 113 6 science science NOUN ajst-20793 113 7 and and CCONJ ajst-20793 113 8 information information NOUN ajst-20793 113 9 technology technology NOUN ajst-20793 113 10 , , PUNCT ajst-20793 113 11 2(1 2(1 NUM ajst-20793 113 12 ) ) PUNCT ajst-20793 113 13 , , PUNCT ajst-20793 113 14 9 9 NUM ajst-20793 113 15 - - SYM ajst-20793 113 16 14 14 NUM ajst-20793 113 17 . . PUNCT ajst-20793 114 1 [ [ X ajst-20793 114 2 4 4 NUM ajst-20793 114 3 ] ] X ajst-20793 114 4 toman toman PROPN ajst-20793 114 5 , , PUNCT ajst-20793 114 6 s. s. PROPN ajst-20793 114 7 ( ( PUNCT ajst-20793 114 8 2021 2021 NUM ajst-20793 114 9 ) ) PUNCT ajst-20793 114 10 . . PUNCT ajst-20793 115 1 web web NOUN ajst-20793 115 2 application application NOUN ajst-20793 115 3 for for ADP ajst-20793 115 4 data datum NOUN ajst-20793 115 5 import import NOUN ajst-20793 115 6 from from ADP ajst-20793 115 7 xlsx xlsx PROPN ajst-20793 115 8 into into ADP ajst-20793 115 9 a a DET ajst-20793 115 10 relational relational ADJ ajst-20793 115 11 database database NOUN ajst-20793 115 12 . . PUNCT ajst-20793 116 1 [ [ X ajst-20793 116 2 5 5 NUM ajst-20793 116 3 ] ] X ajst-20793 116 4 lindstrom lindstrom PROPN ajst-20793 116 5 , , PUNCT ajst-20793 116 6 g. g. PROPN ajst-20793 116 7 ( ( PUNCT ajst-20793 116 8 2005 2005 NUM ajst-20793 116 9 ) ) PUNCT ajst-20793 116 10 . . PUNCT ajst-20793 117 1 programming program VERB ajst-20793 117 2 with with ADP ajst-20793 117 3 python python PROPN ajst-20793 117 4 . . PUNCT ajst-20793 118 1 it it PRON ajst-20793 118 2 professional professional ADJ ajst-20793 118 3 , , PUNCT ajst-20793 118 4 7(5 7(5 NUM ajst-20793 118 5 ) ) PUNCT ajst-20793 118 6 , , PUNCT ajst-20793 118 7 10 10 NUM ajst-20793 118 8 - - SYM ajst-20793 118 9 16 16 NUM ajst-20793 118 10 . . PUNCT