Custome Meta Data Sorting in Alfresco 3.4e

Add the following code To sort the Custom Meta Data:

source file:




function sortTitle(k,j){var m=k.title.toLowerCase(),l=j.title.toLowerCase();return(m>l)?1:(m<l)?-1:0}
function retrieveMetadataForElement(conn, meta, el)
   var res = conn.get(“/api/rma/admin/custompropertydefinitions?element=” + el);
   if (res.status == 200)
      var props = eval(‘(‘ + res + ‘)’).data.customProperties;
      for (var id in props)
         var prop = props[id];
             name: id,
             title: prop.label,
             dataType: prop.dataType

    // sort data before display




Install Alfresco with Mysql on Ubuntu

#install server

sudo apt-get install mysql-server

#check server

sudo netstat -tap | grep mysql

#install client

sudo apt-get install mysql-client

#install Java driver

sudo apt-get install libmysql-java

#install mysql tool

sudo apt-get install mysql-admin  phpmyadmin  mysql-query-browser

#Change the default of encoding to UTF8

sudo nano /etc/mysql/


sudo service mysql restart

#Create database table/user for alfresco

sudo mysql -h localhost -u root -p 

mysql> CREATE DATABASE alfresco DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
mysql> GRANT ALL PRIVILEGES ON alfresco.* TO alfresco@localhost IDENTIFIED BY ‘alfresco';
mysql> GRANT SELECT,LOCK TABLES ON alfresco.* TO alfresco@localhost IDENTIFIED BY ‘alfresco';
mysql> quit;

Install Sun Java & configed as default

sudo add-apt-repository deb maverick partner sudo add-apt-repository deb-src maverick partner sudo apt-get update sudo apt-get install sun-java6-jre sun-java6-bin sun-java6-jdk
sudo update-alternatives --config java
export JAVA_HOME=

# Install alfresco with advanced configuration, without Java,PostgreSql, OpenOffice

# with parameter     


sudo ./alfresco-community-3.4.e-installer-linux-x64.bin

#Install the MySQL database connector

The MySQL database connector is required when installing Alfresco with MySQL. The database connector allows MySQL database to talk to the Alfresco server.

  1. Browse to the MySQL download site:
  2. Download MySQL Connector/J x.x, and extract the following file from the downloaded .zip or .tar.gz file:
  3. Copy the JAR file into the <TOMCAT_HOME>/lib directory for Tomcat 6.

# Launch Alfresco

sudo ./ start


(转摘)Social media and free tools to use

From Inception to Distribution Selected Slides Finance & Sell Your Film in the Digital Age

  1. Where do I start
    1. Your Roadmap:
    2. Locate
    3. Listen
    4. Interact Influence
    5. Give me a place to stand on, and I will } move the Earth. – Archimedes
  2. “Data is the New Oil” – Michael Palmer, 2006 Summerland, California (Santa Barbara County), before 1906
    1. Volume
    2. Topics
    3. Type
    4. Reach
    5. Sentiment
    6. Opinion
    7. Influence
  3. Start your media Wildfire
    1. Your website is a small a part of the process In Web 2.0 everything interacts and builds
  4. Jumpstart your media Wildfire Courtesy of Maury Rogow
  5. You can not manage, if you cant measure
    1. Facebook Ads
    2. Google Adwords
    3. Google Analytics
    4. Google Webmaster
  6. Tools you didn’t know were almost free }
    1. Back up your data AUTOMATICALLY  Drop Box
    2. WordPress
    3. Email auto responders and forms:  Aweber 
    4. Constant contact  mailchimp 
    5. blueskyfactory} } Facebook helps you connect and share with the people in your life. Whether you want to or not.
  7. Search Shortcuts
    1. For phrases, use: quotation marks: “ “ }
    2. Either/or, use: OR }
    3. Synonyms, use: Tilde: ~ (Above Tab) }
    4. Grouping, use: Parentheses: ( ) }
    5. Wayback Machine: }
    6. Babel Fish Translation: }
    7. Facebook search:
  8. An Open Book – Your life on Facebook
  9. Search Shortcuts
    1. Library Databases: LAPL (
    2. ReferenceUSA – Business Directory
    3. Infotrac (Gale & Predicasts PROMPT) & Proquest  Like LexisNexis, but Free– } Gale Goliath-Int’l.: Partially free } } Highbeam: (free or Subscription) } Hoovers (free version: } Invest in Companies (buy one share…)
  10. Brainstorm
    1. Real-time Brainstorming.
    2. Simultaneously work Mind with colleagues on the same map real time. Meister 18
  11. Mention Map – Visual Tracking
    1. Google Docs
    2. DropBo:         Back up your data AUTOMATICALLY  (2G-8G free space)
    3. WordPress:      Blog Tool and publish platform
    4. AWeber        Email Marketing Software         19$/month
    5. mailchimp:      Email Marketing & Constant contact
    6. xMarks – sync your bookmarks and favorites
    7. Zoho – CRM and much more
    8. Skype – Free calls, and screen sharing
    9. Hootsuite – Twitter made easy } Tweetdeck – Twitter made easier! }
    10. Alexa – Ranking of any website }
    11. Google Keywords – }
    12. Google Analytics }
    13. Google Webmaster Tools }
    14. LinkedIn – Social Network for professionals
  13. } Mobile } Location based services } Smart TV

Google TV and Intel Smart TV Search across TV, Web, and Apps Home page with favorite TV channels, Youtube, web pages Share and converse “Media Stacking” Optimize now, the change is occurring