Sunday, 7 April 2019

Colored List in Trello


What is Trello??
Trello is a project management tool that makes team collaboration easier and it's free!!
Check out Trello at https://trello.com/

Although it's free, there is some limitation in Trello and one of them is we can't change the list color.
After googling a little bit, I found out that we can modify our Trello board by using CSS Injector browser extension. I personally use a Chrome extension called "CSS and Javascript Injection"

To add Chrome Extension, click the three dots icon on the right top of your Chrome, select More tools | Extensions - select Get more extensions, then select the extension that you'd like to use.

If you use the same extension as me, then a syringe icon will be displayed on the right top of your Chrome, simply click the icon and a css and js editor will be displayed.



Add the css below to the css editor to change the color of the list title and display stickers in background so that cards with sticker don't take a lot of space on the board.

.list-header-num-cards {
    color: rgba(255,255,255,0.6);
    font-size: 12px;
}

/* Colorize the headers of each column. Add more as needed. */
.js-list:nth-child(2) .js-list-header {
    background: rgb(230,0,0);
}

.js-list:nth-child(3) .js-list-header {
    background: rgb(264,204,95);
}

.js-list:nth-child(4) .js-list-header {
    background: rgb(100,200,210);
}

/* Set list to background*/
.sticker .sticker-remove-image{
    z-index: -0.5; 
}

/* Use a different background color for cards with sticker 
and set the top margin to 0 because we want to display the Sticker in the background */
.list-card.is-stickered .list-card-details  {
    margin-top: 0;
    background-color:rgba(255,229,204, 0.5)
}

.list-card.is-stickered .list-card-details:hover  {
    margin-top: 0;
    background-color:rgba(255,229,204, 0.5)
}

The result:
Trello Coloured List




Tuesday, 23 February 2016

How to solve DB2 "User ID revoked" ERRORCODE -4214 in Windows?

If we tried connecting to DB2 using the wrong password, the user account will be locked after the 3rd attempt and we'll receive the following error message:
Could not create connection
    at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)
........
Caused by: com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][2017][11253][4.14.137] Connection authorization failure occurred.  Reason: User ID revoked. ERRORCODE=-4214, SQLSTATE=28000
To unlocked the user account:
- Open Control Panel | User Accounts
- Select Manage User Accounts
- Select Advanced tab
- Click Advanced button on the Advanced user management section
- Open Users folder on the pop-up window, double-click on the DB2 user account
- Uncheck the Account is locked out option on the user properties pop-up window

Voila! We can now connect to our DB2.


Tuesday, 3 November 2015

How to access DB2 from SQLDeveloper

To be able to access DB2 from SQLDeveloper, you need a JDBC driver (db2jcc.jar - just google it).
Assuming you have downloaded the jar, here's how to setup the SQLDeveloper:
1. Open SQLDeveloper
2. Go to Tools > Preferences
3. Open Database | Third Party JDBC Drivers from the left hand side panel
4. Click 'Add Entry' button,select the jar file that you've downloaded and click 'OK'
  
5. After setup the JDBC driver, a DB2 tab will be added to the New Connection screen

Note for Enter Database field:
  • Enter <DatabaseName> if you wish to display all schema within a database
  • Enter <DatabaseName>:currentSchema=<SchemaName> if you wish to work on a specific schema within a database

Intro...

Just some random techie stuffs....