Working with LDAP is not as easy as I expect. I do need to have a good frontend to handle LDIF. There are several LDAP GUI Applications available in public domain but the easiest one should be web-based software solution. One main reason is to run it on localhost without graphical interface like X server and so on. The most popular one I know is called LDAP Explorer which is available for so long and it is a kind of old project. Right now, it is not easy to find and download this software because the main web site (igloo.its.unimelb.edu.au) has been downed for a while. Anyway, I have found a valid one eventually.

By default, Drupal will have only username and password for such a user. Whenever username is displayed, it will try to call a theme funtion namely username by specified $node. If you want to display user's fullname instead, you have to customize a little bit.

I found a good question regarding PHP snippet for Drupal. Usually, we will list nodes in multiple taxonomies using OR operator. However, you might need to list using AND operator which nodes must be in all specified taxonomies instead. It is not easy to do so using plain SQL. The straightforward solution is to use subquery.

Drupal provides powerful and flexible built-in table sort functionality. However, it will only work with database query through standard db_query() and pager_query(). In many cases, rows are fetched from external system, e.g., mailbox. We may add a few lines to get the same behavior.

OCI8 is an extension for providing APIs to Oracle database management system. However, installing OCI8 is not just easy like apt-get since it requires SDK offered by Oracle and its distribution license prohibits the inclusion to linux distribution. That means we have to download and compile it by ourselves. Fortunately, it is a little bit easy for Ubuntu.

If we want to create material document in SAP R/3 from external system, we can apply BAPI function BAPI_GOODSMVT_CREATE for this action. After we already call this function, we shoud call function BAPI_TRANSACTION_COMMIT or BAPI_TRANSACTION_ROLLBACK to commit or rollback our processes. In the example , i will create issue material doc by apply this function using PHP.