Commit message (Collapse) | Author | Age | Files | Lines | |
---|---|---|---|---|---|
* | fixed issue with not writing header to master - needed to AddRowAtIndex() | Matthew Lemon | 2020-08-02 | 1 | -2/+2 |
| | |||||
* | still cant get first row to write | Matthew Lemon | 2020-08-02 | 1 | -12/+19 |
| | |||||
* | not writing top line to master yet | Matthew Lemon | 2020-08-01 | 2 | -18/+31 |
| | |||||
* | tidying linting and checker errors | Matthew Lemon | 2020-08-01 | 5 | -6/+13 |
| | |||||
* | fixed extraneous variable | Matthew Lemon | 2020-08-01 | 2 | -29/+6 |
| | |||||
* | tidying errors | Matthew Lemon | 2020-08-01 | 1 | -7/+7 |
| | |||||
* | better error handling | Matthew Lemon | 2020-08-01 | 1 | -5/+9 |
| | |||||
* | tweaked | Matthew Lemon | 2020-08-01 | 1 | -1/+0 |
| | |||||
* | now added the column of keys to the master | Matthew Lemon | 2020-08-01 | 1 | -1/+1 |
| | |||||
* | first very rough writing of the datamap from the database - VERY ROUGH | Matthew Lemon | 2020-08-01 | 1 | -10/+37 |
| | |||||
* | getting there with writing the mater | Matthew Lemon | 2020-08-01 | 2 | -5/+51 |
| | |||||
* | fixed test and remove prepare | Matthew Lemon | 2020-08-01 | 2 | -9/+7 |
| | |||||
* | writing sql code and not enjoying it | Matthew Lemon | 2020-07-31 | 1 | -3/+47 |
| | |||||
* | added comment on SQL | Matthew Lemon | 2020-07-31 | 1 | -0/+4 |
| | |||||
* | starting writing the code for master writer | Matthew Lemon | 2020-07-31 | 3 | -8/+103 |
| | |||||
* | upgrade to tealeg.xlsx v3.2.0 - goodbye to coords! | Matthew Lemon | 2020-07-31 | 2 | -25/+40 |
| | |||||
* | added comments | Matthew Lemon | 2020-07-29 | 1 | -0/+8 |
| | |||||
* | testing all the spreadsheets now | Matthew Lemon | 2020-07-29 | 4 | -14/+44 |
| | |||||
* | test for ImportToDB | Matthew Lemon | 2020-07-29 | 1 | -3/+54 |
| | |||||
* | removed short dir in testdata | Matthew Lemon | 2020-07-29 | 5 | -3/+3 |
| | |||||
* | more tests | Matthew Lemon | 2020-07-29 | 3 | -17/+58 |
| | |||||
* | first new test on database import - testing one cell value | Matthew Lemon | 2020-07-29 | 1 | -7/+33 |
| | |||||
* | added setup and teardown funcs | Matthew Lemon | 2020-07-29 | 1 | -15/+35 |
| | |||||
* | chasing golint | Matthew Lemon | 2020-07-28 | 3 | -25/+27 |
| | |||||
* | tidying and linting | Matthew Lemon | 2020-07-28 | 2 | -18/+18 |
| | |||||
* | tidying | Matthew Lemon | 2020-07-28 | 3 | -10/+16 |
| | |||||
* | fixed bug whereby the program would crash on importing even when no required ↵ | Matthew Lemon | 2020-07-28 | 1 | -2/+4 |
| | | | | datamap present | ||||
* | added filename into return_data table | Matthew Lemon | 2020-07-28 | 2 | -2/+10 |
| | |||||
* | I think I fixed the bug whereby multiple returns where created | Matthew Lemon | 2020-07-28 | 1 | -11/+25 |
| | |||||
* | removed old lock file | Matthew Lemon | 2020-07-28 | 1 | -1/+0 |
| | |||||
* | updated README with working JOIN SQL statement | Matthew Lemon | 2020-07-28 | 1 | -0/+5 |
| | |||||
* | updated Makefile | Matthew Lemon | 2020-07-28 | 1 | -0/+3 |
| | |||||
* | enhanced the Makefile | Matthew Lemon | 2020-07-28 | 1 | -0/+15 |
| | |||||
* | removed UNIQUE which didnt make sense after consideration | Matthew Lemon | 2020-07-28 | 1 | -3/+2 |
| | |||||
* | reworked algorithm tha creates extractedData maps to allow the datamap sheet ↵ | Matthew Lemon | 2020-07-28 | 2 | -12/+5 |
| | | | | sequence to be any order | ||||
* | working on failing test where dm not work when sheets not sequential - added ↵ | Matthew Lemon | 2020-07-28 | 10 | -4/+10 |
| | | | | Makefile | ||||
* | UNIQUE constrait on return.name implemented | Matthew Lemon | 2020-07-28 | 1 | -6/+7 |
| | |||||
* | fixed bug where return.id was being left out of return_data row insert | Matthew Lemon | 2020-07-28 | 1 | -2/+2 |
| | |||||
* | better importing to database from populated sheet | Matthew Lemon | 2020-07-28 | 2 | -3/+3 |
| | |||||
* | fixing a bug in ExtractDBDatamap and still working on data import code | Matthew Lemon | 2020-07-27 | 6 | -4/+52 |
| | |||||
* | partially through writing code for commiting extracted data to the database | Matthew Lemon | 2020-07-27 | 1 | -1/+30 |
| | |||||
* | Proof of concept code hard-coded here shows that we can get value from | Matthew Lemon | 2020-07-27 | 1 | -1/+20 |
| | | | | | | | | xlsx file ./datamaps import --returnname "Hunkers" --datamapname "Unnamed Datamap" --xlsxpath ~/Desktop/ -returnname is being ignored here - key is xlsxpath and datamapname returns hardcoded query for Introduction sheet cell C17 | ||||
* | ready to write the code to import extraced XLSX data into database now | Matthew Lemon | 2020-07-27 | 1 | -1/+5 |
| | |||||
* | now we find xlsm files as well seemingly | Matthew Lemon | 2020-07-27 | 3 | -3/+6 |
| | |||||
* | testing func to get xlsx files from dir | Matthew Lemon | 2020-07-27 | 3 | -30/+34 |
| | |||||
* | a lot of working building the new import command in main | Matthew Lemon | 2020-07-27 | 4 | -11/+71 |
| | |||||
* | type in schema | Matthew Lemon | 2020-07-27 | 1 | -3/+7 |
| | |||||
* | improved defers | Matthew Lemon | 2020-07-27 | 3 | -5/+38 |
| | |||||
* | added a README - starting with SQL snippets | Matthew Lemon | 2020-07-26 | 1 | -0/+7 |
| | |||||
* | more hiding | Matthew Lemon | 2020-07-26 | 1 | -9/+9 |
| |