Skip to Content
This question has been flagged
actionattachmentdeletescheduled
3 Replies
9226 Zobrazenia
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šiť
Avatar
Pascal Tremblay
Autor Best Answer

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šiť
Avatar
Axel Mendoza
Best Answer

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šiť
Pascal Tremblay
Autor

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

Related Posts Replies Zobrazenia Aktivita
How to create a scheduled action with timer
action scheduled
Avatar
Avatar
1
mar 24
2840
My scheduled actions aren't running Solved
action scheduled
Avatar
1
dec 21
15224
Add action to Attachment(s) menu?
action attachment
Avatar
0
mar 15
5313
Purpose of the Scheduled Action - "Base: Auto-vacuum internal data" ?
action server auto scheduled
Avatar
Avatar
Avatar
Avatar
4
okt 23
13824
Scheduled Action to Trigger "Compute Price from BOM" Action on All Products Solved
action bom scheduled v13
Avatar
Avatar
Avatar
Avatar
Avatar
4
jún 23
8301