Archive for the ‘webERP’ Category

Database name in webERP

Recently we implemented a weberp based solution for one of our esteemed clients. The development server was hosted on apthost and hence we had to manage database from the apthost cpanel. As we are all aware of the fact that cpanel will pre-append the user name of the shared user to the database that you create from it, we wanted weberp to adjust database name according to that (or for that matter, what ever may be the reason for you to chose a different database name. In case you are interested in looking at other solutions, do checkout our post on open source erp solutions. Weberp supports multiple companies in one installation and hence there can be multiple databases. The trick here is that the name of the database must match the name of the sub-directory in the companies folder. We have been getting a lot of queries on if we can change the association of sub-directories with the database name in the webERP. Unfortunately as of weberp version 3.11, There is still no getting around the fact that the database name and the sub directory under the company directory should still be identical. In case, you are using webERP thro its web-services, then you would need to make another change for the end points to work correctly. You will need to change the variable $DatabaseName to refer to the name of your database. The variable is defined in apiapi_php.php
Change this to the name of your company and you will be all set to go. Though this is not a proper method and proper implementation should be introduced to specify the name of the company from the API calls, but this works for now. Good Luck with your webERP implementation !!