Thursday, November 24, 2011

Retained Earning (Laba Ditahan) di OpenERP

Bismillah,

In process to blogging and sharing my knowledge in OpenERP.
Start with posting about getting retained earning for Balance Sheet Report in OpenERP..

Chek this out...
http://berbagiopenerp.blogspot.com/2011/11/retained-earning-laba-ditahan-di.html

Monday, November 21, 2011

show products on magento homepage

Bismillahirrahmaanirrahiim..

okay, I'm starting to seriously manage my own provate project that is create an online store.
After, browsing, asking etc I found magento as the best free online store I found.
the important thing is it has a good free templates hehe...

the most difficult is how to show products on magento home page.
I thought it should be default, but it is not.

After searching some documentation, I found this good link http://vimeo.com/1070986
So, simple.
1. Create product category (set active as no). It just to collect all products to show up in home page
2. Create products and set category to your home page category
3. Update attributes of products and set it to show in main website
4. Make sure you have update inventory of that product
5. Set up cms homepage content. Add this block:
{{block type="catalog/product_list" category_id="10" template="catalog/product/list.phtml"}}  
Change category_id to number ID that can you see in category management
example:

Full (ID: 10) 

So category_id is 10


that is...
hope this help

Wednesday, November 16, 2011

enable remote access PostgreSQL in Windows

Bismillah...

So, in my current office I am not using Ubuntu more...
I have to use Windows server 2008 as my application server.

Just same when I use Ubuntu...  I should learn from zera how to maintain a server... haha
okay... back to the topic...

I installer PostgreSQL 8.4 on server
and want that database can be accessed remotely...

In ubuntu the steps is easy like my post before enable-remote-access-postgresql
In windows the steps are same, which are
- edit pg_hba.conf
- edit postgresql.conf
- restart server

OKay... it easy but I always failed...
Why?
Because I was totally wrong placing file pg_hba.conf and postgresql.conf
I placed them on root of postgre folder
because some blog said that...

then, after read this blog http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html
I just knew that it should be placed on data dictionary...

It just I place data dictionary in "D" space not "C"
so, I didnt realize that folder...

pfiuuhh....

Ohya don't forget to add New Line in last line of file pg_hba.conf

Hope this help...