Archives
- By thread 1419
-
By date
- August 2019 59
- September 2019 118
- October 2019 165
- November 2019 97
- December 2019 35
- January 2020 58
- February 2020 204
- March 2020 121
- April 2020 172
- May 2020 50
- June 2020 158
- July 2020 85
- August 2020 94
- September 2020 193
- October 2020 277
- November 2020 100
- December 2020 159
- January 2021 38
- February 2021 87
- March 2021 146
- April 2021 73
- May 2021 90
- June 2021 86
- July 2021 123
- August 2021 50
- September 2021 68
- October 2021 66
- November 2021 74
- December 2021 75
- January 2022 98
- February 2022 77
- March 2022 68
- April 2022 31
- May 2022 59
- June 2022 87
- July 2022 141
- August 2022 38
- September 2022 73
- October 2022 152
- November 2022 39
- December 2022 50
- January 2023 93
- February 2023 49
- March 2023 106
- April 2023 47
- May 2023 69
- June 2023 92
- July 2023 64
- August 2023 103
- September 2023 91
- October 2023 101
- November 2023 94
- December 2023 46
- January 2024 75
- February 2024 79
- March 2024 104
- April 2024 63
- May 2024 40
- June 2024 160
- July 2024 80
- August 2024 70
- September 2024 62
- October 2024 121
- November 2024 117
- December 2024 89
- January 2025 59
- February 2025 104
- March 2025 96
- April 2025 107
- May 2025 52
- June 2025 72
- July 2025 60
- August 2025 81
- September 2025 124
- October 2025 63
- November 2025 22
Contributors
-
External access token expiration
Dear communityWith portal module installed, Odoo can send links to documents by e-mail using an access token so that the recipient doesn't need a portal user to see said documents.The token is handled in the portal.mixin https://github.com/odoo/odoo/blob/15.0/addons/portal/models/portal_mixin.py#L15Access to the document is handled through this controller: https://github.com/odoo/odoo/blob/15.0/addons/portal/controllers/mail.py#L206Now, it's been multiple time customer are requiring to expire this token one way or another, because in standard Odoo the document stays accessible forever. The only solutions I could come up with without having to change everything are described below (extracted from personal notes):That means, to restrict the validity of the token that was sent in the mail, the token set on the record that is accessed needs to change after a "validity period". The issue with this, is if the link for a same record is sent multiple times during a single "validity period", the availability will not be the same. For example, if we want to define that access tokens are recomputed every 30 days, someone receiving an e-mail 5 days after the token was recomputed would be able to access the document for 25 days, and someone receiving an e-mail 25 days after the token was recomputed would be able to access it only for 5 days.
A slightly better solution without changing everything but probably more tricky to implement properly, would be to add a new Datetime field next_access_token_refresh on portal.mixin (or another mixin to be inherited on selected models in order to control the application by model) and set it XXX days in the future (according to a server parameter) each time we need to set the access token in an email. If we define the availability to 30 days, that means if a mail is sent to access the same document to a first external user today and to a second external user in 15 days, the first external user would be able to access it during a period of 45 days.
Did anyone here face a similar requirement? How did you handle it?
Ideally, we would need a single token to be generated per e-mail being sent so that we can define the expiration of said token, but it seems like there's no other solution than to overwrite and redefine everything, what I would prefer to avoid to ease maintenance of such a module.
Thanks for sharing your insights.
camptocampINNOVATIVE SOLUTIONSBY OPEN SOURCE EXPERTSAkim JuilleratBusiness solutionsSoftware architect
by Akim Juillerat - 07:46 - 11 Jan 2024-
Re: External access token expiration
Thanks JohanIt's also a solution I had in mind but one I wanted to avoid. Anyway, I guess it will be the only option to have something reliable and that we can control over time.camptocampINNOVATIVE SOLUTIONSBY OPEN SOURCE EXPERTSAkim JuilleratBusiness solutionsSoftware architectOn Fri, Jan 12, 2024 at 10:57 AM Johan Van Hirtum <notifications@odoo-community.org> wrote:Dear,
I don’t use this. But I would make the token field on the document a ‘to many’ field. You create a token, each time you send a document. The tokens get a expire field. And a simple cron job deletes each day the expired tokens. This gives you the required function with little rewrite and practical no penalties : the solution stay the same for the user, there is practically no extra memory or processing needed. So this could maybe be the standard for this modules -)
With kind regards,
Van Hirtum Johan
Van: Akim Juillerat [mailto:notifications@odoo-community.org]
Verzonden: donderdag 11 januari 2024 19:48
Aan: Contributors
Onderwerp: External access token expirationDear community
With portal module installed, Odoo can send links to documents by e-mail using an access token so that the recipient doesn't need a portal user to see said documents.
The token is handled in the portal.mixin https://github.com/odoo/odoo/blob/15.0/addons/portal/models/portal_mixin.py#L15
Access to the document is handled through this controller: https://github.com/odoo/odoo/blob/15.0/addons/portal/controllers/mail.py#L206
Now, it's been multiple time customer are requiring to expire this token one way or another, because in standard Odoo the document stays accessible forever. The only solutions I could come up with without having to change everything are described below (extracte d from personal notes):
That means, to restrict the validity of the token that was sent in the mail, the token set on the record that is accessed needs to change after a "validity period". The issue with this, is if the link for a same record is sent multiple times during a single "validity period", the availability will not be the same. For example, if we want to define that access tokens are recomputed every 30 days, someone receiving an e-mail 5 days after the token was recomputed would be able to access the document for 25 days, and someone receiving an e-mail 25 days after the token was recomputed would be able to access it only for 5 days.
A slightly better solution without changing everything but probably more tricky to implement properly, would be to add a new Datetime field next_access_token_refresh on portal.mixin (or another mixin to be inherited on selected models in order to control the application by model) and set it XXX days in the future (according to a server parameter) each time we need to set the access token in an email. If we define the availability to 30 days, that means if a mail is sent to access the same document to a first external user today and to a second external user in 15 days, the first external user would be able to access it during a period of 45 days.
Did anyone here face a similar requirement? How did you handle it?
Ideally, we would need a single token to be generated per e-mail being sent so that we can define the expiration of said token, but it seems like there's no other solution than to overwrite and redefine everything, what I would prefer to avoid to ease maintenance of such a module.
Thanks for sharing your insights.
camptocamp
INNOVATIVE SOLUTIONS
BY OPEN SOURCE EXPERTS
Akim Juillerat
Business solutions
Software architect
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Akim Juillerat - 05:56 - 12 Jan 2024 -
Re: External access token expiration
Thanks Holger for your answer.I'm not sure it would work in our case if said e-mail has to be sent multiple times, but it's an interesting technique I'll try to keep in mind for a later use.camptocampINNOVATIVE SOLUTIONSBY OPEN SOURCE EXPERTSAkim JuilleratBusiness solutionsSoftware architectOn Thu, Jan 11, 2024 at 9:52 PM Holger Brunn <notifications@odoo-community.org> wrote:> Did anyone here face a similar requirement? How did you handle it? > Ideally, we would need a single token to be generated per e-mail being sent > so that we can define the expiration of said token, but it seems like > there's no other solution than to overwrite and redefine everything, what I > would prefer to avoid to ease maintenance of such a module. Thanks for > sharing your insights. are you aware of the poisoning the cache technique? you can do things like def _notify_get_groups(self, msg_vals=None): self._cache['access_token'] = 'whatever you need for your workflow' return super()._notify_get_groups(msg_vals=msg_vals) and given super won't initiate a new database read, it will stick with whatever you put in the cache, as that's where the ORM reads values from first. I read through your whole thing because I'm a weird kind of nerd, for other people to read it I suggest to start with a TLDR on the beginning so that people can filter if they're interested or not. -- Your partner for the hard Odoo problems https://hunki-enterprises.com
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Akim Juillerat - 05:56 - 12 Jan 2024 -
RE: External access token expiration
Dear,
I don’t use this. But I would make the token field on the document a ‘to many’ field. You create a token, each time you send a document. The tokens get a expire field. And a simple cron job deletes each day the expired tokens. This gives you the required function with little rewrite and practical no penalties : the solution stay the same for the user, there is practically no extra memory or processing needed. So this could maybe be the standard for this modules -)
With kind regards,
Van Hirtum Johan
Van: Akim Juillerat [mailto:notifications@odoo-community.org]
Verzonden: donderdag 11 januari 2024 19:48
Aan: Contributors
Onderwerp: External access token expirationDear community
With portal module installed, Odoo can send links to documents by e-mail using an access token so that the recipient doesn't need a portal user to see said documents.
The token is handled in the portal.mixin https://github.com/odoo/odoo/blob/15.0/addons/portal/models/portal_mixin.py#L15
Access to the document is handled through this controller: https://github.com/odoo/odoo/blob/15.0/addons/portal/controllers/mail.py#L206
Now, it's been multiple time customer are requiring to expire this token one way or another, because in standard Odoo the document stays accessible forever. The only solutions I could come up with without having to change everything are described below (extracte d from personal notes):
That means, to restrict the validity of the token that was sent in the mail, the token set on the record that is accessed needs to change after a "validity period". The issue with this, is if the link for a same record is sent multiple times during a single "validity period", the availability will not be the same. For example, if we want to define that access tokens are recomputed every 30 days, someone receiving an e-mail 5 days after the token was recomputed would be able to access the document for 25 days, and someone receiving an e-mail 25 days after the token was recomputed would be able to access it only for 5 days.
A slightly better solution without changing everything but probably more tricky to implement properly, would be to add a new Datetime field next_access_token_refresh on portal.mixin (or another mixin to be inherited on selected models in order to control the application by model) and set it XXX days in the future (according to a server parameter) each time we need to set the access token in an email. If we define the availability to 30 days, that means if a mail is sent to access the same document to a first external user today and to a second external user in 15 days, the first external user would be able to access it during a period of 45 days.
Did anyone here face a similar requirement? How did you handle it?
Ideally, we would need a single token to be generated per e-mail being sent so that we can define the expiration of said token, but it seems like there's no other solution than to overwrite and redefine everything, what I would prefer to avoid to ease maintenance of such a module.
Thanks for sharing your insights.
camptocamp
INNOVATIVE SOLUTIONS
BY OPEN SOURCE EXPERTS
Akim Juillerat
Business solutions
Software architect
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by johan - 10:56 - 12 Jan 2024 -
Re: External access token expiration
> Did anyone here face a similar requirement? How did you handle it? > Ideally, we would need a single token to be generated per e-mail being sent > so that we can define the expiration of said token, but it seems like > there's no other solution than to overwrite and redefine everything, what I > would prefer to avoid to ease maintenance of such a module. Thanks for > sharing your insights. are you aware of the poisoning the cache technique? you can do things like def _notify_get_groups(self, msg_vals=None): self._cache['access_token'] = 'whatever you need for your workflow' return super()._notify_get_groups(msg_vals=msg_vals) and given super won't initiate a new database read, it will stick with whatever you put in the cache, as that's where the ORM reads values from first. I read through your whole thing because I'm a weird kind of nerd, for other people to read it I suggest to start with a TLDR on the beginning so that people can filter if they're interested or not. -- Your partner for the hard Odoo problems https://hunki-enterprises.com
by Holger Brunn - 09:51 - 11 Jan 2024
-
-
tested website_odoo_debranding: Migration to 17.0
Hi Odoers,Tested the latest changes made by Niels, website_odoo_debranding, and it works, see the link below.Can anybody move this version to the GitHub OCA - version 17?I have no clue what the policy is and who is allowed to create/move this to version 17.Best regards,Michel
by Michel Stroom - 07:11 - 11 Jan 2024-
Re: tested website_odoo_debranding: Migration to 17.0
It looks like the related pull request https://github.com/OCA/website/pull/1017 was only marked approved eight hours ago, so I suggest subscribing to that pull request and patiently giving the maintainers some time to merge.On Thu, Jan 11, 2024 at 1:12 PM Michel Stroom <notifications@odoo-community.org> wrote:Hi Odoers,Tested the latest changes made by Niels, website_odoo_debranding, and it works, see the link below.Can anybody move this version to the GitHub OCA - version 17?I have no clue what the policy is and who is allowed to create/move this to version 17.Best regards,Michel_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by "Adam Heinz" <adam.heinz@metricwise.com> - 07:21 - 11 Jan 2024
-
-
OCA 2024 Membership
Hello OCA Contributors,
Welcome to 2024!I am in the process of sorting out memberships for 2024. Check out our new logo badges!
If you would like, you can purchase your membership yourself on the website:If you would like a corporate membership with all your company's members on the one invoice please get in touch with me at membership@odoo-community.org and I will sort this out for you.We have changed the process up a bit and hope that the new corporate invoicing will be much smoother going forward.I am super excited to share that the membership directory has been fixed as well - once your invoice has been reconciled you should now show on the directory. Big thanks to Benoît Guillot and Graeme Gellatly for all the work on getting this sorted.Please be a little patient with reconciliation on the direct bank payments - this takes a little longer for the info to get through than Paypal and Stripe.Wishing you all a wonderful start to the year.Any questions please just get in touch.
Rebecca--Rebecca GellatlyGeneral SecretaryOdoo Community Association
by Rebecca Gellatly - 03:05 - 11 Jan 2024-
Re: OCA 2024 Membership
Hi Luis,
You can just send me a photo and I will upload for you.
Normally it syncs to your Github profile.I'll message you from within the system so you can talk to me directly about this.Take care,RebeccaOn Fri, 19 Jan 2024 at 13:12, Luis A. Pinzón <notifications@odoo-community.org> wrote:Hi Rebecca. Please, could you tell me how I can update my profile photo? In the details I have no option to do so. thank you so much Luis Pinzón
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Rebecca GellatlyGeneral SecretaryOdoo Community Association
by Rebecca Gellatly - 07:11 - 22 Jan 2024 -
Re: OCA 2024 Membership
Hello everyone, Please I would like you to help me automate the sending of emails every time a product goes out of stock or out of stock. Thank you for helping me with automated actions
Le ven. 19 janv. 2024 à 00:12, Luis A. Pinzón <notifications@odoo-community.org> a écrit :Hi Rebecca. Please, could you tell me how I can update my profile photo? In the details I have no option to do so. thank you so much Luis Pinzón
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--SY Hawa Diallo - (IngéniEure SI)
InfOrmation SystEms EnginEer
by hawa1 - 10:01 - 19 Jan 2024 -
OCA 2024 Membership
Hi Rebecca. Please, could you tell me how I can update my profile photo? In the details I have no option to do so. thank you so much Luis Pinzón
by Luis Pinzon - 01:11 - 19 Jan 2024 -
Re: OCA 2024 Membership
Thanks so much for the support Michael.
You are definitely all set for the new year!
Yes, to show in the membership directory you need to opt in to having your details published on the website through the survey (we instigated this some years back when GDPR came into effect).So people need to fill in the survey to be shown. If anyone is having trouble with the details shown or would like to update etc just let me know and I can help you with his.
While things still probably feel a little clunky at present I really think going forward it will get easier with these new changes we've made and I hope we can add even more automation to smooth out the process for next year. I'm finding this year I am able to do a good amount of cleaning up as I go which is great for the future.
Have a great week everyone and if you haven't bought off the website yet, keep an eye out for invoice through the system this week.
RebeccaOn Fri, 12 Jan 2024 at 22:36, Michel Stroom <notifications@odoo-community.org> wrote:Dear community and Odooers,
I believe we can greatly assist Rebecca by collectively purchasing the 2024 OCA membership online, relieving her from significant manual work.
Membership directory:
If you wish to be included in the membership directory, please take a moment to complete the privacy survey (the survey link is provided in the invoice email).You can also find the survey link in My Account => Documents => Invoices & Bills => select the invoice number => view History below the invoice for a message from Rebecca after logging in to the OCA website.
Buy your 2024 OCA membership TODAY:2024 OCA Member: https://odoo-community.org/shop/24-msm-2024-oca-member-5038092024 OCA Delegate: https://odoo-community.org/shop/24-msb-2024-oca-board-503811
The 2024 OCA Membership is only 50 Euro !!
What are you waiting for ?
I already purchased the 2024 OCA Membership yesterday and completed the survey this morning to be listed in the membership directory.
Let’s help Rebecca and pay your 2024 OCA membership online.
Best regards,
Michel Stroom
Office Everywhere
e: mstroom@office-everywhere.com
w: Office-Everywhere.comOn 12 Jan 2024, at 08:32, Rebecca Gellatly <notifications@odoo-community.org> wrote:
Thanking you Benoît!
Holger, I'll message you now.
Thanks everyone.
On Fri, 12 Jan 2024 at 12:57, Benoît Guillot <notifications@odoo-community.org> wrote:
Hello,
Thank you Radovan.
Indeed, I wanted to display the previous year's members but I was too quick with my fix.
It's corrected, now the numbers of members displayed are consistent.
Le jeu. 11 janv. 2024 à 21:47, Rebecca Gellatly <notifications@odoo-community.org> a écrit :
Thanks for this Radovan. Yes, I noticed this the other day but wanted to see what would happen as we started invoicing.
Will keep you posted.
Appreciate your time.
Rebecca
On Fri, 12 Jan 2024 at 09:27, Radovan Skolnik <notifications@odoo-community.org> wrote:
Hello,
don't know if it's still only me but membership directory is still broken. If you click on the link sent in the email, you will see list if countries with number of patients in each of them. If you click on any of them, you'll get result saying "No result found". See attached screenshot with my country...
Best regards,
Radovan Skolnik
On Jan 11, 2024 03:07, Rebecca Gellatly <notifications@odoo-community.org> wrote:
Hello OCA Contributors,
Welcome to 2024!
I am in the process of sorting out memberships for 2024. Check out our new logo badges!
If you would like, you can purchase your membership yourself on the website:
• 2024 OCA Member
• 2024 OCA Delegate
• 2024 Sponsorship
If you would like a corporate membership with all your company's members on the one invoice please get in touch with me at membership@odoo-community.org and I will sort this out for you.
We have changed the process up a bit and hope that the new corporate invoicing will be much smoother going forward.
I am super excited to share that the membership directory has been fixed as well - once your invoice has been reconciled you should now show on the directory. Big thanks to Benoît Guillot and Graeme Gellatly for all the work on getting this sorted.
Please be a little patient with reconciliation on the direct bank payments - this takes a little longer for the info to get through than Paypal and Stripe.
Wishing you all a wonderful start to the year.
Any questions please just get in touch.
Rebecca
--
Rebecca Gellatly
General Secretary
Odoo Community Association
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
Rebecca Gellatly
General Secretary
Odoo Community Association
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
Benoît Guillot
Mail: benoit.guillot@akretion.com
Mobile : +33 6 66 50 39 90
Jabber/Gtalk : benoit.guillot@akretion.com.br
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
Rebecca Gellatly
General Secretary
Odoo Community Association
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Rebecca GellatlyGeneral SecretaryOdoo Community Association
by Rebecca Gellatly - 08:41 - 15 Jan 2024 -
Re: [SPAM] Re: OCA 2024 Membership -> Thanks!
Hello Michel,As a member of the OCA Board, I wanted to personnaly thank you for the message you sent today to help Rebecca sort things out easily with the new membership process.We need members and contributors with your spiritThanks a lot for your king message!--
Virginie+32 477 64 17 20Info : 2j/semaine sont dédiés à Chaf et 3j/semaine sont dédiés à Coop IT Easy-----Original Message-----From: Michel Stroom <notifications@odoo-community.org>Reply-To: Contributors <contributors@odoo-community.org>To: Contributors <contributors@odoo-community.org>Subject: [SPAM] Re: OCA 2024 MembershipDate: Fri, 12 Jan 2024 09:36:48 -0000Dear community and Odooers,
I believe we can greatly assist Rebecca by collectively purchasing the 2024 OCA membership online, relieving her from significant manual work.
Membership directory:
If you wish to be included in the membership directory, please take a moment to complete the privacy survey (the survey link is provided in the invoice email).You can also find the survey link in My Account => Documents => Invoices & Bills => select the invoice number => view History below the invoice for a message from Rebecca after logging in to the OCA website.
Buy your 2024 OCA membership TODAY:2024 OCA Member: https://odoo-community.org/shop/24-msm-2024-oca-member-5038092024 OCA Delegate: https://odoo-community.org/shop/24-msb-2024-oca-board-503811
The 2024 OCA Membership is only 50 Euro !!
What are you waiting for ?
I already purchased the 2024 OCA Membership yesterday and completed the survey this morning to be listed in the membership directory.
Let’s help Rebecca and pay your 2024 OCA membership online.
Best regards,
Michel Stroom
Office Everywhere
e: mstroom@office-everywhere.com
w: Office-Everywhere.comOn 12 Jan 2024, at 08:32, Rebecca Gellatly <notifications@odoo-community.org> wrote:
Thanking you Benoît!
Holger, I'll message you now.
Thanks everyone.
On Fri, 12 Jan 2024 at 12:57, Benoît Guillot <notifications@odoo-community.org> wrote:
Hello,
Thank you Radovan.
Indeed, I wanted to display the previous year's members but I was too quick with my fix.
It's corrected, now the numbers of members displayed are consistent.
Le jeu. 11 janv. 2024 à 21:47, Rebecca Gellatly <notifications@odoo-community.org> a écrit :
Thanks for this Radovan. Yes, I noticed this the other day but wanted to see what would happen as we started invoicing.
Will keep you posted.
Appreciate your time.
Rebecca
On Fri, 12 Jan 2024 at 09:27, Radovan Skolnik <notifications@odoo-community.org> wrote:
Hello,
don't know if it's still only me but membership directory is still broken. If you click on the link sent in the email, you will see list if countries with number of patients in each of them. If you click on any of them, you'll get result saying "No result found". See attached screenshot with my country...
Best regards,
Radovan Skolnik
On Jan 11, 2024 03:07, Rebecca Gellatly <notifications@odoo-community.org> wrote:
Hello OCA Contributors,
Welcome to 2024!
I am in the process of sorting out memberships for 2024. Check out our new logo badges!
If you would like, you can purchase your membership yourself on the website:
• 2024 OCA Member
• 2024 OCA Delegate
• 2024 Sponsorship
If you would like a corporate membership with all your company's members on the one invoice please get in touch with me at membership@odoo-community.org and I will sort this out for you.
We have changed the process up a bit and hope that the new corporate invoicing will be much smoother going forward.
I am super excited to share that the membership directory has been fixed as well - once your invoice has been reconciled you should now show on the directory. Big thanks to Benoît Guillot and Graeme Gellatly for all the work on getting this sorted.
Please be a little patient with reconciliation on the direct bank payments - this takes a little longer for the info to get through than Paypal and Stripe.
Wishing you all a wonderful start to the year.
Any questions please just get in touch.
Rebecca
--
Rebecca Gellatly
General Secretary
Odoo Community Association
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
Rebecca Gellatly
General Secretary
Odoo Community Association
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
Benoît Guillot
Mail: benoit.guillot@akretion.com
Mobile : +33 6 66 50 39 90
Jabber/Gtalk : benoit.guillot@akretion.com.br
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
Rebecca Gellatly
General Secretary
Odoo Community Association
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Virginie Dewulf. - 02:39 - 12 Jan 2024
-
-
Document Management System
HiThe Documents app from Odoo seems great in presentations, but I think there is something I am missing...Our customer wants to have one workspace for everything related to a customer project, from the time it is created as a lead to the paid invoice, including sales ordes, delivery orders, drawings/other documentation. As you can see some of this is generated outside of Odoo, that must be handled manually, but how can I configure Odoo to create a workspace when a lead is created for example? Seems invoices are supported somehow, but can't find much information on how to use this app.Torvald Baade BringsvorBringsvor Consulting AS - Developer, consultant, allrounderTel (+47) 4548 2848
by Torvald Bringsvor - 09:55 - 10 Jan 2024 -
EDI Platform
Hi,We are a meat processing industry and we want to implement Odoo 16 Community.We have to meet a need very important for us: EDI. Our actual ERP (A3ERP) has a connection directly to our partner "Seres" that send invoices and receiver orders to our customers. The systems sends and receive this messages via FTP.Could anyone help us with this project?Thank you very much.Saludos,Nota Legal: Este mensaje y sus anexos se dirigen exclusivamente a su destinatario y pueden contener información privada y confidencial para uso exclusivo de su destinatario. Si ha recibido este mensaje por error, le rogamos que nos lo comunique inmediatamente por esta misma vía y proceda a su destrucción, informándole que cualquier divulgación, copia, distribución o uso de los mismos está prohibida en virtud de la legislación vigente.Legal Notice: This message and its attachments are exclusively directed to the addressee and may contain private and confidential information for the use of the addressee. If you have received this message by mistake we request that you immediately inform us and delete it. If you are not the intended recipient you are being notified that the coping, disclosing, distribution or use of this information is forbidden by law.
by Sergio Borja - 02:39 - 10 Jan 2024-
Re: EDI Platform
EDI Framework is your tool then,Actually, your approach is similar to the e.Fact approach that I did in l10n-spain repository (SFTP storage) a few years ago. Right now it has been replaced by FACe, but you could easily recover the original codeKind regardsEl jue, 11 ene 2024 a las 3:51, Jordi Ballester Alomar (<notifications@odoo-community.org>) escribió:Hi Sergio, actively use and contribute to the EDI project, and are used to this type of integrations.Regards,Jordi.On Wed, Jan 10, 2024 at 2:42 PM Sergio Borja <notifications@odoo-community.org> wrote:Hi,We are a meat processing industry and we want to implement Odoo 16 Community.We have to meet a need very important for us: EDI. Our actual ERP (A3ERP) has a connection directly to our partner "Seres" that send invoices and receiver orders to our customers. The systems sends and receive this messages via FTP.Could anyone help us with this project?Thank you very much.Saludos,Nota Legal: Este mensaje y sus anexos se dirigen exclusivamente a su destinatario y pueden contener información privada y confidencial para uso exclusivo de su destinatario. Si ha recibido este mensaje por error, le rogamos que nos lo comunique inmediatamente por esta misma vía y proceda a su destrucción, informándole que cualquier divulgación, copia, distribución o uso de los mismos está prohibida en virtud de la legislación vigente.Legal Notice: This message and its attachments are exclusively directed to the addressee and may contain private and confidential information for the use of the addressee. If you have received this message by mistake we request that you immediately inform us and delete it. If you are not the intended recipient you are being notified that the coping, disclosing, distribution or use of this information is forbidden by law.
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Jordi Ballester AlomarCEO & FounderSpain: (+34) 93 694 04 85 - Ext. 101 | USA: (+1) 646 980 4659 | Denmark: (+45) 78 78 21 89 - Ext. 101www.forgeflow.com | Email: jordi.ballester@forgeflow.com | Twitter: /jordibforgeflow | Linkedin: https://www.linkedin.com/company/forgeflow/
The content of this email is confidential and intended for the recipient specified in message only. It is strictly forbidden to share any part of this message with any third party, without a written consent of the sender. If you received this message by mistake, please reply to this message and follow with its deletion, so that we can ensure such a mistake does not occur in the future._______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Enric Tobella AlomarCEO & Founder
by Enric Tobella Alomar - 03:31 - 10 Jan 2024 -
Re: EDI Platform
Hi Sergio, actively use and contribute to the EDI project, and are used to this type of integrations.Regards,Jordi.On Wed, Jan 10, 2024 at 2:42 PM Sergio Borja <notifications@odoo-community.org> wrote:Hi,We are a meat processing industry and we want to implement Odoo 16 Community.We have to meet a need very important for us: EDI. Our actual ERP (A3ERP) has a connection directly to our partner "Seres" that send invoices and receiver orders to our customers. The systems sends and receive this messages via FTP.Could anyone help us with this project?Thank you very much.Saludos,Nota Legal: Este mensaje y sus anexos se dirigen exclusivamente a su destinatario y pueden contener información privada y confidencial para uso exclusivo de su destinatario. Si ha recibido este mensaje por error, le rogamos que nos lo comunique inmediatamente por esta misma vía y proceda a su destrucción, informándole que cualquier divulgación, copia, distribución o uso de los mismos está prohibida en virtud de la legislación vigente.Legal Notice: This message and its attachments are exclusively directed to the addressee and may contain private and confidential information for the use of the addressee. If you have received this message by mistake we request that you immediately inform us and delete it. If you are not the intended recipient you are being notified that the coping, disclosing, distribution or use of this information is forbidden by law.
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Jordi Ballester AlomarCEO & FounderSpain: (+34) 93 694 04 85 - Ext. 101 | USA: (+1) 646 980 4659 | Denmark: (+45) 78 78 21 89 - Ext. 101www.forgeflow.com | Email: jordi.ballester@forgeflow.com | Twitter: /jordibforgeflow | Linkedin: https://www.linkedin.com/company/forgeflow/
The content of this email is confidential and intended for the recipient specified in message only. It is strictly forbidden to share any part of this message with any third party, without a written consent of the sender. If you received this message by mistake, please reply to this message and follow with its deletion, so that we can ensure such a mistake does not occur in the future.
by Jordi Ballester Alomar - 02:50 - 10 Jan 2024
-
-
purchase information gone in 15.0?
Hi! In 14.0 and older I could define purchase information for each product and supplier. (Product -> Purchase -> supplier's line entry) In 15.0 this screen and information seems to be gone. At least it's not where it used to be. Has this been moved to elsewhere? If its removed from base, is there any module which reintroduces this information? Best regards Jan
by Jan Suhr - 06:16 - 9 Jan 2024-
Re: purchase information gone in 15.0?
Yes, product is marked as "can be purchased". I just found it: The information is in the table (instead of a separate window) and disabled by default. After enabling the columns I can access all missing information (e.g. name, short name). Screenshot attached. Am 09.01.24 um 18:27 schrieb Francesco Foresti: > Just making sure, did you mark the product as "can be purchased"? > > Il giorno mar 9 gen 2024 alle ore 18:17 Jan Suhr | Nitrokey > <notifications@odoo-community.org > <mailto:notifications@odoo-community.org>> ha scritto: > > Hi! > In 14.0 and older I could define purchase information for each product > and supplier. (Product -> Purchase -> supplier's line entry) In 15.0 > this screen and information seems to be gone. At least it's not where it > used to be. Has this been moved to elsewhere? If its removed from base, > is there any module which reintroduces this information? > > Best regards > Jan > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 > <https://odoo-community.org/groups/contributors-15> > Post to: mailto:contributors@odoo-community.org > <mailto:contributors@odoo-community.org> > Unsubscribe: https://odoo-community.org/groups?unsubscribe > <https://odoo-community.org/groups?unsubscribe> > > > > -- > > *Francesco Foresti* > /Sicurpharma Srl/ > francesco.foresti@ooops404.com <mailto:francesco.foresti@ooops404.com> > +39 333 8123 790 > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 > <https://odoo-community.org/groups/contributors-15> > Post to: mailto:contributors@odoo-community.org > Unsubscribe: https://odoo-community.org/groups?unsubscribe > <https://odoo-community.org/groups?unsubscribe> >
by Jan Suhr - 09:21 - 9 Jan 2024 -
Re: [SPAM] Re: purchase information gone in 15.0?
Hello Jan,You can find the same info (but not opening in a pop up) in version 16.Example from odoo-community runboat (launched from the purchase-workflow repo, with the "base only" option and I installed only the Purchase standard module) in attachment.Have a nice day,--
Virginie+32 477 64 17 20Info : 2j/semaine sont dédiés à Chaf et 3j/semaine sont dédiés à Coop IT Easy-----Original Message-----From: Francesco Foresti <notifications@odoo-community.org>Reply-To: Contributors <contributors@odoo-community.org>To: Contributors <contributors@odoo-community.org>Subject: [SPAM] Re: purchase information gone in 15.0?Date: Tue, 09 Jan 2024 17:27:28 -0000Just making sure, did you mark the product as "can be purchased"?Il giorno mar 9 gen 2024 alle ore 18:17 Jan Suhr | Nitrokey <notifications@odoo-community.org> ha scritto:Hi!
In 14.0 and older I could define purchase information for each product
and supplier. (Product -> Purchase -> supplier's line entry) In 15.0
this screen and information seems to be gone. At least it's not where it
used to be. Has this been moved to elsewhere? If its removed from base,
is there any module which reintroduces this information?
Best regards
Jan
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Virginie Dewulf. - 09:15 - 9 Jan 2024 -
Re: purchase information gone in 15.0?
Just making sure, did you mark the product as "can be purchased"?Il giorno mar 9 gen 2024 alle ore 18:17 Jan Suhr | Nitrokey <notifications@odoo-community.org> ha scritto:Hi! In 14.0 and older I could define purchase information for each product and supplier. (Product -> Purchase -> supplier's line entry) In 15.0 this screen and information seems to be gone. At least it's not where it used to be. Has this been moved to elsewhere? If its removed from base, is there any module which reintroduces this information? Best regards Jan
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
by Francesco Foresti - 06:26 - 9 Jan 2024
-
-
Inquiry on Preferred BI Tools and Connection Methods for Odoo
Dear OCA Contributors,
I hope this message finds you well. I am reaching out to the knowledgeable and experienced members of the Odoo Community Association to gather insights on a topic that is of growing importance in our field - the integration of Business Intelligence (BI) tools with Odoo.
As we continuously strive to improve our business processes and data analysis capabilities, understanding the most effective tools and techniques for integrating BI solutions with Odoo is crucial. Therefore, I would be immensely grateful if you could share your experiences and preferences in this area. Specifically, I am interested in the following questions:
- Preferred BI Tools: Which BI tools have you found most effective or user-friendly when integrated with Odoo? Any particular reasons for your preference, such as ease of use, comprehensive features, or compatibility?
- Connection Method: What type of connection method do you commonly use for integrating BI tools with Odoo? Have you predominantly been using XML-RPC, or are there other methods that you find more efficient or reliable?
- Experiences and Recommendations: Any specific experiences, challenges, or success stories you can share about integrating BI tools with Odoo? Your insights could be incredibly valuable for others in the community who are navigating similar decisions.
Your feedback and insights will not only assist me in making informed decisions for my current projects but will also benefit the broader OCA community as we all work towards optimizing our use of Odoo in various business scenarios.
Thank you in advance for taking the time to share your knowledge and experiences. I look forward to your valuable responses.
Best regards,
Rafael Blasco
Moduon
by "Rafael Blasco" <rblasco@rbnpro.com> - 04:43 - 9 Jan 2024-
Re: Inquiry on Preferred BI Tools and Connection Methods for Odoo
Good luck Rafael and thanks to share your first decision.
Bruno JoliveauArchitecte solutions - Président+1 514-317-7944
Nouveau
Suivez les publications des Numigiens 👀Découvrir Le mer. 17 janv. 2024 à 14:02, Rafael Blasco <notifications@odoo-community.org> a écrit :Hello all!
Thank you for all your answers.
We decided to go for PowerBI using this connector:
https://github.com/tmijail/Odoo-Power-BI-Connector
The time Will show us if this solution fits or not depending the volume of data and the size of reports.
😊
Best regards,
Rafael Blasco
Moduon
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Bruno Joliveau - 08:36 - 17 Jan 2024 -
RE: Inquiry on Preferred BI Tools and Connection Methods for Odoo
Hello all!
Thank you for all your answers.
We decided to go for PowerBI using this connector:
https://github.com/tmijail/Odoo-Power-BI-Connector
The time Will show us if this solution fits or not depending the volume of data and the size of reports.
😊
Best regards,
Rafael Blasco
Moduon
by Rafael Blasco (Moduon) - 08:00 - 17 Jan 2024 -
Re: Inquiry on Preferred BI Tools and Connection Methods for Odoo
Hi Rafael,
Here the tools we are using in my cooperative, I hope it is helpful.
- Preferred BI Tools: Which BI tools have you found most effective or
user-friendly when integrated with Odoo? Any par ticular
reasons for your preference, such as ease of use,
comprehensive features, or compatibility?
We are using Apache Superset, for us, it is the powerfulest open source BI tool and has a good community behind.
It has a lot of different charts, including maps.
- Connection Method: What type of connection method do you commonly
use for integrating BI tools with Odoo? Have you predominantly
been using XML-RPC, or are there other methods that you find
more efficient or reliable?
We make queries directly from database.
We are useing Postgres Foreign Datawrapper in order to map all odoo, and any other source, incuding flat files, in other postgres instance and then we build datasets in order to make charts in superset.
We also use DBT if we need to persist any query for performance purposes.
With this solution we can show the informations in our dashboards in real time.
- Experiences and Recommendations: Any specific experiences, challenges, or
success stories you can share about integrating BI tools with
Odoo? Your insights could be incredibly valuable for others in
the community who are navigating similar decisions.
We have some financial dashboards (mis reports extended, profit and loss, balance situation) in superset.
We also have dashboards for companies like Som Conexió (telecomunications), Som Mobilitat (carsharing) that takes some information from Odoo and information from other datasources.
We can mount dashboards for any model in Odoo, and if it's necessary, joining the data with other datasources with foreign data wrapper.
Regards,Konstantina Tsagkaricoopdevs.coop
On 9/1/24 16:47, Rafael Blasco wrote:
Dear OCA Contributors,
I hope this message finds you well. I am reaching out to the knowledgeable and experienced members of the Odoo Community Association to gather insights on a topic that is of growing importance in our field - the integration of Business Intelligence (BI) tools with Odoo.
As we continuously strive to improve our business processes and data analysis capabilities, understanding the most effective tools and techniques for integrating BI solutions with Odoo is crucial. Therefore, I would be immensely grateful if you could share your experiences and preferences in this area. Specifically, I am interested in the following questions:
- Preferred BI Tools: Which BI tools have you found most effective or user-friendly when integrated with Odoo? Any par ticular reasons for your preference, such as ease of use, comprehensive features, or compatibility?
- Connection Method: What type of connection method do you commonly use for integrating BI tools with Odoo? Have you predominantly been using XML-RPC, or are there other methods that you find more efficient or reliable?
- Experiences and Recommendations: Any specific experiences, challenges, or success stories you can share about integrating BI tools with Odoo? Your insights could be incredibly valuable for others in the community who are navigating similar decisions.
Your feedback and insights will not only assist me in making informed decisions for my current projects but will al so benefit the broader OCA community as we all work towards optimizing our use of Odoo in various business scenarios.
Thank you in advance for taking the time to share your knowledge and experiences. I look forward to your valuable responses.
Best regards,
Rafael Blasco
Moduon
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
Konstantina Tsagkari
kon.tsagari@coopdevs.orgcoopdevs.org
AVÍS LEGAL:Aquest missatge i els seus arxius adjunts van dirigits exclusivament al seu destinatari, i poden contenir informació confidencial sotmesa a secret professional. No n’és permesa la comunicació, reproducció o distribució sense l’autorització expressa de COOPDEVS TREBALL S.C.C.L.. Si no en sou el destinatari final, si us plau, elimineu-lo i informeu-nos-en per aquesta via.
PROTECCIÓ DE DADES: De conformitat amb el que estableix el Reglament (UE) 2016/679, de 27 d’abril (GDPR), i la Llei Orgànica 3/2018, de 5 de desembre (LOPDGDD), l’informem que les dades personals i adreça de correu electrònic de l’interessat es tractaran sota la responsabilitat de COOPDEVS TREBALL S.C.C.L. per un interès legítim i per enviar comunicacions sobre els nostres productes i serveis, i es conservaran mentre cap de les parts s’hi oposi. No es comunicaran les dades a tercers, tret que sigui obligació legal. Us informem que podeu exercir els drets d’accés, rectificació, portabilitat i supressió de les vostres dades i els de limitació i oposició al seu tractament tot adreçant-vos a Can Batlló Bloc 8 Constitució 19-25, - 08014 Barcelona (Barcelona). E-mail: info@coopdevs.org. Si considereu que el tractament no s’ajusta a la normativa vigent, podeu presentar una reclamació davant l’autoritat de control a www.aepd.es.
by Konstantina Tsagkari - 01:00 - 17 Jan 2024 - Preferred BI Tools: Which BI tools have you found most effective or
user-friendly when integrated with Odoo? Any par ticular
reasons for your preference, such as ease of use,
comprehensive features, or compatibility?
-
Re: Inquiry on Preferred BI Tools and Connection Methods for Odoo
We're using Google Datastream to get near real time replication of our postgres database from oDoo 16 CV to BigQuery.On Tue, Jan 9, 2024, 1:02 PM Diogo Duarte <notifications@odoo-community.org> wrote:Hi Rafael,We've been using Apache Superset because it's well supported and offers the possibility to use SSH Tunnel using RSA keys for direct connection to Postgresql (using a READ ONLY user).This way you don't need a bastion host. If you ussing Odoo.sh you can always use a small server and script a restore from Odoo.sh (using ssh again)It's a simple and powerful solution and allows direct SQL which is universal.Best regards,_Diogo DuarteERPGAPOn Tue, Jan 9, 2024 at 3:47 PM Rafael Blasco <notifications@odoo-community.org> wrote:Dear OCA Contributors,
I hope this message finds you well. I am reaching out to the knowledgeable and experienced members of the Odoo Community Association to gather insights on a topic that is of growing importance in our field - the integration of Business Intelligence (BI) tools with Odoo.
As we continuously strive to improve our business processes and data analysis capabilities, understanding the most effective tools and techniques for integrating BI solutions with Odoo is crucial. Therefore, I would be immensely grateful if you could share your experiences and preferences in this area. Specifically, I am interested in the following questions:
- Preferred BI Tools: Which BI tools have you found most effective or user-friendly when integrated with Odoo? Any par ticular reasons for your preference, such as ease of use, comprehensive features, or compatibility?
- Connection Method: What type of connection method do you commonly use for integrating BI tools with Odoo? Have you predominantly been using XML-RPC, or are there other methods that you find more efficient or reliable?
- Experiences and Recommendations: Any specific experiences, challenges, or success stories you can share about integrating BI tools with Odoo? Your insights could be incredibly valuable for others in the community who are navigating similar decisions.
Your feedback and insights will not only assist me in making informed decisions for my current projects but will al so benefit the broader OCA community as we all work towards optimizing our use of Odoo in various business scenarios.
Thank you in advance for taking the time to share your knowledge and experiences. I look forward to your valuable responses.
Best regards,
Rafael Blasco
Moduon
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by caleb - 08:45 - 9 Jan 2024 -
Re: Inquiry on Preferred BI Tools and Connection Methods for Odoo
Hi Rafael,We've been using Apache Superset because it's well supported and offers the possibility to use SSH Tunnel using RSA keys for direct connection to Postgresql (using a READ ONLY user).This way you don't need a bastion host. If you ussing Odoo.sh you can always use a small server and script a restore from Odoo.sh (using ssh again)It's a simple and powerful solution and allows direct SQL which is universal.Best regards,_Diogo DuarteERPGAPOn Tue, Jan 9, 2024 at 3:47 PM Rafael Blasco <notifications@odoo-community.org> wrote:Dear OCA Contributors,
I hope this message finds you well. I am reaching out to the knowledgeable and experienced members of the Odoo Community Association to gather insights on a topic that is of growing importance in our field - the integration of Business Intelligence (BI) tools with Odoo.
As we continuously strive to improve our business processes and data analysis capabilities, understanding the most effective tools and techniques for integrating BI solutions with Odoo is crucial. Therefore, I would be immensely grateful if you could share your experiences and preferences in this area. Specifically, I am interested in the following questions:
- Preferred BI Tools: Which BI tools have you found most effective or user-friendly when integrated with Odoo? Any par ticular reasons for your preference, such as ease of use, comprehensive features, or compatibility?
- Connection Method: What type of connection method do you commonly use for integrating BI tools with Odoo? Have you predominantly been using XML-RPC, or are there other methods that you find more efficient or reliable?
- Experiences and Recommendations: Any specific experiences, challenges, or success stories you can share about integrating BI tools with Odoo? Your insights could be incredibly valuable for others in the community who are navigating similar decisions.
Your feedback and insights will not only assist me in making informed decisions for my current projects but will al so benefit the broader OCA community as we all work towards optimizing our use of Odoo in various business scenarios.
Thank you in advance for taking the time to share your knowledge and experiences. I look forward to your valuable responses.
Best regards,
Rafael Blasco
Moduon
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by "Diogo Duarte" <dduarte@erpgap.com> - 08:02 - 9 Jan 2024
-
Volumetric weight for packaging
Dear contributors,
do we have a base module (possibly for odoo14) to compute volumetric weight for Delivery Packages ?
I found this one https://github.com/OCA/product-attribute/tree/13.0/product_dimension_volumetric_weight but it's for product dimension, not for packaging/package dimension.
All the best
--
Francesco Ballerini
by Francesco Ballerini - 05:40 - 29 Dec 2023 -
MRP: Replenish MO multi-line (stock.move) selection
Hello OCAers,I have a customer who wants to manually select several lines in a manufacturing order (MO) and launch a replenish action on those selected lines.Basically he wants to have the same functionality as in the overview but to be able to search filter and select many lines in place of having to click on “replenish” for each line; get the wizard popup to select the location, route and launch the replenshment actionThe default replenishment system in Odoo doesn't allow them to filter the replenishment lines (stock.warehouse.orderpoint) to only get lines corresponding to that specific MO (unique line per product/location)Is there some module in the OCA that can help? Any insight?Thank you--Yves Goldbergodoo| Official Partner - OCA delegateOpen Source ERP, CRM & CMST +972 (3) 720 8818
M +972 (55) 966 1405T +32 (2) 588 2500--
by Yves Goldberg - 01:16 - 29 Dec 2023 -
Module Question Last Updated by Users
Hi OCA Mailinglist,this is my first question: Do you know a module where i can search/look the last updates related to a user in all data models ?Regards,Stefan
Stefan Kranz
GeschäftsführerKranz GmbH
Bellevue 1-3
23968 Gägelow / GERMANY
Tel: +49 3841 6290-0
Fax:+49 3841 6290-32
Diese E-Mail und alle Anhänge enthalten vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail und ihren Inhalt. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.
This e-mail and any attached files may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail by mistake) please notify the sender immediately and delete this e-mail. Any unauthorised duplication, disclosure or distribution of this e-mail and content is strictly forbidden.
www.med-technik-kranz.de
HRB Schwerin 1930
by "Stefan Kranz" <stefank@med-technik-kranz.de> - 08:56 - 29 Dec 2023-
Re: Module Question Last Updated by Users
It sounds like you're looking for something like https://apps.odoo.com/apps/modules/14.0/auditlog?On Fri, Dec 29, 2023 at 2:57 AM Stefan Kranz <notifications@odoo-community.org> wrote:Hi OCA Mailinglist,this is my first question: Do you know a module where i can search/look the last updates related to a user in all data models ?Regards,Stefan
Stefan Kranz
GeschäftsführerKranz GmbH
Bellevue 1-3
23968 Gägelow / GERMANY
Tel: +49 3841 6290-0
Fax:+49 3841 6290-32
Diese E-Mail und alle Anhänge enthalten vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail und ihren Inhalt. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.
This e-mail and any attached files may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail by mistake) please notify the sender immediately and delete this e-mail. Any unauthorised duplication, disclosure or distribution of this e-mail and content is strictly forbidden.
www.med-technik-kranz.de
HRB Schwerin 1930_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by "Adam Heinz" <adam.heinz@metricwise.com> - 02:21 - 29 Dec 2023
-
-
Odoo 12 - Specific report for customer
Hi all, i'm looking for a way to specify a potential default report template (for Invoice and/or Order) for each of my customer.
I've got some specific informations to put in the pdf invoice report according to the type of customer. Rather than create a very complex report, i was looking a way to create report to associate to customer. Do you know if is possible to do it? Some OCA module?
Thanks
Happy New Year
by Cedric DEBARD - 11:30 - 28 Dec 2023-
Re: Odoo 12 - Specific report for customer
Hi Cedric,Check out this OCA app: https://apps.odoo.com/apps/modules/16.0/report_substitute/I think this does what you are looking for. I have used it in multi-company environments for companies that have different report needs.Cheers,


Cecilie Barreto
Director of Implementation North America at Sodexis

1-833-763-3947 ext. 701 
cecilie@sodexis.com 
www.sodexis.com "We help manufacturing and distribution companies improve operations by implementing the Odoo ERP solution with the highest possible ROI."
On Thu, Dec 28, 2023 at 10:57 AM DEBARD Cédric <notifications@odoo-community.org> wrote:It is not what i'm looking for. Maybe i was not enough clear.
I would like to be able to specify for each of my custormer a potential default invoice model (model=mail.template) and/or a potential default pdf invoice report (model=ir.actions.report)Thanks_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Cecilie Barreto - 05:20 - 28 Dec 2023 -
Re: Odoo 12 - Specific report for customer
Hi Cedric,Check this addon https://github.com/OCA/reporting-engine/tree/12.0/report_substitute.It allows to define substitution rules for a given report. The report will be replaced if the record match the rule domain.Le jeu. 28 déc. 2023, 16:57, DEBARD Cédric <notifications@odoo-community.org> a écrit :It is not what i'm looking for. Maybe i was not enough clear.
I would like to be able to specify for each of my custormer a potential default invoice model (model=mail.template) and/or a potential default pdf invoice report (model=ir.actions.report)Thanks_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Souheil Bejaoui - 05:20 - 28 Dec 2023 -
Re: Odoo 12 - Specific report for customer
It is not what i'm looking for. Maybe i was not enough clear.
I would like to be able to specify for each of my custormer a potential default invoice model (model=mail.template) and/or a potential default pdf invoice report (model=ir.actions.report)Thanks
by Cedric DEBARD - 04:56 - 28 Dec 2023 -
Re: Odoo 12 - Specific report for customer
Hello CedricYou should manage that with https://apps.odoo.com/apps/modules/16.0/sale_comment_template/RegardsPaul GoubertLe 28 déc. 2023 à 11:32, DEBARD Cédric <notifications@odoo-community.org> a écrit :
Hi all, i'm looking for a way to specify a potential default report template (for Invoice and/or Order) for each of my customer.
I've got some specific informations to put in the pdf invoice report according to the type of customer. Rather than create a very complex report, i was looking a way to create report to associate to customer. Do you know if is possible to do it? Some OCA module?
Thanks
Happy New Year_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Paul Goubert - 11:55 - 28 Dec 2023
-
-
Test OCA Carriers in sandbox
Dear contributors,I see OCA has implemented several providers in OCA/delivery-carrier/14.0 , is it possible to test some of them in sandbox ?Thanks!Best regards--Francesco Ballerini
by Francesco Ballerini - 04:31 - 22 Dec 2023-
Re: Test OCA Carriers in sandbox
Nice tip, I think I would have never found the one under l10n-spain by myself. Thank you David.
--
Francesco Ballerini
Il giorno ven 22 dic 2023 alle ore 16:52 David Vidal <notifications@odoo-community.org> ha scritto:Some of them have test API environments or keys provided by the provider API. With this one for example: https://github.com/OCA/l10n-spain/tree/14.0/delivery_gls_asm or this other one: https://github.com/OCA/delivery-carrier/tree/14.0/delivery_cttexpress (see tests)--David VidalEl vie, 22 dic 2023 a las 16:32, Francesco Ballerini (<notifications@odoo-community.org>) escribió:Dear contributors,I see OCA has implemented several providers in OCA/delivery-carrier/14.0 , is it possible to test some of them in sandbox ?Thanks!Best regards--Francesco Ballerini_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Francesco Ballerini - 02:22 - 23 Dec 2023 -
Re: Test OCA Carriers in sandbox
Some of them have test API environments or keys provided by the provider API. With this one for example: https://github.com/OCA/l10n-spain/tree/14.0/delivery_gls_asm or this other one: https://github.com/OCA/delivery-carrier/tree/14.0/delivery_cttexpress (see tests)--David VidalEl vie, 22 dic 2023 a las 16:32, Francesco Ballerini (<notifications@odoo-community.org>) escribió:Dear contributors,I see OCA has implemented several providers in OCA/delivery-carrier/14.0 , is it possible to test some of them in sandbox ?Thanks!Best regards--Francesco Ballerini_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by David Vidal - 04:50 - 22 Dec 2023
-
-
e-CMR Compliance (transport)
Hello contributors!
For everyone aware about CRM (Convention relative au contrat de transport international de Marchandise par Route)
We plan to develop an OCA set of modules to implement the CMR Convention.
Any one is near of this matter and would like to give an expert opinion?
RFC for CMR Management and e-CMR Integration in Odoo ERP (OCA RFC in stock-logistic-transport)
Introduction
eCMR, as a digital adaptation of the traditional CMR consignment note, has been legally validated and is an integral part of the international transport of goods. Endorsed by numerous countries and supported by the United Nations, its adoption signifies a pivotal move towards digitalization in the transportation sector. This transition is not only a technological advancement but also aligns with global efforts for sustainable and innovative logistics practices.
Objective
Develop and implement a functionality in Odoo ERP to manage transportation processes in compliance with the CMR Convention and to prepare for the mandatory use of e-CMR starting in September 2024.
General Description
- Sale as Route: Each sale represents a transport route.
- Purchases and Carriers: Each purchase linked to a route is a carrier.
- CMR Management: One CMR document is updated by each carrier.
- Final Signature and Invoicing: The completed CMR is attached to the invoice for client payment.
Technical Specifications
- Sale Route Module: Links sales to transport routes and purchases.
- CMR Management Module: Creates, updates, and tracks the CMR document.
- Integration with Purchases: Links purchases to CMR updates.
- Completion and Sending of CMR: Finalizes CMR for invoicing.
- CMR Claims from Suppliers: Automated CMR request and collection.
- Security and Compliance: Ensures legal compliance and data security.
- User Interface and Experience: User-friendly design and accessibility.
- Reporting and Analysis: Tools for tracking and improving logistics.
e-CMR Integration
- Compliance with 2024 Regulation: Adapts to mandatory e-CMR usage.
- Digital Transformation: Transitions from paper-based to digital CMR.
- Subsidy Utilization: Leverages financial programs like "Cheque Moderniza".
- Technical Adaptation: Prepares for technology changes required by e-CMR.
- Training and Support: Provides training for e-CMR system use.
Conclusion
Integrating CMR and e-CMR functionalities in Odoo aligns with regulatory changes and represents a commitment to digital transformation in logistics and transportation management.
Thank you in advance.
Best regards,
Rafael Blasco
Moduon
by Rafael Blasco (Moduon) - 03:54 - 21 Dec 2023 -
Odoo 12 - DMS Module - Directory
Hello All
I've just installed the DMS module on my Odoo12 installation, https://github.com/OCA/dms/tree/12.0, i can create a stockage but can't create a root directory inside this stockage.===============================The requested operation cannot be completed due to security restrictions. Please contact your system administrator(Type de document : Directory, Opération : create) - (Records: [90], User: 2)===============================Any ideaThanks
by Cedric DEBARD - 03:36 - 20 Dec 2023-
Re: Odoo 12 - DMS Module - Directory
You need to set a Group on Groups tabTested on runboatEl mié, 20 dic 2023 a las 15:52, Antonio M. Vigliotti (<notifications@odoo-community.org>) escribió:Hi,
I have the same trouble
Antonio
Il 20/12/2023 15:36, DEBARD Cédric ha scritto:
Hello All
I've just installed the DMS module on my Odoo12 installation, https://github.com/OCA/dms/tree/12.0, i can create a stockage but can't create a root directory inside this stockage.
===============================The requested operation cannot be completed due to security restrictions. Please contact your system administrator
(Type de document : Directory, Opération : create) - (Records: [90], User: 2)===============================
Any idea
Thanks_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Enric Tobella AlomarCEO & Founder
by Enric Tobella Alomar - 04:01 - 20 Dec 2023 -
Re: Odoo 12 - DMS Module - Directory
Hi,
I have the same trouble
Antonio
Il 20/12/2023 15:36, DEBARD Cédric ha scritto:
Hello All
I've just installed the DMS module on my Odoo12 installation, https://github.com/OCA/dms/tree/12.0, i can create a stockage but can't create a root directory inside this stockage.
===============================The requested operation cannot be completed due to security restrictions. Please contact your system administrator
(Type de document : Directory, Opération : create) - (Records: [90], User: 2)===============================
Any idea
Thanks_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Antonio M. Vigliotti - 03:51 - 20 Dec 2023
-
-
"Translating" pictures in website breaks website editor - any workaround?
Hello everyone, sorry for non-development question but this is really so specific I cannot imagine anyone besides experts here would be able to answer. A client has a website where on few pages there is a picture that needs to be different for different language version (because it contains embedded text in that language). The way we came out to deal with this is adding something like <t t-set="image_url" t-value="url_of_the_picture_in_default_language"/> before the image itself and then in the image itself something like <img t-att-href="image_url"/> This way the URL value can be translated to other languages. While it works as planned unfortunately it breaks the website editor - some JS error appears and the component palette won't be loaded :-( I have a stupid feeling I am missing some other obvious option. Any ideas please? Best regards Radovan Skolnik
by Radovan Skolnik - 07:15 - 19 Dec 2023-
Re: "Translating" pictures in website breaks website editor - any workaround?
> Yes! That's exactly that option that made me feel stupid in the back of my > head... > Not optimal in my opinion but better than nothing. under the hood this sets the html lang attribute [1] of the element, that's pretty optimal in the html sense of things in my opinion. I guess you don't want to have users in the editor have to put in all translated img's there? Then I'd suggest to have the users follow a naming scheme for those images, if en_US is the base language, it's /images/en_US/${some_name}.png and in https://github.com/OCA/OCB/blob/17.0/odoo/addons/base/models/ir_qweb.py#L562 you check the current language, if it's not en_US you go and search for //img[starts-with(@src, '/images/en_US/')] and replace that with /images/${language}/${some_name}.png Or do the same thing on the client side with JS. Or generate CSS replacement rules where you hide the en_US image and put the $language image there instead. I assume you've already considered using one SVG and do the text part there where you can also set a lang attribute? Not feasible for a lot of things, but if you generate those images automatically anyways, that might be the way. [1] https://developer.mozilla.org/en-US/docs/Web/HTML/Global_attributes/lang -- Your partner for the hard Odoo problems https://hunki-enterprises.com
by Holger Brunn - 04:01 - 20 Dec 2023 -
Re: "Translating" pictures in website breaks website editor - any workaround?
Yes! That's exactly that option that made me feel stupid in the back of my head... Not optimal in my opinion but better than nothing. Thank you Julien. Best regards Radovan On utorok 19. decembra 2023 19:37:19 CET Julien Guenat wrote: > Hello, > > In Odoo 16 (and maybe before, didn't test) you have a "Visibility" > option on website building blocks (image, image-text ...) where you > can choose to make the block visible only for specific languages. > > If not available in your Odoo version I guess you could use some > t-if. > > Best regards, > > Julien > > Le 19.12.23 à 19:17, Radovan Skolnik a > écrit : > > > Hello everyone, > sorry for non-development question but this is really so specific I cannot > imagine anyone besides experts here would be able to answer. A client has a > website where on few pages there is a picture that needs to be different > for different language version (because it contains embedded text in that > language). The way we came out to deal with this is adding something like > <t t-set="image_url" t-value="url_of_the_picture_in_default_language"/> > before the image itself and then in the image itself something like <img > t-att-href="image_url"/> This way the URL value can be translated to other > languages. While it works as planned unfortunately it breaks the website > editor - some JS error appears and the component palette won't be loaded > :-( I have a stupid feeling I am missing some other obvious option. Any > ideas please? Best regards > Radovan Skolnik > > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [1] > Post to: mailto:contributors@odoo-community.org [2] > Unsubscribe: https://odoo-community.org/groups?unsubscribe [3] > > > > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [4] > Post to: mailto:contributors@odoo-community.org > Unsubscribe: https://odoo-community.org/groups?unsubscribe [5] > > > > [1] https://odoo-community.org/groups/contributors-15 > [2] mailto:contributors@odoo-community.org > [3] https://odoo-community.org/groups?unsubscribe > [4] https://odoo-community.org/groups/contributors-15 > [5] https://odoo-community.org/groups?unsubscribe
by Radovan Skolnik - 07:46 - 19 Dec 2023 -
Re: "Translating" pictures in website breaks website editor - any workaround?
Hello,
In Odoo 16 (and maybe before, didn't test) you have a "Visibility" option on website building blocks (image, image-text ...) where you can choose to make the block visible only for specific languages.
If not available in your Odoo version I guess you could use some t-if.
Best regards,
Julien
Le 19.12.23 à 19:17, Radovan Skolnik a écrit :
Hello everyone, sorry for non-development question but this is really so specific I cannot imagine anyone besides experts here would be able to answer. A client has a website where on few pages there is a picture that needs to be different for different language version (because it contains embedded text in that language). The way we came out to deal with this is adding something like <t t-set="image_url" t-value="url_of_the_picture_in_default_language"/> before the image itself and then in the image itself something like <img t-att-href="image_url"/> This way the URL value can be translated to other languages. While it works as planned unfortunately it breaks the website editor - some JS error appears and the component palette won't be loaded :-( I have a stupid feeling I am missing some other obvious option. Any ideas please? Best regards Radovan Skolnik
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by julien - 07:36 - 19 Dec 2023
-
-
Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17
Dear OCA Team,
We are currently exploring possibilities to connect Odoo.sh with Power BI for odoo versions v15, v16 and v17. I would appreciate it if you could provide insights into the available options and any recommendations for achieving this integration.
Your assistance in this matter is highly valuable. Thank you in advance for your support.Thanks and Regards, 

Mitesh Jayswal Team Lead - Open Source (Odoo Certified) M: +91-7016346545 P: +91-8140810579 / EXTN: 1001 E: mitesh.jayswal@brainvire.com W: www.brainvire.com






Disclaimer: The information transmitted by this email is intended only for the person or entity to which it is addressed. This email may contain proprietary, business-confidential and/or privileged material. Please consider the environment before printing.

by mitesh.jayswal - 02:01 - 18 Dec 2023-
Re: Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17
Hi,we are using the ssh tunnel into odoo.sh to download and restore the latest backup located at /backup.daily/*_daily.sql.gz into another Azure Postgres database once a day.The restore script also creates a readonly user on the odoo database so PowerBI can connect to this Azure Postgres database.Of course the data is always from yesterday, and when you run the database restore from your odoo.sh instance, it should not take longer than 15 minutes because the ssh connection is terminated after a while.You also need to ensure that all connections are closed on your target database when restoring the backup.Best regards,ChristopherAm Mo., 18. Dez. 2023 um 15:23 Uhr schrieb Frederik Kramer <notifications@odoo-community.org>:Mehhh, Paul you are right. I missed the Odoo.SH part in my proposal. Again another good reason not to go for Odoo.SH in the first place
Best Frederik
Am 18.12.23 um 15:16 schrieb Paul Catinean:
Hi Mitesh,
I might be missing something here but in the case of odoo.sh I think you have 2 or 3 options:
1) Use an ssh tunnel to give access to postgresql (not sure if PowerBI supports this). Also I don't think you can create a new read-only user for this purpose.2) Use a tunnel at the http layer (HTTP Tunneling ). I've never attempted this so I have no idea if it works.3) Use the new dedicated odoo.sh instance which provides this feature by default https://www.odoo.sh/faq?q=postgresql#postgresql
These are the only approaches I know of. Would be excited to learn of others if there are any.
Best,Paul
On Mon, Dec 18, 2023 at 3:01 PM Mitesh Jayswal <notifications@odoo-community.org> wrote:
Dear OCA Team,
We are currently exploring possibilities to connect Odoo.sh with Power BI for odoo versions v15, v16 and v17. I would appreciate it if you could provide insights into the available options and any recommendations for achieving this integration.
Your assistance in this matter is highly valuable. Thank you in advance for your support.
Thanks and Regards, 

Mitesh Jayswal Team Lead - Open Source (Odoo Certified) M: +91-7016346545 P: +91-8140810579 / EXTN: 1001 E: mitesh.jayswal@brainvire.com W: www.brainvire.com






Disclaimer: The information transmitted by this email is intended only for the person or entity to which it is addressed. This email may contain proprietary, business-confidential and/or privileged material. Please consider the environment before printing.

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
-- Dr.-Ing. Frederik Kramer Geschäftsführer initOS GmbH Innungsstraße 7 21244 Buchholz i.d.N. Tel: +49 (0) 4181 13503 12 Fax: +49 (0) 4181 13503 10 Mobil: +49 (0) 179 3901819 Email: frederik.kramer@initos.com Internet: www.initos.com Geschäftsführung: Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke Sitz der Gesellschaft: Buchholz i.d.N. Amtsgericht Tostedt, HRB 205226 USt-IdNr.: DE815580155 Steuer-Nr: 15/200/53247
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Christopher Rogos - 03:46 - 18 Dec 2023 -
Re: Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17
Hi Everyone,
Anyhow the postgresql database is not supposed to be directly used, because it will ignore all information and structure provided by the ORM. So xml-rpc or json-rpc would be the interface to use for connecting to Odoo data. This is also fully supported by odoo.sh/
Kind regards, Ronald
On 18-12-2023 15:27, Tom Blauwendraat wrote:
Hi everyone,
there's a commercial module from Techneith that can do this also without the SQL connection.
I don't recommend it for various reasons, but it exists, and works. I don't know how it works, because the code is obfuscated.
-Tom
On 12/18/23 15:16, Paul Catinean wrote:
Hi Mitesh,
I might be missing something here but in the case of odoo.sh I think you have 2 or 3 options:
1) Use an ssh tunnel to give access to postgresql (not sure if PowerBI supports this). Also I don't think you can create a new read-only user for this purpose.2) Use a tunnel at the http layer (HTTP Tunneling ). I've never attempted this so I have no idea if it works.3) Use the new dedicated odoo.sh instance which provides this feature by default https://www.odoo.sh/faq?q=postgresql#postgresql
These are the only approaches I know of. Would be excited to learn of others if there are any.
Best,Paul
On Mon, Dec 18, 2023 at 3:01 PM Mitesh Jayswal <notifications@odoo-community.org> wrote:
Dear OCA Team,
We are currently exploring possibilities to connect Odoo.sh with Power BI for odoo versions v15, v16 and v17. I would appreciate it if you could provide insights into the available options and any recommendations for achieving this integration.
Your assistance in this matter is highly valuable. Thank you in advance for your support.
Thanks and Regards, 

Mitesh Jayswal Team Lead - Open Source (Odoo Certified) M: +91-7016346545 P: +91-8140810579 / EXTN: 1001 E: mitesh.jayswal@brainvire.com W: www.brainvire.com






Disclaimer: The information transmitted by this email is intended only for the person or entity to which it is addressed. This email may contain proprietary, business-confidential and/or privileged material. Please consider the environment before printing.

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by "Ronald Portier" <rportier@therp.nl> - 03:46 - 18 Dec 2023 -
Re: Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17
Hi Tom
That being said "the code ist obfuscated" is already enough not to feed such a modul with credentials to the database. I wouldn't need an argument other than this to avoid using it ;-)
Best Frederik
Am 18.12.23 um 15:27 schrieb Tom Blauwendraat:
Hi everyone,
there's a commercial module from Techneith that can do this also without the SQL connection.
I don't recommend it for various reasons, but it exists, and works. I don't know how it works, because the code is obfuscated.
-Tom
On 12/18/23 15:16, Paul Catinean wrote:
Hi Mitesh,
I might be missing something here but in the case of odoo.sh I think you have 2 or 3 options:
1) Use an ssh tunnel to give access to postgresql (not sure if PowerBI supports this). Also I don't think you can create a new read-only user for this purpose.2) Use a tunnel at the http layer (HTTP Tunneling ). I've never attempted this so I have no idea if it works.3) Use the new dedicated odoo.sh instance which provides this feature by default https://www.odoo.sh/faq?q=postgresql#postgresql
These are the only approaches I know of. Would be excited to learn of others if there are any.
Best,Paul
On Mon, Dec 18, 2023 at 3:01 PM Mitesh Jayswal <notifications@odoo-community.org> wrote:
Dear OCA Team,
We are currently exploring possibilities to connect Odoo.sh with Power BI for odoo versions v15, v16 and v17. I would appreciate it if you could provide insights into the available options and any recommendations for achieving this integration.
Your assistance in this matter is highly valuable. Thank you in advance for your support.
Thanks and Regards, 

Mitesh Jayswal Team Lead - Open Source (Odoo Certified) M: +91-7016346545 P: +91-8140810579 / EXTN: 1001 E: mitesh.jayswal@brainvire.com W: www.brainvire.com






Disclaimer: The information transmitted by this email is intended only for the person or entity to which it is addressed. This email may contain proprietary, business-confidential and/or privileged material. Please consider the environment before printing.

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
-- Dr.-Ing. Frederik Kramer Geschäftsführer initOS GmbH Innungsstraße 7 21244 Buchholz i.d.N. Tel: +49 (0) 4181 13503 12 Fax: +49 (0) 4181 13503 10 Mobil: +49 (0) 179 3901819 Email: frederik.kramer@initos.com Internet: www.initos.com Geschäftsführung: Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke Sitz der Gesellschaft: Buchholz i.d.N. Amtsgericht Tostedt, HRB 205226 USt-IdNr.: DE815580155 Steuer-Nr: 15/200/53247
by Frederik Kramer - 03:41 - 18 Dec 2023 -
Re: Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17
Hi everyone,
there's a commercial module from Techneith that can do this also without the SQL connection.
I don't recommend it for various reasons, but it exists, and works. I don't know how it works, because the code is obfuscated.
-Tom
On 12/18/23 15:16, Paul Catinean wrote:
Hi Mitesh,
I might be missing something here but in the case of odoo.sh I think you have 2 or 3 options:
1) Use an ssh tunnel to give access to postgresql (not sure if PowerBI supports this). Also I don't think you can create a new read-only user for this purpose.2) Use a tunnel at the http layer (HTTP Tunneling ). I've never attempted this so I have no idea if it works.3) Use the new dedicated odoo.sh instance which provides this feature by default https://www.odoo.sh/faq?q=postgresql#postgresql
These are the only approaches I know of. Would be excited to learn of others if there are any.
Best,Paul
On Mon, Dec 18, 2023 at 3:01 PM Mitesh Jayswal <notifications@odoo-community.org> wrote:
Dear OCA Team,
We are currently exploring possibilities to connect Odoo.sh with Power BI for odoo versions v15, v16 and v17. I would appreciate it if you could provide insights into the available options and any recommendations for achieving this integration.
Your assistance in this matter is highly valuable. Thank you in advance for your support.
Thanks and Regards, 

Mitesh Jayswal Team Lead - Open Source (Odoo Certified) M: +91-7016346545 P: +91-8140810579 / EXTN: 1001 E: mitesh.jayswal@brainvire.com W: www.brainvire.com






Disclaimer: The information transmitted by this email is intended only for the person or entity to which it is addressed. This email may contain proprietary, business-confidential and/or privileged material. Please consider the environment before printing.

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Tom Blauwendraat - 03:26 - 18 Dec 2023 -
Re: Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17
Mehhh, Paul you are right. I missed the Odoo.SH part in my proposal. Again another good reason not to go for Odoo.SH in the first place
Best Frederik
Am 18.12.23 um 15:16 schrieb Paul Catinean:
Hi Mitesh,
I might be missing something here but in the case of odoo.sh I think you have 2 or 3 options:
1) Use an ssh tunnel to give access to postgresql (not sure if PowerBI supports this). Also I don't think you can create a new read-only user for this purpose.2) Use a tunnel at the http layer (HTTP Tunneling ). I've never attempted this so I have no idea if it works.3) Use the new dedicated odoo.sh instance which provides this feature by default https://www.odoo.sh/faq?q=postgresql#postgresql
These are the only approaches I know of. Would be excited to learn of others if there are any.
Best,Paul
On Mon, Dec 18, 2023 at 3:01 PM Mitesh Jayswal <notifications@odoo-community.org> wrote:
Dear OCA Team,
We are currently exploring possibilities to connect Odoo.sh with Power BI for odoo versions v15, v16 and v17. I would appreciate it if you could provide insights into the available options and any recommendations for achieving this integration.
Your assistance in this matter is highly valuable. Thank you in advance for your support.
Thanks and Regards, 

Mitesh Jayswal Team Lead - Open Source (Odoo Certified) M: +91-7016346545 P: +91-8140810579 / EXTN: 1001 E: mitesh.jayswal@brainvire.com W: www.brainvire.com






Disclaimer: The information transmitted by this email is intended only for the person or entity to which it is addressed. This email may contain proprietary, business-confidential and/or privileged material. Please consider the environment before printing.

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
-- Dr.-Ing. Frederik Kramer Geschäftsführer initOS GmbH Innungsstraße 7 21244 Buchholz i.d.N. Tel: +49 (0) 4181 13503 12 Fax: +49 (0) 4181 13503 10 Mobil: +49 (0) 179 3901819 Email: frederik.kramer@initos.com Internet: www.initos.com Geschäftsführung: Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke Sitz der Gesellschaft: Buchholz i.d.N. Amtsgericht Tostedt, HRB 205226 USt-IdNr.: DE815580155 Steuer-Nr: 15/200/53247
by Frederik Kramer - 03:21 - 18 Dec 2023
-
-
Receive and deliver in Packages
Hello, I couldn't find this feature in out of the box Odoo, nor existing OCA modules, but tapping the collective brain in case I'm missing something:
I receive from my supplier boxes with Parts A, B and C.
They have serial numbers, so I'm receive them individually and the put them in a Package , to track them together.
This works out of the box, with some UX sugarcoat that may become an OCA module.
Then I want to deliver that box to a customer.
I want the picking person to select a box, and then the delivery order should have those 3 lines with the particular SNs of the box that was selected.
I can't get this working, even enabling the "Move packages" option in the Operation Type.
So my guess is that I'll need a feature to pick a box in a DO.
But maybe someone knows better.
Thanks for the feedback.
--
DANIEL REIS
MANAGING PARTNERM: +351 919 991 307
E: dreis@OpenSourceIntegrators.com
A: Avenida da República 3000, Estoril Office B, 3º Escr.34, 2649-517 Cascais
by Daniel Reis - 02:39 - 15 Dec 2023-
Re: Receive and deliver in Packages
Thank you Vincent.
Unfortunately that won't match the needed reception workflow, that is more specific:
You scan the Kit SKU, the we know explodes into parts, and we then only scan the part SNs without the need to scan their Product barcodes.
And the warehouse is too simple to use the shopfloor app.
I'm looking at a Delivery Order form feature.
I guess I'll have to create something new for this.
Thanks
Daniel
On 15/12/2023 15:33, Vincent Regouby wrote:
Hello Daniel,
Did you try https://github.com/OCA/wms/tree/14.0/stock_reception_screen ?
From the module, you validate the reception, lot number, packaging and put everything in a box with a SSID.
Then you just scan the SSID to pick the box.
You can then use shopfloor to manage the box with SSID.
Regards
Vincent Regouby Port Cities 06 49 67 47 16
Le 15/12/2023 à 14:39, Daniel Reis a écrit :
Hello, I couldn't find this feature in out of the box Odoo, nor existing OCA modules, but tapping the collective brain in case I'm missing something:
I receive from my supplier boxes with Parts A, B and C.
They have serial numbers, so I'm receive them individually and the put them in a Package , to track them together.
This works out of the box, with some UX sugarcoat that may become an OCA module.
Then I want to deliver that box to a customer.
I want the picking person to select a box, and then the delivery order should have those 3 lines with the particular SNs of the box that was selected.
I can't get this working, even enabling the "Move packages" option in the Operation Type.
So my guess is that I'll need a feature to pick a box in a DO.
But maybe someone knows better.
Thanks for the feedback.
--
DANIEL REIS
MANAGING PARTNERM: +351 919 991 307
E: dreis@OpenSourceIntegrators.com
A: Avenida da República 3000, Estoril Office B, 3º Escr.34, 2649-517 Cascais_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
DANIEL REIS
MANAGING PARTNERM: +351 919 991 307
E: dreis@OpenSourceIntegrators.com
A: Avenida da República 3000, Estoril Office B, 3º Escr.34, 2649-517 Cascais
by Daniel Reis - 09:26 - 15 Dec 2023 -
Re: Receive and deliver in Packages
Hello Daniel,
Did you try https://github.com/OCA/wms/tree/14.0/stock_reception_screen ?
From the module, you validate the reception, lot number, packaging and put everything in a box with a SSID.
Then you just scan the SSID to pick the box.
You can then use shopfloor to manage the box with SSID.
Regards
Vincent Regouby Port Cities 06 49 67 47 16
Le 15/12/2023 à 14:39, Daniel Reis a écrit :
Hello, I couldn't find this feature in out of the box Odoo, nor existing OCA modules, but tapping the collective brain in case I'm missing something:
I receive from my supplier boxes with Parts A, B and C.
They have serial numbers, so I'm receive them individually and the put them in a Package , to track them together.
This works out of the box, with some UX sugarcoat that may become an OCA module.
Then I want to deliver that box to a customer.
I want the picking person to select a box, and then the delivery order should have those 3 lines with the particular SNs of the box that was selected.
I can't get this working, even enabling the "Move packages" option in the Operation Type.
So my guess is that I'll need a feature to pick a box in a DO.
But maybe someone knows better.
Thanks for the feedback.
--
DANIEL REIS
MANAGING PARTNERM: +351 919 991 307
E: dreis@OpenSourceIntegrators.com
A: Avenida da República 3000, Estoril Office B, 3º Escr.34, 2649-517 Cascais_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by v.regouby - 04:31 - 15 Dec 2023
-
-
AUTOMATISATION D'ENVOIE DE MAIL EN CAS DE SEUIL CRITIQUE
Bonjour à tous je viens vers vous solliciter votre aide, aufaite je suis sur odoo online version 16, puis que j'ai pas d'accès au code source j'aimerais automatisé le seuil minimale atteint par un mail envoyé au responsable de stock si c'était possible avec les actions automatisés svp aider moi--SY Hawa Diallo - (IngéniEure SI)
InfOrmation SystEms EnginEer
by hawa1 - 02:01 - 13 Dec 2023-
Re: [SPAM] AUTOMATISATION D'ENVOIE DE MAIL EN CAS DE SEUIL CRITIQUE
OK THANK YOU SO MUCHLe mer. 13 déc. 2023 à 17:32, Virginie Dewulf <notifications@odoo-community.org> a écrit :Bonjour,La communication sur cette mailing liste se fait en anglais, pas en français.La communauté OCA discute de sujets liés au code libre (Odoo Community Edition + modules de l'OCA), donc pas Odoo Enterprise (Odoo Online). Vous devez donc vous adressez à Odoo S.A. directement.Bonne continuation,--
Virginie+32 477 64 17 20Info : 2j/semaine sont dédiés à Chaf et 3j/semaine sont dédiés à Coop IT Easy-----Original Message-----From: DIALLO Innah <notifications@odoo-community.org>Reply-To: Contributors <contributors@odoo-community.org>To: Contributors <contributors@odoo-community.org>Subject: [SPAM] AUTOMATISATION D'ENVOIE DE MAIL EN CAS DE SEUIL CRITIQUEDate: Wed, 13 Dec 2023 13:02:37 -0000Bonjour à tous je viens vers vous solliciter votre aide, aufaite je suis sur odoo online version 16, puis que j'ai pas d'accès au code source j'aimerais automatisé le seuil minimale atteint par un mail envoyé au responsable de stock si c'était possible avec les actions automatisés svp aider moi--SY Hawa Diallo - (IngéniEure SI)
InfOrmation SystEms EnginEer
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--SY Hawa Diallo - (IngéniEure SI)
InfOrmation SystEms EnginEer
by hawa1 - 09:41 - 14 Dec 2023 -
Re: [SPAM] AUTOMATISATION D'ENVOIE DE MAIL EN CAS DE SEUIL CRITIQUE
Bonjour,La communication sur cette mailing liste se fait en anglais, pas en français.La communauté OCA discute de sujets liés au code libre (Odoo Community Edition + modules de l'OCA), donc pas Odoo Enterprise (Odoo Online). Vous devez donc vous adressez à Odoo S.A. directement.Bonne continuation,--
Virginie+32 477 64 17 20Info : 2j/semaine sont dédiés à Chaf et 3j/semaine sont dédiés à Coop IT Easy-----Original Message-----From: DIALLO Innah <notifications@odoo-community.org>Reply-To: Contributors <contributors@odoo-community.org>To: Contributors <contributors@odoo-community.org>Subject: [SPAM] AUTOMATISATION D'ENVOIE DE MAIL EN CAS DE SEUIL CRITIQUEDate: Wed, 13 Dec 2023 13:02:37 -0000Bonjour à tous je viens vers vous solliciter votre aide, aufaite je suis sur odoo online version 16, puis que j'ai pas d'accès au code source j'aimerais automatisé le seuil minimale atteint par un mail envoyé au responsable de stock si c'était possible avec les actions automatisés svp aider moi--SY Hawa Diallo - (IngéniEure SI)
InfOrmation SystEms EnginEer
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Virginie Dewulf. - 06:31 - 13 Dec 2023
-
-
Sale Order packaging without specify products
Hello,TLTRI am searching (for Odoo v14) a module which add a one2many on sale order, linking SO with multiple product packaging objects.More detailsLong time ago I've been asked to make implementations for a workflow when we need to define product packaging objects in a Sale Order so that we can store packaging dimensions, compute the proper rate and send some info to the carrier.We don't want to define any package on sale order line, or link specific products to a packaging: we just need to define an X number of packaging objects related to the sale order.Also, we want to do it from sale order because we adjust product lines accordingly to the "on hand quantity" directly on sale order, before picking generation, plus we don't manage backorder in the classic Odoo way, so picking is basically only "validate" for us.I already have developed the workflow, but it's not properly integrated with some Odoo modules/models so I want to make some refactors and possibly integrate it with some OCA modules like product_packaging_dimension to use already implemented features when possible.But I did not find anything covering this, possibly did I miss it?ThanksFrancesco Ballerini
by Francesco Ballerini - 12:24 - 11 Dec 2023-
Re: Sale Order packaging without specify products
Thanks for reporting Daniel, it's always good to know!
--
Francesco
Il giorno ven 22 dic 2023 alle ore 17:02 Daniel Reis <notifications@odoo-community.org> ha scritto:Probably they don't address your particular use case, but for information there are a few PRs now trying to solve problems around moving Packages:
- https://github.com/OCA/stock-logistics-workflow/pull/1422
- https://github.com/OCA/stock-logistics-workflow/pull/1463
Thanks
Daniel
On 22/12/2023 15:17, Francesco Ballerini wrote:
I think I found a good solution for this.
In very short worlds:
Added a Smart Button on Sale Order that allows to directly create Delivery Packages (product.packaging without product ID).
When creating Delivery Packages from this Smart Button Odoo will perform two automatism: create a PACK and link the PACK to the Sale Order Delivery Package
extended some functions, e.g. StockPicking._compute_packages() in order to merge Sale Order Delivery Packages related PACKS to packages defined by Picking Stock Move Lines. In case of multiple pickings, Sale Order Delivery Packages are only linked to the picking having “customer location” as destination location
This way when a provider loops through pickings to get PACKS/Delivery Packages dimension and weight it will also take info by PACKS defined by Sale Order Smart Button, even if they are not related to any product. You still can define products ID/PACK relation on the picking, if needed. Of course the use case is a bit specific (when it's not?), but it looks decent on paper.
I might be able to propose this as an OCA module in the future, in case someone has similar interests.
Best regards
Francesco Ballerini
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
DANIEL REIS
MANAGING PARTNERM: +351 919 991 307
E: dreis@OpenSourceIntegrators.com
A: Avenida da República 3000, Estoril Office B, 3º Escr.34, 2649-517 Cascais_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Francesco Ballerini - 02:22 - 23 Dec 2023 -
Re: Sale Order packaging without specify products
Probably they don't address your particular use case, but for information there are a few PRs now trying to solve problems around moving Packages:
- https://github.com/OCA/stock-logistics-workflow/pull/1422
- https://github.com/OCA/stock-logistics-workflow/pull/1463
Thanks
Daniel
On 22/12/2023 15:17, Francesco Ballerini wrote:
I think I found a good solution for this.
In very short worlds:
Added a Smart Button on Sale Order that allows to directly create Delivery Packages (product.packaging without product ID).
When creating Delivery Packages from this Smart Button Odoo will perform two automatism: create a PACK and link the PACK to the Sale Order Delivery Package
extended some functions, e.g. StockPicking._compute_packages() in order to merge Sale Order Delivery Packages related PACKS to packages defined by Picking Stock Move Lines. In case of multiple pickings, Sale Order Delivery Packages are only linked to the picking having “customer location” as destination location
This way when a provider loops through pickings to get PACKS/Delivery Packages dimension and weight it will also take info by PACKS defined by Sale Order Smart Button, even if they are not related to any product. You still can define products ID/PACK relation on the picking, if needed. Of course the use case is a bit specific (when it's not?), but it looks decent on paper.
I might be able to propose this as an OCA module in the future, in case someone has similar interests.
Best regards
Francesco Ballerini
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
DANIEL REIS
MANAGING PARTNERM: +351 919 991 307
E: dreis@OpenSourceIntegrators.com
A: Avenida da República 3000, Estoril Office B, 3º Escr.34, 2649-517 Cascais
by Daniel Reis - 05:00 - 22 Dec 2023 -
Re: Sale Order packaging without specify products
I think I found a good solution for this.
In very short worlds:
Added a Smart Button on Sale Order that allows to directly create Delivery Packages (product.packaging without product ID).
When creating Delivery Packages from this Smart Button Odoo will perform two automatism: create a PACK and link the PACK to the Sale Order Delivery Package
extended some functions, e.g. StockPicking._compute_packages() in order to merge Sale Order Delivery Packages related PACKS to packages defined by Picking Stock Move Lines. In case of multiple pickings, Sale Order Delivery Packages are only linked to the picking having “customer location” as destination location
This way when a provider loops through pickings to get PACKS/Delivery Packages dimension and weight it will also take info by PACKS defined by Sale Order Smart Button, even if they are not related to any product. You still can define products ID/PACK relation on the picking, if needed. Of course the use case is a bit specific (when it's not?), but it looks decent on paper.
I might be able to propose this as an OCA module in the future, in case someone has similar interests.
Best regards
Francesco Ballerini
by Francesco Ballerini - 04:16 - 22 Dec 2023 -
Re: Sale Order packaging without specify products
Update 2From what I can understand the management of carrier deliveries with packages is super complex either from a functional and developing point of view as the delivery package definition is a bit clunky by itself.I finally understood that you still need to you need to define a "delivery package" associated with carrier, because dimension and weight data cannot be not taken from package directly. They are taken instead from each "delivery package" linked with a picking "package".. but you still have to define both package and delivery package to access packaging data because picking structure will be likepicking > multiple packages (stock.quant.packages) > every package has packaging_id (product.packaging) (which is designed to be product specific unless you define it as a "delivery packages", aka a "product.packaging" object without product id 😵💫 )If this is correct and someone has taken the trouble to read until this point, maybe you could also confirm that it is possible to speed up (a lot) the whole process by generating multiple "packaging" objects from a sale order and automatically recreate the structure> picking > packages > delivery packages
by automatically generating- 1 package containing all products and- n° fake packages (containing no products, or a dummy product..)- link every package to one of previously defined delivery packages (this workflow can be activated, for example, by clicking put in pack if a custom option is selected on picking.. to avoid conflicts with normal workflows)Of course this is possible only if you manage the whole delivery in a single picking, like we do.Seems like it's going to be more challenging than I thought but it seems like it can be done, unfortunately I don't think that we already have designed a workflow for this situation.Francesco BalleriniIl giorno mar 12 dic 2023 alle ore 20:29 Francesco Ballerini <francescobl.lavoro@gmail.com> ha scritto:Update:Forgive me I have mistaken "packaging" and "package" business logic.I think that if I want to provide this feature and keep a decent level of scalability/extensibility I need to:1 - make possible for backend user to generate n° stock.quant.package objects from a sale order (simply adding a one2many relation with stock.quant.package, in Sale Order)2 - use stock_quant_package_dimension to allow setting dimensions and automatic volume calculation from the Sale Order as well3 - when the outgoing picking is generated by confirming order (as I previously said we have a really simplified picking process but this part will still probably be a bit tricky in case of picking and/or order cancel)3a) all sale order packages will be automatically attached to the outgoing picking by setting them on "picking.package_ids"3b) all the products will automatically be put in a single pack, the other packs will be "fake packs" in the sense that they will not store any products but still has dimensionsThis will not provide huge advantages by itself, but definitely better than having separate model to manage "shipping packs" delivery rate and tracking. Tracking will not be really accurate as it doesn't target products, but the rate we need to get is always based on taxable weight, so it should be a decent solution. I'm still not sure if it's worth to manage "package_id" on stock.quant.package, if I am not wrong that's needed in order to print shipping label.If you have any kind of suggestions that comes from experience in developing similar workflows (TLDR generating packages from sale order without having to specify the pack content) it will be helpful for sure.Thanks,Francesco BalleriniIl giorno dom 10 dic 2023 alle ore 23:27 Francesco Ballerini <francescobl.lavoro@gmail.com> ha scritto:Hello,TLTRI am searching (for Odoo v14) a module which add a one2many on sale order, linking SO with multiple product packaging objects.More detailsLong time ago I've been asked to make implementations for a workflow when we need to define product packaging objects in a Sale Order so that we can store packaging dimensions, compute the proper rate and send some info to the carrier.We don't want to define any package on sale order line, or link specific products to a packaging: we just need to define an X number of packaging objects related to the sale order.Also, we want to do it from sale order because we adjust product lines accordingly to the "on hand quantity" directly on sale order, before picking generation, plus we don't manage backorder in the classic Odoo way, so picking is basically only "validate" for us.I already have developed the workflow, but it's not properly integrated with some Odoo modules/models so I want to make some refactors and possibly integrate it with some OCA modules like product_packaging_dimension to use already implemented features when possible.But I did not find anything covering this, possibly did I miss it?ThanksFrancesco Ballerini
by Francesco Ballerini - 12:28 - 13 Dec 2023 -
Re: Sale Order packaging without specify products
Update:Forgive me I have mistaken "packaging" and "package" business logic.I think that if I want to provide this feature and keep a decent level of scalability/extensibility I need to:1 - make possible for backend user to generate n° stock.quant.package objects from a sale order (simply adding a one2many relation with stock.quant.package, in Sale Order)2 - use stock_quant_package_dimension to allow setting dimensions and automatic volume calculation from the Sale Order as well3 - when the outgoing picking is generated by confirming order (as I previously said we have a really simplified picking process but this part will still probably be a bit tricky in case of picking and/or order cancel)3a) all sale order packages will be automatically attached to the outgoing picking by setting them on "picking.package_ids"3b) all the products will automatically be put in a single pack, the other packs will be "fake packs" in the sense that they will not store any products but still has dimensionsThis will not provide huge advantages by itself, but definitely better than having separate model to manage "shipping packs" delivery rate and tracking. Tracking will not be really accurate as it doesn't target products, but the rate we need to get is always based on taxable weight, so it should be a decent solution. I'm still not sure if it's worth to manage "package_id" on stock.quant.package, if I am not wrong that's needed in order to print shipping label.If you have any kind of suggestions that comes from experience in developing similar workflows (TLDR generating packages from sale order without having to specify the pack content) it will be helpful for sure.Thanks,Francesco BalleriniIl giorno dom 10 dic 2023 alle ore 23:27 Francesco Ballerini <francescobl.lavoro@gmail.com> ha scritto:Hello,TLTRI am searching (for Odoo v14) a module which add a one2many on sale order, linking SO with multiple product packaging objects.More detailsLong time ago I've been asked to make implementations for a workflow when we need to define product packaging objects in a Sale Order so that we can store packaging dimensions, compute the proper rate and send some info to the carrier.We don't want to define any package on sale order line, or link specific products to a packaging: we just need to define an X number of packaging objects related to the sale order.Also, we want to do it from sale order because we adjust product lines accordingly to the "on hand quantity" directly on sale order, before picking generation, plus we don't manage backorder in the classic Odoo way, so picking is basically only "validate" for us.I already have developed the workflow, but it's not properly integrated with some Odoo modules/models so I want to make some refactors and possibly integrate it with some OCA modules like product_packaging_dimension to use already implemented features when possible.But I did not find anything covering this, possibly did I miss it?ThanksFrancesco Ballerini
by Francesco Ballerini - 09:04 - 12 Dec 2023
-
-
Packaging
Dear OCA’ers,
i am looking for a way to attach packaging products (storable, with selling price) to a sales order automatically, when a specific product is selected.
I already checked the sale_attach_product of the sales_workflow repo, but this doesnt seem to cover the needs in this case. It adds the same quantity of the parent product.
I also checked the product-pack repo. But the flow seems to be the opposite way. You can select a pack in the sales order, which adds the pack components to the SO.
What i want to achieve… Add a product „Product 1“ to sales order (e.g. quantity of 20).
Automatic addition of the packaging product „Packaging Product“ to the sales order (quantity = quantity of Product 1 / variable then round up, so in this case e.g. 20/6=3,33 -> 4).
Ideally this is related only to selected delivery methods or route. So for example: When the delivery is done by the company itself, the packaging product should be apllied to the sales order. If the delivery is performed by a shipping provider, the mechanism should not apply.
I will go ahead checking the stock-logistics-warehouse repo. But if there is something helpful crossing your minds, feel free to share these thoughts…
Cheerio
Nils
--
NICO SOLUTIONS - ENGINEERING & IT
Dr.-Ruckert-Str. 1G
28865 Lilienthal
Deutschland (Germany)
Ust.-Idnr. (VAT-ID): DE341437044
by Nils Coenen - 06:31 - 8 Dec 2023-
Re: Packaging
HI Jairo,
thanks for your reply.
Unfortunatly this does not cover the needs. When you enter a product to the sales order it only adds the packaging if the quantity of the product divided by the number of products inlcuded is an integer value. For example… a package with 6 is defined.
In SO if you add 6 or 12 or 18 it adds the packaging. If you add 8 it will not add any packaging. And i want to have the package reusable.
I will do some further testing. But anyway. Thanks for the input!
All the best
Nils
--
NICO SOLUTIONS - ENGINEERING & IT
Inhaber (Owner): Nils Coenen
Dr.-Ruckert-Str. 1G
28865 Lilienthal
Deutschland (Germany)
Ust.-Idnr. (VAT-ID): DE341437044Von: jairo <notifications@odoo-community.org>
Antworten an: Contributors <contributors@odoo-community.org>
Datum: Montag, 11. Dezember 2023 um 13:32
An: Contributors <contributors@odoo-community.org>
Betreff: Re: PackagingEl vie, 08-12-2023 a las 17:32 +0000, Nils Coenen | NICO SOLUTIONS - ENGINEERING & IT escribió:
i am looking for a way to attach packaging products (storable, with selling price) to a sales order automatically, when a specific product is selected.
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Nils Coenen - 10:26 - 12 Dec 2023 -
Re: Packaging
El vie, 08-12-2023 a las 17:32 +0000, Nils Coenen | NICO SOLUTIONS - ENGINEERING & IT escribió:i am looking for a way to attach packaging products (storable, with selling price) to a sales order automatically, when a specific product is selected.
by Jairo Llopis - 01:30 - 11 Dec 2023
-