OpenERP Appliance

Collaboration Works

Magento 1.4.0.1 installer for Ubuntu

OpenERP Appliance & All-In-One & Magento Forum

A new release of this open source script is available. It automates the installation of Magento 1.4.0.1 from source code.

Click on this link to grab the new installer

OpenERP Appliance & All-In-One & Magento Forum

This script automates the setting up of openerp-server-5.0.3 & openerp-client-5.0.3 & openerp-web-5.0.3 & openerp-addons-5.0.3 for Ubuntu 8.04 LTS Desktop

The Goal is to provide a graphical installer of OpenERP for Ubuntu Desktop with a KISS philosophy

This post is obsolete! This script doesn’t work any longer as openerp v5.0.3 is out of date and not available at openerp.com. Please consider the new script and post: OpenERP 5.0.5 on Ubuntu All-in-one installer & updater For Dummies: http://bit.ly/3RL7Sa

Requirements: A fresh installation of Ubuntu 8.04 LTS Desktop (http://www.ubuntu.com/getubuntu/download)

Run the script through the Graphical User Interface:

1. uncompress the file
2. right click on openerp-allinone-setup-5.0.3-GUI.sh icon
3. click on ” Properties”
4. click on “Permissions” tab
5. select “Execute: Allow executing file as program”
6. click on “Close”
7. double click on the icon and “Run”

The installation process can be as simple as “Accept” for each question. You will need to type your user password (sudo).

Additional info:

1. OpenERP on Ubuntu 8.04 is recommended for production systems
2. Desktop Icons for openerp-client and openerpweb URL are made
3. Available IP addresses are shown to ease the IP address input. The first configured IP is marked as default one
4. An OpenERP-README.txt file is created with the remaining steps to be done from the OpenERP client (GTK or Web)

Screenshots:

Advertisements

February 13, 2010 Posted by | ERP, Scripting, Turnkey | | Leave a comment

New release of OpenERP All-in-one installer & updater for Ubuntu

A new release of this open source script is available and compatible with Ubuntu 9.10. It automates the installation and update of OpenERP from source code (latest stable or trunk branch from launchpad.net). The following optional modules have been included: openerp-spain, magentoerpconnect, report-openoffice and openetl.

Many thanks to Ana Juaristi (openerpsite.com) for suggesting the idea of adding report-openoffice into this installer. Brandnew OpenOffice.org Reporting Engine rocks!!

Click on this link to grab the new installer

January 31, 2010 Posted by | ERP, Scripting, Turnkey, Ubuntu Desktop, Ubuntu Server Canonical | , , | 21 Comments

OpenERP-Magento-Facebook integration on Ubuntu

OpenERP Appliance & All-In-One & Magento Forum

Magento E-commerce management using OpenERP

The new magentoerpconnect module is now included in this release of OpenERP installer for Ubuntu. An installer for Magento 1.4.0.1 on Ubuntu >= 9.04 is also available on this post. Both scripts cannot be run on the same ubuntu system.

Social shopping: Magento-Facebook integration

Links of interest

https://launchpad.net/magentoerpconnect
Which openERP integration to use
Some basic questions about your magento-openerp connector
Magento extension for multiwebsite OpenERP connector by Open Labs
Zend and Varien Partner to Deliver an All-In-One PHP and Magento eCommerce Solution

November 6, 2009 Posted by | ERP, Scripting, Social Shopping, Turnkey, Ubuntu Desktop, Ubuntu Server Canonical | , , | 9 Comments

Instalador y actualizador gráfico de OpenERP Spain para Ubuntu (descarga última versión estable de launchpad)

OpenERP Appliance & All-In-One Forum

Click here to view this post in English

El siguiente script de software libre automatiza la instalación y actualización de openerp-server, openerp-client, openerp-web, openerp-addons y openerp-extra-addons para Ubuntu 8.04 LTS, Ubuntu 9.10 y Ubuntu 10.04 LTS (Desktop ó Server):

  • openerp-allinone-setup.sh : Instala o actualiza las última ramas (branch) estables ó trunk (desarrollo) disponibles en launchpad.net. Incluye opcionalmente las ramas en desarrollo openerp-spain, magentoerpconnect, report-openoffice y openetl.
  • Mayo 2010: El nuevo módulo pxgo_openoffice_reports, una mejora con respecto a report-openoffice, se encuentra disponible en extra-addons. Para su instalación seleccionar “report-openoffice” en el all-in-one para ubuntu, activando posteriormente el módulo pxgo_openoffice_reports desde el cliente openerp (sin cargar el módulo report-openoffice).
  • 15 Mayo 2010:  OpenERP Appliance disponible!! Esta es una importante mejora con respecto al all-in-one para linux, muy recomendable para entornos de pruebas y producción. No requiere conocimientos técnicos. Disponible aquí.
  • 27 Mayo 2010: OpenERP 6 trunk appliance disponible para pruebas.

17 Febrero 2010: Hay un problema al instalar openerp trunk con este script: /usr/bin/openerp-server no es creado y es necesario volver a instalarlo con uno de los dos procedimientos siguientes: 1) Ejecutando nuevamente el script, como si fuera una actualización, pero haciendo click en “Cancelar” al no encontrar nuevas actualizaciones y proceder con la reinstalación. 2) Manualmente desde línea de comandos:

cd /opt/openerp-server

sudo python setup.py install

sudo /etc/init.d/openerp-server start

El objetivo es desarrollar un completo instalador y actualizador gráfico de OpenERP para Ubuntu con un principio KISS y con el último código fuente disponible.

Actual rama estable de OpenERP es la versión 5.0.7 (marzo 2010)

Requisitos: Una nueva instalación de Ubuntu 8.04 LTS, Ubuntu 9.10 ó Ubuntu 10.04 LTS (http://www.ubuntu.com/getubuntu/download)

El proceso de instalación puede ser tan simple como responder “Aceptar” ó “OK” en cada pregunta. Es necesario introducir la clave de usuario (sudo).

Consejo: probar este script dentro de una Máquina Virtual tras instalar Ubuntu 8.04 LTS Desktop ó Ubuntu 9.10 Desktop. Tamaño mínimo de la máquina virtual: 5 GB (apurando mucho) – 6 GB (1GB libre en un Ubuntu Desktop con un completo openerp). Ubuntu Server requiere menos espacio al no disponer de interfaz gráfica. Ejecutar la máquina virtual en una bridged network: host y guest comparten misma subred y son accesibles desde la red local (LAN).

Ubuntu Desktop (para iniciados en Linux ó usuarios interesados en escritorio con interfaz gráfica): Ejecutar el script desde el escritorio

  1. descomprimir el fichero
  2. click derecho en el icono de openerp-allinone-setup.sh
  3. click en ” Propiedades”
  4. click en pestaña “Permisos”
  5. click en la casilla de verificación “Ejecución: Permitir ejecutar el archivo como un programa”
  6. click en “Cerrar”
  7. doble click en el icono y “Ejecutar en un terminal” ó “Ejecutar”: OpenERP será instalado en la primera ejecución. Una vez instalado, el script actualizará OpenERP si se vuelve a ejecutar con doble click (siempre y cuando existan nuevas actualizaciones).
  8. El fichero OpenERP-README.txt incluye los pasos siguientes a configurar en OpenERP desde el cliente Web ó GTK

Ubuntu Server (para usuarios avanzados no interesados en escritorio con interfaz gráfica): Durante la instalación de Ubuntu Server no seleccionar software a instalar como LAMP Server ó PostgreSQL Server en el menú “Selección de Software” (a excepción de SSH Server). Ejecutar el script como no-root con los siguientes comandos en una sesión SSH con X11 Forwarding

  1. Crear una sesión de shell seguro (SSH) con X11 Forwarding:
  2. Transferir el script a Ubuntu Server. Dos opciones:
  3. gzip -d openerp-allinone-setup.sh.gz
  4. chmod +x openerp-allinone-setup.sh
  5. ./openerp-allinone-setup.sh
  6. Salir de la sesión SSH:
    • exit
  7. Iniciar de nuevo una sesión SSH con X11 Forwarding:
    • Linux o Mac: ssh -X usuario@yourubuntuserver8.04
  8. ./openerp-allinone-setup.sh
  9. OpenERP será instalado en la segunda ejecución, y se actualizará de aquí en adelante si el script es ejecutado de nuevo.
  10. El fichero OpenERP-README.txt incluye los pasos siguientes a configurar en OpenERP desde el cliente Web ó GTK

Información adicional:

  1. Se recomienda Ubuntu 8.04 LTS para OpenERP en entornos de producción
  2. El Control de Calidad de OpenERP realizado por Tiny y Axelor se desarrolla en plataformas Debian Etch y Ubuntu Hardy (versión 8.04 LTS)
  3. Durante el proceso de instalación se muestran las direcciones IP disponibles en el sistema. La primera es seleccionada por defecto.
  4. En el directorio /opt se descarga el software de OpenERP a compilar e instalar
  5. Apache es configurado como frontal de OpenERP Web y redirecciona todo el tráfico HTTP entrante a HTTPS (HTTP Seguro). El mensaje de error “invalid security certificate” que aparece en su navegador Web es correcto porque el certificado SSL es de prueba.
  6. Se configura el firewall de Ubuntu con los siguientes puertos abiertos: SSH, HTTP, HTTPS, 8069 & 8070 (para el acceso remoto de los clientes GTK de OpenERP).
  7. Se crean los scripts de inicio (startup/init scripts) para openerp-server y openerp-web.
  8. Se crean en el Escritorio los iconos para openerp-client y openerpweb URL.
  9. Se crea el fichero OpenERP-README.txt con instrucciones para comenzar la configuración de la Base de Datos desde el cliente Web ó GTK de OpenERP.
  10. Se crea el fichero OpenERP-updates.txt con registros de las revisiones instaladas ó actualizadas. Esto resulta útil para mantener un control de las actualizaciones.
  11. El actualizador de OpenERP funciona ejecutando “bzr missing” y “bzr pull”.
  12. Los siguientes mensajes pueden ser ignorados (ref #1, ref #2) durante la instalación si se ejecuta el script en un Terminal:
    /usr/lib/python2.5/distutils/dist.py:263: UserWarning: Unknown distribution option: ‘console’ warnings.warn(msg)
    /usr/lib/python2.5/distutils/dist.py:263: UserWarning: Unknown distribution option: ‘windows’ warnings.warn(msg)
    /usr/lib/python2.5/distutils/dist.py:263: UserWarning: Unknown distribution option: ‘copyright’ warnings.warn(msg)
    File “build/bdist.linux-i686/egg/pyparsing_py3.py”, line 2470
    except ParseException as err:
    ^
    SyntaxError: invalid syntax
    File “/usr/lib/python2.5/site-packages/pyparsing-1.5.2-py2.5.egg/pyparsing_py3.py”, line 2470
    except ParseException as err:
    ^
    SyntaxError: invalid syntax
  13. Módulo Document: Menú -> Gestion de Documentos -> Navegar por los archivos usando FTP. Por defecto es configurado para localhost (lado del servidor) en el puerto 8021, pero el asistente de configuración puede modificarlo y el usuario abrir el puerto  en el firewall (sudo ufw allow 8021/tcp).

Enlaces de interés:

Capturas de pantalla:

September 27, 2009 Posted by | ERP, Scripting, Turnkey, Ubuntu Desktop, Ubuntu Server Canonical | , , | 97 Comments

OpenERP: The rise of open-source business management software

September 27, 2009 Posted by | ERP, Presentation | , , , | 10 Comments

OpenERP installation: All-in-One for Ubuntu with updates (latest revisions from launchpad)

OpenERP Appliance & All-In-One Forum

Haga click aquí para ver este mismo post en español con infomación de módulos OpenERP Spain

The following open source script automates the setting up and the update of openerp-server, openerp-client, openerp-web, openerp-addons and openerp-extra-addons for Ubuntu 8.04 LTS, Ubuntu 9.10 and Ubuntu 10.04 LTS (Desktop or Server):

  • openerp-allinone-setup.sh : Installs or updates latest stable or trunk branch from launchpad.net with the following optional modules: openerp-spain, magentoerpconnect, report-openoffice and openetl.
  • May 2010: The brandnew pxgo_openoffice_reports module (an improvement over report-openoffice) is available in extra-addons. It can be set up after installing report-openoffice with the all-in-one for linux. Just make sure you don’t load both modules from the openerp client.
  • May 15th 2010:  OpenERP Appliance available!! This is an important improvement over the all-in-one for linux, recommended for both testing and production environments. Non technical knowledge required. Click here to grab it.
  • May 27th 2010: OpenERP 6 trunk appliance available for testing purposes. Click here to grab it.

17th February 2010: There’s a problem with openerp trunk when installed by this script: /usr/bin/openerp-server is not created and has to be reinstalled with one of the following two procedures: 1) Running again the script, like if you were updating openerp, and then “cancel” button to reinstall as no new branches are found. 2) Manually from command line:

cd /opt/openerp-server

sudo python setup.py install

sudo /etc/init.d/openerp-server start

The aim is to develop a graphical installer and update mechanism of OpenERP for Ubuntu with a KISS principle and with the latest source code.

Current stable branch is version 5.0.7 (March 2010)

Requirements: A fresh installation of Ubuntu 8.04 LTS, Ubuntu 9.10 or Ubuntu 10.04 LTS (http://www.ubuntu.com/getubuntu/download)

The installation process can be as simple as “Accept” for each question. You will need to type your user password (sudo).

TIP: test this script within a Virtual Machine after installing Ubuntu 8.04 LTS Desktop or Ubuntu 9.10 Desktop from scratch. Minimum virtual machine size of 5 GB space for testing, although at least 6 GB recommended (around 1GB free with a flat ubuntu desktop and full openerp). Remember that Ubuntu Server has even less space requirements. Run the virtual machine in a bridged network: host and guest have same subnet and can be reached from the LAN.

Ubuntu Desktop (for Linux newbies or users interested in having a GUI desktop): Run the script through the Graphical User Interface

  1. uncompress the file
  2. right click on openerp-allinone-setup.sh
  3. click on ” Properties”
  4. click on “Permissions” tab
  5. Click on checkbox “Execute: Allow executing file as program”
  6. click on “Close”
  7. double click on the icon and “Run in a Terminal” or “Run”: OpenERP will be installed during the first execution. OpenERP will be updated from this point onwards if you double click again on the icon.
  8. An OpenERP-README.txt file is created with the remaining steps to be done from the OpenERP client (GTK or Web)

Ubuntu Server (for advanced users not interested in having a GUI desktop): Only the core of the system is needed, so during the installation of your Ubuntu Server don’t select software to install like LAMP Server or PostgreSQL Server in the “Software Selection” menu (except for OpenSSH Server). This script installs Apache and Postgres and expects to deal with default config files. Run the script as non-root user with the following commands in an SSH session with X11 Forwarding

  1. Create a secure shell (SSH) session with X11 Forwarding enabled:
  2. Transfer the script to Ubuntu Server. Two options:
  3. gzip -d openerp-allinone-setup.sh.gz
  4. chmod +x openerp-allinone-setup.sh
  5. ./openerp-allinone-setup.sh
  6. Exit from the SSH session:
    • exit
  7. Start again a new SSH session with X11 Forwarding enabled:
  8. ./openerp-allinone-setup.sh
  9. OpenERP will be installed during the second execution. OpenERP will be updated from this point onwards if the script is executed again.
  10. An OpenERP-README.txt file is created with the remaining steps to be done from the OpenERP client (GTK or Web)

Additional info:

  1. OpenERP on Ubuntu 8.04 LTS (Long Term Support) is recommended for production systems
  2. OpenERP has been tested by Tiny and Axelor on Debian Etch and Ubuntu Hardy (release 8.04 LTS)
  3. openerp-server and openerp-client (>= v5.0.3) are available on Ubuntu 9.10 Karmic Koala as Ubuntu packages: https://launchpad.net/ubuntu/+search?text=openerp
  4. Ubuntu 8.04 does not provide Ubuntu packages for OpenERP but is LTS (Long Term Support). Basically this is why I wrote this script (it makes less sense on newer Ubuntu releases)
  5. During the installation process, available IP addresses are shown to ease the IP address input. The first configured IP is marked as default one.
  6. /opt is the working directory where OpenERP files are downloaded.
  7. Apache is configured as a front-end for OpenERP Web and redirects all the incoming HTTP traffic to HTTPS. The “invalid security certificate” error message in your Web browser is correct as the SSL certificate has been created for testing purposes.
  8. Ubuntu’s firewall is setup with the following ports open: SSH, HTTP, HTTPS, 8069 & 8070 (for remote access of OpenERP GTK clients).
  9. Startup/init scripts for openerp-server and openerp-web are added.
  10. Desktop Icons for openerp-client and openerpweb URL are created
  11. An OpenERP-README.txt file is created with the remaining steps to be done from the OpenERP client (GTK or Web)
  12. OpenERP-updates.txt file is created with records of installed or updated OpenERP revisions. This is useful to be in control of your updates.
  13. This OpenERP Updater works by running “bzr missing” and “bzr pull”.
  14. The following messages can be ignored (ref #1, ref #2) during the installation if you run the script in a Terminal:
    /usr/lib/python2.5/distutils/dist.py:263: UserWarning: Unknown distribution option: ‘console’ warnings.warn(msg)
    /usr/lib/python2.5/distutils/dist.py:263: UserWarning: Unknown distribution option: ‘windows’ warnings.warn(msg)
    /usr/lib/python2.5/distutils/dist.py:263: UserWarning: Unknown distribution option: ‘copyright’ warnings.warn(msg)
    File “build/bdist.linux-i686/egg/pyparsing_py3.py”, line 2470
    except ParseException as err:
    ^
    SyntaxError: invalid syntax
    File “/usr/lib/python2.5/site-packages/pyparsing-1.5.2-py2.5.egg/pyparsing_py3.py”, line 2470
    except ParseException as err:
    ^
    SyntaxError: invalid syntax
  15. Document module: the “Browse Files Using FTP” option is setup by default for localhost (server side) on port 8021. This can be configured with the wizard and by opening that port on the firewall (sudo ufw allow 8021/tcp)
  16. Remember to set up your mail server specified in /etc/openerp-server.conf file if you want OpenERP to send emails.

Links of interest:

Screenshots:

The following two scripts automate the setting up and update openerp-server-5.0.x & openerp-client-5.0.x & openerp-web-5.0.x & openerp-addons-5.0.x & openerp-extra-addons-5.0.x for Ubuntu 8.04 LTS Desktop and Server:* openerp-allinone-setup-stable.sh : Installs or updates latest stable branch from launchpad.net. This is the recommended one.
* openerp-allinone-setup-trunk.sh : Installs or updates latest trunk (development) branch from launchpad.net. Current branch links are not valid (view status of source code trunk and stable: http://openobject.com/forum/topic13013.html)The aim is to provide a graphical installer and update mechanism of OpenERP for Ubuntu Desktop and Server with a KISS principleCurrent stable branch is version 5.0.6 (Sep 22th 2009)Requirements: A fresh installation of Ubuntu 8.04 LTS Desktop or Server (http://www.ubuntu.com/getubuntu/download)TIP: test this script within a Virtual Machine after installing Ubuntu 8.04 LTS Desktop or Server from scratch. Run the virtual machine in a bridged network: host and guest have same subnet and can be reached from the LAN.Ubuntu Desktop: run the script through the Graphical User Interface1. uncompress the file
2. right click on openerp-allinone-setup-stable.sh or openerp-allinone-setup-trunk.sh icon
3. click on ” Properties”
4. click on “Permissions” tab
5. select “Execute: Allow executing file as program”
6. click on “Close”
7. double click on the icon and “Run in a Terminal” or “Run”: OpenERP will be installed during the first execution. OpenERP will be updated from this point onwards if you double click again on the icon.Ubuntu Server: Only the core of the system is needed, so during the installation of your Ubuntu Server don’t select software to install like LAMP Server or PostgreSQL Server in the “Software Selection” menu (except for OpenSSH Server). This script installs Apache and Postgres and expects to deal with default config files. Run the script as non-root with the following commands in a SSH session with X11 Forwarding1. ssh -X user@ubuntuserver8.04
2. gzip -d openerp-allinone-setup-stable.sh.gz
3. chmod +x openerp-allinone-setup-stable.sh
4. ./openerp-allinone-setup-stable.sh
5. exit
6. ssh -X user@ubuntuserver8.04
7. ./openerp-allinone-setup-stable.sh
8. OpenERP will be installed during the second execution. OpenERP will be updated from this point onwards if the script is executed again.The installation process can be as simple as “Accept” for each question. You will need to type your user password (sudo).Additional info:1. OpenERP on Ubuntu 8.04 LTS is recommended for production systems
2. OpenERP has been tested by Tiny and Axelor on Debian Etch and Ubuntu Hardy (release 8.04 LTS)
3. The “invalid security certificate” error message in your Web browser is correct as the SSL certificate has been created for testing purposes
4. Desktop Icons for openerp-client and openerpweb URL are made
5. Available IP addresses are shown to ease the IP address input. The first configured IP is marked as default one
6. An OpenERP-README.txt file is created with the remaining steps to be done from the OpenERP client (GTK or Web)
7. OpenERP-updates.txt file is created with records of installed or updated OpenERP revisions. This is useful to be in control of your updates.
8. Update process is now working by running “bzr missing” and “bzr pull” (Sep 22th).
9. Note for those who already downloaded stable extra-addons branch: Change of name due to bzr_set.py. Change the parent location and bound location in your .bzr/branch/branch.conf file. Changes: stable_5.0_extra-addons to stable_5.0-extra-addonsScreenshots:

September 15, 2009 Posted by | ERP, Scripting, Turnkey, Ubuntu Desktop, Ubuntu Server Canonical | , , | 232 Comments

OpenERP 5.0.3 on Ubuntu All-in-one installer For Dummies

OpenERP Appliance & All-In-One & Magento Forum

This script automates the setting up of openerp-server-5.0.3 & openerp-client-5.0.3 & openerp-web-5.0.3 & openerp-addons-5.0.3 for Ubuntu 8.04 LTS Desktop

The Goal is to provide a graphical installer of OpenERP for Ubuntu Desktop with a KISS philosophy

This post is obsolete! This script doesn’t work any longer as openerp v5.0.3 is out of date and not available at openerp.com. Please consider the new script and post: OpenERP 5.0.5 on Ubuntu All-in-one installer & updater For Dummies: http://bit.ly/3RL7Sa

Requirements: A fresh installation of Ubuntu 8.04 LTS Desktop (http://www.ubuntu.com/getubuntu/download)

Run the script through the Graphical User Interface:

  1. uncompress the file
  2. right click on openerp-allinone-setup-5.0.3-GUI.sh icon
  3. click on ” Properties”
  4. click on “Permissions” tab
  5. select “Execute: Allow executing file as program”
  6. click on “Close”
  7. double click on the icon and “Run”

The installation process can be as simple as “Accept” for each question. You will need to type your user password (sudo).

Additional info:

  1. OpenERP on Ubuntu 8.04 is recommended for production systems
  2. Desktop Icons for openerp-client and openerpweb URL are made
  3. Available IP addresses are shown to ease the IP address input. The first configured IP is marked as default one
  4. An OpenERP-README.txt file is created with the remaining steps to be done from the OpenERP client (GTK or Web)

Screenshots:

September 9, 2009 Posted by | ERP, Scripting, Turnkey, Ubuntu Desktop | , , | 10 Comments

HOWTO Backup OpenERP

For saving OpenERP you need to backup the Database with your data.

From the GTK openerp-client menu

  • File-> Databases->Backup Database

Then you can restore it after saving from the same menu:

  • File-> Databases->Restore Database

From the OpenERP Web login screen

  • Databases -> Backup / Restore

pgAdmin III

A complete OpenERP database can be moved using PostgreSQL’s native backup/restore mechanism. Apart from the command line, the easy and straightforward way is to use pgadmin3 (GUI admin tool). Run pgadmin3, then connect to the database server, right click on the database name and select Backup from the contextual menu. I recommend to use COMPRESS mode (native and efficient) to save the backup. Still using pgadmin3, connect on the destination server, create a new database, right click on its name and select Restore.

Virtualization

Consider virtualizing your OpenERP installation. This would allow you to redeploy OpenERP by cloning your OpenERP’s virtual machine.

One great virtualization solution and probably the easiest way to set up a virtual machine in Linux is KVM, already available in Fedora 11 and the new Red Hat Enterprise Linux 5.4. KVM is intregated in the Linux kernel and virtual machines can be easily deployed with virt-manager and Virtual Network Editor (GUI tools). CentOS 5.4 & ScientificLinux 5.4 (RHEL clones) will be available in 2-4 weeks.

System Backup and Bare-Metal Restore on Linux platforms

You can also backup your OpenERP Software for bare-metal recovery:

https://opensourceconsulting.wordpress.com/2009/09/05/installing-mondorescue/
https://opensourceconsulting.wordpress.com/2009/09/05/linux-p2v-physical-to-virtual-migrations-using-mondorescue-by-hewlett-packard/
http://www.mondorescue.org/
http://mkcdrec.org/
http://www.clonezilla.org/

References:

http://www.postgresql.org/docs/8.3/interactive/backup.html
http://www.openerp.com/forum

September 6, 2009 Posted by | Backup, ERP | | 8 Comments

Adding OpenERP 5.0 Modules for Spain on Ubuntu 8.04 LTS (in Spanish)

En este blog se ha facilitado un script de instalación de OpenERP 5.0 en Ubuntu 8.04 LTS Server & Desktop.

El siguiente paso es generar un plan contable e impuestos desde la plantilla correspondiente a nuestro país. Actualmente no figuran como oficiales los módulos OpenERP para España, así que será necesario descargarlos desde launchpad.net (alojamiento de código fuente que utiliza el sistema de control de versiones Bazaar).

24 Septiembre 2009. El nuevo instalador de este blog incluye stable_5.0-extra-addons, en cuyo caso resuta prescindible la parte de este procedimiento donde figura trunk-extra-addons. Si se emplea el instalador openerp-spain-allinone-setup-stable.sh también sería prescindible el procedimiento aquí detallado de descarga e instalación de módulos openerp-spain.

Descarga de las versiones más recientes de los módulos openerp-spain y trunk-extra-addons. Copiamos los nuevos módulos al directorio /usr/lib/python2.5/site-packages/openerp-server/addons

cd /opt
sudo bzr branch lp:openerp-spain
sudo chown -R openerp.root openerp-spain
sudo cp -r openerp-spain/l10n_es/* /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r openerp-spain/l10n_es_extras/* /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r openerp-spain/l10n_es_ES/* /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r openerp-spain/extra_addons/* /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r openerp-spain/l10n_ca_ES/* /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r openerp-spain/l10n_gl_ES/* /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r openerp-spain/l10n_eu_ES/* /usr/lib/python2.5/site-packages/openerp-server/addons

sudo bzr branch lp:~openerp-commiter/openobject-addons/trunk-extra-addons
sudo chown -R openerp.root trunk-extra-addons/
sudo cp -r trunk-extra-addons/account_payment_extension/ /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r trunk-extra-addons/sale_payment/ /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r trunk-extra-addons/label/ /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r trunk-extra-addons/partner_spam/ /usr/lib/python2.5/site-packages/openerp-server/addons
sudo cp -r trunk-extra-addons/smtpclient /usr/lib/python2.5/site-packages/openerp-server/addons

Donde:

* l10n_es_ES para las traducciones al castellano (directorio vacío)
* l10n_ca_ES para las traducciones al català
* l10n_gl_ES para las traducciones al galego (directorio vacío)
* l10n_eu_ES para las traducciones al euskera (directorio vacío)

Desde el cliente OpenERP (Web ó GTK): Administración -> Módulos -> Actualizar Lista de Módulos . Esta opción actualiza la lista de módulos y añade los nuevos en la lista de los “no instalados”.

24 Septiembre 2009-> No aplica en últimas revisiones de openerp-spain: Crear una nueva base de datos desde el cliente OpenERP con la opción de no instalar datos de prueba (de otro modo se generaría un error durante el procedimiento de instalación de los módulos). Una vez creada la base de datos,  NO continuar con el asistente de configuración (hacer click en “Saltar paso” cuando aparezca la pantalla de “Definir ejercicios fiscales y seleccionar plan contable“). De esta manera evitamos los errores que surgirían al instalar la plantilla contable y los ejercicios.

Desde el cliente OpenERP: Administración -> Módulos -> Instalar el nuevo módulo “l0n_ES_pyme_install” y todas sus dependencias.

Crear los topónimos del Estado Español (crear las provincias mediante el asistente que se ejecuta automáticamente al instalar el anterior módulo)

Cear cuentas contables a partir de la plantilla (mediante el menu Gestion financiera/Configuracion/Contabilidad financiera/Plantillas/Generar plan contable a partir de una plantilla de plan contable).

Instalar modulo l10n_ES_pyme_custom y todas sus dependencias (este modulo crea ejercicios para 2009 y 2010).

24 Septiembre 2009. Actualizar módulos de openerp-spain con las últimas revisiones de launchpad.net (en el caso de no emplear el instalador específico para España openerp-spain-allinone-setup-stable.sh):

  • cd /opt/openerp-spain
  • sudo bzr missing
  • sudo bzr pull
  • Copiar nuevamente los módulos a /usr/lib/python2.5/site-packages/openerp-server/addons
  • Actualizar la lista de módulos desde el cliente Web ó GTK de OpenERP

Referencias:

September 4, 2009 Posted by | ERP, Turnkey | | 3 Comments

How to upgrade OpenERP on Ubuntu Linux

Here are my steps to upgrade OpenERP from 5.0.2 release to 5.0.3 on Ubuntu Linux. Please note this procedure only applies when OpenERP 5.0.2 was previously installed from source code (.tar.gz files). This upgrade is easy because both releases share the same Python libraries. This procedure is expected to work with the next OpenERP releases.

TIP: Copy and paste the following lines on a linux terminal

cd /opt
sudo apt-get install wget -y
sudo wget http://www.openerp.com/download/stable/source/openerp-server-5.0.3.tar.gz
sudo wget http://www.openerp.com/download/stable/source/openerp-client-5.0.3.tar.gz
sudo wget http://www.openerp.com/download/stable/source/openerp-web-5.0.3.tar.gz
sudo tar xvzf openerp-server-5.0.3.tar.gz
sudo tar xvzf openerp-client-5.0.3.tar.gz
sudo tar xvzf openerp-web-5.0.3.tar.gz
cd /opt/openerp-server-5.0.3
sudo python setup.py install
cd /opt/openerp-client-5.0.3
sudo python setup.py install
cd /opt/openerp-web-5.0.3
sudo python setup.py install

August 26, 2009 Posted by | Backup, ERP, Linux, Procedure, Ubuntu Desktop, Ubuntu Server Canonical | , | 10 Comments