Pentaho Data Integration (Kettle)

http://ithelp.ithome.com.tw/articles/10186567

Logback

https://examples.javacodegeeks.com/enterprise-java/logback/logback-file-appender-example-2/

https://stackoverflow.com/questions/2488558/logback-to-log-different-messages-to-two-files

UI/UX process

https://blog.akanelee.me/posts/278602-ux-is-not-a-wireframe/

https://blog.akanelee.me/posts/686437-ui-design-process/

IOT

https://villesmartblog.wordpress.com/2016/11/29/iot-%E5%B8%B8%E7%94%A8%E7%9A%84%E5%82%B3%E8%BC%B8%E5%8D%94%E5%AE%9A%E4%BB%8B%E7%B4%B9/

JBOSS 教學

http://jbosstut-christina.rhcloud.com/archives/category/jboss-%E6%95%99%E5%AD%B8

The road ahead for WebLogic 12c

http://biemond.blogspot.tw/2013/10/the-road-ahead-for-weblogic-12c.html

Pollexsurvey data creation

1. Create data with excel template

2. Copy & paste to SQL Server Managment studio

3. Insert into local mysql database (Link server need to be configured in advance)
INSERT OPENQUERY(MYSQLLOCAL,'SELECT * FROM pollexsurvey.pls_respondent') SELECT * FROM pls_respondent WHERE uid > 4280;
INSERT OPENQUERY(MYSQLLOCAL,'SELECT * FROM pollexsurvey.pls_respondent_role') SELECT * FROM pls_respondent_role WHERE respondent_uid >  4280;
INSERT OPENQUERY(MYSQLLOCAL,'SELECT * FROM pollexsurvey.pls_respondentdetail_extsat2017') SELECT * FROM pls_respondentdetail_extsat2017 WHERE uid >  4280;

4. Delete data of earlier batches
delete from pollexsurvey.pls_respondent WHERE uid <=4280;
delete from pollexsurvey.pls_respondentdetail_extsat2017 WHERE uid <=4280;
delete from pollexsurvey.pls_respondent_role WHERE respondent_uid <=4280;

select count(*) from pollexsurvey.pls_respondent;
select count(*) from pollexsurvey.pls_respondentdetail_extsat2017;
select count(*) from pollexsurvey.pls_respondent_role;

5. Export the SQL