OpenERP provides a strong integrated support for the Subscription and Recurring, Subscription is a module that provides and configuration and automatic creating a subscription entries based on the configuration. Recurring is an inbuilt support to atomize a accounting entries like postdated claques and ECS payments. here is a presentation that show you quick configuration for both the systems.
Showing posts with label Tools. Show all posts
Showing posts with label Tools. Show all posts
Sunday, August 1, 2010
Monday, June 21, 2010
Quick Configuration - ServerAction !!
Hello !!
Make your system automated, send email on the confirmation of invoice. please go through presentation to configure server action and smtpclient.
Prepare a Object Operation base on the Server Action soon.. !
Make your system automated, send email on the confirmation of invoice. please go through presentation to configure server action and smtpclient.
Prepare a Object Operation base on the Server Action soon.. !
Fix Messages, in OpenERP Server
Hello,
I am going to write after a long time, I would like to write about one module, which was written since long time, its very simple and useful for end users to remove the warning messages quickly just after installing any new module.
You will be able to get the 2 major warning messages on the OpenERP Server console, its regarding the object "no access rules !" and "no quality certificate".
Quality certificate is one of the good features from OpenERP for the enterprise users to get the surety about the bug fix, and migration. Click here for more information.
Another warning message "no access rules !" can be remove easily, for that you need to install a module "wizard_access_rules" from trunk extra addons.
It will install setup wizard which will run after any upgrade and check for new objects which is installed from he upgrade process, also checks for the security rules.
This wizard will run just after the installing module "wizard_access_rules" and display all object which does not have any rules also read access control will be applied by default, you can change according to your requirements. also you can assign groups.
OpenERP will not display any warning messages related to access controls at next run.
Sunday, June 20, 2010
Are you updated with OpenERP Development ?
Hello !!!
Liferea will updated you for the development process of OpenObject.
Liferea Feed Reader is a really small but great tool for reading the RSS & Atom reader. I got an idea to use it efficiently for getting updated with the OpenERP development and discussion process. Here is a few tricks using Liferea.
The Left first Icon is the Liferea application. It display currently 2 recent unread entries.
You can configure the RSS for the OpenERP RSS resources are configured on my laptop to getting updated with the all development branches. Launchpad is good source of information.
Liferea Feed Reader is a really small but great tool for reading the RSS & Atom reader. I got an idea to use it efficiently for getting updated with the OpenERP development and discussion process. Here is a few tricks using Liferea.
The Left first Icon is the Liferea application. It display currently 2 recent unread entries.
You can configure the RSS for the OpenERP RSS resources are configured on my laptop to getting updated with the all development branches. Launchpad is good source of information.
The Left first Icon is the Liferea application. It display currently 2 recent unread entries.
You can configure the RSS for the OpenERP RSS resources are configured on my laptop to getting updated with the all development branches. Launchpad is good source of information.
Getting Update Project OpenObject
Announcements
http://feeds.launchpad.net/openobject/announcements.atom
Latest Revision
http://feeds.launchpad.net/openobject/branches.atom
Latest Branches
http://feeds.launchpad.net/openobject/branches.atom
Latest Bugs
http://feeds.launchpad.net/openobject/latest-bugs.atom
Forum
http://www.openobject.com/forum/rss.php
Announcements
http://feeds.launchpad.net/openobject/announcements.atom
Latest Revision
http://feeds.launchpad.net/openobject/branches.atom
Latest Branches
http://feeds.launchpad.net/openobject/branches.atom
Latest Bugs
http://feeds.launchpad.net/openobject/latest-bugs.atom
Forum
http://www.openobject.com/forum/rss.php
You can configure the other RSS feeds in the same way to get updated on the Desktop.
Sunday, May 2, 2010
Emails to Documents !!
Hello !!!
After getting a great success with the fetchmail module i get an idea to integrate it with the document module, for that i have already start development a new module document_email which will allow users to create a document directly from the emails only.
I have also thinking to do integrate of fetchmail with the wiki module to write a wiki document through email.
I will write a complete detail very soon about the document_email.
mga@tinyerp.com
After getting a great success with the fetchmail module i get an idea to integrate it with the document module, for that i have already start development a new module document_email which will allow users to create a document directly from the emails only.
I have also thinking to do integrate of fetchmail with the wiki module to write a wiki document through email.
I will write a complete detail very soon about the document_email.
mga@tinyerp.com
Fetchmail Module – Replacement of openerp_mailgate.py
Hello !!
In process parameter model is the most important parameter based on that fetchmail will be able to decide that which object is to be notify when new email arrives in to the system.
I will arrange more screens very soon.
mga@tinyerp.com
www.openerp.com
During the review process i getting touch with the module mail_gateway which was simple migration of code from openerp_mailgate.py to module which seems tightly coupled with the crm module only.
During the process i get a idea to develop a clean module to interact with the emails and easy integration with other modules too.
I have started a development for the same, and it is ready to use now also replaces the module email_gateway. we also required email sending facility, when we are going to make a powerful email receiver like fetchmail to en reach openerp by email functionalities. as we have already module smtpclient that is powerful, and integrated email sending tool.
mail_gateway = smtpclient + fetchmail
Now, we will have a new menu structure when we can access all email services (sending, receiving and queing and history of the same)
Normally emails sending functions is used at many places in erp, crm is the only module in the beginning which act based on email receive. which also take care for the new email or old email continuous conversation. there are so many things to take care if we going to design a generic module for the email receive as email can be a new email or reply of the previous emails which is not always specific to the crm module.
To keep the track of the every in system we design a message history which will histories the very minimal information to identify the email easily and get the reference of the same. Message-Id is the most important value also References is the one more important value to track the continuous communications.
Methods to be supplied in orer to work with fetchmail.
def message_new(self, cr, uid, msg, context):
called by the fetchmail module when new email arrives
def message_update(self, cr, uid, ids, vals={}, msg="", default_act=None, context={}):
called by the fetchmail when reply will come for an continuous communication.
General Configuration of Fetchmail ServerIn process parameter model is the most important parameter based on that fetchmail will be able to decide that which object is to be notify when new email arrives in to the system.
Here, again we are going to use the power of server action feature in Auto Reply field. it will be domain based allow to select only email actions, so that we can easily configure that what and how to reply for the incoming emails.
We can fetch emails by the following protocols
- IMAP without SSL
- IMAP with SSL
- POP3 without SSL
- POP3 with SSL
In both the methods variable msg will be use to describe message in easy and understandable format, so it will be easy for routin programmer to interact with the email easily without doing much processing.
Here are the few fields mapping
Email Fields = OpenERP Fields
Message-ID = id or message-id
Subject = subject
Content-Type = content-type
From = from
Delivered-To = to
Cc = cc
Date = date
Content-Transfer-Encoding = encoding
References = references
X-Priority = priority
Multi part (message text) = body
Multipart (Message Attachments) = attachments
Using the openerp field its will be easy to play with the emails data.
Look at the user inbox for the OpenERP support case, its displayed in the threats and not like the previous view each time new emails, now it reference with the previous communications.
I will arrange more screens very soon.
mga@tinyerp.com
www.openerp.com
Sunday, December 6, 2009
How To connect a Mylyn repository to Redmine
Mylyn is an Eclipse plugin for task management.
This HowTo explains how to connect to Redmine using the generic web repository connector.
Note that the generic web repository connector is not part of the default Mylyn install.
So, you have to install it first from the incubator update site (see http://download.eclipse.org/tools/mylyn/update/incubator).
The following Query pattern value reads Status and Tracker fields too (Mylyn 3.2.1) :
<td class="tracker">({Type}.+?)</td><td class="status">({Status}.+?)</td>.+?<td class="subject"><a href="/issues/({Id}\d+)">({Description}.+?)</a></td>
Status is read as "uncomplete" or "complete" in Eclipse.

Redmine-Mylyn Connector is another solution providing better integration with Mylyn
Source Original post: http://www.redmine.org/wiki/1/HowTo_Mylyn
This HowTo explains how to connect to Redmine using the generic web repository connector.
Note that the generic web repository connector is not part of the default Mylyn install.
So, you have to install it first from the incubator update site (see http://download.eclipse.org/tools/mylyn/update/incubator).
Create a Task Repository
- Right-click on the task repositories list and click Add task repository
- Choose Web Template (Advanced) and click Next
- Configure the repository:
You can replace the Query request URL parameter with the following if you want to get only the issues that are assigned to you:Server: http://www.redmine.org -- Replace it with the URL of yourRedmine instanceTask URL: ${serverUrl}/issues/show/New task URL: ${serverUrl}/projects/foo/issues/new -- Replacefoo with the identifier of the project used for new tasksQuery request URL: ${serverUrl}/issuesQuery pattern: <td class="subject">.*?<a href="/issues/show/(\d+)">(.+?)</a></td>Login request URL: ${serverUrl}/login?username=${userId}&password=${password}[POST]
${serverUrl}/issues?set_filter=1&assigned_to_id=meThe following Query pattern value reads Status and Tracker fields too (Mylyn 3.2.1) :
<td class="tracker">({Type}.+?)</td><td class="status">({Status}.+?)</td>.+?<td class="subject"><a href="/issues/({Id}\d+)">({Description}.+?)</a></td>
Status is read as "uncomplete" or "complete" in Eclipse.
Create a Query
- On the task list, right-click and choose New -> Query...
- And select your newly created repository
Redmine-Mylyn Connector is another solution providing better integration with Mylyn
Source Original post: http://www.redmine.org/wiki/1/HowTo_Mylyn
Monday, November 2, 2009
Hiding database name on login
It's important to be able to hide database names from login screen for security purpose, the users who know with Database names can login, for others database name is not accessible.
Now this enhancement is implemented in trunk server and client,
We have an option --list_db on the openobject server to disable the list of Databases,
Run server like:
./openerp-server.py --addons-path=../../../addons/ --list_db=False
If the option has value "False" it will provide a char field instead of having a selection box for the Databases, Or the user can specify database name manually:

To summarize, --list_db=False option on OpenERP server lets us to hide all databases names from client...
Now this enhancement is implemented in trunk server and client,
We have an option --list_db on the openobject server to disable the list of Databases,
Run server like:
./openerp-server.py --addons-path=../../../addons/ --list_db=False
If the option has value "False" it will provide a char field instead of having a selection box for the Databases, Or the user can specify database name manually:
- OpenERP Login Screen with --list_db=False
If the database does not exist, it will raise an error:
After the first connection, the DB name is stored on the ~/.openerprc and on the next login, the char field will be filled with the last database name connected.
The selection list is also removed from "Drop Database" and "Backup Database"To summarize, --list_db=False option on OpenERP server lets us to hide all databases names from client...
Tuesday, September 1, 2009
Base Report Creator – Module
Report Creator
An exciting module for the System Manager, those who have to challenge every day new requirements, for the data collection, using Tiny ERP one can present the Report using the 3 ways, Create a Views, and Graph and Calender on that. this is the simplest way to create any complex display report in tiny. Now Tiny provides an module to do the same function without any code development. you can download base_report_creator is an module available as extra_addons. this will provide the atomized way to create a Report, Graph, and Calender view on your desire data.
Method for creating an report is as follows.
Partner Summary Report
This is a simple report that display the total credit and debit amount for the Partner from the Sales, Expanse, and Bank Journals. after executing the report we can have the filters on the Data to get the Debit, Credit amount in between two dates too.
This is an important report to get the sales turn over for the product in terms of the Quantity and Price. we also have the user wise sales report too.
download the complete documentation to create a same report using the base_report_creator module just configure, without coding,
CRM Case Analysis Report
Tiny CRM and SRM module is multi purpose module that, is designed in such a way that we can
configure and use for multi requirements. it can be used for the
section for the Grouping.
User wise cost and revenue
Section wise cost and revenue
download the complete documentation to create a same report using the base_report_creator module just configure, without coding,
Method for creating an report is as follows.
- Select an Objects (Tiny Objects) from which you want to fetch data.
- Configure the Views - normally it generate the List as a first view, then Graph, but you can change the order of the view and number of views too.
- Select fields which are going to display on the views. (List, Graph, and Calender)
- Apply filter if requirements of specific data.
- Apply the Permission - which user can access this report.
- Create a menu with the permission.
- Give higher priority to the relational objects first. i.e. if you want to create a report for the sales then the important object is Sale Order Line, and after then select the Sale Order if you required more information. so always go for the Object which carry important and huge data.
Partner Summary Report
This is a simple report that display the total credit and debit amount for the Partner from the Sales, Expanse, and Bank Journals. after executing the report we can have the filters on the Data to get the Debit, Credit amount in between two dates too.
download the complete documentation to create a same report using the base_report_creator module just configure, without coding,
Product Wise Sales Report
Product Wise Sales Report
download the complete documentation to create a same report using the base_report_creator module just configure, without coding,
CRM Case Analysis Report
Tiny CRM and SRM module is multi purpose module that, is designed in such a way that we can
configure and use for multi requirements. it can be used for the
- Help desk and Support
- Sales Opportunity
- Marketing and Leads
- Hr Recruitment
section for the Grouping.
User wise cost and revenue
Section wise cost and revenue
download the complete documentation to create a same report using the base_report_creator module just configure, without coding,
SMTP Email client - Automized Email Module
Email Sending Facility in Tiny ERP
Tiny ERP Support the email sending facility from the beginning version, but if we go through this functionalities it seems for the specific purpose, like reply CRM Case, and Mass Mailing, its very easy to configure the smtp-server, user and password while running the TinyERP-Server.
#----------------------------------------------------------
# Emails
#----------------------------------------------------------
def email_send(email_from, email_to, subject, body, email_cc=None, email_bcc=None, on_error=False, reply_to=False, tinycrm=False):
you may found this code in to the tools.misc.py file enables user to send the emails, because of its written for the specific purpose, the limitation of this facility is we can not send the file attachment, can not get the statistic regarding the email sent, and while configuration of the user, password and smtp-server we not get the confirmation like its configured successfully. more over it's better if we put the security on the email sending facility, like only authorized user can send the email.
To get all this facility you can use the a new module which is specifically designed to manage the email address. You can get this module from the https://svn.tinyerp.com/svn/extra_addons/trunk/smtpclient smtpclient is the module name which install the Smtp-Client, History, Objects related to the Statistic for email sending.
More over this module is just used for the configuration by the System Administration, and used by the Tiny Developers, for example developers want the functionalities like when user confirm the Sale Order or Invoice that will be also be used to deliver via Email Immediately. then this provides the surety of the email delivery. because while configuration of the Email Address it performs 2 way checking, first is tiny can send the successfully able to send the email from the provided email address, and second things is when ever content send to recipient that also verify by the Verification code.
System Administrator configure the email address, and ask for the verification, the Verification process send the random generated key to the supplied email address, and after that user have to verify that email address by supplying the verification code. after that all user which have the access to this email address they can send the email using this address.
SMTP Client provides an enhancements to the existing modules like its great if we can send the Sale Order copy in email to the Customer immediately after confirmation of the Sale Order. or Send the Delivery Notes to the Customer after confirmation of the Picking. this kind of functionalities will be available in the extra_addons.
Download complete article
Tiny ERP Support the email sending facility from the beginning version, but if we go through this functionalities it seems for the specific purpose, like reply CRM Case, and Mass Mailing, its very easy to configure the smtp-server, user and password while running the TinyERP-Server.
#----------------------------------------------------------
# Emails
#----------------------------------------------------------
def email_send(email_from, email_to, subject, body, email_cc=None, email_bcc=None, on_error=False, reply_to=False, tinycrm=False):
you may found this code in to the tools.misc.py file enables user to send the emails, because of its written for the specific purpose, the limitation of this facility is we can not send the file attachment, can not get the statistic regarding the email sent, and while configuration of the user, password and smtp-server we not get the confirmation like its configured successfully. more over it's better if we put the security on the email sending facility, like only authorized user can send the email.
To get all this facility you can use the a new module which is specifically designed to manage the email address. You can get this module from the https://svn.tinyerp.com/svn/extra_addons/trunk/smtpclient smtpclient is the module name which install the Smtp-Client, History, Objects related to the Statistic for email sending.
More over this module is just used for the configuration by the System Administration, and used by the Tiny Developers, for example developers want the functionalities like when user confirm the Sale Order or Invoice that will be also be used to deliver via Email Immediately. then this provides the surety of the email delivery. because while configuration of the Email Address it performs 2 way checking, first is tiny can send the successfully able to send the email from the provided email address, and second things is when ever content send to recipient that also verify by the Verification code.
System Administrator configure the email address, and ask for the verification, the Verification process send the random generated key to the supplied email address, and after that user have to verify that email address by supplying the verification code. after that all user which have the access to this email address they can send the email using this address.
SMTP Client provides an enhancements to the existing modules like its great if we can send the Sale Order copy in email to the Customer immediately after confirmation of the Sale Order. or Send the Delivery Notes to the Customer after confirmation of the Picking. this kind of functionalities will be available in the extra_addons.
Download complete article
Friday, June 5, 2009
Check your module’s quality using Quality Module
Hello All,
Now you can check your module's quality using new module added in trunk-extra-addons (base_module_quality).
We have added wizard on Administration/ Module Management/ Modules
Name of the module: base_module_quality
Thanks,
OpenERP Team.
Now you can check your module's quality using new module added in trunk-extra-addons (base_module_quality).
We have added wizard on Administration/ Module Management/ Modules
Salient features of module:
- Check the quality of the module using different criteria (pylint, speed efficiency, coding standard followed by openerp, etc...)
- Evaluate score in percentage (%) for whole module as well as it can provide score for individual tests also
- It can skip some tests if module is not installed in server(workflow test...) so that your score is not go down.
- Use Ponderation value to calculate score.
- It allows you to save the detail result of test (Save Report button)
- Module also provide generic framework to define your own quality test.- For more information (base_module_quality/README.txt)
- Tests available :
- Workflow Test
- Pylint Test
- Speed Test
- PEP-8 Test
- Structure Test
- Terp Test
- Method Test
- Object Test
-
* Sale module tested by Quality Module
- Quality
For more information and screenshots please check the documentation available in base_module_quality/Document/quality.doc
So if you want to increase your module quality, check this module! Enjoy...
You can get these module on launchpad in trunk-extra-addonsName of the module: base_module_quality
Thanks,
OpenERP Team.
Wednesday, June 3, 2009
OpenERP on the Google MAP
Hello Everyone,
We have come up with new features, which gives you flexibility to get your data like, partner information : individual partner information, country wide partner information on Google MAP with just one click. It is very simple to have your data from any OpenERP database on Google MAP.
Now, we have made it easier to trace partners information with name, address, code, receivable and payable, etc on a single click. More over can get data complied with number of invoice made and turnover of country. Also can find delivery routes with customer location / warehouse location with number of delivery and number of product sent.
Delivery routes on google map:
Partners on map:
Partners country On map:
How to use:
- Install Google_earth on your OpenERP database.
- You will find this module at Menu -> Partners -> Google Map / Earth
- You will get
- Customer on map with turnover
- Partners country on map
- Delivery routes find
- By running these wizard, you will get KML file, upload it in your google map account
- Now, enjoy looking at analyzed data on Google MAP.
Thank you,
OpenERP Team.
Thursday, May 28, 2009
OpenERP made language translation easy with Google Translate
Hello,
Now translate OpenERP terms / fields / objects etc. in any language, as we have made it easier for you with the integration of Google Translate.
We have developed new module which can translate your terms using google translate, You can find menu here: Administration / Translation / Application terms / need review terms...
Google Translate


Enjoy using your favorite OpenERP application with Google Translation.
You can get these modules on launchpad in trunk-extra-addon
Name of the module
1. Google_translate
Thanks,
OpenERP Team.
Now translate OpenERP terms / fields / objects etc. in any language, as we have made it easier for you with the integration of Google Translate.
We have developed new module which can translate your terms using google translate, You can find menu here: Administration / Translation / Application terms / need review terms...
Google Translate
After Translation
Enjoy using your favorite OpenERP application with Google Translation.
You can get these modules on launchpad in trunk-extra-addon
Name of the module
1. Google_translate
Thanks,
OpenERP Team.
Friday, May 22, 2009
Faster Html Reports Using Mako Templates
Hello EveryOne,
Now you can create your HTML reports using Mako Templates for faster and formatted output.OpenERP has added new type of report called mako2html. Mako is a template library written in Python. It provides a familiar, non-XML syntax which compiles into Python modules for maximum performance.
Advantages:
- Fast: simple three-sectioned layout mako template report takes 1.10 ms
- Control structures constructed from real Python code (i.e. loops, conditionals) Which will allow user to create reports faster.
- Straight Python blocks, inline or at the module-level
You can format the report as you need using HTML.
Requirements:
- Mako 0.2.4 should be installed on your system.
- openERP-server : Trunk version
- openERP-client : Trunk version
- openERP-addons : Trunk version
As an overview lets see a small example
For your company header you need to include
<%include file="mako_header.html"/>
for your company footer you need to include
<%include file="mako_footer.html"/>
This files will bring the header and footer that you have defined for your company in the database.
For Complete Example of Sale_order please Refer the module sale_report_html from : https://code.launchpad.net/~openerp-community/openobject-addons/trunk-addons-community
Subscribe to:
Posts (Atom)








