Fatma Saafan 4e68e03ebbc add pme data to the database 26 Apr 2024 FeyzaSakin 171b6eb3dcd '_format_ecap' is modified to set year to current year when the data's month in the current year ended or set it to the previous year if the data's month in the current year didn't end year. Ecap data is re-added with the newer '_format_ecap'. 13 Apr 2024 Fatma Saafan b94a1c856d1 update Readme file 22 Mar 2024 Fatma Saafan 92b13da602d update Readme.md file 22 Mar 2024 Fatma Saafan a590113756e update poster and abstract 22 Mar 2024 Fatma Saafan ca365a7fcf0 add status report 3-22-24 22 Mar 2024 Fatma Saafan 0565472cae0 add a file that has a link to Bitbucket repo 22 Mar 2024 Fatma Saafan bb96b74c8bf update design files 22 Mar 2024 Fatma Saafan b4a5550b05d update documentation 22 Mar 2024 aiman-hanif d91e2179afe deleted unnecessary filter output files 21 Mar 2024 aiman-hanif da3815c6ea9 checked all commands 21 Mar 2024 Fatma Saafan 4b037af7b73 add pme (missed dir) to METRIC_TYPES 21 Mar 2024 FeyzaSakin c0b1742cc4c In the cmd_filter-database.py command, the spelling for 'sucess' is changed. The workflow file is modified and renamed as 'README_instructions.qmd'. The workflow folder is moved to the capstone's root directory and renamed to 'instructions'. 21 Mar 2024 aiman-hanif 9d4a69dae2e deleted unnecessary commands clean_convert_to_csv dump_table_to_csv clean_folder 21 Mar 2024 aiman-hanif db015f398f2 deleted unnecessary folders: added data, reports, oldsrc, working 21 Mar 2024 FeyzaSakin b99d207a42c The workflow chart's data is modified for PME and ECap to 'Electric Interval Data (PME)' and 'Utility Bill Data (ECap)' 19 Mar 2024 Fatma Saafan 8785c2486bc Modify _main.py to include check command. 19 Mar 2024 Fatma Saafan 3fc8b5bb860 create check.py to verify installation of Python3, SQLite3, and pandas. 19 Mar 2024 FeyzaSakin 18519894238 Created the .dist folder in the 'tools' directory and commented 'dist/' in the .gitignore to add the dist folder 16 Mar 2024 FeyzaSakin 4cf79b1daeb Status report files are modfied for the week 8 15 Mar 2024 aiman-hanif 5bf5bfd6e91 changed the logic of add_new_files_to_database so it should now work with metric as an optional argument and looks for files to add in all subdirectories; also updated workflow doc 15 Mar 2024 FeyzaSakin 0828d6cfec0 In the workflow docs, the period for the 'fcltls plot' instruction is deleted 14 Mar 2024 FeyzaSakin 4ce75c9c49d To workflow docs and the workflow chart, 'fcltls plot' details are added. In the filter command comment, the 'filter' instruction is changed to 'columns' 14 Mar 2024 Nathan Goehring 3ae57232e1a added plotting 12 Mar 2024 Fatma Saafan fb52a987f96 update status report table (week 8) 11 Mar 2024 Fatma Saafan e61cb218582 add 3 new files to Data folder (Dominion-PME-Waterscope) 11 Mar 2024 aiman-hanif 1003a1e006b updated work flow chat in wordflow.qmd 01 Mar 2024 aiman-hanif 79864b3b9a5 updates 01 Mar 2024 aiman-hanif d9cbe50c8f0 updated help 01 Mar 2024 aiman-hanif 679095332ae M resolve merge conflicts 01 Mar 2024 aiman-hanif 04086d4909d updates 01 Mar 2024 aiman-hanif 18a1321f350 cleaned up filter-database and updated workflow.qmd 01 Mar 2024 Nathan Goehring 6c0340636ff help messages 01 Mar 2024 FeyzaSakin e0de16da865 Added a line to worklflow.qmd on turning the qmd into a html 29 Feb 2024 FeyzaSakin 0c430c4a7b2 Worklow.qmd is added to tools/src/workflow. Readme files are modified for W7 - 02/29. 29 Feb 2024 Fatma Saafan 1d2af3aa636 update reset to include updating scanned_files table in db and communicating better with user 29 Feb 2024 Fatma Saafan 9eeed9e8feb update documentation for scan code 29 Feb 2024 Fatma Saafan 33bd3f3fe55 correct db name in scan file 29 Feb 2024 Fatma Saafan d3b6eea74b8 update scan-for-new-files to print a correct warning message 29 Feb 2024 Fatma Saafan 1c75b314740 add documentation to utils.py 28 Feb 2024 Fatma Saafan dadc1a6905d update scan code to use current folder as path, print a warning msg if necessary, and import get_list from utils.py 28 Feb 2024 Fatma Saafan d747d002186 update utils.py to import sqlite3 and add get_list_of_already_scanned(metric) function 28 Feb 2024 Fatma Saafan 24abcbab144 remove printing exisiting files in db message from scan code 28 Feb 2024 aiman-hanif bec98c3733c simplified the logic for add-new-files-to-database 27 Feb 2024 aiman-hanif 4fadb5097d8 updated the filter command so it allows for all the columns in the database to be used as a filter + added comments to code 27 Feb 2024 FeyzaSakin 032c7cd9793 A line from the previous version of the code is added 27 Feb 2024 FeyzaSakin 2a2e3724be4 Formatting codes for dominion, pme, and ecap are modified. Datetime values are saved under record_time column and time values are added to ecap and dominion 27 Feb 2024 aiman-hanif 71200a00525 corrected errors in filter command 27 Feb 2024 aiman-hanif 1978cde5241 M updated files 27 Feb 2024 aiman-hanif 48f5f8112fc updated add-new-files-to-database, added the filter-database command, modified formatting for the data 27 Feb 2024