Ubuntu 13.04 : Manual installation of Libre Office 4

Download latest Libre Office from :
http://www.libreoffice.org/download

To install LibreOffice 4 you will need to remove all previous versions.
Run:
sudo apt-get remove --purge libreoffice-core libreoffice-common
sudo apt-get autoremove --purge

Extract the files:

cd to the Downloads directory: cd Downloads

Extract the tar.gz:

For 64 bit:
tar -xvzf LibreOffice_4.0.3_Linux_x86-64_deb.tar.gz

For 32 bit:
tar -xvzf LibreOffice_4.0.3_Linux_x86_deb.tar.gz

Install the program:

cd to the programs folder:

For 64 bit:
cd LibreOffice_4.0.3.3_Linux_x86-64_deb/DEBS

For 32 bit:
cd LibreOffice_4.0.3.3_Linux_x86_deb/DEBS

Install part one (for both 32 and 64 bit):
sudo dpkg -i *.deb

Install the desktop integration (again for 32 and 64 bit):
cd desktop-integration
sudo dpkg -i *.deb

You're done!

Ubuntu 13.04 64bit : Unable to install ia32-libs

If you are unable to install ia32-libs package on your fresh installation of Ubuntu 13.04 64bit, for installation of Skype, Teamviewer or Adobe Reader, than you should do :

- Switch Update server to Main, in System Settings / Software & Updates
- Check on all Install updates from option on Update tab

than do in Terminal :

sudo dpkg --add-architecture i386

sudo apt-get update
sudo apt-get install ia32-libs

Increase php memory limit

If you get this error on OpenCart system 1.5x :

PHP Fatal Error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 32 bytes)

then

in system/startup.php add line

// Register Globals

ini_set('memory_limit','-1');

[July 24th] [Sense 3.5] Energy™ -.¸¸.·´¯ Sense 3.5 with working SD-EXT Mod

I want to share my successful procedure with this Sense ROM for HD2 :

1. Prepare Ext4 partition on your SD card (min 1 Gb)
2. Setup system partition to 380 Mb in CLK
3. Clean everything throw ClockworkMode Recovery
1. Wipe data/factory reset  
2. Wipe cache partition
3. Advanced > Wipe dalvik cache
4. Advanced > Wipe battery stats
4. Install [July 24th] [Sense 3.5] Energy™ -.¸¸.·´¯ Sense 3.5 ROM in NAND mode 
5. Don't reboot just exit
6. Install SD-EXT Mod - AMARULLZ DATA TO SD-EXT  
7. Now reboot

Now you have best and fastest Sense ROM for your HTC HD2 with working DataOnExt.
Just update it throw Google Play and that's it.

If you experience robotic voice throw calls follow this fix.

How to remove robotic voice in HTC HD2 Sense Android roms

- go to settings/sounds
- uncheck audible touch tones
- make a phone call and when finished
- reboot

OpenCart CMS - Import multilanguage data

- Make first language default which is the same with your data. And import these language data.
- And then make second language default. And import this language data.

Now you have items in two languages.

OpenCart CMS - Export/Import Excel file

Categories

Categories looks like the most confusing to get your head around at the start however it’s fairly straight forward.

The technique to doing it is to add all your categories in first and assign a unique id to it and group the categories together.  It’s probably best to even work backwards too.

• Category_id – the unique id of the category, you cannot assign multiple id’s to a category or assign a single id to multiple categories
• Parent_id – the id of the category that the category belongs to.  ‘0’ is a top level category (the category that will be shown and that houses sub-categories etc)
• Name – the name of the category
• Sort_order – if you want categories to appear in a specific order you can number them, just remember if you don’t assign a number to a category it will default to ‘0’ which will place it before all the other categories in that particular level / sub-category
• Image_name – the image that is assigned to the category.  See additional images in products section for example and explanation
• Date_added – put today’s date
• Date_modified – put today’s date
• Language_id – keep at 1 (English)
• Seo_keyword – similar to meta_keywords
• Description – the description of the category
• Meta_description – a brief concise description of the product / category to help with search engines
• Meta_keywords – keywords that are specific to the product / category, to help with search engines
• Store_ids – keep at ‘0’, don’t change
• Status enabled – whether or not a product is enabled or disabled (shown or hidden) true = shown, false = hidden

Products

With products, only the product name is a mandatory field, you can leave as many areas blank as you like.  You don’t need to fill them all in.

Product_id – the unique id of the product, you cannot assign multiple id’s to a product or assign a single id to multiple products

• Name – The name of the product
• Categories – the categories that the product belongs to.  You can add a product to multiple categories,  just separate category id’s with a comma (eg. 23, 56, 5)
• Sku – the SKU number of the product (SKU’s are assigned to barcodes to allow for easy identification when scanned)
• Location – the location of the product (eg. Brisbane, Australia)
• Quantity – the about of the product that you have in stock
• Model – the model number of the product
• Manufacturer – this is the brand of the product (for example, windows 7 is a Microsoft product so you’ll add in ‘Microsoft’ and people will be able to search for products by manufacturer) note: you can only have one manufacturer
• Image_name – same as additional images (see for example)
• Requires shipping – set to yes unless it’s a digital download
• Price – the price of the product (before tax)
• Date_added – put today’s date
• Date_modified – put today’s date
• Date_available – put today’s date unless it will be available at a specific date.
• Weight – weight only needed if you have a shipping method that is weight based (eg AusPost) also be sure to keep the weight in kilograms (eg. 250g = 0.25)
• Unit – keep at ‘kg’
• Length – not needed for anything but you can add it if you like
• Width – not needed for anything but you can add it if you like
• Height – not needed for anything but you can add it if you like
• Length unit – keep at ‘cm’
• Status enabled – whether or not a product is enabled or disabled (shown or hidden) true = shown, false = hidden
• Tax_class_id – keep at ‘9’ (GST)
• Viewed – number of times the product has been viewed (leave blank)
• Language_id – keep at 1 (English)
• Seo_keyword – similar to meta_keywords
• Description – the description of the product / category (the description is in HTML however don’t be afraid of this, all you need to do is have a at the start of each paragraph and an at the end of each paragraph and that will format it.  If you want bold add around the words you’d like in bold and for italics.
• Meta_description – a brief concise description of the product / category to help with search engines
• Meta_keywords – keywords that are specific to the product / category, to help with search engines
• Additional images – the links to additional images for a product, if there are additional images for a specific product, add a comma after each image url, don’t add spaces.  Start all links with data/(name of folder that will contain the image)/(image name)
• Stock_status_id – this is the status that is shown when a product is out of stock (keep at ‘5’ which is the default ‘out of stock’)
• Store_ids – keep at ‘0’, don’t change
• Related_ids – id’s of products that are related to a specific product
• Tags – tags act as keywords, however it will list them at the bottom of the product page and if someone clicks on a specific keyword, then all the products with that tag will be grouped and displayed.  (add commas between each tag)
• Sort_order – if you want products to be displayed in a specific order
• Subtract – whether or not it will subtract from the products stock number when purchased
• Minimum – the minimum amount of a specific product that the customer has to buy when purchasing the product
• Cost – the cost price of the product  (not needed)

Options

This area is for additional options that a product might have.  For example, a shirt will have shirt sized of small, medium, large, etc, etc.

• Product_id – the product id number that this option will belong to.
• Language_id – keep at 1 (English)
• Option – the name of the option (eg shirt sizes)
• Option_value – the options of the product (eg small, medium, large)
• Quantity – the quantity of stock of the option (you can leave blank if you don’t have to worry about stock quantities)
• Subtract – whether or not it will subtract from the products stock number when purchased
• Price – the price difference of the option to the base product (for example of the additional option is $50 more then it will be 50)
• Prefix – add a ‘+’ or ‘-‘ here to indicate whether the above price subtracts from or adds to the base product price.
• Sort_order – the order of which you’d like the individual options to be listed

Specials

• Product_id – the product id number that this discount/special will belong to.
• Customer_group – if you have customer groups, for example the store has retail set as the default however if you were to add wholesale it too you can set the discount/special for a specific group only.
• Priority – priority of discounts
• Price – price of product after discount (eg. $500 product has $50 dicount, price = $450
• Date_start – starting date, must be in this format – yyyy/mm/dd
• Date_end – ending date, must be in this format – yyyy/mm/dd

Discounts

• Product_id – the product id number that this discount/special will belong to.
• Customer_group – if you have customer groups, for example the store has retail set as the default however if you were to add wholesale it too you can set the discount/special for a specific group only.
• Quantity – I think this is in reference to the amount that can be bought at the discount price before it ends (just leave it blank)
• Priority – priority of discounts
• Price – price of product after discount (eg. $500 product has $50 discount, price = $450
• Date_start – starting date, must be in this format – yyyy/mm/dd
• Date_end – ending date, must be in this format – yyyy/mm/dd

from source > http://www.support.mywork.com.au/OpenCart---ExportImport-Excel-File

MS Access : Wizard isn't installed or has been disabled.

When I discover that none of the MS Access wizards are working, first noticed it when I tried to run the Query wizard. Form and Report wizards also do not work.

The error I get when trying to link tables is: "The Wizard you've requested is not installed or is in a bad state. Please install or reinstall the wizard. If you do not have permissions to do this on your computer see your system Administrator."

For the Report or Query wizard the message is: "This feature isn't installed or has been disabled."

I did an Office Diagnostic and a Repair installation. Neither helped. I've been doing some searching on the Internet and found this tip:

Remove folder : C:/Program Files/Common Files/Microsoft Shared/VBA/VBA6 (apparently MS Access 2010 creates it). After deleting that folder, I launched MS Access 2010, and automatically, some repair process started, which thankfully, fixed this frustrating problem.

Now, all my Wizards are working again. :-)

Lockscreen Policy - Disable Android 4.2 Lockscreen Widgets and Camera

Install application Lockscreen Policy from Google Play to get rid of widgets and camera on the Android 4.2 lockscreen.

P.S.: from XDA Developers

XDA: NexusHD2-JellyBean-CM10.1 - 2G/3G signal indicator

To correct signal strength indicator change line in /system/build.prop to ro.telephony.ril.v3=signalstrength,singlepdp,apptypesim

P.S.: Download BuildProp editor from Play Store and edit it the easy way.

Prepare HTC HD2 for XDA Nexus 4.1.2 rom

1. Install HSPL 2.08;
2. Install Magldr
3. Partition correctly with Magldr: 5MB cache, 285MB ROM (choose custom and type 285 in the textbox, then repartiton with HD2 tools)
4. After partitioning, you will have access to AD Recovery.
4.1 Use AD recovery to partition your SD card: 2G sd-ext, 256M swap.
4.2 Use AD recovery to mount USB storage, copy ROM and upadates on the card.
4.3 Flash ROM then reboot. Do NOT boot.
4.4 Flash all other updates. Reboot phone, go through the setup.

How to install mobile phone over USB on Windows 7 VirtualBox

If you are trying to install the drivers for HTC mobile phone inside MS Windows 7 VirtualBox, try installing the VirtualBox Extension Pack and enable USB 2.0 in the settings after doing that.

How to install Clementine music player in Ubuntu

In Terminal window type :

sudo add-apt-repository ppa:me-davidsansome/clementine
sudo apt-get update
sudo apt-get install clementine

Speed Up Ubuntu

1. sudo apt-get install preload

2. sudo apt-get autoclean

3. sudo gedit /etc/fstab

• - At the end of the file, add these lines:
• # Move /tmp to RAM
• tmpfs /tmp tmpfs defaults,noexec,nosuid 0 0

4. sudo gedit /etc/sysctl.conf

• - At the end of the file, add these two lines:
• #
• # Decrease swap usage to a workable level
• vm.swappiness=10

5. gksudo gedit /etc/init/network-manager.conf

• Copy and paste the below code, below the existing ‘stop on stopping dbus’:
• kill timeout 1

6. gksudo gedit /etc/init/modemmanager.conf

• Then look for the existing ‘stop on stopped network-manage’ text line, and simply paste the below code just below it :
• kill timeout 1

7. Comment out this line works too in /etc/init/modemmanager.conf :

• #start on starting network-manager
• stop on stopped network-manager

* If your Eclipse Android SDK Manager wont start after 3rd step in moving /tmp to RAM,

then execute :

• sudo mount -o remount,exec /tmp

and in /etc/fstab comment line

• # Move /tmp to RAM
• # tmpfs /tmp tmpfs defaults,noexec,nosuid 0 0

How to configure Ubuntu to allow IP Forwarding for torrent ?

I figured it out.

Edit /etc/default/ufw and set

DEFAULT_FORWARD_POLICY="ACCEPT"

and restart network...

Set root password in Ubuntu

Open the terminal and type

• sudo passwd root

and write new password .

How to setup CodeTyphon - for Cross compiling FPC and Lazarus - AIO

This is install procedure in Ubuntu 12.10 64bit environment :

1. Install last CodeTyphon zip packet from

• http://www.pilotlogic.com/sitejoom/index.php/codetyphon/codetyphon-download

2. Extract archive in folder , for example :

• /home/ct 

3. Enter that folder from Terminal with root privileges and start

• ./install.sh

4. Only for the first time of CodeTyphon installation in your Computer, select option

• (3) "Install System Libraries" (about 10 min.)
• for Ubuntu 12.10, you will need to manually add these packages
• sudo apt-get install binutils-dev devel-essential

5. After System Libraries Installation, run again "Install.sh" and select option

•  (0) "Install CodeTyphon Studio"

6. After copy operation, select option

•  (8) "Remove and Build All" (about 15 min.)

6. After that, you have CodeTyphon Studio installed in your dash, start it and select :

• menu Cross-Build and choose desired platform

7. Than you should start Lazarus and choose related fpc, for example :

• /usr/lib/codetyphon/fpc/bin/x86_64-linux/ppcx64 (for Linux64)
• /usr/lib/codetyphon/fpc/bin/x86_64-linux/ppcross386 (for Win32)
• /usr/lib/codetyphon/fpc/bin/x86_64-linux/ppcrossx64 (for Win64)

8. Finally, don't forget to choose menu Project/Project Options/Code Generation/Target OS :

• Linux
• Win32
• Win64

Write Once, Compile Anywhere

How to build FPC and Lazarus from SVN for cross-compiling

This procedure is implemented in Ubuntu 12.10 64bit.

1. You need to install subversion via apt-get in Terminal window :

• sudo apt-get install subversion

2. Than you can download your first trunk of fpc and lazarus :

• cd /home/svn
• cd fpc
• svn checkout http://svn.freepascal.org/svn/fpc/trunk
• cd lazarus
• svn checkout http://svn.freepascal.org/svn/lazarus/trunk

3. For later update from svn sources :

• cd /home/svn
• svn update fpc 
• svn update lazarus

4. To build fpc and lazarus

• make clean all

How to download source code from SVN or GIT in Ubuntu

In terminal windows type :

sudo apt-get install subversion
sudo apt-get install git

than you can download trunk with sort of these commands :

svn checkout http://android-samples.googlecode.com/svn/trunk/ android-samples-read-only
git clone https://code.google.com/...

How to set RelativeLayout inside ScrollView

<?xml version="1.0" encoding="utf-8"?>

<ScrollView xmlns:android="http://schemas.android.com/apk/res/android"

android:id="@+id/ScrollView01"

android:layout_width="fill_parent"

android:layout_height="fill_parent" >

<RelativeLayout

android:id="@+id/RelativeLayout01"

android:layout_width="fill_parent"

android:layout_height="638dp" >

... UI elements here ...

</RelativeLayout>

</ScrollView>