Přejít na obsah
You need to be registered to interact with the community.
All Posts Lidé Odznaky
Štítky (View all)
odoo accounting v14 pos v15
O tomto fóru
This question has been flagged
actionattachmentdeletescheduled
3 Odpovědi
9232 Zobrazení
Avatar
Pascal Tremblay

Hello there,

In Odoo 8, if I'm trying to delete the attachment "/sitemap.xml" each day to refresh it.

I'm trying this way but I get an error :


Error is :

2016-12-08 09:07:37,267 14478 ERROR odoo-iv openerp.addons.base.ir.ir_cron: Call of self.pool.get('ir.attachment')._file_delete(cr, uid, *('/', 's', 'i', 't', 'e', 'm', 'a', 'p', '.', 'x', 'm', 'l')) failed in Job 10
Traceback (most recent call last):
    File "/home/odoo-iv/odoo-8.0-20161109/openerp/addons/base/ir/ir_cron.py", line 138, in _callback    getattr(model, method_name)(cr, uid, *args)  
    File "/home/odoo-iv/odoo-8.0-20161109/openerp/api.py", line 268, in wrapper    
    return old_api(self, *args, **kwargs)
TypeError: _file_delete() takes exactly 4 arguments (15 given)


Somebody could help?


EDIT #1

Answer From Axel was right. 

But I think to delete a file, I have to use the unlink function of ir.attachement class. This function needs IDs to delete attachments. See image below, I have deleted two attachments with this action :

But now, big problem... When the new sitemap.xml attachment is recreated, it doesn't have the same id... So the action is unusable. How to overcome this problem?

Avatar
Zrušit
Avatar
Pascal Tremblay
Autor Nejlepší odpověď

Here is our solution to this problem.

Since the _file_delete function was not the right method to use to delete an attachment.

Since the unlink method needs an ids list to work.

We had written this method who works well. May be you will have some changes in this method to get it better. We are not very strong in Python...


def delete_sitemap(self, cr, uid):
        id_list = []
        cr.execute("SELECT id FROM ir_attachment WHERE name ilike '%sitemap%'")
        res = cr.fetchall()
        if res:
            for r in res:
                id_list.append(r[0])
                self.unlink(cr, uid, id_list)
                return True
        return False


Avatar
Zrušit
Avatar
Axel Mendoza
Nejlepší odpověď

Hi Pascal

You just need to put your arguments value as:

("sitemap.xml",)

because in Python a tuple of one element needs a comma after the element to be taken as a tuple, meaning that:

("sitemap.xml") will be taken by Python as "sitemap.xml"

that's why Odoo take the "sitemap.xml" as the arguments tuple due to that strings in Python like many others programming languages could be taken as a list, tuple or array of characters

Avatar
Zrušit
Pascal Tremblay
Autor

Your answer is good. Thanks. But, I think I used the wrong function. I edit my post.

Related Posts Odpovědi Zobrazení Aktivita
How to create a scheduled action with timer
action scheduled
Avatar
Avatar
1
bře 24
2846
My scheduled actions aren't running Vyřešeno
action scheduled
Avatar
1
pro 21
15232
Add action to Attachment(s) menu?
action attachment
Avatar
0
bře 15
5317
Purpose of the Scheduled Action - "Base: Auto-vacuum internal data" ?
action server auto scheduled
Avatar
Avatar
Avatar
Avatar
4
říj 23
13827
Scheduled Action to Trigger "Compute Price from BOM" Action on All Products Vyřešeno
action bom scheduled v13
Avatar
Avatar
Avatar
Avatar
Avatar
4
čvn 23
8302