Armaghan

Finally! Google opened up the AppInventor to the general public.

So...when I was given the choice between an Apple (iPhone4) and an Android phone (HTC Desire), the choice for me was obvious. Being a hardcore Google user (Gmail, Google Maps, Google Docs to name a few), I was extremely pumped to get my hands on a Google Phone. 

I have performed a few ES to ES2 Migrations and there isn't too much information out there on what is involved in the process. Here is an outline based on my personal experience:

The following link gives you the ability to step over the first few manual steps to the migration process: Adobe Labs

Have a look at the following blog post as well as the captivate video that gives an overview of the migration process if its done from scratch :  LiveCycle Expresso

This should serve as a starting point to your migration process.A few things to look out for: 

1. XfaForm variables are no longer supported in ES2. However, you will be able to run such processes in deprecated mode but not for too long. 
2. The concept of application based projects has been introduced in ES2. 
3. The concept of a repository is no longer there in ES2. The applications refer to their own local resources in the applications or you can create an application that contains all the resources/ Assets etc. You must export all your assets from the repository manually and import them into a new application in ES2. 
4. You must configure all the paths to the assets in the repository to the application containing your artifacts. 
5. If you have an assembler service in your process, you must re-configure it to use a document variable instead of a string (this has not been document anywhere and is a bug).
6. If you have any custom components, you must export them manually from the ES server and import them into ES2 before you migrate the processes. 
7. Finally, you must remove all the deprecated services and replace them with the ES2 versions. 
8. I won't recommend the approach of creating an ES LCA and importing into ES2. This has caused a lot of issues for me in the past. 

Thats just my 2 cents. If you have any questions, or require assistance, please leave a comment on my blog.

You might find the following queries quite handy for your day to day SQL operations:

1. Get the total number of records in a table:

SELECT COUNT(*) FROM TABLE_NAME;

Here are a few  useful user SQL code snippets in Oracle:

1. To create a user

CREATE USER username
IDENTIFIED BY password
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;

2. Grant user privileges:

GRANT CONNECT, RESOURCE, CREATE SESSION, CREATE VIEW TO username;


3. Grant all privileges:

GRANT all privileges TO username;

4. Delete a user or to delete a user and the associated user schema

drop user username cascade;

This SQL Snippet get a list of all the tables under a user:

select * from user_objects where object_type = 'TABLE';

This SQL Snippet will get you a list of all the sequences in a DB Schema for the user tables

select * from user_sequences

This SQL Snippet will get you a list of all the view in a DB Schema for the user tables

select * from user_views;

Happy Coding :)

If you ever have to find out the version of Oracle using SQL, use the following SQL command and it will spit out all the details.

SQL
 SELECT * FROM V$VERSION;

OUTPUT

BANNER                                                          
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production                          
CORE    10.2.0.1.0    Production                                        
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production         
NLSRTL Version 10.2.0.1.0 - Production
----------------------------------------------------------------

Happy Coding :)

I had to run two webservers on my machine at the same time. Since both of them used port 8080 , the easiest way to run the two servers at the same time was to modify the port number on one of them. 
Here is how we can change the port number in Apache Tomcat:

1. Navigate to : Apache Software Foundation\Tomcat X.X\conf

There are lots of crazy ways of manipulating XML in ActionScript.Here are a few simple tips and tricks on manipulating XML in Actionscript.

1. Declaring an XML Variable: An XML variable can be created in ActionScript as follows :

                 var tempSearchXML:XML =     <searchCriteria>
                                                                <branchName>023</branchName>
                                                                <contfirstname></contfirstname>
                                                                 <contlastname></contlastname>
                                                                 <contmailsort></contmailsort>
                                                                 <contphone></contphone>
                                                             </searchCriteria>
                                         
2.  Preview an XML Variable : An XML variable can be previewed in an Alert Box by converting the XML to a string object
       
            Alert.show(tempSearchXML.toString());
           
3.  Getting the value of a Node in the XML:

           Alert.show(tempSearchXML.branchName.toString());

4.  Setting the Value of Node in the XML : The following code sets the value of a node 'contfirstname '.
 
            tempSearchXML.contfirstname ="Armaghan";

5.  Setting / Changing / Updating the Node Attribute in the XML: The following code snippet changes the name of a Node from 'contlastname' to 'lastname'.

            tempSearchXML.contlastname.setName("lastname") ;
           
5.  Delete a Node in the XML: The following code snippet deletes a Node called 'contphone' in the XML.

            delete tempSearchXML.contphone;

6.  Adding a Node in the XML: The following code snippet adds a Node called 'text' in the XML and sets its value at the same time.

            tempSearchXML.text ="Taylor" ;

Happy Coding :)

If you ever need to dump the build information from the command prompt console into a log file, just add a -logfile <filename>.log parameter after your build file call in the command prompt console and you're good to go.

Happy Coding :)