iDempiere

ERP to Webstore Integration

Posted on

Inventory is on iDempiere Script to get inventory on CSV File Script to upload CSV File from iDempiere's server to webstore SSH to Remote Webstore to execute update Script Current Problems... Script to Export puts " " on the String.   Products are being doubled because comparison does not work. productImport.php ---> when comparing the […]

OpenERP

Odoo: Super easy Installation

Posted on

From a new Ubuntu Server execute the following commands:   # wget -O - https://nightly.odoo.com/odoo.key | apt-key add - # echo "deb http://nightly.odoo.com/9.0/nightly/deb/ ./" >> /etc/apt/sources.list # apt-get update && apt-get install odoo Thats it!!! You can access the App by going to http://YOURSERVERIP:8069/   Reference: https://www.odoo.com/documentation/9.0/setup/install.html#setup-install-packaged

Shell Scripts

Shell Scripts

Posted on

If you want to execute a Shell Script, that connects to another server and executes another script, this is the nomenclature. Make sure to include the && between each command. ssh root@$SERVERIP 'cd /PATH/TO/SHELL SCRIPT && ./SCRIPT.sh

PostgreSQL

PgSql: pgdump authentication

Posted on

I'm trying to do a backup similar to mysqldump... but it seems that pgsql (very intelligently though) does not allow you to pass pasword on via text on the script. So the solution to be able to execute this command is create a file called ".pgpass" in the folder of the user that will execute […]

iDempiere

iDempiere: Backup the System

Posted on

Requirements: I need to have a working backup of the complete System, what in case of catastrophe I will be able to easily reinstall in another server. I'm not sure what's the best practice to backup this particular system, but for the time being I'll just do an old fashion file backup (I'll backup the […]

Prestashop

Pretashop: Add and Update products Programmatically

Posted on

I'm working on a project where I need to add products from our ERP System to a Prestashop Catalog, and need to regularly mass update (10,000 products) some information on specific product (Pricing, Stock Information etc...) Current Situation: I've managed to create script to import from a CSV and add the files to the DB using […]

iDempiere

iDempiere: Modify Templates

Posted on

I don't like the default document templates that print from iDempiere, and also don't like the built-in "template editor" which to me makes it very complicated and gives me limited possibilities to edit the template I want. So the third and best option is to create an external template using Jasper Studio, put the file […]

iDempiere

IDempiere: Lastest Version (3.1) Installation

Posted on

I'm looking for a robust system basically to manage inventory. I'm working on a project to manage tens of thousands of items (industrial spare parts), all of them virtual, but I need to have a place to store list price, our distributor price, our markup, manufacturer, mfgr contact information and then publish them to our catalogs and […]