Download and/or Read Directly a File from FTP with Python

See this script below: Hope this help

install php mysql on ubuntu

http://www.developmentwall.com/install-apache-php-mysql-phpmyadmin-ubuntu/

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

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

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...

[openerp] The modules menu is missing!!

Bismillah...

what a shock, that I couldn't found modules menu on menu administration in openerp although I've login as administrator...

That menu is very important to install update new modules...

Then I gugling, and found a very simple solution..

that is switch your interface mode from simplified to be extended.

Just it!

Hope this help :D

[openerp] ZipImportError: bad local file header in pathtozipfile.zip

Bismillahirrahmaanirrahiim...

Today I just learned how to create a simple module in openerp...

I read this sources:

1. http://www.ibcscorp.com/application-integration-customization/erp/openerp-2/openerp-custom-module-development-quick-start-guide/
2. http://imsciences.edu.pk/serg/2010/09/openerp-module-development-part-1/

There are some different method from that two sources:

1. The first source using file named __openerp__.py as module descriptor file, but the 2nd source using file named __terp__.py
   I don't why they using different file name... I will find out later
2. the first source says that we should zip folder as modulename.zip then instal to openerp through menu administration/import module,
   but the 2nd source says that we just put the folder into folder openerpserver/addons but dont know the next procedure

So, I have try the first source and it was install successfully..

then I tried the 2nd source but with 1st source method to install the module.

1. Zip the module
2. Go to menu administration/modules/import module
3. attach the zip file
4. go to menu modules
5. search module name I created
6. click schedule for installation
7. apply schedule upgrades

but it raises error such these:

openerp ZipImportError: bad local file header in pathtofile.zip

I search in google and founf this answer (http://www.openerp.com/forum/topic15598.html)

in server, unzip student_info.zip in addons/student_info (but warning, you do not have addons/student_info/student_info)
in client go to administration->modules, update list of modules, install your module.
If you use dia to build your modules, or generally, unzip it in addons before, and update list of modules.

SO, the solution is:

1. cancelling the installation of module
2. unzip the modulename.zip in openerpserver/addons/
3. remove modulname.zip file
4. click menu administration/modules/update modules list
5. search for my modulname
6. schedule for installation
7. apply schedule upgrades

then I can see the real error,

I fix it directly in openerpserver/addons/modulename

then I click apply schedule upgrades until success information appear

btw, the 2nd source will make you dizzy

because we will found some error when implemented that...

it just because different text fonts when you use quotes and double quotes

and there a line missing in sim.py

which is:

from osv import osv, fields

in first line

Hope this help