Monday, June 13, 2011

Update the Index of Database

Sometimes in properties in the Lotus Notes Database doesnt work to rebuilt the index by using the Delete and Create and Update. 

So to totally rebuilt the document's index, try to execute the following code in the Domino Administration in Server Console:



load updall databasepath -R
load updall databasepath -X



Wednesday, May 25, 2011

How to set up domino directory assistance

One of the problems I encountered was to set up directory assistance in my own server to test the other names2.nsf to work properly in my server or other server. And when I ask our Administrator, he guided me and return to my desk to document what he taught me. And here it is


1. Create new database named it names2.nsf using the template in Domino Directory(pubnames.ntf)
2. Then create new database da50.nsf using Domino Directory Assisstance template.
3. Then open the da50.nsf and click the Add Directory Assistance




4. And then click the Domino Tab And go back to the names2.nsf. Click the Edit->Copy As-> Application Link


5. And paste the link to Application links Box



6. Then open the Domino Administration and click the


7. Then enter the path of domino directory assistance


8. And you will notice in the Configuration that the database has been included in the Directory Information



9. Restart the server to take effect the configuration

Software Development



Plenty of things ive learned from reading the first chapter of the Head First Software Development - O'Reilly Media. It really amazed me because everything that has been discussed or tackled is very relevant with what ive been doing right now. And hopefully i will going to finish this wonderful book immediately.


And here is the brief summary of the First Chapter:




Sunday, May 22, 2011

How to set the values of Namepicker in to the main server instead of Local server(contact Directory) when accessing the XPAGES Application in lotus Notes Client


Set the value of the following:

dataProvider: DominoNABNamePicker
addressBookDB: {servername}!!{databasename}
addressBookSel: db-name

  Code:

       
                
     


Friday, May 20, 2011

How to set up/ install the extension Library in the Lotus notes Client



I have this problem that how to install the extension library in Lotus Notes Client because it requires to Install the extension in the Lotus Notes if the application will be accessing in LN aside from Web.But after searching the workaround such as installing the package as Widgets, i came across the Wildfire widgets. It explains in the installation how to enable the File->Application->Install.

See the Image below the application properties in the designer that requires extension library to be installed in LN Client.  


1.        Close you Lotus Notes client
2.       Browse to the plugin_customization.ini in the notes framework\rcp
a.       Add com.ibm.notes.branding/enable.update.ui=true
For more information about plugin_customization click here
3.        Save and close file and restart Lotus Notes
4.        You should now find the Install menu option available in Lotus Notes.
5.        Select File -> Application -> Install.

 6.       Add the Extension Library update site zip file:



7.        Reply to the questions and restart Client
8.        Open the application that uses the Extension Library and it works now properly




Tuesday, May 17, 2011

How to connect to MYSQL in Lotus Notes AGENT in Windows XP

1. Install the MYSQL
2. Install the Mysql-ODBC Driver.
3. Go to Control Panel -> Administrative Tools > Data Sources ODBC
4. Go to System DSN tab
5.    Click Add button and select the  Mysql OBDC 5.1 Driver
6.    Supply the information and click OK

7.    This will add employee variable in the list
8.    In the Desktop, add Text Document

9.    Rename the file to test2.udl or any name with the extension of udl.
10.    Click or open the test2.udl
11.    Choose the Provider tab and select Microsoft OLE DB Provider for ODBC Drivers




12.    In the Connection tab, Use the employee as data source name. And click OK



13.    Open the test2.udl in Notepad and will show the following code:
Provider=MSDASQL.1;Persist Security Info=False;Data Source=employee
14.    Create and agent and copy and paste the code below

Option Public

Option Declare


Sub Initialize

      Dim con As Variant

      Dim rs As Variant

      Dim com As Variant

     

      Set con = CreateObject("ADODB.Connection") ' Database connection

      Set rs = CreateObject("ADODB.Recordset") ' Handles the record set

      Set com = CreateObject("ADODB.Command") ' the query or command

      'From the test2.udl opened in the notepad

      con.open = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=employeeDB"

     

      Set com.ActiveCOnnection = con

       'Must have already created table in the employeeDB database

      com.CommandText = {Select * from name}

     

      Set rs = com.Execute

      rs.MoveFirst

     

      While Not rs.EOF

            MsgBox rs.Fields("name").Value

                        'Call doc.save(True,False)

           

            rs.MoveNext

           

      Wend

     

End Sub


   
For more information about ADO connection visit W3school

15. Run the agent to test.




Install the driver Mysql-ODBC driver in the Windows XP

1. Download the file from Mysql Website
2. Extract the file and Click the Install.bat found in extracted file.

3. To check the driver installed  Go to Control Panel-> Administrative Tools->Data Sources(ODBC)
4. In the ODBC Data Sources Administrator Dialog Box , click the Add and you will see the MYSQL ODBC 5.1 Driver.

 

Thursday, April 14, 2011

Expression Language Operators


Category
Operators

Arithmetic
+, -, *, / (or div), % (or mod)

Relational
== (or eq ), != (or ne), < (or lt), > (or gt), <= (or le), >= (or ge)

Logical
&& (or and), || (or or), ! (or not)

Conditional
A ? B : C (Evaluate A to Boolean. If true, evaluates and returns B. Otherwise, evaluates and returns C.)

Empty
= empty A (If A is null or is an empty string, array, Map, or Collection, returns true. Otherwise returns false.)

Locations of visitors to this page