Español (spanish formal Internacional)English (United Kingdom)

PostHeaderIcon Grants 40% in Andalucia Board for ERP, CRM, POS and Electronic Commerce

Let me inform you of the existence of these grants of up to 40% of the total project cost for implantantación solutions such as:

- Implementation of integrated management system (ERP Software)

- Implementation of e-commerce solution (online shop web)

- Implementation of a management solution for retail, bars or restaurants (TPV)

- Implementation of a solution to improve business process management (CRM software)

Innoempresa SMB Program Andalucía.

Amount: Up to 40% subsidy in implementing ERP software, CRM, eCommerce, Management
Eligible Expenses: Consulting, implementation, software and licenses.
Beneficiaries: SMEs in the Community of Andalusia.
Project Deadline: In various calls to December 30, 2013.

In Hostgreen can arrange free presentation of these grants to the Agency Idea (Junta Andalucía) for the development and implementation of any of these projects with us from one of the free software solutions to implement and we are specialists.


PostHeaderIcon Connection between Openbravo POS and Zen-Cart



Hostgreen has made bridge, a connection, between Openbravo POS and Zen-Cart, a script called "Conector POS-Zen".

In this project as a basis for innovation we had two solutions that until now had not been integrated together - Openbravo POS and Zen-Cart. To do this, we made a script that will run at a frequent pace to synchronize and determine the definition of the product offering and stock.

These two solutions (Openbravo POS and Zen-Cart) function completely autonomous and the synchronization point in the supply of products is run through our script, so that all stock and POS products which are available are automatically uploaded to the online store. This is the fundamental task of our script "Connector POS-Zen".

On a technical level there is integration with tables’ categories and products in both applications. Master data is in POS database.

The synchronization process will automatically upload all categories, articles, photos that illustrate items and stock available to the Zen-Cart solution avoiding duplicates to keep the offer in the online store effortlessly, here is where optimization lies to achieve this project. For example as a product runs out at the POS after a sale, this will be reflected in the online store with a sign "product not available" and prevent the online purchase at that time from the web.

The "Connector POS-Zen" script basically makes a sweep in the product tables that exist in Openbravo POS and proceeds to update this information on the basis of Zen-Cart MySQL data which is available online. All existing categories, new products released, stock available would be updated at the time for these products.

This script requires having an open port on hosting of MySQL server on the Internet to access the database dump of Zen-Cart and all information remotely. The script was developed on Java platform, which is platform of Openbravo POS. Our script resides on the machine or PC which runs Openbravo POS. There is a possibility in the Openbravo POS for each product that discharged a mark to indicate whether the product is uploaded or not to the Internet, it covers the needs for power control which products are finally published in its online store. So we can easily check and uncheck from Openbravo POS product if it is sold on the Internet or not.

In the local PC, where the POS system will have a windows scheduled task (cron in Linux case) will call our script for automatic upload in product offering and the photographs illustrating these within the Openbravo POS to be viewed in the online store. Photo upload is carried out via FTP, where our "Connector POS-Zen" moves through each product protocol, uploads this file via FTP to the server of the online store and then moves the image linked to the item recorded in the database.

Configuration parameters required for our script: the data connection to local and remote MySQL database, FTP server account and file path, where the images in the shop are, the local path where the POS is installed. The call rate remains as our script configuration parameter within the task scheduler that invokes cron or scheduled tasks.

Openbravo POS will be used as a POS software for trade

Zen-Cart platform will be used as e-commerce solution, which is available from




PostHeaderIcon SugarCRM vs comparison. vtiger CRM

This comparison is made from our view and experience.

Advantage of VTiger CRM over SugarCRM:

- Supports full sales cycle (budget, order, invoice), database products and services.

- Faster loading times

- According to users improved usability, more intuitive, improved stability, ease of installation, billing module.


Adventages of SugarCRM over VTiger CRM:

- Can be implemented in large companies, VTiger CRM is designed for medium or small companies.

- The agenda module is shared more powerful and integrated with Microsoft Outlook.

- More functionality, support wide range of business processes.

- Increased community support, free nad paid version.

- Block access possibility to information through mobile terminals.

- Increased brand awareness, position leader in its segment.

- The installation of SugarCRM is more reliable and stable than the VTiger CRM.


PostHeaderIcon Procedure for making remote copies via ftp Cobian Backup

COBAIAN BACKUP program (black moon next to the clock on taskbar) has the possibility in addition to moving the backup to "pen drive" (or other hard drive) it can be configured to automatically upload to a FTP account to safeguard your files on the Internet. It is much more comfortable since we abstract from the pen drive but requires that the PC has Internet connection and you to have a FTP account with sufficient size to store your copy (this will cost hosting on a remote server).

In the small manual that I have prepared and attached I present a method to do this configuration though COBIAN. I recommend you to implement it if you want to have an even higher degree of automation and safety in your automated backup. If you currently do not have a hosting provider who has a sufficient size for FTP, let me inform you that we have a special product in Hostgreen for these needs. It is called GreenBackup which gives you an FTP account with 1 GB of capacity and it only costs 55 Euros per year.


PostHeaderIcon Malaga Information LOPD






THE LOPD is the Law 15/1999 of December 13, PROTECTION OF PERSONAL DATA


This law came into force in the month January of 2000, established three deadlines to adapt to it. The last deadline expired on June 26, 2002, so that any company, professional group, association, social club, etc.. Who have not regularized the status of their files to the Data Protection Agency (Public Authority for ensuring compliance) is in breach of legislation, imposing sanctions from 6000 to 600,000 euros.



This Organic Law is to guarantee and protect, with regard to the processing of personal data, civil liberties and fundamental rights of physical persons, and especially their honor and personal and family privacy.




Any file containing personal data (any database, however small, that contains customer names, phone numbers, addresses etc ...), must meet certain requirements and be registered in the Registry Protection Agency , otherwise it violates the applicable law, and is liable to be fined.



The Data Protection Act applies to all employers and professionals as well as to all entities, whether public or private, within the framework of its activities, which seek personal data in the Spanish territory.




Many companies, professional associations, etc.. are being inspected by trade, and have already been fined 600,000 euros, which has resulted in the closure of some.


The number of fines has increased eightfold in just one year, because the Data Protection Agency currently is funded exclusively through sanctions. We should note that it is not neccessary to make big mistakes for being fined, but simply the fact that no discharged APD files are punishable by fines of up to 300,000 euros.

The transfer of files to third parties, outsourcing the payroll preparation process without adequate security measures or lack of backups are some commercial habits by the company sanctioned.

In addition, in connection with the LSSI (Law of Services of the Information Society), a web must have your domain registered in the commercial register, and if you use forms, warn your users that will become part a database and their rights, among other things.



The organizational, legal and technical adaptation of the data files, in the said laws have certain deadlines that must be met . Thus:

  • File-baseline: until March 26, 2000. ATTENTION: The deadline has expired more than 7 years.


  • File-average: Until June 26, 2000..

ATTENTION: The deadline has expired more than 7 years.


  • High-level files: Until June 26, 2002.

ATTENTION: The deadline has expired more than 5 years.


Regarding the Biennial Audits :

  • Files-average : Until June 26, 2002.

ATTENTION: The deadline has expired more than 5 years.


  • High-level Files: Until June 26, 2004.

ATTENTION: The deadline has expired more than 3 years.

Catálogo Productos
Your Cart is currently empty.