Sabtu, 07 Juli 2012

Cara Menginstall OpenERP 6.0 (Bagian 2 -4)


Install Postgresql dan pgadmin3

$ sudo apt-get install postgresql

$ sudo apt-get install pgadmin3

Langkah berikutnya adalah membuat postgreesql user. Masuklah ke posgres.

$ sudo su postgres
$ createuser --createdb --username postgres --no-createrole --pwprompt openerp

Enter password for new role: XXXXXXXXXX
Enter it again: XXXXXXXXXX
Shall the new role be a superuser? (y/n) y
CREATE ROLE

  •  --createdb  : user baru bisa buat database
  •  --username postgres         : createuser menggunakan postgres user (superuser)
  • --no-createrole : user baru tidak dapat membuat user lain          
  • --pwprompt : createuser akan meminta password baru
  • Postgres (warna merah)   : nama database. Anda bisa memberi nama apapun yang anda inginkan.
  • openerp (warna merah)   : username baru. Anda bisa memberi nama apapun yang anda inginkan.
  • XXXXXXXXXX (warna merah) : password baru

Cara Mudah Install OpenERP 6.0 (Bagian I - 4)


Disini saya akan memberikan dokumentasi tentang instalasi OpenERP 6.0 di Ubuntu 12.04.
Ada 4 langkah utama untuk menginstall OpenERP sebagai web client
1.       Persiapan
2.       Konfigurasi dan instalasi PostgreSQL Server
3.       OpenERP Server Installation
4.       OpenERP Web Installation

Persiapan
Download openERP server dan openERP web-client dalam bentuk tar di


Setelah itu ekstrak file tar yang sudah di download dengan perintah
    $ sudo tar –xzf openerp-server-6.0.0.tar.gz
    $ sudo tar –xzf openerp-web-6.0.0.tar.gz

Update Ubuntu

Disini kita harus mengupdate dulu Ubuntu kita. Jika anda sudah meng-update dan meng-upgrade Ubuntu, anda bisa lanjutkan ke langkah instalasi openerp-server. Jika belum, disini dicontohkan cara meng-update dan meng-upgrade Ubuntu dari server kambing ui.

Buka Source list

$ sudo gedit /etc/apt/sources.list

Copy-kan code ini di akhir bari kode-kode source list

### sources.list.kambing
### Repository dengan menggunakan server mirror kambing.ui.ac.id
### Untuk rilis lain selain  precise silakan ganti semua kata
### dengan misalnya precise dsb
## REPOSITORY UTAMA
deb http://kambing.ui.ac.id/ubuntu precise main restricted universe multiverse
deb-src http://kambing.ui.ac.id/ubuntu precise main restricted universe multiverse
## INI UNTUK MAJOR BUG FIX UPDATES
deb http://kambing.ui.ac.id/ubuntu precise-updates main restricted universe multiverse
deb-src http://kambing.ui.ac.id/ubuntu precise-updates main restricted universe multiverse
## INI UNTUK UBUNTU SECURITY UPDATES
deb http://kambing.ui.ac.id/ubuntu precise-security main restricted universe multiverse
deb-src http://kambing.ui.ac.id/ubuntu oneiric-security main restricted universe multiverse

Lalu save source list yang sudah ditambahkan kode di atas.

Ugrade Ubuntu

Lakukan upgrade Ubuntu

                $ sudo apt-get upgrade

Daftar Sumber



Rabu, 04 Juli 2012

Step by step to Send Gmail from OpenERP

The main steps to send email from openERP throught gmail:
  1. You have had gmail account 
  2. Install email_template module in your openERP
  3. Create and configure email account
  4. Try to send email to your friend :)

STEP 1
You have had gmail account. You can register in mail.google.com

STEP 2
Install email_template module throught Administration --> Modules --> Update Module List.
After you installed it, you would find Tools menu.

STEP 3
Create and configure email account. Go to Tools --> Configuration --> Email Template --> Email Account  then create new account.

Configure Server Information,
Server : smtp.googlemail.com
SMPT port : 587 or 25
TLS : checked
After that try to test outgoing connection. In my experience, my testing got the result "WARNING" but without messages. It is indication that you are success even you get result "WARNING". But if you got result "WARNING" and some message there, you just try to make sure your configuration like above and don't forget to try combination between port 587 and 25.




Then configure user Information,
from email : fill with your gmail
password : your gmail password
user name : your username that you want
related user : choose your user login.
Don't forget to approve your account then.

STEP 4
Try to send email to your friend :)

Go to Tools --> Email Template --> Emails and the create new email to sent.



Fill the form like you send an email just like usual. The important things you have to do is choose user account. Go to tab advanced d then choose user account that you have configured before. See the picture below.


After that, go to tab Standard body again and click Send Mail button.

Tell to your friend that you've sent an email and see what the miracle! :D
Good Luck

How to Connect openERP to Gmail?

I've try to connect openERP with my gmail account. This is the way I've done.

Step 1
You have to install CRM module and fetchmail module.
Fetchmail module is the main module to configure email server.

Step 2

Go to Sales --> Configure --> Emails --> Email Server

Create new email server and configure it just like what I've done here

Name : Google
Server Type : IMAP Server
Server : imap.googlemai.com
Port : 993
username : your gmail account.
password : your gmail password.

You also have to check : Add attachment, active, SSL



Dont forget to confirm your configuration

Step 3
Refresh your browser and look at
Go to Sales --> Configure --> Emails --> Email Server
 You will see some message over there from your gmail. Good Luck :)