hi thanks for your tutorial i inherit product.template model in my module and add new field on it. and i want to show value of this new field in BoM & Structure report. i add column to report but i couldn't pass value in right position in table how can i pass value of this field to xml file and compute on it?
Hi @Odoo Mates Thank you for the explanation. How to download multiple pdf files from tree view ?? not in single pdf file Can you just help me out with any suggestion or reference link??
how i can insert data from query. i am doing that. self.env.cr.execute("insert into scms_equ_count(equipment_catagory,tcount) values(select equipment_catagory,count(*) from scms_company_equipment group by equipment_catagory)") self.env.cr.commit()
Excuse me, i'm trying to follow your interesting tutorial but i'm not able to print messages on pycharm console. How can i do this? What i have to setup on pycharm and/or in odoo.conf? Thanks a lot
@@OdooMates my console seemed to be frozen maybe because pycharm and the odoo service had been running for several days. i restarted pycharm and the project and now i see the messages. Thanks for your help
Hola! Saludos desde Paraguay! Soy nuevo en Odoo13 No encuentro un tutorial bien detallado y claro de como imprimir en letras el total de la factura de cliente, impreso desde el POS. Tenes algo hecho o podrias hacerlo? Gracias!!!!
@@OdooMates Asi mismo, si lo muestra, el tema es que yo cree una factura personalizada y reemplaze todo codigo Qweb y en ese codigo no pude lograr imprimirlo en letras... Me seria de mucha ayuda si me das una mano con esto.
@@OdooMates Gracias por tu buena predisposicion y tu respuesta, ese link ya lo mire una y otra vez, yo trato de solucionar a travez de las vistas Qweb especificamente report_invoice_document, incluso tengo la funcion en python num2word.py que recibe el numero y devuelve en letras, pero no halle en ninguna parte hay algo que explique como llamar desde la vista QWeb esta funcion... :( de manera detallada y simple.
Hi.. really appreciate your efforts... Thanks I have installed odoo on my local system (windows 10)... I am having an issue... my pdf reports are not getting downloaded instead they get printed in html form and gives this pop-up message: "Unable to find Wkhtmltopdf on this system. The report will be shown in html.". Is there any way I can fix this? I have already installed "Wkhtmltopdf". Some online solutions say to add path in some conf file somewhere inside odoo directory... I have added path to installed Wkhtmltopdf in multiple config files but no success..Please help..
@Odoo Mates i have done all after so much trys all done thanks for such videos.
welcome :)
@@OdooMates Odoo Mates, I want to sum and count values and pass to pdf report can you help me?
i can print qweb report in any language but it not working in arbic ?
hi
thanks for your tutorial
i inherit product.template model in my module and add new field on it.
and i want to show value of this new field in BoM & Structure report. i add column to report but i couldn't pass value in right position in table
how can i pass value of this field to xml file and compute on it?
do you have any video create report through quires?
We haven't added yet
@@OdooMates please make video on that or if have material or link on that plz share
hi i inherit a report and want to call a python function so in python file what should be report name?
Hi @Odoo Mates
Thank you for the explanation.
How to download multiple pdf files from tree view ?? not in single pdf file
Can you just help me out with any suggestion or reference link??
We haven't made a video on it, yet, but its easy, have you checked the working of sale/quotation report ?
how i can insert data from query. i am doing that.
self.env.cr.execute("insert into scms_equ_count(equipment_catagory,tcount) values(select equipment_catagory,count(*) from scms_company_equipment group by equipment_catagory)")
self.env.cr.commit()
INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway');
www.w3schools.com/sql/sql_insert.asp
hi how I can add the total amount in word in the exiting pdf invoice report
ruclips.net/video/l2tvrpfOR1E/видео.html
_get_report_values() function is not called when printing. please reply about the issue. I'm using odoo11. render_html() functinon is not working also
In v11 it is get_report_values
@@OdooMates Thank you
Gracias por compartir tanto conocimiento. Me gustaría un tutorial en el cual se modifique el pos sale
Gracias por los comentarios, seguro que lo agregaremos. Espero que te guste, suscríbete y apoya el canal
I want to calculate values against some field in report how i can do that.like i want add value of fields.
Thanks
from the python function you can calculate and return the value to the template
@@OdooMates thanks. i am new on odoo.
How i can pass parameters to report. to filter. any video on that? Thanks.
Hiii odoomate... Thanks for your videos...
Do you know how to print many2one field using this method... I coldn't get the values.
can i see how you tried
@@OdooMates classroom = self.env['class.room'].search([('subject_id','=',i.id)])
print("classroom",classroom)
class_lines =[]
for name in classroom:
vals={
'student_name':name.student_name
}
class_lines.append(vals)
print(name.student_name)
print("classroom",classroom)
print("class_lines",class_lines)
student_name is a many2one field
@@thanshidhap.p4743 use student_name.name
@@thanshidhap.p4743 then use student_name.name
Excuse me, i'm trying to follow your interesting tutorial but i'm not able to print messages on pycharm console. How can i do this? What i have to setup on pycharm and/or in odoo.conf? Thanks a lot
Are you running Odoo with pycharm itself ?
ruclips.net/video/p7SJW36lqVE/видео.html
@@OdooMates my console seemed to be frozen maybe because pycharm and the odoo service had been running for several days. i restarted pycharm and the project and now i see the messages. Thanks for your help
@@0039048 cool, happy that you have found the solution
It doesn't seem to work on Odoo 15
in odoo15 it is: _get_report_values
@odoo Mates
can you have code for qweb report ,that when there is data missing in recored ,then a message display to user to fill the unfilled field
you mean to show some validation message without printing the report ?
my function is not calling while printing report.i am trying to print massage but its not coming. Please help. thanks
is the function is written properly ? like class name should be same as report template
@@OdooMates yes all written fine. but on report parameters are not coming
no data showing in report dont now what issue
from odoo import api, models, _
class ReportPmService(models.AbstractModel):
_name = 'report.scms.report_pmreport'
_description = 'first PM Service Report'
@api.model
def _get_report_values(self, docids, data=None):
docs = self.env['scms.company.pm'].browse(docids[0])
equipments = self.env['scms.company.equipment'].search([('company_name','=',docids[0])])
equipment_list = []
for eqi in equipments:
vals = {
'name': eqi.company_name,
'eqi_desc': eqi.equipment_desc,
'eqi_spec': eqi.equipment_spec,
}
equipment_list.append(vals)
return {
'doc_ids': docids,
'doc_model': 'scms.company.pm',
'data': data,
'equipment_list': equipment_list,
}
Excellent content, when you upload a video on how to download a report from the website
Good day, this video is helpful , kindly advise if Hospital management module can be shared ?
github.com/odoomates/Development-Tutorials
@@OdooMates can you please update the github with this new python file patient_card.py in reports folder thanks
@@neilsenarnachellum166 Sure we will do it now
@@neilsenarnachellum166 Done
@@OdooMates Thanks
Hola!
Saludos desde Paraguay!
Soy nuevo en Odoo13
No encuentro un tutorial bien detallado y claro de como imprimir en letras el total de la factura de cliente, impreso desde el POS.
Tenes algo hecho o podrias hacerlo?
Gracias!!!!
en el ticket de pos predeterminado o en el informe de la factura, odoo muestra el monto total de forma predeterminada, ¿verdad?
@@OdooMates Asi mismo, si lo muestra, el tema es que yo cree una factura personalizada y reemplaze todo codigo Qweb y en ese codigo no pude lograr imprimirlo en letras...
Me seria de mucha ayuda si me das una mano con esto.
@@edgarlepelblaires www.odoo.com/forum/help-1/how-to-add-amount-in-words-text-to-printed-invoice-83347
@@OdooMates Gracias por tu buena predisposicion y tu respuesta, ese link ya lo mire una y otra vez, yo trato de solucionar a travez de las vistas Qweb especificamente report_invoice_document, incluso tengo la funcion en python num2word.py que recibe el numero y devuelve en letras, pero no halle en ninguna parte hay algo que explique como llamar desde la vista QWeb esta funcion... :( de manera detallada y simple.
how to use groupby in search_count plz help
Read_group will help ?
using this method loading issues coming ..plz do video on retrieving records using queries instead of ORM.
yes for better speed we can fetch data from table using the queries
@@OdooMates how to fatch data from queries?
i found error template not found what to do? plz help
check the given template name is given correctly and imported in manifest file
@@OdooMates thanks brother its working. thanks alote
hi Odoo Mates
Please,
what can we put in the data object
The data you need to get in the template, list, list of dict, character etc
how to do it in the 14 th version
see: ruclips.net/video/4uTmaruVEek/видео.html
hello it very usefull thank you, but how to change the filename ?
I am getting an issues in list only last value is coming?
how you add value to list ?
@@OdooMates problem solved
@@OdooMates thanks. Can you help me i excute query and now want to create list and send data to report
@@abduljabbar8383 happy to know it
@@abduljabbar8383 what issues you face here ?
Hi.. really appreciate your efforts... Thanks
I have installed odoo on my local system (windows 10)... I am having an issue... my pdf reports are not getting downloaded instead they get printed in html form and gives this pop-up message: "Unable to find Wkhtmltopdf on this system. The report will be shown in html.". Is there any way I can fix this? I have already installed "Wkhtmltopdf". Some online solutions say to add path in some conf file somewhere inside odoo directory... I have added path to installed Wkhtmltopdf in multiple config files but no success..Please help..
Hi, first of all we are not good in windows, still if you can find the odoo configuration file, there is something like setting the bin path
first of all be sure if any pdf editor is installed in your system, if not , install one (any pdf reader).
second in your template: try to change in:
i hope it help you
@@wadhajable thanks for helping
ValueError: External ID not found in the system: SCMS.report_pmreport, I am getting this error when running report. please help
is there a template/record with the name report_pmreport inside the module SCMS ?
amazing
Thank you! Cheers!