whats up man ? it is not what we are busy about , it is about what we busy is it align to our vision for Instant-ERP, a localized Malaysia/Singapore Odoo services ,as i am clearing out my pipeline , i am more free nowadays to share with you whats up with us here ,
we are focusing on these fews ... making our Cloud structure fully integrated with great platform service provider such as AWS ( we are now able to use AWS s3 services for our Instant-ERP that powered by Odoo in the File attachment , we have successfully help clients to migrate their files which saved in the database , if you do not know what this is and you are using Odoo and keep attaching files into your Odoo , take a look at the size of your db , it can be quite AMAZING o ! Wah so Big !!! )
and we have been working on a few offline capable apps , that is Lorry Driver routing , Technician and Job order app which will sync to instantERP's db.
And we are now leverage our skills from Google apps , which we have been using it to automate our GEmails ( yes automate gmail using scripts ) and as we love using Google spreadsheets , in fact , i have long time not using Microsoft excel file anymore ... are you still using Microsoft office ... if you are , you are a bit out liao , as Google has always give us a FOC spreadsheet which capable of doing many wonderful things , include TEAM collaboration and centralized file control. )
So this time , i am going to show you how we can use Google to do lots of things with Odoo , the engine that powers up InstantERP.
some reference first ,
FB, shared this on youtube at 2013 and yes , it is still working in Odoo v7 , 8 and 9 ! https://www.youtube.com/watch?v=P6lkB05Emuo ,
we are using the google spreadsheet API developing some in house reporting and supports process , it works great !
for this to work , you have to setup ,
- 1. url , db name , user login and user password ,
- 2. FIXED some bugs ,make sure your code has been updated to the latest , for me i have to fix minor bugs in the google app scripts , where "session_id" is missing out !
- 3. after you have authorized the scripts , it will be ready to use .
so if our invoices detail is our Odoo ERP server is as follow ,
we have 2 records of invoice and we now can use the Google spreadsheet to pull the data out from Odoo powered instant-ERP data from it ,
and the formula will look something like this ...
=oe_read_group("account.invoice"; "user_id date_invoice amount_total"; "user_id date_invoice"; "[['state','in',['draft','cancel']],['user_id','ilike','"&B43&"'],['partner_id','ilike','"&B44&"']]";; 5; 1)
i have made some changes to the condition , where the original is "not in" instead of "in" , so the draft , it will displayed as the following above , where it detected in the ERP there is a record for Agrolait in the state of draft !
and of course if you enter the name not exists or Salesman not exists in the Odoo database , then it will display something like below ...
or if customer name is not exists in the Odoo database ,
now , imagine , u want to pull data of following ,
- salesman daily sales
- invoice with tag "cashbill"
- stock and product lists
we can in fact help you to develop into a fully functional spreadsheet
reports should you engage our services . Hope this sharing give you some idea of how you can make use of Google Spreadsheet to pull data for analysis from our Instant-ERP platform that powered by Odoo !
so happy Odooing !