initial POM setup and DB script files for adding in a MySQL DB to pull info from an ancient version of MS Access (one old enough that I can't open the .MDB file in Access 2010); however Open Office will read the file and I can export the data to CSV from there; hence all of the work to pump CSVs into a MySQL DB
adding data directory to .gitignore
- added import for SQL tables needed for the Shepherd's Staff program; this is so I can run a diff on the missing data and then create a CSV import for the missing data
- fixed some type definitions
- added some column comments
- added SQL used to pull out of ChurchWindows (CW) and Shepherd's Staff (SS) DB, into the CSV format needed for the Silver Migration package for Church Community Builder (CCB).
- fixed some NULL problems on import from CSV files.
- fixed location of file to be a local reference; probably should fix the build to copy to the remote directory 1st; but not necessary since this is simply a sample project
- removed files; since we won't be exporting these into their own DB schema; instead we will be pulling the raw data directly from the MS Access DB into the uploaded file format
messed with the pom.xml configuration; tried to get two flyway instances to work, but punted on that due to spending too much time on weird errors; instead just added in some default configuration values; so it's more obvious as to what is occurring
- fixed imports so that '' is NULL for all of the files
- added view that combines both the CW and SS datasets into a single individuals files
- added scripts to create raw data files in the CCB format for CW and SS (these are then dumped back into the DB for a final dedup / merging of the data)
- removed setting of campus name (this will be done in final export)
- fixed a logic error causing duplicates to appear in the SS export
- added files for how to pull out the CW data
- correct some data integrity on import
- adjusted how the family_id and individual_id fields are being pulled back for those records in the church windows file
- moved to migration directory so they are automatically applied
- correctly different names in the chart of accounts to be consistent for SS and CW
- corrected date format
- corrected how the chart of accounts was captured due to different naming conventions in SS vs CW
- converted BOOLEAN to Yes/No for final data migration output
Merge branch 'release/1.0.0'