Ali Abdel Aziz

Workshop on Software Engineering Education in Egypt
Challenges and Opportunities
June 3, 2007,
Seminar Hall,
Faculty of Computers and Information,
Cairo University

read more

JETS Launch and Workshop Day "Open source … the trend for the future"

read more

/*
* TransformMaster.java
*
* Created on April 29, 2007, 9:59 AM
*
* To change this template, choose Tools | Template Manager
* and open the template in the editor.
*/

package com.arpu.opencds.datatransformation;

import java.io.*;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.text.MaskFormatter;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.sax.SAXSource;
import javax.xml.transform.stream.StreamResult;

read more

/*
* SqlXMLReader.java
*
* Created on April 29, 2007, 12:07 PM
*
* To change this template, choose Tools | Template Manager
* and open the template in the editor.
*/

package com.arpu.opencds.datatransformation;

import java.io.*;
import java.net.URL;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import org.xml.sax.*;
import org.xml.sax.helpers.*;

/** A utility class that parses a Result Set Value
* and outputs its contents using SAX2 events.
* For simple values, the SQL Result Set file may look like this:
*

read more

/*
* SqlInputSource.java
*
* Created on April 29, 2007, 5:24 PM
*
* To change this template, choose Tools | Template Manager
* and open the template in the editor.
*/

package com.arpu.opencds.datatransformation;

import java.sql.ResultSet;
import org.xml.sax.InputSource;

/**
* a class that extends InputSource.
* The intent of this class is to just holds a copy of the ResultSet object
* for the XML reader to use it.
* @author aabdelaziz
* http://www.aliabdelaziz.com/
*/
public class SqlInputSource extends InputSource {

/**
* Zero-argument default constructor.
*
* @see #setPublicId
* @see #setSystemId
* @see #setByteStream
* @see #setCharacterStream
* @see #setEncoding
* @see #setResultSet
*/
public SqlInputSource() {
super();
}

/**
* Create a new sql input source with a system identifier.
*
*

Applications may use setResultSet to include a
* public identifier as well.

read more

/*
* AbstractXMLReader.java
*
* Created on April 29, 2007, 12:20 PM
*
* To change this template, choose Tools | Template Manager
* and open the template in the editor.
*/

package com.arpu.opencds.datatransformation;

/**
*
* @author aabdelaziz
* http://www.aliabdelaziz.com/
*/
import java.io.IOException;
import java.util.*;
import org.xml.sax.*;

/**
* An abstract class that implements the SAX2 XMLReader interface. The
* intent of this class is to make it easy for subclasses to act as
* SAX2 XMLReader implementations. This makes it possible, for example, for

read more

As we are currently working on migration from my company old CMS to OpenCDS so I have to migrate the old data from the old CMS database (MSSQL Server) to OpenCDS database (Oracle) and offcourse the two ERDs are completely different.
So the solution that I follow is to export the data from my old CMS to XML files then use XML_Submission to insert this data into OpenCDS and this will guarantee that the relation for each piece of content is created correctly.

I will discuess in this Article how to export the data from your old CMS database to XML files with format that can be imported into OpenCDS.

read more

I have used XSLT as a transformation engine to transform the Devices profiles from the manufacture form to the OpenCDS form.

Handsets Profiles Links:

• Nokia:
  1. http://www.lebodic.net/nokia.html

A few Notes on the Following XSLT:
some MIME Types are not found in OpenCDS so I maped it to temp directory with .tmp extension, so you should create this Content Tyype (temp) and attach to it all MIME TYPEs that doesn't exit in the system

the following is Nokia XSL that is used to transform from Nokia format to OpenCDS format: