aboutsummaryrefslogtreecommitdiffstats
Commit message (Collapse)AuthorAgeFilesLines
* fixed issue with not writing header to master - needed to AddRowAtIndex()Matthew Lemon2020-08-021-2/+2
|
* still cant get first row to writeMatthew Lemon2020-08-021-12/+19
|
* not writing top line to master yetMatthew Lemon2020-08-012-18/+31
|
* tidying linting and checker errorsMatthew Lemon2020-08-015-6/+13
|
* fixed extraneous variableMatthew Lemon2020-08-012-29/+6
|
* tidying errorsMatthew Lemon2020-08-011-7/+7
|
* better error handlingMatthew Lemon2020-08-011-5/+9
|
* tweakedMatthew Lemon2020-08-011-1/+0
|
* now added the column of keys to the masterMatthew Lemon2020-08-011-1/+1
|
* first very rough writing of the datamap from the database - VERY ROUGHMatthew Lemon2020-08-011-10/+37
|
* getting there with writing the materMatthew Lemon2020-08-012-5/+51
|
* fixed test and remove prepareMatthew Lemon2020-08-012-9/+7
|
* writing sql code and not enjoying itMatthew Lemon2020-07-311-3/+47
|
* added comment on SQLMatthew Lemon2020-07-311-0/+4
|
* starting writing the code for master writerMatthew Lemon2020-07-313-8/+103
|
* upgrade to tealeg.xlsx v3.2.0 - goodbye to coords!Matthew Lemon2020-07-312-25/+40
|
* added commentsMatthew Lemon2020-07-291-0/+8
|
* testing all the spreadsheets nowMatthew Lemon2020-07-294-14/+44
|
* test for ImportToDBMatthew Lemon2020-07-291-3/+54
|
* removed short dir in testdataMatthew Lemon2020-07-295-3/+3
|
* more testsMatthew Lemon2020-07-293-17/+58
|
* first new test on database import - testing one cell valueMatthew Lemon2020-07-291-7/+33
|
* added setup and teardown funcsMatthew Lemon2020-07-291-15/+35
|
* chasing golintMatthew Lemon2020-07-283-25/+27
|
* tidying and lintingMatthew Lemon2020-07-282-18/+18
|
* tidyingMatthew Lemon2020-07-283-10/+16
|
* fixed bug whereby the program would crash on importing even when no required ↵Matthew Lemon2020-07-281-2/+4
| | | | datamap present
* added filename into return_data tableMatthew Lemon2020-07-282-2/+10
|
* I think I fixed the bug whereby multiple returns where createdMatthew Lemon2020-07-281-11/+25
|
* removed old lock fileMatthew Lemon2020-07-281-1/+0
|
* updated README with working JOIN SQL statementMatthew Lemon2020-07-281-0/+5
|
* updated MakefileMatthew Lemon2020-07-281-0/+3
|
* enhanced the MakefileMatthew Lemon2020-07-281-0/+15
|
* removed UNIQUE which didnt make sense after considerationMatthew Lemon2020-07-281-3/+2
|
* reworked algorithm tha creates extractedData maps to allow the datamap sheet ↵Matthew Lemon2020-07-282-12/+5
| | | | sequence to be any order
* working on failing test where dm not work when sheets not sequential - added ↵Matthew Lemon2020-07-2810-4/+10
| | | | Makefile
* UNIQUE constrait on return.name implementedMatthew Lemon2020-07-281-6/+7
|
* fixed bug where return.id was being left out of return_data row insertMatthew Lemon2020-07-281-2/+2
|
* better importing to database from populated sheetMatthew Lemon2020-07-282-3/+3
|
* fixing a bug in ExtractDBDatamap and still working on data import codeMatthew Lemon2020-07-276-4/+52
|
* partially through writing code for commiting extracted data to the databaseMatthew Lemon2020-07-271-1/+30
|
* Proof of concept code hard-coded here shows that we can get value fromMatthew Lemon2020-07-271-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 nowMatthew Lemon2020-07-271-1/+5
|
* now we find xlsm files as well seeminglyMatthew Lemon2020-07-273-3/+6
|
* testing func to get xlsx files from dirMatthew Lemon2020-07-273-30/+34
|
* a lot of working building the new import command in mainMatthew Lemon2020-07-274-11/+71
|
* type in schemaMatthew Lemon2020-07-271-3/+7
|
* improved defersMatthew Lemon2020-07-273-5/+38
|
* added a README - starting with SQL snippetsMatthew Lemon2020-07-261-0/+7
|
* more hidingMatthew Lemon2020-07-261-9/+9
|