Convert excel spreadsheet to sql file into GigaDB database
The folder uploadDir stores spreadsheet which prepare to import into database.
The folder dataDir stores all spreadsheets which already imported into database.
The folder logFile stores all datasets import log including error log (if you want to debug it).
The folder sqlFile stores all datasets import sql files.
The folder configuration stores all parameters including database setting, validation setting, file-format setting etc.
The lib stores all jar packages which used in this project.
/configuration/setting.xml set the databaseUrl, databaseUsername, databasePassword
Make sure /uploadDir folder has the spreadsheet. e.g. 100670newversion.xls
Run /src/Main.java
Check the log file and dataDir to see whether it was successful uploaded.