66.How To Create Excel Report From Wizard In Odoo14 || Odoo Excel Reporting

[@ahmedsamy3509]

Appreciate your effort 🙏

[@OdooMates]

So nice of you

[@liker9170]

please tell me that, is this video for previous versions of odoo, i am using odoo18 do i have do the same procedure because i have import and export oprtions for excel in my version.

[@parulsharma7474]

when i tried to print in xls report for a in rec['installment_lines']: sheet.write(row, col + 8, str(a['total'])) i got error (TypeError: 'int' object is not subscriptable) what i have to do?

[@OdooMates]

Is it resolved? What is the value inside the rec['installment_lines'] ?

[@muhammadkamal9245]

Hello Sir , I appreciate your efforts and I have question can we generate pdf report and xlxs for sale register mean i have report in xlsx which show sale register can i generate pdf for sale register?

[@OdooMates]

you mean whether we can convert excel report to pdf ?

[@ahmedahmed-mc7jc]

Hello, can I contact you privately?

[@sanjukriplani502]

Hello sir , Thank You so much for this playlist... Sir i want to learn complete odoo, so after this playlist what should i do?...which playlist i should watch or what is better way to learn professional odoo development?...

[@OdooMates]

if you complete the odoo14 playlist, just go through the odoo12 playlist having 150 videos, dont watch all the videos, see the video topic and see the videos that you havent explored yet

[@sanjukriplani502]

@@OdooMatesOkay Thank You Sir..

[@bunhinciong8832]

Hi Odoomates, nice tutorial Thank you. Would you please create tutorial for creating html views, pdf report and excell report without fill into database but directly generated from sql query or python code

[@ahmedahmed-mc7jc]

Hello, can I contact you privately?

[@vanessadundee9255]

When I click on the button „print excel“, then there won’t get an excel sheet printed. But there comes no error and I did the same code as you

[@OdooMates]

Can you see the code execution and see how far it goes

[@vanessadundee9255]

Nothing happens when I click on the button. Not even the wizard get closen

[@MSSYUVARAJS]

How to send the report in sales module as a pdf file to sftp linux server using a button or something? If it's not clear let me know

[@OdooMates]

possible to achieve it, generate the pdf from odoo and using python codes, we can store in the specified location

[@chotanawab8071]

nice nd verfy informated video...sir can u plz told me how we are calling the meanu buton as a excel report printing?

[@OdooMates]

thanks brother

[@malikkamil6596]

hello i create a many2many field in wizard for selecting company field appears in wizard when clicked it says You are not allowed to access 'Unknown' (_unknown) records. No group currently allows this operation. Contact your administrator to request access if necessary. help plz i tried but ...

[@OdooMates]

Please share your code here

[@malikkamil6596]

@@OdooMates thanks resolved i appreciate your work your videos are very helpful

[@OdooMates]

[@andrew99682]

Hello, in order to upgrade module in apps menu, add in pycharm configuration "-u "

[@OdooMates]

kzbin.info/www/bejne/e6PdgJyXlKZlZ9k

[@OdooMates]

will try to use it

[@andrew99682]

@@OdooMates you can upgrade it when restart service and not need to specify database name

[@OdooMates]

@@andrew99682 i think we have to specify the db name if we need to update the module only in a particular db

[@andrew99682]

@@OdooMates this will updates the module only in db is selected in conf file, so your pycharm will start wit this code "python odoo.bin -c your_conf_file -u your_module_name"

[@Anjalisharma-zj8ce]

sir how can we add field of another module in xls report

[@OdooMates]

From python code, we can fetch data from any modules using odoo orm,

[@Anjalisharma-zj8ce]

sir, how to sum(total) one2many filed in xls report in oodo

[@OdooMates]

if your one2many field name is line_ids and having a field amount in the o2m lines, to get the sum, you can do as follows: total = sum(self.line_ids.mapped('amount'))

[@AndresDawidowicz]

The report action does not work for me, it does not give me an error and it never goes through there, in Odoo16, please help, thank you

[@mujahidahmed11]

Hello, if i write any code under data={ } i am getting this error TypeError: object of type 'NoneType' has no len(). data is getting printed in the terminal but showing an error in odoo ui . iam using odoo14 .how can i solve this?

[@OdooMates]

may be issue with the code you added inside data ? followed same as in the video or ..

[@mujahidahmed11]

@@OdooMates thanks for replying. and yes i followed the same as in the video

[@mujahidahmed11]

when i dont pass any value inside the data{} then a empty xls report is generating. if i pass data as in your video , that error is coming.

[@OdooMates]

@@mujahidahmed11 can you install this module and see whether it works fine ? github.com/odoomates/odooapps/tree/14.0/om_hospital

[@mujahidahmed11]

@@OdooMates yes it is working fine. but there is no wizard for an excel report in your module. that's where im getting problem. rest is working fine in my module as well since i have followed your videos.

[@MeroCasulli]

hi! great tutorial! how can i change the xlsx filename to a fixed one? lets say "Sales Report.xslx" instead of the module_name...

[@indeveloperid6061]

Is this work on Odoo 12?

[@OdooMates]

yes, it will

[@thaotran8405]

Do you know how to attach this excel file to an email ?

[@OdooMates]

you may have to store it as an attachment in the db, then we can send it over the email

[@santiagocosta1658]

How can I fix error 414 query to large, this happens when i print the xlxs...

[@OdooMates]

when you receive this error

[@santiagocosta1658]

@@OdooMates when i print the xlxs from the wizard

[@OdooMates]

@@santiagocosta1658 you used the same method shown in the video or tried something different ?

[@santiagocosta1658]

@@OdooMates I used the same method, but I work with a lots of data because the report is from invoices

[@santiagocosta1658]

Hello, how can i change the name of the xls file ? Thanks in advance

[@OdooMates]

dynamic name or a specific name for all reports ?

[@santiagocosta1658]

@@OdooMates dynamic or specific but for this kind of report created by xlsx.

[@futhedude4848]

@@santiagocosta1658 I'm looking for answer of this question too. Do you solved it yet?

[@semarafa]

Nice tutorial! But I have a problem: File "/home/odoo/src/user/report_xlsx/models/ir_report.py", line 18, in render_xlsx raise UserError(_("%s model was not found") % report_model_name) odoo.exceptions.UserError: report.False model was not found If I try to call the report, it´s give this error. How can I solve this?

[@OdooMates]

it is resolved ?

[@semarafa]

@@OdooMates Not yet xS

[@semarafa]

​@@OdooMates Finally! There was a space in the xml report template(report_name field). I removed it, and everything works.

[@osmoh6738]

Hello my friend Can help my please . How to Connect Odoo with Arduino and received data from Arduino to odoo

[@OdooMates]

Will this help ? kzbin.info/www/bejne/n6TNmaqBdrFpaa8

[@AbdelrhmanGouda-g7j]

can i get the source code ??

[@OdooMates]

apps.odoo.com/apps/modules/14.0/om_hospital

[@alidaudi5646]

please upload this module in you github Thank you

[@ivanespinosa9104]

Hello, I followed each step of the video, but it throws me ValueError: Expected singleton: (It happens to me when I add the read in var = self.env['class.name'].search_read([]))

[@OdooMates]

kzbin.info/www/bejne/iKeXZaF8i9OSa7c