DSpace @ National Library of Malaysia : A Digital Initiative by Govt

Salam everybody, Today i'm gonna write about 1 special project that i have just completed few months back.Its a project by National Library of Malaysia. Its quite a big project(to me) bcoz its involved extra operations such as data migration. They have installed DSpace before(for testing/prove of concept purpose) and have collections inside but then they wanted to make it real(production) so they required the latest version of DSpace, a customized design tailored to PNM (Perpustakaan Negara Malaysia) and of course the data migration.

Below are the process involved during the project and softwares used:-
a) OS Installation (LINUX)
b) Installation & configuration

• DSpace v3.1
• Apache Tomcat 6
• Apache Maven and Apache Ant
• jdk
• PostgreSql

c) Data Migration from old DSpace to the latest version this includes not only data but assets folder.
d) CSS customization, Dynamic page banner and page counter.

I'm struggled for almost 3 weeks while trying to install apache maven due to the unavailable default repository. Anyway, i found other website hosting all maven jar so i download and copy to the server manually before i install on the DSpace server. My special thanks to PNM's Bahagian Digital and IT for their support and trust in this open source project.

PNM currently has not yet announced to the public about the repository, therefore i can not reveal its name and its web address. I will update the post as soon as i know they have opened the repository to the public. Below is the screen shot for the repository. Until the next writing, take care and wish you a very happy new 2014 year :)

Akad Sinergi | Pinjaman Peribadi MBSB

Salam,

Few weeks back i spent my night and weekend working on the website for Akad Sinergi Sdb Bhd. Its my brother's company and they are master agent for MBSB. At 1st i just use static html but then i add few dynamics page(php) with simple db(MySql). But a domain and hosting it locally(Malaysia's hosting provider)

Users are able to register to become a marketing agent for the company and for goverment staff they can apply personal loan(pinjaman peribadi) online. Both transaction will alert the admin thru email and the user will be notified also thru email.

I have a big plan for this website(expand more advance functions) but it would take more time and effort. With 2 small daughters, its quite difficult :) See you on my next post.

Crosstab VS Subreports

Salam,

I have developed reports using open source iReport software over the years. Sometimes, the report's design require developer to use crosstab function. It happens when we need column and row both to be dynamic. Usually we have number of column fixed and row will be dynamic. If you still don't get me, please see the image below :-

The above example show that the column is fixed(Total) and the row(Country) is dynamic(will be populate base on data). For each country, we want to know how many customer exist. Now, let see the 2nd example :-

The above example show that the both country and month is populated base on data.
Now, we can accomplish this via crosstab or subreports. See below for the advantages and of both solutions.

Crosstab :

• Fast way and easy to use if you understand the concept
• Can add sub column and sub row
• Can add total by sub column and sub row

Subreports :

• Easier than crosstab(for beginners)
• Able to generate row eventhough it has no data for that month(perhaps u want to display 0)

Bear in mind that you may need many subreports in order to satisfy the design. I always think that crosstab is the best solution.Anyway, other people might think the other way around.

Adios..